Groups | Search | Server Info | Login | Register

Groups > comp.apps.spreadsheets > #77

Re: Long spreadsheets

Show all headers | View raw

* 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/

Back to comp.apps.spreadsheets | Previous | Next — Previous in thread | Next 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