[libreoffice-users] Re: Calc trumps Excel

T.R. Valentine

When you open a tab delimited file in Excel it automatically recognizes the
data types. Therefore your string e.g. 2011-02-26 10:23:47 is correctly
interpreted as a value. Therefore it is natural that using FIND, VALUE, LEFT
or any other functions would not work.

As I said in the previous post you need to use other functions.

LibO and OOo don't have any problem with tab delimited files. The only
difference is that you can not Open a tab delimited file (otherwise it is
loaded in Writer). You need to Insert, Sheet from File.

Luuk

Indeed there is a lot of work... I just found another bug: typing =now() in
a cell shows the value instead of a date (of course you can format it
yourself...)

-- 
View this message in context: 
http://nabble.documentfoundation.org/Calc-trumps-Excel-tp2573005p2581181.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***