Bug 96399 - SUMIF expression broken references after saving, closing and re-opening
Summary: SUMIF expression broken references after saving, closing and re-opening
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-12-11 01:46 UTC by diegogullo
Modified: 2015-12-11 21:45 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
example file (29.50 KB, application/vnd.ms-excel)
2015-12-11 01:46 UTC, diegogullo 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description diegogullo 2015-12-11 01:46:21 UTC 
Created attachment 121215 [details]
example file

I am using a calc sheet where i use an expression

=SUMIF($'ItemisedEntry'.C$1:C$983040,A10,$'ItemisedEntry'.D$1:D$983040) 

This goes to the itemised entry and does a per type sum of values. 

Everytime i use this expression it works but if i save the calc sheet when i reopen i see #REF!

In the lines the SUMIF expression shows 

=SUMIF($ItemisedEntry.#REF!$#REF!:#REF!$#REF!,A21,$ItemisedEntry.#REF!$#REF!:#REF!$#REF!)
Comment 1 m_a_riosv 2015-12-11 01:57:41 UTC 
Hi @diegogullo, thanks for reporting.

You are using xls type file to save, xls only allow 65534 rows.

Better use the OpenDocumentFormat ODF, ods the extension for calc. And if you need to share the file with who can read ods, use the xlsx format.
Comment 2 diegogullo 2015-12-11 21:45:18 UTC 
thanks