Issue 109432 - datapilot in m71 dont recognize color
Summary: datapilot in m71 dont recognize color
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: DEV300m71
Hardware: Unknown Windows XP
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: regression
Depends on:
Reported: 2010-02-19 11:02 UTC by mr_smyle
Modified: 2013-08-15 06:17 UTC (History)
3 users (show)

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

DataPilot without color marks (69.00 KB, application/
2010-02-19 11:04 UTC, mr_smyle
no flags Details
2.4.3 vs. 4.0 (307.90 KB, image/jpeg)
2013-08-15 06:17 UTC, Edwin Sharp
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description mr_smyle 2010-02-19 11:02:00 UTC
1. Open attached file in 3.2
2. Open it in m71
3. DataPilot table is on sheet #2

No color lines present.
Other problem is no crop for long lines, but I think it will be fixed without me.
Comment 1 mr_smyle 2010-02-19 11:04:05 UTC
Created attachment 67910 [details]
DataPilot without color marks
Comment 2 Stefan Weigel 2010-02-19 19:31:51 UTC
Your example is a XLS document.

* Open this XLS with MS Excel 2002 --> NO colors in DataPilot.
* Open this XLS with OOo 3.1.1 ubuntu build --> NO colors in DataPilot
* Open this XLS with OOo 3.2 vanilla build --> colors in DataPilot are there
* Open this XLS with m71 --> NO colors in DataPilot

* Open this XLS with OOo 3.2 and save it as an ODF
* Open this ODF with OOo 3.1.1 ubuntu build --> colors in DataPilot are there
* Open this ODF with m71 --> colors in DataPilot are there

* Refresh the DataPilot, no matter what version you are using, color will disappear.

I am not sure how to classify this. Seems to be a XLS import problem, somehow.
But surely it is related to issue #75934 and possibly to issue #32303.

However, the intended behaviour seems not to be specified at all. So, if we do
not have any imagination of the intended behaviour, we cannot classify the
current behaviour as a defect.

It is likely, that opening a document, that contains a DataPilot, means
refreshing the DataPilot. Since refreshing a DataPilot can mean a completely new
structure of its result, how should cell formats be preserved, that had been
applied before the refresh?

I tend to resolve this issue as a duplicate of issue #75934.
Comment 3 mr_smyle 2010-02-19 20:30:24 UTC
May be just excel import filter, because I know about loosing formatting after
refresh. Interesting difference between 3.2, 3.1.1, and m71. May be you know who
to add to CC, who working on import  filters?
Comment 4 kyoshida 2010-02-19 20:42:13 UTC
Sorry, the problem description is not clear.  I opened the example file in
Excel, and there is no color at all even there.  You need to attach a file that
contains color when opened in Excel.
Comment 5 Stefan Weigel 2010-02-20 09:25:32 UTC

you got it right: open the example file in Excel, and there is no color.

But open it in OOo 3.2,  there *is* color. Open it in OOOo m71, there is *no* color.

Quite confusing.
Comment 6 Frank Schönheit 2010-04-16 14:12:33 UTC
*** Issue 110928 has been marked as a duplicate of this issue. ***
Comment 7 Edwin Sharp 2013-08-15 06:17:12 UTC
Created attachment 81332 [details]
2.4.3 vs. 4.0
Comment 8 Edwin Sharp 2013-08-15 06:17:59 UTC
As given in description

Rev. 1507307 Win 7