About "Spreadsheet`s Lable in Expressions ",please help!

[xsuper9988]

1.
I build spreadsheets
Then use Lable "TestABC" in the expression

2.
I modify the spreadsheet Lable "TestABC" to "TestAAA"
The expression is automatically updated to "TestAAA"

3.
I modify the variable's Lable
Spreadsheet automatically updates but not using Label "TestAAA"
this is causing trouble for me

4.
when i have a lot of spreadsheets
If the expression is not displayed in Label
that would be unreadable
And every time i modify the variable Lable, i need to modify a lot of places

Is there any way to solve
Thank you everyone

[adrianinsaval]

that is indeed annoying, anyone knows where in code this is handled?

[TheMarkster]

Here is a workaround. Instead of creating the spreadsheet in the spreadsheet workbench, create it in the python console and give it your label name as a name.

Code: Select all

App.ActiveDocument.addObject("Spreadsheet::Sheet", "TestABC")

Or you can make a macro that asks for the name:

Code: Select all

from PySide import QtGui
name, ok = QtGui.QInputDialog.getText(Gui.getMainWindow(), "New Sheet", "Enter sheet name:")
if ok:
    App.ActiveDocument.addObject("Spreadsheet::Sheet", name)

[xsuper9988]

Here is a workaround. Instead of creating the spreadsheet in the spreadsheet workbench, create it in the python console and give it your label name as a name.

Code: Select all

App.ActiveDocument.addObject("Spreadsheet::Sheet", "TestABC")

Or you can make a macro that asks for the name:

Code: Select all

from PySide import QtGui
name, ok = QtGui.QInputDialog.getText(Gui.getMainWindow(), "New Sheet", "Enter sheet name:")
if ok:
    App.ActiveDocument.addObject("Spreadsheet::Sheet", name)

Still the same problem
When the variable is redefined
Expressions are not using Label
Spreadsheet file name cannot be changed
When the file name is repeated
File name cannot be edited
Is there a solution to change the filename?

Still thank you very much

May I ask you another question?
Except for spreadsheets
Are there other solutions for global variables?

[thomas-neemann]

....
Is there any way to solve
..

I would only use 1 table as a workaround

[xsuper9988]

....
Is there any way to solve
..

I would only use 1 table as a workaround

Because I use a lot of parameters
Need to use more spreadsheets
This reduces recalculation time
It is also more convenient for classification management

[thomas-neemann]

..
This reduces recalculation time
...

ok, does it make sense to split such an assembly into several files?

[xsuper9988]

..
This reduces recalculation time
...

ok, does it make sense to split such an assembly into several files?

"One Part" with "One Spreadsheet"
Easy to copy the entire Part
Then modify the parameters

Of course here the spreadsheet is used instead of the global variable
It would be better if there were other solutions with global variables
Because the spreadsheet has a little Lag

[adrianinsaval]

There's DynamicData_Workbench

[xsuper9988]

There's DynamicData_Workbench

I have tested "DynamicData_Workbench"
But I forgot why I stopped using it
I will download and test again
Discuss when I test again