Hi Everybody!

I am trying to design a FBSpread() in wich one column would be a checkbox.
Does anybody know how to do that ?

There is a ‘Style’ attribute in the FBSpreadPart() object, but I do not succeed to use it.

Thanks,
L.

Ok, I found the answer :

Now I need to understand how to retrieve the cell data !

EDIT 25/6:
Ok, now that’s a REAL question: how do you set/retrieve data in a FBSpread’ cells ??? Please help !!!

L.

Bump..

Surely there is a way of doing this?  If FBSpread is exposed to python then you must be able to get/set cell values?  According to the documentation there is a “Caption” attribute but in actual fact there is not.

These are the available attributes and functions for an FBSpreadCell object:

[’BeginChange’, ‘ClassName’, ‘Column’, ‘Components’, ‘ConnectAt’, ‘ConnectDst’, ‘ConnectDstAt’, ‘ConnectSrc’, ‘ConnectSrcAt’, ‘DisableObjectFlags’, ‘DisconnectAllDst’, ‘DisconnectAllSrc’, ‘DisconnectDst’, ‘DisconnectDstAt’, ‘DisconnectSrc’, ‘DisconnectSrcAt’, ‘EnableObjectFlags’, ‘Enabled’, ‘EndChange’, ‘FBCreate’, ‘FBDelete’, ‘FBDestroy’, ‘GetDst’, ‘GetDstCount’, ‘GetDstType’, ‘GetObjectFlags’, ‘GetObjectStatus’, ‘GetOwned’, ‘GetOwnedCount’, ‘GetOwner’, ‘GetOwnerCount’, ‘GetSrc’, ‘GetSrcCount’, ‘GetSrcType’, ‘HasObjectFlags’, ‘Is’, ‘IsSDKComponent’, ‘Justify’, ‘MoveSrcAt’, ‘Name’, ‘OnUnbind’, ‘Parents’, ‘ProcessNamespaceHierarchy’, ‘ProcessObjectNamespace’, ‘PropertyAdd’, ‘PropertyCreate’, ‘PropertyList’, ‘PropertyRemove’, ‘ReadOnly’, ‘ReplaceDstAt’, ‘ReplaceSrcAt’, ‘Row’, ‘Selected’, ‘SetObjectFlags’, ‘SetObjectStatus’, ‘Style’, ‘SwapSrc’, ‘__class__’, ‘__delattr__’, ‘__dict__’, ‘__doc__’, ‘__getattribute__’, ‘__hash__’, ‘__init__’, ‘__module__’, ‘__new__’, ‘__reduce__’, ‘__reduce_ex__’, ‘__repr__’, ‘__setattr__’, ‘__str__’, ‘__weakref__’]

There is no SetCell function available to an FBSpread object as there is in the SDK.  Can someone at Autodesk confirm if Im wasting my time trying to work this out?

Thanks

Right Autodesk have said this is fixed in MB 2010.  I can confirm it is partially fixed.

While they have exposed GetCellvalue and SetCellValue functions you can only set/get values for strings, floats and ints so checkboxes and combo boxes are a no go as far as I can tell.  Autodesk are going to confirm.