Groups | Search | Server Info | Login | Register
Groups > comp.apps.spreadsheets > #79
| From | Eike Rathke <erack-nutznetz.n@posteo.de> |
|---|---|
| Newsgroups | comp.apps.spreadsheets |
| Subject | Re: Long spreadsheets |
| Date | 2018-11-18 01:17 +0000 |
| Organization | possibly |
| Message-ID | <N3e8I5bf0bd5bT7352@kulungile.erack.de> (permalink) |
| References | (2 earlier) <ed71b486-2940-4c29-9434-9dd6fbe288cb@googlegroups.com> <N3e8I5be80c80T2101@kulungile.erack.de> <34e6b875-6965-4cac-8701-f9856ea50204@googlegroups.com> <N3e8I5be8b66fT32c7@kulungile.erack.de> <5bf010fb$0$22362$e4fe514c@news.xs4all.nl> |
* Luuk, 2018-11-17 13:00 UTC:
> 1) 12/30/1899 (default)
> And the strange thing is that EXCEL uses '31 december 1899'
Excel thinks there was 1900-02-29 which of course there was not.
> (actually EXCEL only supports dates starting from the year 1900)
> DATAVALUE("01-01-1900") returns 1 in Excel
> DATAVALUE("01-01-1900") returns 2 in LibreOffice
So with the null date shifted back by one day in LibreOffice dates
starting from 1900-03-01 have equal date serial numbers.
Eike
--
OpenPGP/GnuPG encrypted mail preferred in all private communication.
GPG key 0x6A6CD5B765632D3A - 2265 D7F3 A7B0 95CC 3918 630B 6A6C D5B7 6563 2D3A
Use LibreOffice! https://www.libreoffice.org/
Back to comp.apps.spreadsheets | Previous | Next — Previous in thread | Find similar
Long spreadsheets dr.s.lartius@gmail.com - 2018-11-06 15:29 -0800
Re: Long spreadsheets Luuk <luuk@invalid.lan> - 2018-11-07 14:55 +0100
Re: Long spreadsheets Eike Rathke <erack-nutznetz.n@posteo.de> - 2018-11-10 19:09 +0000
Re: Long spreadsheets Eike Rathke <erack-nutznetz.n@posteo.de> - 2018-11-10 19:09 +0000
Re: Long spreadsheets dr.s.lartius@gmail.com - 2018-11-10 14:56 -0800
Re: Long spreadsheets Eike Rathke <erack-nutznetz.n@posteo.de> - 2018-11-11 11:04 +0000
Re: Long spreadsheets dr.s.lartius@gmail.com - 2018-11-11 04:04 -0800
Re: Long spreadsheets Eike Rathke <erack-nutznetz.n@posteo.de> - 2018-11-11 23:08 +0000
Re: Long spreadsheets Luuk <luuk@invalid.lan> - 2018-11-17 14:00 +0100
Re: Long spreadsheets Eike Rathke <erack-nutznetz.n@posteo.de> - 2018-11-18 01:17 +0000
csiph-web