[Issue] Formatting data series on Stock chart

Discuss the spreadsheet application

[Issue] Formatting data series on Stock chart

Postby TropicWill » Wed Jan 16, 2019 10:06 pm

I have a stock chart (type 1) with two data series, each with high, low and average (shown as closing) daily values. I format the first series to colour [chart 2] and line thickness 0.1 cm; and the second series to colour [chart 4] and line thickness 0.1 cm. The chart looks just as I want it and prints correctly too. I save the spreadsheet but when I come back to it the next day to add another day's data, the format for the second series is changed to the default black with a 0 thickness line although the first series is unchanged. I have corrected the format a number of times, tried deleting and re-creating the chart but the behaviour persists. Is there anything else I can try?
Last edited by Hagar Delest on Sun Jan 20, 2019 11:58 am, edited 1 time in total.
Reason: tagged issue
OpenOffice 4.1 on Windows 10 (64bit)
TropicWill
 
Posts: 4
Joined: Wed Jan 16, 2019 9:44 pm

Re: Formatting data series on Stock chart

Postby robleyd » Thu Jan 17, 2019 1:02 am

Are you saving the spreadsheet in the native .ods format, or in some foreign format such as .xls? If so, try using the native format.

Also, see [Tutorial] Differences between Writer and MS Word files
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2858
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Formatting data series on Stock chart

Postby TropicWill » Thu Jan 17, 2019 2:26 am

In .ods .
OpenOffice 4.1 on Windows 10 (64bit)
TropicWill
 
Posts: 4
Joined: Wed Jan 16, 2019 9:44 pm

Re: Formatting data series on Stock chart

Postby MrProgrammer » Fri Jan 18, 2019 7:41 pm

Hi, and welcome to the forum. I haven't used that chart type myself, but I can attempt to reproduce the difficulty you've experienced. And maybe I'll have an idea for a solution.

Attach a document demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3777
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Formatting data series on Stock chart

Postby TropicWill » Fri Jan 18, 2019 9:48 pm

Thank you for your offer. I attach part of the spreadsheet with the chart data and the chart itself (I've taken out the source for the data).
It is possible to amend the colour and thickness of the second set of data but the changes do not persist when the file is saved and re-opened.
Attachments
stock chart example.ods
(22.11 KiB) Downloaded 13 times
OpenOffice 4.1 on Windows 10 (64bit)
TropicWill
 
Posts: 4
Joined: Wed Jan 16, 2019 9:44 pm

Re: Formatting data series on Stock chart

Postby gerard24 » Fri Jan 18, 2019 10:06 pm

I can reproduce with your file.

Seems to be an (unsolved) old bug : Bug 69698 - FILESAVE: Line width & color of Stock Chart not properly saved.
I don't know if there is a bug report also for OpenOffice....
LibreOffice 6.2.4 on Windows 10
gerard24
Volunteer
 
Posts: 948
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: Formatting data series on Stock chart

Postby TropicWill » Sat Jan 19, 2019 10:45 pm

Interesting to learn that it is an old "bug".
I have had a look at the xml generated for the chart and it appears that there is a difference in treatment of stock charts in OpenOffice compared with the OASIS Standard OpenDocument 1.2 .
The Standard describes one stock value represented by up to 4 series (see the defined values for <chart:class> at 19.15.1).
OpenOffice extends this to a number of stock values, each represented by up to 4 series.
The Standard defines additional drawing elements with their own styles (<chart:stock-gain-marker>, <chart:stock-loss-marker> and <chart:stock-range-line>) which are children of <chart:plot-area> only, unlike the styles for other chart types which can also be children of <chart:series> within <chart:plot-area>. So the Standard does not provide a way to save more than one set of stock drawing styles, and OpenOffice uses default values for those not saved.
It seems to me that the OpenOffice implementation is more generally useful (my compliments to the design team) but I do not know how to suggest that the Standard be revisited. To allow the stock-drawing elements to be children of <chart:series> as well as <chart:plot-area> would seem to give scope for more than one stock without making existing files non-compliant.

Meantime I will continue to correct the colours each time I want that particular chart.
OpenOffice 4.1 on Windows 10 (64bit)
TropicWill
 
Posts: 4
Joined: Wed Jan 16, 2019 9:44 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 13 guests