Bug 134496 - Calculation sheets. Cells with format: Dec. 31. 1999. . In the month of May, it appears: ###, if the day has 2 digits.
Summary: Calculation sheets. Cells with format: Dec. 31. 1999. . In the month of May, ...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.4.2 release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-07-04 09:25 UTC by NEtapa
Modified: 2020-11-01 08:18 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Contains the example of the error, if the date is less than May 10, all correct, because the day has less than 2 digits. (9.68 KB, image/png)
2020-07-04 09:30 UTC, NEtapa 		Details
View All 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 NEtapa 2020-07-04 09:25:33 UTC 
Description:
Good day:

In the spreadsheets, if the date format is not numerical, and it is from May: 05/10/99, 05/10/1999, etc.

Three ### appear in the cell, if day has two digits.

Regards.

Steps to Reproduce:
Put the cell, with any non-numeric date format, for example: 31. dec. 1999

Actual Results:
Put the cell, with any non-numeric date format, for example: 31. dec. 1999

Expected Results:
10. may. 2020


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: es
Module: StartModule
[Information guessed from browser]
OS: Mac OS X (All)
OS is 64bit: no
Comment 1 NEtapa 2020-07-04 09:30:52 UTC 
Created attachment 162630 [details]
Contains the example of the error, if the date is less than May 10, all correct, because the day has less than 2 digits.
Comment 2 m_a_riosv 2020-07-06 20:51:28 UTC 
An image in this case doesn't help, please attach a spreadsheet sample file.
Comment 3 b. 2020-11-01 08:18:48 UTC 
hello @NEtapa, 

normally such sign - '###' - appears if the column is too narrow to display the value with the selected font and size and format and zoom ... 

just try widening the column, 'optimal column width' or similar, 

setting 'wfm', pls. reopen if i'm wrong,