Issue 109432 - datapilot in m71 dont recognize color
Summary: datapilot in m71 dont recognize color
Status: CONFIRMED
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:
URL:
Keywords: regression
Depends on:
Blocks:
 
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: ---

Attachments
DataPilot without color marks (69.00 KB, application/vnd.ms-excel)
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
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 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 
@kohei,

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