Bug 56541 - Spreadsheet created in MS Excel 2010 does not translate VB script correctly in Spreadsheet program
Summary: Spreadsheet created in MS Excel 2010 does not translate VB script correctly i...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.6.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-10-29 20:24 UTC by D. Charlie Curcija
Modified: 2013-04-10 20:52 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:

Attachments
Example MS Excel spreadsheet containing VB script that does not run in LibreOffice (914.54 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2012-10-29 20:24 UTC, D. Charlie Curcija 		Details
View All

Description D. Charlie Curcija 2012-10-29 20:24:14 UTC 
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.
Comment 1 LeMoyne Castle 2012-12-19 23:01:29 UTC 
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.
Comment 2 bfoman 2013-03-04 14:28:33 UTC 
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.