| Author |
 Topic  |
|
|
AKazak
Russia
1235 Posts |
|
|
Cecilia_syy
67 Posts |
 Posted - 05/22/2022 : 11:40:09 PM
|
Hi Andrey,
I can see same issue. Currently, recalculate for join worksheet does not keep status of set as categorical, so index color of graph is fail. We will check and fix it with ORG-24969-P2.
Thanks
Cecilia |
 |
|
|
AKazak
Russia
1235 Posts |
Posted - 05/23/2022 : 01:57:36 AM
|
quote:
Originally posted by Cecilia_syy
Hi Andrey,
I can see same issue. Currently, recalculate for join worksheet does not keep status of set as categorical, so index color of graph is fail. We will check and fix it with ORG-24969-P2.
Thanks
Cecilia
Dear Cecilia,
Got it.
I would be happy to test an update.
---
Andrey |
|
|
|
minimax
365 Posts |
Posted - 05/24/2022 : 10:31:35 PM
|
Hi Andrey,
It is because Join Worksheets by Column will copy source column's format into output columns.
Specific to your sample project, if you first set col(E) in both sheet "A" and "B" as categorical,
and then Change Parameters again, the graph should keep well.
Is it good enough for you? |
|
|
|
minimax
365 Posts |
Posted - 08/14/2022 : 11:07:57 PM
|
Hi AKazak,
Do you think the workaround is good enough? |
|
|
|
AKazak
Russia
1235 Posts |
Posted - 08/15/2022 : 10:07:20 PM
|
quote:
Originally posted by minimax
Hi AKazak,
Do you think the workaround is good enough?
The workaround works very fine.
What would Join Worksheets by Column do if the column in Set as Categorical on one sheet, but Set as not Categorical on another sheet?
---
Andrey |
|
|
|
minimax
365 Posts |
Posted - 08/16/2022 : 05:48:49 AM
|
quote:
What would Join Worksheets by Column do if the column in Set as Categorical on one sheet, but Set as not Categorical on another sheet?
I am not sure if I understand your question correctly.
The tool will copy columns one by one in each sheet, so they are independent and will not affect each other.
i.e. in your case, in output sheet one col will be categorical and the other will be not, just same as source.
If it happens to be used as the matched column and turn on merge as one option, for now we will adopt the property from 1st sheet (w1). |
|
|
|
AKazak
Russia
1235 Posts |
Posted - 08/16/2022 : 11:01:00 PM
|
quote:
Originally posted by minimax
If it happens to be used as the matched column and turn on merge as one option, for now we will adopt the property from 1st sheet (w1).
Got it!
Thanks for clarifying this.
---
Andrey |
|
|
|
AmandaLu
439 Posts |
Posted - 11/13/2022 : 9:31:05 PM
|
quote:
Originally posted by AKazak
quote:
Originally posted by Cecilia_syy
Hi Andrey,
I can see same issue. Currently, recalculate for join worksheet does not keep status of set as categorical, so index color of graph is fail. We will check and fix it with ORG-24969-P2.
Thanks
Cecilia
Dear Cecilia,
Got it.
I would be happy to test an update.
---
Andrey
Hi,
Origin 2023 is available!
Following issue you reported in this post has been fixed in Origin 2023:
Want to keep Categorical Status when there is recalculate (ORG-24969).
Right now, Origin can keep categorical status when there is recalculate for Join worksheet.
Please try it in Origin 2023.
We are looking for your feedback! Any suggestion will be appreciated!
Thanks,
Amanda
OriginLab Technical Service
|
|
|
|
AKazak
Russia
1235 Posts |
Posted - 11/14/2022 : 8:53:26 PM
|
quote:
Originally posted by AmandaLu
quote:
Originally posted by AKazak
quote:
Originally posted by Cecilia_syy
Hi Andrey,
I can see same issue. Currently, recalculate for join worksheet does not keep status of set as categorical, so index color of graph is fail. We will check and fix it with ORG-24969-P2.
Thanks
Cecilia
Dear Cecilia,
Got it.
I would be happy to test an update.
---
Andrey
Hi,
Origin 2023 is available!
Following issue you reported in this post has been fixed in Origin 2023:
Want to keep Categorical Status when there is recalculate (ORG-24969).
Right now, Origin can keep categorical status when there is recalculate for Join worksheet.
Please try it in Origin 2023.
We are looking for your feedback! Any suggestion will be appreciated!
Thanks,
Amanda
OriginLab Technical Service
Dear Amanda,
Great news!
I will report here if find issues with this.
---
Andrey |
|
|
| |
Topic |
|
Join Worksheets by Column breaks Graph