Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#304 ODS-Charts-Data Lable-Show as percent not supported in XLSX

open
Dieter
5
2008-10-20
2008-10-20
Pradeep Nemadi
No

Data label value shows as percentage is not supported in Excel.

In Excel, number format can be applied on the data value.
So from conversion from ods to xlsx, if value is set as "value as percent", percentage number format will be set for that value. Value wont be converted to percentage.

for example, if in ods file, value "11232" is set as "show value as percent", it will be displayed as 35%
The same is not supported by excel.
Only number format can be set in excel(i.e 11232%)

The same doesn't retain in internal conversion(i.e ods-xls-xlsx)

Discussion

  • Pradeep Nemadi
    Pradeep Nemadi
    2008-10-20

    Input ods file

     
  • Pradeep Nemadi
    Pradeep Nemadi
    2008-10-20

    File Added: Chart Properties 4SAVEAS.xls

     
  • Pradeep Nemadi
    Pradeep Nemadi
    2008-10-20

    Ods file saved as xls file

     
  • Pradeep Nemadi
    Pradeep Nemadi
    2008-10-20

    File Added: Chart Properties 4SAVEAS.xlsx

     
  • Pradeep Nemadi
    Pradeep Nemadi
    2008-10-20

    Show value as percent is supported by pie charts only in excel.
    for column chart is not supported.

     
  • Pradeep Nemadi
    Pradeep Nemadi
    2008-10-24

    Correction: Show value as percent is not supported by charts other than pie chart in excel. so if data label value is set as "show values as percent" in ods file, only value will be retained in xlsx file for charts other than pie chart. And in round trip file(ods>xlsx>ods), value will be set as "show as value".