https://bugs.documentfoundation.org/show_bug.cgi?id=96399
Bug ID: 96399
Summary: SUMIF expression broken references after saving,
closing and re-opening
Product: LibreOffice
Version: 5.0.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 121215
--> https://bugs.documentfoundation.org/attachment.cgi?id=121215&action=edit
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!)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
