Groups | Search | Server Info | Login | Register

Groups > comp.apps.spreadsheets > #79

Re: Long spreadsheets

Path csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From Eike Rathke <erack-nutznetz.n@posteo.de>
Newsgroups comp.apps.spreadsheets
Subject Re: Long spreadsheets
Date 18 Nov 2018 01:17:19 GMT
Organization possibly
Lines 19
Message-ID <N3e8I5bf0bd5bT7352@kulungile.erack.de> (permalink)
References <145c6eb1-d7ea-4b42-8cf9-5b2187042936@googlegroups.com> <N3e8I5be72ac8T2d61@kulungile.erack.de> <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>
X-Trace individual.net 4a9zX0XMejFiFqsPDLNiLwpj0nCv8TTQrhoS4RdkF8Yu0IxwM=
Cancel-Lock sha1:k1Ig4mXONSx9ZWjoQLzJoWRQ/W8=
X-Accept-Language de,en
X-PGP-Hash SHA256
X-PGP-Key 0x6A6CD5B765632D3A
X-PGP-Sig GnuPG-v2 From,Newsgroups,Subject,Message-ID iQIzBAEBCAAdFiEEImXX86ewlcw5GGMLamzVt2VjLToFAlvwvVsACgkQamzVt2Vj LTo3vBAAmpBK6TBdfpf3BZyeelGoPxai29stVdlvibRH+OAvymobUoy8ouLI/4Jl rOAwfjZW0HvttnlAZB4K+YYVcgxXj58y0omZaWfpquZscvpxNN/5TA7zl7AiJshZ zAAFBDDa4dCgxDAWkBgnUiEyT3wixJ+dMachueBLePSGrQC55V1HJC7RAVNBhigS qlj1mQtb3pWtjNK4sT9wUjmDnx44u0ZwfT+SMpNk/4DpqBNWDlhP/mS718Sy52bX lLfj6G3cZaDCfnLKXSdI0tL3xyuEFjt6fuw+3ljtKEfKMeQg88N/e7JysMEft3ej hi7RPpp22ezOCaxZnVjlu42dzINlXSq8pjlvduxH7EKMlrh+pSjaUyVtbA+BgW7f x/U+4HcoQSMI3eqaa+2L2Zs+Za6GUdwXskIonzKMTeSsjv87MN5kIKk7sE1HamHb CwMFEXFPBKtKSYhavYfLAaMjZQd8ObvnNL16rJjpsO20UbsIkrEbWUJQ/3Ey/IUp b6EJCkBxHzGPKx6h5ZAaVW3DQzlqlayrSwkds8HyvD2QfROLGaepuOoGS6WsQvQK LKkYAdlL9ka02HrSWLekRkDaPM/hqxuky3asO8yZ/aowGpb5f8r6xSSPP3Xh6mq0 D88g9pjbAbW6xF9F6ll3IaItcx0LzgppYSjgZQRi0PUdCPMxVjo= =c9Ck
User-Agent slrn/1.0.3 (Linux)
Xref csiph.com comp.apps.spreadsheets:79

Show key headers only | View raw

* 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

Thread

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