Issue 125669

Summary: Number format problem with cumipmt_add and cumprinc_add
Product: Calc Reporter: Oliver Specht <os_ooo>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3    
Version: 4.1.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

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.