Issue 125670 - Parsing of expressions fails
Summary: Parsing of expressions fails
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.1.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-09-24 09:58 UTC by Oliver Specht
Modified: 2014-09-24 09:58 UTC (History)
0 users

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


Attachments
Example file (14.25 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-09-24 09:58 UTC, Oliver Specht
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Oliver Specht 2014-09-24 09:58:03 UTC
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)