[libreoffice-users] Calc trumps Excel

Thought I'd share an interesting experience.

I've been trying to use Office 2007 at my new job. (It is a bit of a
struggle. I'd rather use Office 2003.)

I imported a tab-delimited file into Excel without a problem. One of
the fields was in MM/DD/YYYY HH:MM tt format. I wanted to divide the
one field into a YYYY-MM-DD field and an H:MM field. Excel could NOT
do it. It could separate the fields, but Excel *insisted* they had to
be text fields (with the apostrophe mark in front). Neither the VALUE
nor the DATEVALUE fields worked.

After several minutes of being stymied, I installed LO and launched
Calc. The same formulas that didn't work in Excel, worked in Calc just
as I wanted.

So score one for Calc being able to do the job when Excel failed miserably.


-- 
T. R. Valentine
Your friends will argue with you. Your enemies don't care.
'When I get a little money I buy books; and if any is left I buy food
and clothes.' -- Erasmus

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