| T O P I C R E V I E W |
| AKazak |
Posted - 05/21/2022 : 4:39:02 PM
OriginPro 2022b (64-bit) SR1 9.9.5.167
Windows 7 Pro SP1 x64
Greetings!
Please the following project:
https://my.originlab.com/ftp/forum_and_kbase/Images/Graph%20Color%20Indexing%20Fails.opju
In my environment, changing something in either sheet A or sheet B immediately breaks the graph.
Do you reproduce the issue?
Thank you.
---
Andrey |
| 9 L A T E S T R E P L I E S (Newest First) |
| AKazak |
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 |
| AmandaLu |
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 |
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 |
| minimax |
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 |
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 |
Posted - 08/14/2022 : 11:07:57 PM
Hi AKazak,
Do you think the workaround is good enough? |
| minimax |
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? |
| AKazak |
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 |
| Cecilia_syy |
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 |
