Issue 116395

Summary: Opening spreadsheet produces "BASIC runtime error 423 OperatingSystem"
Product: Calc Reporter: blueh2o <mcastelein>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOo 3.2.1Keywords: crash
Target Milestone: ---   
Hardware: PC (x86_64)   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: 4.0.0
Developer Difficulty: ---
Description Flags
Example spreadsheet none

Description blueh2o 2011-01-10 15:11:08 UTC
OpenOffice does not seem to like these spreadsheets with BASIC code in them,
specifically the following statement:

  MacXL = (UCase(Left(Application.OperatingSystem, 3)) = "MAC")

Apparently "Application" does not have a property "OperatingSystem".. 

Some sheets in this file do not appear correctly and trying to delete them also
causes OpenOffice to crash entirely.
Comment 1 Edwin Sharp 2013-05-03 12:26:17 UTC
Please attach example.
Comment 2 blueh2o 2013-05-03 17:57:59 UTC
Created attachment 80635 [details]
Example spreadsheet
Comment 3 Edwin Sharp 2013-05-10 07:25:34 UTC
Thank you and sorry for late reply.

Only Purchase Order sheet is visible in Excel 2010.
In Calc Rev. 1479897 also sample1, sample2, sample3 sheets are visible.
Deleting one of them causes a crash.
Comment 4 Edwin Sharp 2013-12-13 13:50:27 UTC
No crash when delete sheets.

AOO410m1(Build:9750)  -  Rev. 1543812
Win 7
Comment 5 Edwin Sharp 2013-12-13 14:02:58 UTC
Sorry. There is a crash.
Comment 6 Edwin Sharp 2013-12-13 14:03:11 UTC