Bug 131114 - number / date format display error after formula
Summary: number / date format display error after formula
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.4.1 rc
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-03-04 09:07 UTC by stefm74
Modified: 2021-02-09 12:51 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

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

Note You need to log in before you can comment on or make changes to this bug.
Description stefm74 2020-03-04 09:07:53 UTC 
Description:
Depuis la mise a jour 6.3.5, j'ai un bug d'affichage : 
j'ai une cellule avec des calculs pour donner un nombre de jours, et j'ai un affichage en "date" que je ne peux pas modifier.
fonctionne normalement jusqu'à la version 6.3.4.1

Steps to Reproduce:
1.cellule E266 = 31/01/20
2.cellule O266 =SI(E266="";-1;SI(F266="";SI(G266="";JOURS( AUJOURDHUI();E266 );JOURS(AUJOURDHUI();G266));0))
3.

Actual Results:
01/02/00

Expected Results:
33


Reproducible: Always


User Profile Reset: No



Additional Info:
sur les anciennes versions (6.3.0.4) le résultat actuel s'obtient en appliquant le format date.
problème présent également sur la version 6.4
Comment 1 Oliver Brinzing 2020-03-06 17:53:15 UTC 
Description:
Since update 6.3.5, I have a display bug:
I have a cell with calculations to give a number of days, and I have a display in "date" that I cannot modify.
works normally up to version 6.3.4.1

Steps to Reproduce:
1.cell E266 = 1/31/20
2.cell O266 = IF (E266 = ""; - 1; IF (F266 = ""; IF (G266 = ""; DAYS (TODAY (); E266); DAYS (TODAY (); G266)); 0) )
3.

Actual Results:
02/01/00

Expected Results:
33


Reproducible: Always


User Profile Reset: No

Additional Info:
on older versions (6.3.0.4) the current result is obtained by applying the date format.
problem also present on version 6.4
Comment 2 Oliver Brinzing 2020-03-06 17:54:08 UTC 
Thank you for reporting the bug. 

To be certain the reported issue is not
related to corruption in the user profile, could you please reset your
Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and
re-test?

If the problem still persists, please attach a sample document, as this makes it easier for us to verify the bug. 
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Comment 3 stefm74 2020-03-09 10:40:17 UTC 
le problème ne s'est pas résolu en reinitialisant le profil.
j'ai créé un nouveau classeur, copié les feuilles et ça fonctionne normalement?!?
Comment 4 Xisco Faulí 2021-02-09 12:51:33 UTC 
Thanks for retesting the issue with the latest version.
Setting to RESOLVED WORKSFORME since the commit fixing this issue hasn't been
identified.