XLSX: Cell format "Accounting" not retained after roundtrip

Brought to you by: agnieszkab, annerose, dia-jen, diamakz, and 21 others

#407 XLSX: Cell format "Accounting" not retained after roundtrip

Milestone: Out_of_scope

Status: open

Owner: Pradeep Nemadi

Labels: Format Cell (15)

Priority: 6

Updated: 2009-05-25

Created: 2007-08-20

Creator: Nils Haffke

Private: No

Environment:
Windows 2003 / Office 2007
r3353 AddIn
XLSX->ODS

Severity: Irritating

Type of bug: Conversion

Filename: Reise.DE.xlsx

Sheetname: all

Problem:
Cell format "Accounting with 2 decimal places" is translated to "Currency".
The format is not retained after roundtrip conversion (open in Excel, save as ODF, open ODF in Excel).

Discussion

Nils Haffke - 2007-08-23

Logged In: YES
user_id=1820706
Originator: YES

After open in Excel, save as ODF, open ODF in Excel --> Format will be "General"

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Miroslaw Czenczak - 2007-08-28

assigned_to: karolinazw --> kkoscielniak
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Krzysztof Kościelniak - 2007-08-31

assigned_to: kkoscielniak --> karolinazw
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Nils Haffke - 2007-09-18

Logged In: YES
user_id=1820706
Originator: YES

Still occurs with r3601 !

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dirk Vollmar - 2007-10-04

priority: 7 --> 6
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

A. Hümbert - 2008-02-08

milestone: 691625 --> Out_of_scope
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dieter - 2008-03-12

Logged In: YES
user_id=1878471
Originator: NO

r4411 (add-in)

Problem still exists.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

befr - 2008-10-14

R4840 Add-In
see also
Filename: MS_Kalkulace_Campus_Agreement.xlsx
Sheetname: all

after roundtrip cell format accounting is translated either to percentage or to number

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dieter - 2008-11-26

r4980
OOx->ODF->OOX (roundtrip)
file:Berechnungen mit zwei Bereichen_mica.xls
sheet Berechnng (1)

Same Problem

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Ruth S. - 2009-05-18

R5239
Office 2007

Problem persists.

File: Reise.DE.xlsx
Source: Accounting with 2 decimal places
Single conversion: Currency
Roundtrip: Number with 0 decimal places

File: MS_Kalkulace_Campus_Agreement.xlsx
Source: Accounting with 2 decimal places
Single conversion: Currency
Roundtrip: Percentage with 0 decimal places or Number with 2 decimal places

File: Berechnungen mit zwei Bereichen_mica.xls
Source: Accounting with 2 decimal places
Single conversion: Number with 2 decimal places
Roundtrip: Percentage with 0 decimal places

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Ruth S. - 2009-05-18

labels: 953526 --> Format Cell
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Ruth S. - 2009-05-25

assigned_to: karolinazw --> pradeepgn
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dieter - 2010-05-21

R5293

Bug persists.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.