Created attachment 114393 [details] 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.
Hello Paulo, thanks for reporting bug. 2. is bug 86624. You can add you to cc to see when it will be resolved. 7. please create new bug for crasher
Test 1 4. recolha.a2 after copy is Coa.A2 Looks like a duplicate of bug 50860. Take a look, please, if it's duplicate.
Test2 1 - I can confirm, referencies are correct. 3 - I can not reproduce with LO 4.4.1.2, win7. Data is from CoA_2 sheet.
Test 1-4. It is a duplicate of bug 50860. Sorry for not seeing it. Test 2-3. It's hard to reproduce. The probability greately increases with the size of the work book. I'll copy the crash situation to a new bug repport.
(In reply to Paulo da Silva from comment #4) > > Test 2-3. > It's hard to reproduce. The probability greately increases with the size of > the work book. > Please try to create new test file and then set to unconfirmed. Thank you Please note that the attachment will be public, remove any sensitive information before attaching it. How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/FDO/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team This NEEDINFO message was generated on: 2015-10-14
Dear Bug Submitter, Please read this message in its entirety before proceeding. Your bug report is being closed as INVALID due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team This INVALID Message was generated on: 2016-05-09