Apache OpenOffice (AOO) Bugzilla – Issue 125670
Parsing of expressions fails
Last modified: 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)