Bug 80982 - FILESAVE: Numbers with decimal places switch to displaying "###" after a save or autosave
Summary: FILESAVE: Numbers with decimal places switch to displaying "###" after a save...
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.1.5.3 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-07-06 20:31 UTC by emefbee
Modified: 2014-07-19 01:19 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments

Description emefbee 2014-07-06 20:31:06 UTC
Problem description: 

Numbers with decimal places switch to displaying "###" after a save or autosave. It can be corrected by using the menu of cell formatting and setting 1 decimal place there. It only stays so until next autosave.

When the displaying of those cells contents/results is OK, those cells also ignore a button that tells them to decrease the number of decimal places. But pressing a button to increase the number of decimal places suddenly makes them jump up to a single decimal place. This is in a sheet that has been copied via the sheet copy feature.

The cells in question have a simple equation "=H11/2", etc.

Steps to reproduce:
1. ....
2. ....
3. ....

Current behavior:
as above


Expected behavior:
spreadsheet software should NEVER EVER change the contents of the spreadsheet tables and properties willy nilly on its own.
              
Operating System: Ubuntu
Version: 4.1.5.3 release
Comment 1 tommy27 2014-07-18 23:29:07 UTC
the 4.1.x version you are using is end-of-life
try upgrading to 4.2.5.2 and tell if issue persists
Comment 2 Joel Madero 2014-07-19 01:19:30 UTC
Please at least provide the sample document. Marking as NEEDINFO.

Once you attach a sample document (and hopefully test against 4.2) - set the bug to UNCONFIRMED. Thanks


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.