incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 120199] New: With space character used at the beginning of a sheet name in a 3D reference, it can not be parsed properly, while import .xlsx file.
Date Thu, 05 Jul 2012 06:55:37 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=120199

          Priority: P3
            Bug ID: 120199
          Assignee: ooo-issues@incubator.apache.org
           Summary: With space character used at the beginning of a sheet
                    name in a 3D reference, it can not be parsed properly,
                    while import .xlsx file.
          Severity: normal
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Reporter: shanzhu33@gmail.com
          Hardware: All
            Status: UNCONFIRMED
           Version: AOO 3.4.0
         Component: open-import
           Product: spreadsheet

Created attachment 78584
  --> https://issues.apache.org/ooo/attachment.cgi?id=78584&action=edit
3dref.xlsx

Build: AOO3.4.1_r1354891

Steps to reproduce:
( To create the sample file:
1a.Rename one sheet, use a string start with a space character in Excel
2007/2010. Say, ' joker'.
1b. Create a formula using a 3D references as parameter. 
Say, = SUM(' joker:Sheet3'!A1). Save file. (A sample file attached for your
reference), save as .xlsx file. )

1. Open the .xlsx attached in OO3.4.

Defect:
The sheet name in 3D-refrences range can not be parsed properly.
The formula will return error.

PS:Import .xls does not have this problem.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Mime
View raw message