Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Eike Rathke Newsgroups: comp.apps.spreadsheets Subject: Re: Long spreadsheets Date: 11 Nov 2018 23:08:54 GMT Organization: possibly Lines: 29 Message-ID: References: <145c6eb1-d7ea-4b42-8cf9-5b2187042936@googlegroups.com> <34e6b875-6965-4cac-8701-f9856ea50204@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: individual.net MBCKKS9JUg3N//wzCbKZiAksaeCUczpCre7rRYVvgaufQV8xM= Cancel-Lock: sha1:wDNq3PynZo6hPkUS7Vuj5+1PZYE= X-Accept-Language: de,en X-PGP-Hash: SHA256 X-PGP-Key: 0x6A6CD5B765632D3A X-PGP-Sig: GnuPG-v2 From,Newsgroups,Subject,Message-ID iQIzBAEBCAAdFiEEImXX86ewlcw5GGMLamzVt2VjLToFAlvotnAACgkQamzVt2Vj LTpoiQ/+K9lDJat4hhFdsGrGJqxH2uGvfixUYw14X/MNdLpEhuP4vYu2zOEVGpwr UlQwTYqMqh6hGGRdnb8wHsTtE8VacEE0ECXIa5KCjEOxK5wxZ/Yt5bCGK/nxw/AQ 6Weoh76pIPRY6jukKP3zXZokotstQqx6E7cyoeIBT6veW5QytFXRzr2i8YYbh1qR sC/LPQEsb3uLc5MqLsXJCMghCgHS89JdzEi04ToQyqOKONOFcr3qWvB4JT7v8mHr KxS/9VQBLflEYVA6oX45ua5bnFzP/zW5shStAFNLABPViD8rx6L4HnwIWXLU67mI 2JCidBgYKi6Zn38iELNxSBcdEE8SdN7yY32+jDQiYQR8PDvsY73qlPmnplLjtJ4K 19pTeTfsCdzAIX0VzS9axb5hH2BnSlKdcIPjkpDsU9VMvJPDvj369LvCGGOPiPya Lyu7q1W/WmGhkQ7zY04qtNYRrToJEjJ9fbKuGclQPeGG1G6Q2ky40sJfpnkl4WBE NL4YlMlZJkLu0Ax0ugwN+H7xrL8/NvSqclYXYT8GeUuyi4kLIT2Rpjcb9+qHlucq 6aW6PditbnpxCPoRQfzKObLq3klnuvuOzoBNNXrb9KWIuxibisqJlYTsxwkdpwnZ YOnGH1up7H+rFKS4GQ9TfyJhvJoX04vliZ1+zaF8lP88uzAtnjI= =tvBF User-Agent: slrn/1.0.3 (Linux) Xref: csiph.com comp.apps.spreadsheets:77 * dr.s.lartius@gmail.com, 2018-11-11 12:04 UTC: >> In the context of spreadheets though any numeric input without >> separators is a number. > No; I type 33333 into my first column, and see 1999-04-05 appear; That is because dates(+time) are formatted date serial numbers, 33333 days since the null-date, which is 1899-12-30. > I type 9 into my third column, and see £9.00 appear. Because the cell is formatted with a *display* format of [$£-809]#,##0.00 or some such. > I believe that they are stored as IEEE Doubles; Yes. > but the cells know what the number should mean. The cell knows what the number should be displayed as. Display formats are not input masks. 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/