Unable to set Line properties beyond 2 curves in Calc Chart

Keyboard macros or custom scripts

Unable to set Line properties beyond 2 curves in Calc Chart

Postby misitu » Fri Oct 21, 2016 11:33 pm

Been knocking myself out over this ...

As mentioned here, I am going to report this as a bug unless I hear back from a forum contributor (that it's something I've overlooked) or else find a fix in the newer releases of AOO.

[Edit]I reported this as a potential bug to the AOO Bugzilla 21/10/2016/Edit]

Two calc spreadsheet files are attached. Both relate to data which appear on the second worksheet of each.

The idea is to colour code the curves applying to which currency (GBP or PEN) they relate to. To do that I need to set the colour and line dash appropriately.

What happens is that after the first two curve specs (DataRowProperties) it isn't possible to set colour etc any more. You either put up with the Chart N colour or else things start disappearing.

The first file contains evidence of four curves. The relevant part of the Basic macro is listed on the Chart worksheet.
The second file contains evidence of LOSS of one of the curves. The Basic text has the additional lines highlighted in reverse.
The third file is the full basic macro, just in case it's of material interest.

Thanks for any insights or requests

Basic Macro Text.txt
(11 KiB) Downloaded 53 times
But 1 curve missing.ods
Second chart, a line has gone missing
(27.39 KiB) Downloaded 85 times
All 4 curves displayed.ods
First chart, shows it all
(28.12 KiB) Downloaded 62 times
OpenOffice 4.1.1
HSQLDB 2.3.4
Windows 7 HP / Windows 10
User avatar
Posts: 89
Joined: Mon Dec 16, 2013 5:34 am
Location: Trujillo - La Libertad - Perú

Return to OpenOffice Basic, Python, BeanShell, JavaScript

Who is online

Users browsing this forum: No registered users and 4 guests