On 10/14/09 11:05, Madhur Kashyap wrote:
I am writing a small application in OpenOffice calc using Basic programming.
There is a need to construct a list of valid strings based on current
settings in one cell and enable data validation of another cell using this
list of strings.
I am facing two level difficulties
1.) I can't completely figure out what APIs would be used for this purpose.
I have reffered to XPropertySet, XSheetCondition, TableValidation, SheetCell
for this purose.
It's described at
http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Other_Table_Operations.
2.) I can find some documentation on how to specify a numeric condition but
I am failing to find help on how to specify list of valid strings.
Use a formula like "one";"two";"three".
3.) I can't get this code to work
oCell.Validation.setPropertyValue("Type",
com.sun.star.sheet.ValidationType.DECIMAL)
oCell.Validation.setPropertyValue("IgnoreBlankCells",1)
oCell.Validation.setPropertyValue("InputTitle","Width Distribution")
xPropertySetInfo = oCell.Validation.getPropertySetInfo()
MsgBox oCell.Validation.getPropertyValue("Type")
The last syntax always returns 0, whether I use DECIMAL or LIST. Infact I
printed the value of DECIMAL constant and found out it is "2".
Please help me figure out what am I doing wrong and what all am I missing ?
The validation object just stores the settings. To apply them, you have
to set the "Validation" property again:
oValidation = oCell.Validation
oValidation.Type = com.sun.star.sheet.ValidationType.LIST
oValidation.Operator = com.sun.star.sheet.ConditionOperator.EQUAL
oValidation.Formula1 = """one"";""two"";""three"""
oCell.Validation = oValidation
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org
For additional commands, e-mail: dev-h...@api.openoffice.org
