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,...
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
3dref.xlsx (8.63 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-07-05 06:55 UTC, Shan Zhu 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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