This problem occurred twice in two days for two different ODS spreadsheets using LibreOffice Calc 3.4.2 (OOO340m1 Build:1206) running on OpenSUSE 11.4. In the first case, I had a spreadsheet workbook with 3 worksheets, and on each worksheet was a chart relating to the data on that worksheet. I decided that I wanted to order the sheets differently, so (using drag-and-drop on the worksheet tabs) I switched the first and third worksheets, so the first was now last and vice versa. I then saved the workbook, and closed LibreOffice. When I went back into it later, I found that the chart for the data in the first worksheet was on the third worksheet, and vice versa. I switched them (using copy-and-paste), saved and re-opened the workbook, and the positions did not change. In the second case, I had a spreadsheet workbook with 8 worksheets. The first sheet was a "summary" sheet, and on each of the rest of the sheets were data accompanied by charts relating to that data. I inserted a new sheet between the first (summary) and second sheets, and started a new dataset there, creating a chart relating to that data. Once again, I saved the amended workbook and closed LibreOffice. When I went back into it later, I found that the chart for the "old" second worksheet (now the third) was on the "new" second worksheet; and so on throughout the workbook. It was only after cutting-and-pasting the charts onto their correct pages that I found the newest chart (which had been hidden underneath the "wrong" one on sheet 2). I saved the amended sheet and re-opened it with no further problems. In conclusion, it seems that the charts in my LibreOffice spreadsheet workbooks are positioned using fixed worksheet points (taken from the sheet positions at time of creation) and do not move with their worksheet when that is moved.
Might be related to "Bug 44467 - Deleting sheets can shift images or graphics between next sheets"? @Bob Bevan-Jones: May I ask you to read hints on <http://wiki.documentfoundation.org/BugReport> carefully? Then please: - Write a meaningful Summary describing exactly what the problem is - Attach a sample document (not only screenshot) - Attach screenshots with comments if you believe that that might explain the problem better than a text comment. Best way is to insert your screenshots into a DRAW document and to add comments that explain what you want to show - Contribute a step by step instruction containing every key press and every mouse click how to reproduce your problem (due to example in Bug 43431) – if possible contribute an instruction how to created a sample document from the scratch - add information -- concerning your PC -- concerning your OS (Version, Distribution, Language) -- concerning your LibO version and localization (UI language, Locale setting) –- Libo settings that might be related to your problems -- how you launch LibO and how you opened the sample document -- everything else crossing your mind after you read linked texts
Dear Rainer: Thankyou for your initial investigation of the bug I reported in December. I decided I would attempt to show the bug in action on a freshly-created spreadsheet; however, I was unable to do this, despite three different approaches. I returned to one of my original spreadsheets, to confirm to myself that the problem still existed; and it does (for that spreadsheet). I'm reluctant to attach the spreadsheet, as it contains personal data, which could still exist within the ODS file after anonymisation. I will persist with this and post something at a later date. In the meantime, here is the environment information you requested: (1) meaningful summary: "Moving sheets in a workbook containing several sheets - e.g. sheet AAA, sheet BBB and sheet CCC, with sheet CCC brought to the front, so the order becomes CCC, AAA, BBB. The chart for sheet CCC moves with the sheet; but the charts for sheets AAA and BBB *remain in their original sheet position". The effect of this is that the new first sheet (CCC) contains two charts: its 'proper' chart plus the chart showing data from sheet AAA; the new second sheet (AAA) contains the chart for sheet BBB; and the new third sheet (CCC) contains no chart." (2) attach sample document: I will do this at a later date, as explained above. (3) attach screenshot: ditto (4) step-by-step instruction: ditto (5) sample document created from scratch: ditto (possibly) (6) PC information: Shuttle XS35GT purchased new in December 2010 and equipped with one Crucial 2Gb DDR PC25300 memory module and one 500Gb Western Digital Scorpio 2.5" SATA 5400rpm hard disk; also an external DVD-R drive and a Samsung ML-1660 laser printer (7) OS information: (Linux) OpenSUSE 11.4 kernel 2.6.37.6-0.11-default (8) LibO information: LibreOffice 3.4.2 OOO340m1 (Build:1206) (9) LibO settings: language = English(UK); currency = GBP; dictionary = standard; measurement unit = centimetre; default font = Liberation Sans 10pt (10) LibO launch & document creation: launch LibreOffice Calc from LXDE menu; create new document; save as new file (11) miscellaneous information: I installed OpenSUSE on my PC in early November 2011, to replace Ubuntu, which I had fallen out of love with; this was a frseh destructive install, but the spreadsheet had been created by this time (with a single sheet), using Ubuntu 11.04 (which I upgraded soon after to 11.10). Hope this is helpful. Bob Bevan-Jones
Created attachment 68402 [details] First spreadsheet ("before") (See my latest posting dated 10-Oct-2012 for information relating to this attachment.)
Created attachment 68403 [details] Second spreadsheet ("after") (See my latest posting dated 10-Oct-2012 for information relating to this attachment.)
10-Oct-2012: In order to demonstrate this bug, I created two example spreadsheets today, constructed using one of the original spreadsheets that had revealed the bug to me. I am attaching these two spreadsheets. The first spreadsheet is called "FuelTracker1.ods". The second is called "FuelTracker2.ods", and is derived from the first spreadsheet. Here is how I derived it: (1) Open file "FuelTracker1.ods" with LibreOffice Calc, which on my computer is now up to version 3.4.4 OOO340m1 (Build:402). I am now running Linux Mint Lisa, by the way, with Linux kernel 3.0.0-12-generic. (2) The spreadsheet has three sheets: CCC, BBB and AAA (in that order). Each sheet contains data and an embedded chart. If you examine the data ranges in the charts, you will see that they expressly relate to data within that chart. Before continuing, observe the shapes of the charts on each sheet. (3) Now, drag-and-drop sheet CCC to the last sheet position; then drag-and-drop sheet AAA to the first sheet position. The sheets are now in the order: AAA, BBB and CCC. (4) Save the spreadsheet as "FuelTracker2.ods"; and exit LibreOffice Calc. (5) Re-open "FuelTracker2.ods" with LibreOffice Calc, and scrutinize the charts. You will find that the chart for sheet AAA is now on sheet CCC; and vice versa.
NOT reproducible with reporter's sample document and "LibreOffice 3.5.7.2 rc German UI/Locale [Build-ID: 3215f89-f603614-ab984f2-7348103-1225a5b] on German WIN7 Home Premium (64bit). But I was able to reproduce the problem with 3.4.5, so I believe that this one indeed is a DUP of Bug 44467, what has been fixed for 3.5.0 Lifecycle for 3.4 has ended, there will be no fix for that version. So DUP! But I see an ugly effect that with 3.5 the chart in BBB changes position when I proceed due to comment before and will be partial out of the page (to the left). I will do some more investigations and submit a new bug for that if necessary. @reporter: Please feel free to reopen this Bug if you find evidence that we have an independent issue here what still exists with 3.5.7 or later. *** This bug has been marked as a duplicate of bug 44467 ***