Issue 16241 - Excel filter: constant source data for chart series
Summary: Excel filter: constant source data for chart series
Status: CLOSED DUPLICATE of issue 64821
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 Beta2
Hardware: PC Windows 98
: P3 Trivial (vote)
Target Milestone: ---
Assignee: daniel.rentz
QA Contact: issues@sc
Keywords: ms_interoperability
: 83945 84520 (view as issue list)
Depends on:
Reported: 2003-06-30 13:19 UTC by Rainer Bielefeld
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

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

Document for tests (15.96 KB, application/octet-stream)
2003-06-30 14:25 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Rainer Bielefeld 2003-06-30 13:19:23 UTC
I tested with german version WIN98SE and also 
1.1 Beta2  german version WIN98SE with same result

steps to reproduce:

0. open attached file volumenstrom_neu.sxc
1. save as EXCEL98/200/XP
2. close OOo
3. reopen OOo
4. Open created EXCEL-document 'volumenstrom_neu.xls'
   expected: complete data visible
   actual: In chart Volumenstrom_Temperatur in the Diagram the
           graph is missing, also units at X- and Y-axis are wrong. 
           Instead of Data-Definition (as in sxc)
           $'Tabellarische Aufstellung'.$A$1
           I find

With the attached document this is 100% reproducible for me.

My questions to other testers:
- reproducible?
- all OS?
- how does the created XLS-document look in EXCEL?

Comment 1 Rainer Bielefeld 2003-06-30 14:25:33 UTC
Created attachment 7258 [details]
Document for tests
Comment 2 oc 2003-07-07 14:19:39 UTC
The mentioned chart has its own dataset. It has no reference to cells
on a sheet. 
Comment 3 Rainer Bielefeld 2003-07-07 17:10:27 UTC
Reply to Comments From Oliver Craemer 2003-07-07 06:19 PDT

Yes, so it is. I do not know how it happened that mentioned chart does
not use data from first sheet, might be I made something wrong when I
configured the chart :-)

I' do not know whether EXCEL can handle such charts. Should the OOo
export filter correct that?

By the way: samte test results with 644m11

Comment 4 daniel.rentz 2003-07-08 08:24:01 UTC
Yes, constant source data for charts is possible in Excel:
- Open empty Excel sheet
- Insert -> Chart -> Finish (an empty window appears)
- Right-Click -> Source-Data -> Series
- Add -> Values -> ={1,2,3,4} (or ={1;2;3;4} in German locale)

These construct is called "constant matrix", and can be used in
spreadsheet formulas too. Calc does not support them, so the Excel
filters do not support them. The problem is, that in Excel some of the
data series can be linked to cells, and others can have constant
values. In Calc it is only possible to have either constant values or
linked values for all series.

The new chart implementation [1] will support separate source data for
each data series. And it is planned to add support for constant
matrixes in Calc. Therefore this should be fixed if this new
functionality is available.

Comment 5 daniel.rentz 2003-09-16 10:41:39 UTC
Comment 6 frank 2004-05-04 14:43:50 UTC
Due to limited time ressources I re-Target this one to OOo Later
Comment 7 IngridvdM 2007-07-30 13:53:53 UTC
This issue is related to issue 11890.
Comment 8 kla 2007-11-26 10:34:51 UTC
*** Issue 83945 has been marked as a duplicate of this issue. ***
Comment 9 kla 2007-12-17 10:28:45 UTC
*** Issue 84520 has been marked as a duplicate of this issue. ***
Comment 10 IngridvdM 2010-07-08 16:55:13 UTC
The missing feature about constant values for series in charts is reported with
issue 64821. The issue description there is short and very easy to understand.
Therefor I would suggest to exceptionally close this older issue as duplicate.
Comment 11 Regina Henschel 2012-07-22 16:02:35 UTC
Close as duplicate to issue 64821 as suggested by Ingrid.

Matrix constants are possible now in formulas, but still not possible for data series.

*** This issue has been marked as a duplicate of issue 64821 ***