[Libreoffice-bugs] [Bug 107276] renaming sheet causes chart data ranges referencing sheet to change to Data Table - unrecoverable

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=107276

--- Comment #2 from Rich <benchrest1 at att.net> ---
Created attachment 132704
  --> https://bugs.documentfoundation.org/attachment.cgi?id=132704&action=edit
see comment

This is not as striat forward as I first thought. In the file I am attaching,
renaming the first sheet or the second sheet doesn't seem to cause a problem.
Both seem to need renamed and then not all charts that I expect would chage do
not. Seems like a different one each time.
Not all charts on the following file have been redone yet. 
This is the actual file: "Fund & Sector Comparison 2017.ods"
There are four charts to look at that I rebuilt. They were all altered with the
initial failure along with others. Yet in recreating the problem, they all do
not fail, and a differnt one each time. I am having difficulty isolating a
specific sequence that causes the same chart to fail each time.
The charts to look at to varify they are correct before renaming the sheets
are: On the second sheet named "Fund Comparison 2016", two charts. On the far
right below the data entry is "YTD Comparison 2017-1" "Primary Funds & Indexes"
below that chart is a chart titled "YTD Comparison 2017-1" "Secondary Funds &
Indexes"
The other two charts are on the sheet named "YTD Comparison" On the right is a
Chart titled "Year to Date Comparison 2017-1" "Primary Funds, Indexes &
Sectors". Below it is a chart titled "Year to Date Comparison 2017-1"
"Secondary Funds, Indexes & Sectors"
With all four charts select the chart and right click to see menu. You shoud
see "Data Ranges"
Then change the names on the first two sheets from "Sector Tracter 2016" and
"Fund Comparison 2016" to  "Sector Tracter 2017" and "Fund Comparison 2017"
Now reselect the four charts above to see if they all show "Data Ranges" or if
one or more has changed to "Data Table"
If you don't see something easily, I am thinking that instead of repairing the
charts in this file I may go to my January backup or create a new file copying
only the data and reenter forulas and charts. There may be some residual
problem from my initial failure that I am not seeing.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170420/27958fc1/attachment.html>