Spreadsheet properties

[HakanSeven12]

I think class connections for that properties didnt done yet.

I tried this.

Code: Select all

obj = App.activeDocument().addObject('Spreadsheet::Sheet','Spreadsheet')
type(obj.cells)

It return this.

Code: Select all

<class 'Spreadsheet.PropertySheet'>

Then I tried this.

Code: Select all

import Spreadsheet
ps = Spreadsheet.PropertySheet()

But it returns that error

Code: Select all

Traceback (most recent call last):
  File "<input>", line 1, in <module>
AttributeError: module 'Spreadsheet' has no attribute 'PropertySheet'

[Chris_G]

I gave a try at Spreadsheet :

Code: Select all

o1 = App.activeDocument().addObject('Spreadsheet::Sheet','Spreadsheet')

for prop in o1.PropertiesList:
	print("{} (<{}>) = {}".format(prop, o1.getTypeIdOfProperty(prop), o1.getPropertyByName(prop)))

returns :

Code: Select all

ExpressionEngine (<App::PropertyExpressionEngine>) = []
Label (<App::PropertyString>) = Spreadsheet002
Label2 (<App::PropertyString>) = 
Visibility (<App::PropertyBool>) = True
cells (<Spreadsheet::PropertySheet>) = <PropertySheet object>
columnWidths (<Spreadsheet::PropertyColumnWidths>) = <PropertyColumnWidths object>
rowHeights (<Spreadsheet::PropertyRowHeights>) = <PropertyRowHeights object>

So 'columnWidths', for example, is supposed to contain a PropertyColumnWidths object.
How can we create such an object ?

Code: Select all

o1.columnWidths.__class__
# ---> <class 'Spreadsheet.PropertyColumnWidths'>

Can we create such an object from Spreadsheet module ? :

Code: Select all

import Spreadsheet
Spreadsheet.

Typing the dot after Spreadsheet offers nothing interesting.
So, I think Spreadsheet module is not offering any python API for customization.

[Kunda1]

So, I think Spreadsheet module is not offering any python API for customization.

[uwestoehr]

@uwestoehr would you happen to know?

No, I don't know if and how Spreadsheet can be used for scripting.

But Hyarion knows the Spreadsheet code well and can maybe help to implement something.

.

[HakanSeven12]

Is there anyone who fix that?

So, I think Spreadsheet module is not offering any python API for customization.

[Kunda1]

bump

[Evgeniy]

Do you want change size of column in spreadsheet from Python console?

[HakanSeven12]

No. I can't create spreadsheet property classes on python. Because python API integration is missing. I'm asking for someone to do it.

[Evgeniy]

If I'm not mistaken, there is an article in the wiki on how to wrap a c++ command for access from Python.
I don't understand much about this, but maybe someone will be interested.
https://wiki.freecadweb.org/Wrapping_a_ ... _in_Python

[HakanSeven12]

I don't know c++ too. I hope someone can help for this.