Issue 125669 - Number format problem with cumipmt_add and cumprinc_add
Summary: Number format problem with cumipmt_add and cumprinc_add
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.1.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-09-24 08:50 UTC by Oliver Specht
Modified: 2014-09-24 08:50 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Oliver Specht 2014-09-24 08:50:54 UTC 
Other than cumipmt/cumprinc the functions cumipmt_add and cumprinc_add result in values _not_ formatted as currency. 

This is documented in
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_CUMIPMT_ADD_function
and
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_CUMPRINC_ADD_function

But if the file is stored and reloaded the *_ADD functions are not only converted to there versions without the '_ADD' but also the number format is changed to currency.