Issue 119453 - [From Symphony]]Import .xlsx file, fomulas using space as intersection operator will return error.
Summary: [From Symphony]]Import .xlsx file, fomulas using space as intersection operat...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0
Hardware: PC All
: P3 Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-28 09:21 UTC by Shan Zhu
Modified: 2012-07-17 08:49 UTC (History)
1 user (show)

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

Attachments
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-05-28 09:21:46 UTC 
Build info: r1327774

Steps:
1. In MSExcel2007/2010, input formula in cells which has space characters as intersection operator in.
For example, =SUM(F2:F4 F3:F5), =(($D$12) ($D$12))
2. Save it as .xlsx.
3. Open the .xlsx file in AOO3.4.

Issue:
The Excel's intersection operator can not be translated into "!" which is the intersection operator of AOO.
The formula will return error.
Comment 1 Du Jing 2012-07-17 08:49:43 UTC 
confirmed,change its status