Part of our workflow involves importing worksheets that in turn updates plugin objects. My issue is with the "Import Worksheet" command. If I import a worksheet, it sporadically changes the number format of various cells. I narrowed it down to some text that i have in some of the cells. More specifically, the "6x Post Min. / 8" Stemwall Min." is causing all the numbers after that to get converted to the wrong number type. You can see the effect on the data below.
Obviously, this is a bug that needs to get fixed. Seems like the text is not isolated from the format and is somehow changing the format of future cells.
Thanks,
Tyler
You can see the effect on our plugin object below. This requires is to go in and manually change every one so it has the correct format.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
El Dinyo
Part of our workflow involves importing worksheets that in turn updates plugin objects. My issue is with the "Import Worksheet" command. If I import a worksheet, it sporadically changes the number format of various cells. I narrowed it down to some text that i have in some of the cells. More specifically, the "6x Post Min. / 8" Stemwall Min." is causing all the numbers after that to get converted to the wrong number type. You can see the effect on the data below.
Obviously, this is a bug that needs to get fixed. Seems like the text is not isolated from the format and is somehow changing the format of future cells.
Thanks,
Tyler
You can see the effect on our plugin object below. This requires is to go in and manually change every one so it has the correct format.
Tyler
Vectorworks 2020
Link to comment
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.