https://bugs.documentfoundation.org/show_bug.cgi?id=146167
Bug ID: 146167
Summary: =INDEX returns unknown numbers when a column with date
formatted data is in the cells.
Product: LibreOffice
Version: 7.2.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 176844
--> https://bugs.documentfoundation.org/attachment.cgi?id=176844&action=edit
Spredsheet with bug displayed
=INDEX(Sheet1.A1:$B$10)
or
=INDEX(Sheet1.$A1:$A10;1;1)
With date formatted data in the cells returns unknown numbers in the A2 and A3
cells. As demonstrated below. I rebooted my pc to make sure my memory was
working correctly. Nothing changed.
Date
44538
44536
12/04/2021
12/01/2021
11/29/2021
11/27/2021
11/24/2021
11/22/2021
11/20/2021
11/17/2021
11/15/2021
11/13/2021
11/10/2021
11/08/2021
11/06/2021
11/03/2021
11/01/2021
10/30/2021
10/27/2021
10/25/2021
10/23/2021
10/20/2021
10/18/2021
10/16/2021
10/13/2021
10/11/2021
10/09/2021
10/06/2021
10/04/2021
10/02/2021
09/29/2021
--
You are receiving this mail because:
You are the assignee for the bug.
