Summary: | Spreadsheet created in MS Excel 2010 does not translate VB script correctly in Spreadsheet program | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | D. Charlie Curcija <dccurcija> |
Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | normal | ||
Priority: | medium | CC: | bfo.bugmail, lemoyne.castle |
Version: | 3.6.2.2 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Windows (All) | ||
Whiteboard: | |||
i915 platform: | i915 features: | ||
Attachments: | Example MS Excel spreadsheet containing VB script that does not run in LibreOffice |
Charlie, Your spreadsheet was attached as plain text and is therefore hard to read. Also it would be helpful to have more info on the error that you see when the script is run in LibreOffice. Confirmed with: LO 4.0.0.3 Build ID: own W7 debug build Windows 7 Professional SP1 64 bit Error message: BASIC runtime error. '1' Type: com.sun.star.uno.RuntimeException Message: in row: If ActiveSheet.DropDowns("czpicker").Value <> "" Then |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 69251 [details] Example MS Excel spreadsheet containing VB script that does not run in LibreOffice MS Excel spreadsheet created in MS Office 2010 (MS Windows 7 64 bit OS with MS Office 2010 32 bit) contains VB script that works correctly in Excel (both on Windows and Mac versions), but when opened in LibreOffice Spreadsheet it reports error when VB is started. VB is run from the tab "Ranking" by pressing "Rank Options" button. Affected file is attached.