Bug 330872

Summary: Cell as percentage is incompatible with other spreadsheet programs
Product: [Applications] calligrasheets Reporter: Antonis G. <gaantonio>
Component: opendocumentAssignee: Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null>
Status: RESOLVED WORKSFORME    
Severity: normal    
Priority: NOR    
Version First Reported In: 2.7.5   
Target Milestone: ---   
Platform: unspecified   
OS: Linux   
Latest Commit: Version Fixed/Implemented In:
Sentry Crash Report:
Attachments: The original file created by calligra sheets
Same file edited with libreoffice

Description Antonis G. 2014-02-07 04:09:21 UTC 
In a cell I used the button with the percent icon "%" (located in the cell formatting tab under number format) to make numbers as percentages, instead of manullaly multiplying by 100. This however was not correctly recognized with libreoffice calc.

Reproducible: Always




Note that files edited with libreoffice calc are backwards compatible with calligra, but not the opposite.
Comment 1 Antonis G. 2014-02-07 04:10:59 UTC 
Created attachment 85025 [details]
The original file created by calligra sheets
Comment 2 Antonis G. 2014-02-07 04:11:25 UTC 
Created attachment 85026 [details]
Same file edited with libreoffice
Comment 3 Antonis G. 2016-02-01 21:25:10 UTC 
Works in current version of Calligra, so closing.