OLEExcel demo bug

Forums Forums SIMPOL Programming OLEExcel demo bug

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #3647
    Ian Macpherson
    Participant

    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

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.