Bug 94510 - Validity list of dates converted to numbers inside list
Summary: Validity list of dates converted to numbers inside list
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
Reported: 2015-09-25 15:31 UTC by Marcelo
Modified: 2020-10-07 11:54 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:

validity list shows date as general numbers (9.72 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-09-25 15:31 UTC, Marcelo

Note You need to log in before you can comment on or make changes to this bug.
Description Marcelo 2015-09-25 15:31:03 UTC
Created attachment 119024 [details]
validity list shows date as general numbers

Supose you create two named ranges:
- one constant 'fixed_range' ranges from: $Sheet1.$A$3:$A$30
- second dynamic size 'dynamic_range' ranges using this formula: $Sheet1.$A$3:INDEX($Sheet1.$A$3:$A$30,COUNT($Sheet1.$A$3:$A$30))

Let's say the data are formatted as date.
Create two validaty cells which items are linked to names 'fixed_range' and 'dynamic_range'.

When you open dynamic_range list the date are shown as general numbers not on date format actually.
Comment 1 raal 2015-09-26 16:54:34 UTC
I can confirm with Version:
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e
and Version:
Build ID: 83ef294dddf3b1ab5cd5f91a792a7d9413a08f1f
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-09-20_07:00:46
Comment 2 QA Administrators 2016-11-08 10:33:33 UTC Comment hidden (obsolete)
Comment 3 ThierryT 2016-12-17 16:56:57 UTC
I confirm that the bug still exists on version :

Version: (x64)
Build ID: 8783ba61dfea562444cb6390e69aa8b3c5e91156
Threads CPU : 4; Version de l'OS :Windows 6.29; UI Render : par défaut; 
Locale : fr-FR (fr_FR); Calc: group
Comment 4 QA Administrators 2018-07-07 02:39:28 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2020-07-07 03:38:29 UTC Comment hidden (obsolete)
Comment 6 NISZ LibreOffice Team 2020-10-07 11:52:15 UTC
Still a problem in:

Version: (x64)
Build ID: a883002d8e2fd77f80c43b7b2e6ac329d83d929d
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL