Bug 239754

Summary:	kspread:msoffice2000: Correct colors of the chart are not retained in kspread
Product:	[Applications] calligrachart	Reporter:	Lassi Nieminen <lassi.ta.nieminen>
Component:	general	Assignee:	Inge Wallin <inge>
Status:	VERIFIED FIXED
Severity:	normal	CC:	keerthi.reddyb, sebsauer, swathi.vegesna999
Priority:	NOR
Version:	unspecified
Target Milestone:	---
Platform:	unspecified
OS:	All
Latest Commit:		Version Fixed In:
Sentry Crash Report:
Attachments:	testdata to be opened in kspread screenshot of the document in kspread screenshot of the document in msexcel Testdata screenshot with current master that shows that the colors are correct now Screenshot in tables.

Description David Faure 2010-05-28 03:31:54 UTC



---- Reported by lassi.ta.nieminen@nokia.com 2010-04-29 10:27:38 +0300 ----

Created an attachment
testdata to be opened in kspread

SOFTWARE VERSION:
  Kubuntu 9.10
  Koffice (svn version  1118926)
  svn://websvn.kde.org/home/kde/branches/work/koffice-ko
  Test document (MSOffice 2000):me00_clustered_bar_chart.xls

STEPS LEADING TO THE PROBLEM:
  1. Open the attached document MSOffice 2000
  2. Open the same document in KOffice.
  3. Observe the colors displayed in the chart

EXPECTED OUTCOME:
   Colors of the chart should be displayed correctly.
   see attachment ms00_chart_colors_msexcel.PNG

ACTUAL OUTCOME:
   Colors of the chart are not retained.
   see attachment ms00_chart_colors_kspread.png

FREQUENCY:
  Always

Note: Similar fix should be tested for all the chart types.



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-04-29 10:31:14 +0300 ----

Created an attachment
screenshot of the document in kspread



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-04-29 10:31:27 +0300 ----

Created an attachment
screenshot of the document in msexcel



--- Bug imported by faure@kde.org 2010-05-28 03:31  ---

This bug was previously known as _bug_ 166243.

Imported an attachment (id=47213)
Imported an attachment (id=47214)
Imported an attachment (id=47215)

Unknown bug field "example" encountered while moving bug
   <example>2010-04-29 10:31:27</example>

Comment 1 keerthi 2011-08-19 04:35:18 UTC

Attaching another test data with similar issue.

Comment 2 keerthi 2011-08-19 04:36:56 UTC

Created attachment 62968 [details]
Testdata

Comment 3 Sebastian Sauer 2011-08-30 13:20:06 UTC

Was fixed meanwhile. Note that there is a separate bug-report about the reverse order of the bars in a bar-chart and that problem is NOT part of this bugreport. This bugreport is about the colors and that's what got fixed and is correct now.

Comment 4 Sebastian Sauer 2011-09-13 13:46:20 UTC

Created attachment 63617 [details]
screenshot with current master that shows that the colors are correct now

Comment 5 keerthi 2011-12-09 05:29:06 UTC

Tested on fca6eaf7279acb92562ee4d4b7fb784554d58ac8.
Issue is reproducible for the second document*(pie chart) attached.

Screenshot attached.

Comment 6 keerthi 2011-12-09 05:31:00 UTC

Created attachment 66527 [details]
Screenshot in tables.

Comment 7 Sebastian Sauer 2011-12-09 11:44:03 UTC

Was fixed with commit f42d4150a94a4c2e2a3d8fe7bfc1290514db0a29 .

Comment 8 swathi 2011-12-21 10:42:28 UTC

Verified in b2b29030922345d8e727ed03e80fb77537aece46.