https://bugs.documentfoundation.org/show_bug.cgi?id=100529
--- Comment #3 from Kolbjørn Stuestøl <[email protected]> ---
A simple example:
Using it for weather statistics to find the first occurrence of frost in
autumn.
In a spreadsheet A contains the date of the month starting from A1, B contains
the temperature measured the corresponding day.
My workaround in this example is:
Copy the dates from A to D.
In C1 write “= IF(B1<0;1;0)” and fill this down to the end of the month (row
31).
In A33 insert “VLOOKUP(1;C1:D31;2;0)”.
To get the last day with frost I have to sort a copy of my tables descending
(dates 31 to 1) before using the same procedure as mentioned above.
(Of course I have to do a bit more coding to avoid “#N/A” in A33 if no frost
the particular month).
Download simplified example from: http://www.stuestoel.no/temp/FIND.FIRST.ods
I know that the developers have plenty to do, but I hope someone will give this
suggestion a thought. It is no problem to write (simple) workarounds for many
of the functions already in use, so I do not think a function is unnecessary
only because it is possible to write workarounds. (For example the first
function in the function list: ABS(A1) can be written as IF(A1<0;A1*-1;A1)).
But if I am the only one in the world in need for such a function, it is of
course a good reason to close it.
Kolbjørn
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
