Issue 19559 - XY chart saved in Excel format gains symbol ticks
Summary: XY chart saved in Excel format gains symbol ticks
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-14 11:34 UTC by Unknown
Modified: 2013-02-24 21:18 UTC (History)
1 user (show)

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

Attachments
test document with line/XY charts, for import/re-export (21.00 KB, application/vnd.ms-excel)
2003-12-11 10:13 UTC, daniel.rentz 		no flags Details
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 Unknown 2003-09-14 11:34:05 UTC 
An XY chart with subformat "Lines Only" is saved as
"Symbols and Lines" in Excel format.
Saving in native format is correct.
Added symbols are shown both by Excel and scalc.
Possibly related to issue 6496.
Comment 1 kla 2003-09-15 10:31:27 UTC 
Hi Bjoern,
for you.
tk
Comment 2 bjoern.milcke 2003-09-15 12:26:45 UTC 
I'll take a look (ACCEPTED)
Comment 3 bjoern.milcke 2003-10-31 11:18:12 UTC 
BM->DR: It looks like the filter would not set the chart type
correctly. The XDiagram has a property "SymbolType" (see service
XYDiagram/LineDiagram) which is "-3" meaning NONE. In this case the
sub-chart type should change to "no symbols"
Comment 4 daniel.rentz 2003-11-10 14:52:38 UTC 
The property "SymbolType" of the diagram returns -3, as expected, but 
the same property from a single data row returns 0, and this is used 
to export the series. The return type should be -3 for all data rows 
and data points in charts without symbols.
Comment 5 bjoern.milcke 2003-11-10 16:00:03 UTC 
Ok, I will check this.
Comment 6 bjoern.milcke 2003-11-13 16:48:44 UTC 
data points and series now return -3 (NONE) for symbol type, if the
chart type has no symbols.
Comment 7 bjoern.milcke 2003-11-21 14:57:09 UTC 
->AF: please review my fixes.
Comment 8 groucho266 2003-11-21 14:57:54 UTC 
Bug fix reviewed.
Comment 9 bjoern.milcke 2003-11-21 15:42:50 UTC 
Fixed in CWS sch7pp2
Comment 10 bjoern.milcke 2003-12-04 13:16:32 UTC 
Please verify (sch7pp2 is on cwsserver 3).
Comment 11 kla 2003-12-09 09:46:02 UTC 
Export Selection in Excel is none.
Import Selection in Calc is wrong.
Comment 12 sascha.ballach 2003-12-11 09:54:01 UTC 
review done
Comment 13 daniel.rentz 2003-12-11 09:59:11 UTC 
Fixed import and export of line charts and XY charts (CWS FIX645/sch7pp2).

On Excel import: Correct setting of chart type according to visibility of lines 
and symbols (did not work for symbol-only XY charts too). Problem was that the 
chart type dialog did not show the correct chart type.

On Excel export: Correct setting of chart type according to visibility of lines 
and symbols, and spline type. Problem was that Excel's chart type dialog did not 
show a selection in the chart type area.

I will attach a test document containing all line/XY chart types. Note that a 
line chart without lines (symbols only) is a user-defined type, and therefore 
Excel correctly shows no selection in its dialog, in difference to a 
symbols-only XY chart.
Comment 14 daniel.rentz 2003-12-11 10:08:39 UTC 
fixed
Comment 15 daniel.rentz 2003-12-11 10:13:30 UTC 
Created attachment 11885 [details]
test document with line/XY charts, for import/re-export
Comment 16 daniel.rentz 2003-12-12 11:39:07 UTC 
back to QA
Comment 17 kla 2003-12-15 11:52:51 UTC 
verified in sch7pp2
Comment 18 kla 2003-12-15 11:53:37 UTC 
verified
Comment 19 kla 2004-01-21 11:32:50 UTC 
closed