Convert Text To Number

(0 votes)
TextToNumber_0.png

ConvertTextToNumber replaces numbers that are formatted as text, with real numbers and also marks the cells with a colour. This only on the active sheet. As a result formulas that use such cells, will be calculated in Calc. Calc does not use cells, with numbers formatted as text, in formulas. Other spreadsheet programs may well do that.
This extension adds the tool bar 'CT2N' to Calc.

Download extension
Operating System: System Independent
Official release: 0.9.2
Date: 2008-Feb-14
Size: 20.6 KB
License: opensource | Read license
Further product information: Product details
Provider: Nou&Off

Comments

Text to Column & Column to text

Hi, this is a great extension for OO. But is there any extension can use for column to text?

column to text

Thanks for the compliment.
reg. your question: is it this one from OOoMacro's:
http://www.ooomacros.org/user.php#104183 ?

Pls note that OOo 2.4.0 (RC2 is on it's way) will hold that function.
See the draft info:
http://wiki.services.openoffice.org/wiki/New_Features_2.4#Calc_2

Regards,
Cor

Nothing happens

Hi!

I tried this extension on spreadsheet converted from Excel xls file with lot of this kind of numbers - '7,8. But nothing happened. Converter just select all content of the spreadsheet and prints message with empty list of edited cells. Ubuntu 7.10, openoffice.org 2.3.1. Am I doing something wrong?

Andis

Nothing happens

Thanks for your comment, Andis. Was bug that is fixed now in 0.9.2
Cor