Issue 27449 - complex functions of german Calc return values including "." as decimal seperator istead of ","
Summary: complex functions of german Calc return values including "." as decimal seper...
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-04-05 11:09 UTC by norbert2
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

complex.sxc (5.64 KB, application/vnd.sun.xml.calc)
2004-04-05 11:10 UTC, norbert2
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description norbert2 2004-04-05 11:09:58 UTC
The complex functions of german Calc return values including "." as decimal 
seperator istead of ",".

Please open the attached spreadsheet with german Calc version:

The blue cell sums the both values in the white cells, using the built-in 
function "IMSUMME":
"110.34+5.2i", but "110,34+5,2i" would be correct for german version of Calc.

(Maybe other language Calc versions that should use "," as decimal seperator 
have the same problem.)
Comment 1 norbert2 2004-04-05 11:10:33 UTC
Created attachment 14335 [details]
Comment 2 frank 2004-04-06 08:54:03 UTC
Hi Niklas,

as a German Excel displays the imaginary numbers with a comma as decimal
Separator, we should do it in the same way. Also and in my opinion more
relevant, a function result under german locales has to be displayed using the
german separators even if they are results from imaginary numbers.

Comment 3 niklas.nebel 2004-04-06 09:11:55 UTC
No, function results shouldn't depend on the language of the installation. They
never do. Making it dependent on the system locale seems like a bad idea, too.
It would potentially affect further calculations using the result. This is very
different from the formatting (for display only) of a numeric result.
Comment 4 frank 2004-04-06 09:14:47 UTC
Hi Falko,

it's your turn now.

I think we have to implement a 'view' for imaginary function results to display
with the correct decimal separators.

Comment 5 norbert2 2004-04-06 11:16:08 UTC
The complex function's can be given over values with "." OR "," as decimal 
seperator. Only the return-values are always displayed with ".".

So, I think, if one complex function gives its value with "," to another 
complex function should be not a problem.

So, Niklas, why is it a problem to make the display dependent on the program-
language, like Frank has suggested?
Comment 6 falko.tesch 2004-04-07 08:51:20 UTC
FT: Yes, we could think about this - but not in this relaese.
Please make an RFE out of this issue with target "Office Later" and assign it to
BH. Thx.
Comment 7 frank 2004-04-07 10:03:13 UTC
Set the flags according to Falkos decission.

Comment 8 bettina.haberer 2010-05-21 15:13:14 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".