Ask Your Question
0

Why does =FIND("Company","Company") return 31/12/99 [closed]

asked 2014-11-07 22:41:22 +0100

william1835 gravatar image

updated 2016-03-05 22:03:02 +0100

Alex Kemp gravatar image

In a Libreoffice Calc I do =FIND("Company","Company") and it returns 31/12/99. Is this supposed to happen and what is the expected outcome? Thank You Version 4.3.3.2 OS: Ubuntu 14.10

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-05 22:03:16.828782

1 Answer

Sort by » oldest newest most voted
0

answered 2014-11-07 23:22:54 +0100

karolus gravatar image

updated 2014-11-07 23:28:00 +0100

The expected return-Value is 1 but the dumb user in Front of the Keyboard has formatted the FormulaCell as Date - so 1 is showed as first Day since Day Zero at 30 Dez 1899

edit flag offensive delete link more

Comments

You mean 'dumb'.

rautamiekka gravatar imagerautamiekka ( 2014-11-07 23:23:59 +0100 )edit
karolus gravatar imagekarolus ( 2014-11-07 23:29:47 +0100 )edit

I never formatted the cell!

william1835 gravatar imagewilliam1835 ( 2014-11-08 22:30:01 +0100 )edit

@william1835
who else ??

karolus gravatar imagekarolus ( 2014-11-11 09:46:05 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2014-11-07 22:41:22 +0100

Seen: 39 times

Last updated: Nov 07 '14