Bug 125593

Summary:	oocalc2 can't read KSpread currency format
Product:	[Applications] calligrasheets	Reporter:	Michael Pyne <mpyne>
Component:	opendocument	Assignee:	Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null>
Status:	CONFIRMED ---
Severity:	normal
Priority:	NOR
Version:	unspecified
Target Milestone:	---
Platform:	unspecified
OS:	Linux
Latest Commit:		Version Fixed In:

Description Michael Pyne 2006-04-14 20:44:34 UTC

Version:           1.5 (using KDE 3.5.2, compiled sources)
Compiler:          Target: i686-pc-linux-gnu
OS:                Linux (i686) release 2.6.15.3

When I set the format to some of my cells in a .ods spreadsheet to Currency - Dollar (United States), and then try to open the resulting document in OO.o calc 2, oo.o calc simply doesn't display anything in the cell (the rest of the formatting, colors, borders, etc. is fine).

I also tried using the "USD - United States Dollar" near the bottom of the format list, with the same results.

Comment 1 Elián Hanisch 2008-11-02 21:21:07 UTC

i can confirm in trunk, if I write $32 in both A1 and B1, then set A1 cell format to 'money' (leave B1 as is) and save as ods, when you open it with calc you see 32.00$ in A1 and 32 in B1. I should be $32.00 or $32 I think

Comment 2 Justin Zobel 2021-03-09 22:43:42 UTC

Thank you for the bug report.

As this report hasn't seen any changes in 5 years or more, we ask if you can please confirm that the issue still persists.

If this bug is no longer persisting or relevant please change the status to resolved.