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)
Version:
(earliest affected)
4.2.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
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:

Attachments
Operating expenses for House (120.48 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-12-02 15:24 UTC, Lutz Wittber 		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 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 
Hello,
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 ***