https://bugs.documentfoundation.org/show_bug.cgi?id=96978
Bug ID: 96978
Summary: updating charts in a spread sheet I created for my own
use.
Product: LibreOffice
Version: unspecified
Hardware: Other
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ka0...@icloud.com
my spreadsheet contains 5 charts. I recently revised three of them to add a new
data series. I inserted the revised charts using the provided chart wizard. Two
of my charts remain unchanged. There is no problem with the unchanged charts.
The new charts do not update correctly.
The old charts track five data series. The new charts track six data series.
Five of the data series in the new charts duplicate five data series in the old
charts. Only one data series in the new charts is new information.
One data series is common to all of the five charts. It is a date. I format
that date day month, year (i.e. 8 Dec, 15). The date information is moved from
a line at the top of my spread sheet to the first column in each of five data
tables. This is accomplished by an update macro I wrote for this related
purposes. I've used this macro in various iterations of my spreadsheet with
reasonable success over the last several years, dating back to Open Office.
Here is the problem. When I run the macro, after all of the new data is
properly in place, everything appears to function correctly; that is until I
look at the x axis data on the charts. On the two old charts the new date
appears and functions correctly. On the new charts the date information is
displayed as a five digit date code. (i.e. 42303 instead of the corresponding
date in October 2015).
I've tried a number of work arounds for this problem. All of them are a bit
cumbersome. Some of them were a complete waste of time. I finally hit on one
that is only somewhat inconvenient and yields a satisfactory result.
I go to the data table that one of the new charts tracks. I copy date
information from an earlier cell in the table and paste in place of the latest
date. Then I correct the data to reflect the latest date. That eliminates the
five digit code from the x axis, changing it to the date format I prefer. The I
copy and paste the new data to the data table for the other two affected
charts. At that point the problem is corrected until the next time I update the
spread sheet.
Please excuse the length of my description Of the problem. I prefer to be
thorough.
--
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
