Menu

#885 ODS roundtrip: Charts - color not retained

Reg_(Old)_Excel
open
Charts (100)
6
2010-03-17
2009-02-24
dia-morh
No

Environment:
Windows 2003
Office 2007
AddIn for Office r5145

ODS -> XLSX -> ODS

files:
pie-chart.ods
_1.1_lineargrapher.ods

Most colors are properly converted, but for some reason, in few chart some colors are changed after roundtrip conversion:

1. file: pie-chart.ods
the white sector in pie-chart.ods is displayed in blue after roundtrip

2. _1.1_lineargrapher.ods
all lines changed color after roundtrip conversion.

3. SchaumAG.XLS.DE.ods, Sheet Umsatzbericht
all colors in the net chart at the bottom of the page changed

Discussion

  • dia-morh

    dia-morh - 2009-03-20

    Very much improved in r5221.
    Pies charts , donuts charts , column charts, and line charts work fine now!

    Only for net the colors and line styles a are not properly retained.

     
  • Ruth S.

    Ruth S. - 2009-08-10

    Win XP
    Office 2007
    R5248

    Compared to R5221, the conversion is worse again (same as in R5145)

    File pie-chart.ods, Sheet 1:
    The white sector is displayed in dark blue after the roundtrip conversion.

    File _1.1_lineargrapher.ods, Sheet Linear Grapher:
    All the lines are displayed in the wrong colour after roundtrip conversion.

    File SchaumAG.XLS.DE.ods, Sheet Umsatzbericht:
    All colours in the net chart are displayed wrong after roundtrip conversion.

     
  • Ruth S.

    Ruth S. - 2009-08-10
    • labels: 948401 --> Charts
    • priority: 5 --> 6
     
  • Ravindra(Sonata)

    • milestone: 777273 --> Reg_(Old)_Excel
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.