https://bugs.documentfoundation.org/show_bug.cgi?id=90275
Bug ID: 90275
Summary: Serious and lots of problems copying sheets!
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 114393
--> https://bugs.documentfoundation.org/attachment.cgi?id=114393&action=edit
The referred example
I tried to implement in LO a work (big) that I had in gnumeric.
Everything from scratch.
I found lots of serious problems!
I tried to build small examples to illustrate the problems but couldn't.
After several experiments I managed to get an example that illustrates
a small, but important, part of the problems.
Test 1:
1. I am using LO calc 4.4.1.2 kubuntu 14.04
2. Open the attached example
Here I had a relatively small problem that is not the subject of this
bug repport. If needed, I'll file a separate bug report.
The legend of 2nd. graphic ("BuySell Trigger MACD RSI") shows
up on the upper left corner. It was placed before saving on top in the
center manually i.e. double clicking on it and dragging to that
position.
This is a regression. Opening with 4.2.7.2 shows it correctly placed.
3. Now copy the sheet CoA before CoA (right clicking down on CoA and choosing
Move/copy, etc.)
A new sheet CoA_2 is created but lots of things are wrong.
The new sheet should look exactly the same as CoA but with all
its referencies, graphics included, pointing to itself (CoA) except
the gray area that should point to "Recolha" sheet.
But everything seems badly wrong.
4. Goto cell AF7. It should refer to =Recolha.A2. But it didn't.
5. Insert =Recolha.A788 in that cell.
It now displays "CoB". Correct.
6. Now copy that cell *formula only* to all the gray area
(paste special and select formula only)
Now all 3 graphics are correct displayed but with other
set of data. This is right. All referencies are also correct.
7. Now let's do another copy of CoA (NOT CoA_2) but this time to before sheet
"Recolha".
Right click CoA down tab, choose before "Recolha" and copy.
Calc crashes!!!
Test 2:
1. From the original file repeat steps 2, 3, 4 and 7 of previous test (SKIP
steps 5 and 6).
Now sheet CoA_3 is correct as expected. All cell and graphics
referencies are correct.
2. Goto CoA_2. It is wrong.
3. Using CoA_2 execute steps 5 and 6 of previous test.
In general I found graphics referencies to be correctly pointing
to CoA_2 cells but a few times I got graphic 3 pointing to CoA cells
instead.
This example is a small extract of a much bigger work.
Sometimes I needed to do 4 copies of a sheet before I got the correct
referencies. And this seems random! Repeating the same actions gives
different results!
I also found some other problems but I couldn't replicate them.
Helper note for reference:
All gray cells refer to data in "Recolha" sheet and the whole data
and graphics in the sheet depend on the gray cells.
--
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
