86346 – Excel import/export: empty cell display in charts

Issue 86346 - Excel import/export: empty cell display in charts

Summary: Excel import/export: empty cell display in charts

Status:	CLOSED FIXED

Alias:	None

Product:	General
Classification:	Code
Component:	chart (show other issues)
Version:	3.3.0 or older (OOo)
Hardware:	All All

Importance:	P3 Trivial (vote)
Target Milestone:	---
Assignee:	oc
QA Contact:	issues@graphics

URL:
Keywords:

Duplicates (1):	95620 (view as issue list)
Depends on:	65549
Blocks:
	Show dependency tree

Reported:	2008-02-22 10:25 UTC by IngridvdM
Modified:	2017-05-20 11:42 UTC (History)
CC List:	2 users (show)

See Also:
Issue Type:	ENHANCEMENT
Latest Confirmation in:	---
Developer Difficulty:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.

Description IngridvdM 2008-02-22 10:25:46 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!

Comment 1 daniel.rentz 2008-02-25 09:03:52 UTC

started

Comment 2 kla 2008-10-31 12:56:58 UTC

*** Issue 95620 has been marked as a duplicate of this issue. ***

Comment 3 daniel.rentz 2008-11-26 11:54:42 UTC

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

Comment 4 daniel.rentz 2008-11-26 12:58:56 UTC

fixed in DEV300/dr67 (OOo 3.1)
BIFF5/BIFF8/OOXML import, BIFF8 export

Comment 5 daniel.rentz 2009-03-12 12:20:15 UTC

back to QA

Comment 6 oc 2009-04-02 14:15:08 UTC

verified in internal build cws_dr67