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
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 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)