The extension does work.
The problem is that there is a BUG in the Trim functions when handling
numbers.
If you do =TRIM(" Testing Trim ") and copy and Paste Special as Text to
another cell, you get "Testing Trim" (without quotes)
However if you do =TRIM("1.25 ") you get 1.25 as expected but not if you
do =TRIM(1.25 ), which is the same as doing =TRIM(A1). In this case the
spaces are not trimmed so you get "1.25 " (without quotes) again...
So apparently TRIM is not adding the quotes as expected :)
Fixing this probably allows to use the Extension and make your users happy
:)
--
View this message in context:
http://nabble.documentfoundation.org/Converting-text-to-numbers-tp2032297p2033692.html
Sent from the Users mailing list archive at Nabble.com.
--
Unsubscribe instructions: E-mail to [email protected]
List archive: http://www.libreoffice.org/lists/users/
*** All posts to this list are publicly archived for eternity ***
