Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Parsing of expressions fails | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | Oliver Specht <os_ooo> | ||||
Component: | open-import | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CONFIRMED --- | QA Contact: | |||||
Severity: | Normal | ||||||
Priority: | P3 | ||||||
Version: | 4.1.1 | ||||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | All | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Created attachment 83982 [details] Example file The attached document contains in E39:E41 fomulas that mix names and address references that are not correctly detected in Calc. SUM(Q:T!Q) SUM(T2:Q:T:Q2) SUM(T2:T:Q2) T and Q are defined names. The cells are imported with errors and wrong formulas: =SUM(Q:t!q) =SUM(T2:Q2:T$1:Q$1048576) =SUM(Q2:T2)