Apache OpenOffice (AOO) Bugzilla – Issue 82177
Excel filter: chart data label type and separator
Last modified: 2013-02-24 21:22:30 UTC
With CWS chart14 the data label capabilities of the chart were enhanced. Thus it would now be possible to im- and export those things: 1) And a numberformat can be set for the value and percentage value (see issue 37792) 2) It is possible to display the value and the percentage value at the same time for pie charts. (see issue 43489) 3) A label separator (see issue 82051).
->Daniel, please have a look what you can do for the new features in the excel filter.
1) fixed with issue 81392
title, started
target
OOXML import already implemented in master DEV300m44.
fixed in CWS DEV300/chart37
Import/export of label type (value, percentage, category) and import/export of separator between label components implemented in BIFF8 and OOXML filters. (BIFF8: import/export, OOXML: import only). Test documents: http://sc.openoffice.org/testdocs/index.html -> Chart Settings and Formatting -> Data series, labels -> BIFF8, XML2003, XML2007 Inside the documents, look at sheet "Data Labels", chapter 3.5 "Data Label Type". The bar chart shows all possible combinations of label types supported by Excel: value, category name, series name. Chart2 can show value and category name only (not series name). The pie chart shows all possible combinations of value, percentage, category name, series name. Again, Chart2 cannot show the series name. Last chart is a bubble chart in Excel, can be ignored here. Chapter 3.6, first chart, shows label separators. First is "automatic" which is a semicolon in Excel. NOTE: Due to issue 101093 (fixed in another OOo3.2 CWS), loading of charts is currently VERY slow. A little (!) workaround is to increase the number of cached OLE objects: Tools -> Options -> Memory -> Cache for inserted objects -> Number of objects = 200. Restart of Office is required (quickstarter too)! The fix of issue 101093 makes loading even faster than this workaround.
Seen ok in cws chart 37 -> verified
Seen ok in current master -> closed