Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index

On 2022/08/09 14:53, Johnny Rosenberg wrote:

Den tis 9 aug. 2022 kl 12:26 skrev Hylton Conacher (ZR1HPC) < <>>:

    Hi Johnny,

    On 2022/08/08 22:19, Johnny Rosenberg wrote:
     > Den mån 8 aug. 2022 kl 21:47 skrev Hylton Conacher (ZR1HPC)
     > < <>
    < <>>>:
     >     Hi,
     >     Using LO Calc and I have a 28 column table RAW Data
    table in
     >     excess of 65k rows. A three column sample below:
>     Date                            Simple Date  Outdoor Temp
     >     2022-01-01T00:05:00+02:00       2022-01-01 00:05:00     17.5
     >     2022-01-01T00:00:00+02:00       2022-01-01 00:00:00     17.4
     > Are those dates numbers formatted as dates or just text?

    The Date column is formatted as number and the simplified Date is
    formatted as text.

    Is VLOOKUP fussy about the format of the cells it must search? I
    it is just matching a string of characters?

It's not fussy about the format, but rather about the actual value in the cells, because if it's formatted as a date, it's really just a number (0.0 = 1899-12-30 00:00:00 and so on....

The tab called Raw Data is actually a .csv import of an external file on which I have no ability to determine how the columns are formatted. As time progresses so I will download another .csv file and overwrite the existing one with an updated file.

The bits that contain any formula will remain unchanged, apart from having their ranges extended due to the additional rows added.

But I wonder about the other column that is formatted as text. What do you mean by that?

I clicked on one of the cells in the Simple Date column and selected 'Format->Cell' and it returned that is how it was formatted.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.