Bug 86902 - Calc lost when saving or worksheet change table covers on the current worksheet
Summary: Calc lost when saving or worksheet change table covers on the current worksheet
Status: RESOLVED DUPLICATE of bug 79441
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2014-12-01 12:49 UTC by Lutz Wittber
Modified: 2014-12-06 20:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Operating expenses for House (120.48 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-12-02 15:24 UTC, Lutz Wittber

Note You need to log in before you can comment on or make changes to this bug.
Description Lutz Wittber 2014-12-01 12:49:03 UTC
Calc lost when saving or worksheet change table covers on the current worksheet away. From "$Table1.$A$1" --> $A$! "$ A $ 1" or from "Table1.A1" --> "A1". 
Tables that were created and saved using "OpenOffice"(TM) hold the table covers.
I do not use parallel installation of LibreOffice and OpenOffice.
Comment 1 raal 2014-12-02 10:14:42 UTC
please could you attach sample test file and provide steps for reproduction?
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)

Is it the same problem as in bug 86519 ?
Comment 2 Lutz Wittber 2014-12-02 15:24:25 UTC
Created attachment 110358 [details]
Operating expenses for House

This complex file has now been adjusted with oO (I hope so).

The errors are visible among other things on sheet "Uml" "D7" should be refers to"$NK.$D$8" point and  Uml.D8 refers to "$NK$32".
Or: Uml.G15 refers to WE.$G$9 (or $WE$G$9). And so on...

Corrected with Apache OpenOffice (TM) 4 fields refer back to the correct cells in other sheets.

I think it's the same problem as bug 86519 (Part 1)
Comment 3 raal 2014-12-06 06:32:04 UTC
Hello Lutz,
thank you for the file. This is file after the error. Uml.D8=D$8
Are you able to reproduce the error and provide reproduction steps?
Comment 4 Jean-Baptiste Faure 2014-12-06 20:08:34 UTC
Probably duplicate of bug 79441. See also bug 87010, bug 86916, bug 86125.

Please try https://bugs.freedesktop.org/show_bug.cgi?id=87010#c2

Feel free to reopn if it does not solve the problem for you.

Best regards. JBF

*** This bug has been marked as a duplicate of bug 79441 ***