Apache OpenOffice (AOO) Bugzilla – Issue 86346
Excel import/export: empty cell display in charts
Last modified: 2017-05-20 11:42:18 UTC
When the fix for issue 65549 is integrated it will be possible to choose what should be displayed in case of empty cells. Use the new property 'MissingValueTreatment' at the diagram. The new option should also be implemented in the im- and export. Thanks a lot!
started
*** Issue 95620 has been marked as a duplicate of this issue. ***
following test documents have been created: BIFF5 (Excel 5/95) http://sc.openoffice.org/testdocs/chart/chart_sourcedata_missing_import_biff5.xls BIFF8 (Excel 97-2003) http://sc.openoffice.org/testdocs/chart/chart_sourcedata_missing_import_biff8.xls OOXML (from Excel 2003 XML plugin) http://sc.openoffice.org/testdocs/chart/chart_sourcedata_missing_import_oox3.xlsx OOXML (Excel 2007) http://sc.openoffice.org/testdocs/chart/chart_sourcedata_missing_import_oox7.xlsx
fixed in DEV300/dr67 (OOo 3.1) BIFF5/BIFF8/OOXML import, BIFF8 export
back to QA
verified in internal build cws_dr67