Apache OpenOffice (AOO) Bugzilla – Issue 112717
MS-EXCEL VBA Macro Rows property 'OutlineLevel' does not supported by Calc
Last modified: 2013-02-24 20:56:57 UTC
I have a excel doc which contain the macros in VBA. Every thing works well before I add the function which containing operation to get outline level(that is the group level of this row). Calc report error "can not find method or property `OutlineLevel" while executing the following line. lineLevel = Rows(3000).OutlineLevel
@pppoe: May I ask you to read our guidelines on <http://qa.openoffice.org/issue_handling/pre_submission.html> and <http://www.openoffice.org/bugs/bug_writing_guidelines.html> before you file further issues or post again here? Then please select correct information for Issue Tracker selection fields Component, Subcomponent, Platform, OS, Version, Priority (generally: leave '3'), contribute a clear step by step instruction containing all observations (error messages ...), EVERY key press and EVERY mouse click how to reproduce the problem, and explain why you believe that your results are unexpected. That means (for example): do not write something like "I am not able to ...", but 6. left mouse click on … expected: …, color of … changes, … actual: no …., color remains white, no … Screenshots might help to explain the problem. Please - always specify your OOo download source, version, localization, OS and Platform you used for your tests! - attach a sample document (always with ODF source document)! - Always contribute a meaningful Summary - contribute more information concerning your PC (Procesor, memory, Graphic card ...)
OO version 3.2.0, OS is windowsXP or RedHat EL4, 1. open the attached file "sample.xls" with MS-Excel, click the button "test" in the first sheet, it will execute the macro "testSub", the code of that sub is as the following. we will find the cell(1,1) will show the group level of line 1. That's as we expected. Sub testSub() lineLevel = Rows(1).OutlineLevel Cells(1, 1) = lineLevel End Sub 2. open attached file "sample.xls" with Openoffice Calc, enable VBA supporting. click the button "test" in the first sheet, it will execute the macro "testSub". a dialog will popup with the error notify, "BASIC Runtime error,can not find method or property: `OutlineLevel` "
Created attachment 70240 [details] the test excel doc
How about this issue? My project blocked by this very much, very appreciate if this could be solved.
how could I get the group level number of one row? In Excel VBA that is in the property of "OutlineLevel", what's that in Openoffice Calc Basic?
>How about this issue? >My project blocked by this very much, very appreciate if this could be solved. Thanks for the sample, unfortunately that api is not yet implemented, we will keep the sample in mind for future api support >In Excel VBA that is in the property of "OutlineLevel", what's that in >Openoffice Calc Basic? Unfortunately I don't know, perhaps you could try and find out on one of the mailing lists. If you do find out what the equivalant openoffice api code is then please post it here. If we know the openoffice api code then we could wrap that with a vba api wrapper. Or if you have some coding skill you could try and provide a patch yourself ( we would help with that )
>In Excel VBA that is in the property of "OutlineLevel", what's that in >Openoffice Calc Basic? Unfortunately I don't know, perhaps you could try and find out on one of the mailing lists. If you do find out what the equivalant openoffice api code is then please post it here. If we know the openoffice api code then we could wrap that with a vba api wrapper. Or if you have some coding skill you could try and provide a patch yourself ( we would help with that ) [pppoe] I'm very new to openoffice, and have no much idea about openoffice api. If the developer of OO could provider that code, that would be helpful to me. Thank you.