Bug 239754 - kspread:msoffice2000: Correct colors of the chart are not retained in kspread
Summary: kspread:msoffice2000: Correct colors of the chart are not retained in kspread
Status: VERIFIED FIXED
Alias: None
Product: calligrachart
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: unspecified All
: NOR normal
Target Milestone: ---
Assignee: Inge Wallin
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-04-29 09:27 UTC by Lassi Nieminen
Modified: 2011-12-21 10:42 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
testdata to be opened in kspread (22.50 KB, application/vnd.ms-excel)
2010-04-29 09:27 UTC, Lassi Nieminen 		Details
screenshot of the document in kspread (167.63 KB, image/png)
2010-04-29 09:31 UTC, Lassi Nieminen 		Details
screenshot of the document in msexcel (107.06 KB, image/png)
2010-04-29 09:31 UTC, Lassi Nieminen 		Details
Testdata (20.50 KB, application/octet-stream)
2011-08-19 04:36 UTC, keerthi 		Details
screenshot with current master that shows that the colors are correct now (56.20 KB, image/png)
2011-09-13 13:46 UTC, Sebastian Sauer 		Details
Screenshot in tables. (150.23 KB, image/x-png)
2011-12-09 05:31 UTC, keerthi 		Details
View All Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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.