https://bugs.freedesktop.org/show_bug.cgi?id=58030
Priority: medium
Bug ID: 58030
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: EDITING: Charts break when renaming sheet while charts
are hidden in collapsed rows with autofilter
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: thinke...@rocketmail.com
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 3.6.3.2 release
Component: Spreadsheet
Product: LibreOffice
I am not able to reproduce this error with a new small and fresh test-file, but
the error that I faced with my working file was the following:
Problem description:
1. I am having a file with 5 sheets
2. One of those sheets has >1000 lines and >20 columns
3. In the first column I have entered "menu" data, which means that I enter
different keywords to each line and then place an auto-filter to this column.
This way I can hide and show lines via the autofilter-menu. This is like a menu
emulation for different levels of detail
4. In the deepest level of detail I am having 80 charts which relate to data
inside the same sheet
5. After having selected a level of detail in which those charts are not
visible (i.e. hidden by the autofilter) and RENAME the sheet, at some later
moment, after having continued editing, saving, closing and re-opening the file
multiple times, I realized that most of the charts are broken!
6. The charts are empty and do not relate to any data. I can not select the
"Data Ranges.." menu item from the context menu either, since this option is
not existing anymore. Instead of this, I have a new option now called "Chart
Data Table" where I could manually enter chart data if I wanted.
7. I solved the problem by:
- Expanding all lines of the sheet, including the broken charts
- Rename the sheet to the previous name
- Save the file
8. After reopening the file, all charts where fixed again! I even could rename
the sheet again to something else (while having all lines expanded!) and it
would work fine
Regards
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
