OLEExcel demo bug

[Ian Macpherson]

For those who want to use OLE I have discovered a small bug in the oleexcel demo in projects\examples
line 128 False should be replaced by 0
line 133 true should be replaced by -1
I have also discovered for anyone wanting to use the French version of Excel that Numbers should be written with a decimal point 1,23 instead of 1.23 Also the French version of excel does not understand RC[-2]*RC[-1] for calculations …. you have to use LC(-2°*LC(-1).This can be handled by doing a register search with
if reg.getvalue(HKEY_CURRENT_USER, “Control Panel\International”, “sDecimal”, SPECIFIC_RIGHTS_ALL, REG_SZ) == “,” or sCountry = “France” for example
here are some other things you can do
rangeselect(excel,”A10:C10″, error=e)
excel.putproperty(property = “Selection.Font.Name”, error=e, “Arial”)
excel.putproperty(property = “Selection.Font.FontStyle”, error=e, “Regular”)
excel.putproperty(property = “Selection.Font.Size”, error=e, 9)
excel.putproperty(property = “Selection.Font.Strikethrough”, error=e, 0)
excel.putproperty(property = “Selection.Font.Superscript”, error=e, 0)
excel.putproperty(property = “Selection.Font.Subscript”, error=e, 0)
excel.putproperty(property = “Selection.Font.OutlineFont”, error=e, 0)
excel.putproperty(property = “Selection.Font.Shadow”, error=e, 0)
excel.putproperty(property = “Selection.Font.Underline”, error=e, – 4142)
excel.putproperty(property = “Selection.Font.ColorIndex”, error=e, – 4105)
excel.putproperty(property = “Selection.Borders.LineStyle”, error=e, 1)
excel.putproperty(property = “Selection.Borders.Weight”, error=e, -4138)
excel.putproperty(property = “Selection.Borders.ColorIndex”, error=e, – 4105)
theoretically it should be possible to say
excel.putproperty(property = “Selection.Borders(9).Weight”, error=e, -4138 where Borders(9) refers to
xlEdgeBottom and -4138 refers to xlMedium but I have discovered that the current version of wxautomation() can handle classes but not members of the class e.g Borders works fine but Borders(9) causes error 530. In the same thread Bookmarks is recognized fine but a specific Bookmark(1) causes error 530. Perhaps this will not be the case with the next version of wxwidgets
Hope this helps anybody Ian Macpherson

[Author]

Posts