Issue 120199 - 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.
Summary: With space character used at the beginning of a sheet name in a 3D reference,...
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2012-07-05 06:55 UTC by Shan Zhu
Modified: 2012-07-18 02:28 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

3dref.xlsx (8.63 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-07-05 06:55 UTC, Shan Zhu
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Shan Zhu 2012-07-05 06:55:37 UTC
Created attachment 78584 [details]

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.

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.
Comment 1 Du Jing 2012-07-18 02:28:11 UTC
confirmed,change its status~