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...
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:
Depends on:
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: ---


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

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.

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