| Summary: | loss of date formatting in ods | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Romulo <romulomendesfigueiredo> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | major | CC: | jmadero.dev, sophi |
| Priority: | medium | ||
| Version: | 4.1.4.2 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Document to reproduce the possible bug | ||
Hi, TODAY() is set to return the system date, this is why it sends a date back I guess, your formula should be =DAYS(C2;TODAY()), but it should not be possible to set a number format, have the correct count and then lose it after. So set to New - Sophie Ubuntu 15.04 x64 LibreOffice 5 Version: 5.0.0.0.alpha1+ Build ID: 7d890d0482abb8e051144d8177917c21844638c3 Locale: en-US (en_US.UTF-8) I cannot reproduce this. If I download the file - C3 is already set to Number, if I change it, then change it back to Number, save, close, and reopen. the Number format is retained. Setting to WFM. @Romulo - if you can reproduce this on 4.4.3 or newer please set back to NEW and give us an updated comment (your OS and LibreOffice version). Thanks! |
Created attachment 96752 [details] Document to reproduce the possible bug Problem description: When open an document lost formatting in cell Steps to reproduce: 1. Open the documento days.ods 2. Go to C3 cell 3. Press Ctrl + 1 4. Choose number format 5. Save and close the document 6. Open and... the cell format is equals to date not equals number... Current behavior: 01/03/00 (DD/MM/YY) Expected behavior: Cell C3 equal to 61 uname -a Linux Notebook 3.2.0-4-amd64 #1 SMP Debian 3.2.54-2 x86_64 GNU/Linux