Convert Text To Number is a useful OpenOffice extension designed to replace numbers written as text with real numbers. The latest version offers a window to make choises about marking of cells, including cells with non- default decimal separators, and more.
As a result of the conversion, the text cells will become real numbers, and then will be counted in formulas Calc.
Calc does not use numbers formatted as text. Other spreadsheet programs may well do that.
This extension adds the tool bar 'CT2N' to Calc only. The screenshot shows it all.
Current languages: Russian, French, English and Dutch.
- added possibility to convert dates as well, with code contribution from Karim Doumaz
- changed behaviour of main window, so that is stays open while cells are processed
- select start selection again at the end of the process
- rearranged dialog
- added button to abort, changed button behaviour
- skipped last window, in stead present results in main window
- show present info in the main window
- solved bug with rule 1F, 3G in CheckForTextInString