https://bugs.freedesktop.org/show_bug.cgi?id=43877

             Bug #: 43877
           Summary: Charts move between spreadsheet worksheets
    Classification: Unclassified
           Product: LibreOffice
           Version: unspecified
          Platform: x86 (IA32)
        OS/Version: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Chart
        AssignedTo: [email protected]
        ReportedBy: [email protected]


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.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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

Reply via email to