Summary: | Charts move between spreadsheet worksheets | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Bob Bevan-Jones <bevan-jones> |
Component: | Chart | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED DUPLICATE | ||
Severity: | normal | CC: | bwo, LibreOffice |
Priority: | medium | ||
Version: | 3.4.2 release | ||
Hardware: | x86 (IA32) | ||
OS: | Linux (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: |
First spreadsheet ("before")
Second spreadsheet ("after") |
Description
Bob Bevan-Jones
2011-12-16 02:01:06 UTC
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 *** |