CT2N - Convert Text To Number (and dates)

17 0

ConvertTextToNumber replaces numbers and dates, formatted as text, with real numbers. Choices can be made about marking of cells, including cells with non- default decimal separators, conversion of dates, and more. As a result of the conversion, the text cells will become real numbers, and then will be counted in formulas Calc.

Project Description

Works in 5.0.x, 5.1,.x, 5.2.x ConvertTextToNumber replaces numbers and dates, formatted as text, with real numbers. Choices can be made about marking of cells, including cells with non- default decimal separators, conversion of dates, and more. As a result of the conversion, the text cells will become real numbers, and then will be counted as expected in formulas Calc. This extension adds the tool bar 'CT2N' to Calc only. The screen shot shows it all. Available languages: Spanish, Swedish, Russian, French, English, Italian and Dutch. Translations for other languages would be gladly accepted. Please note: We get requests about all kind of clean-up actions, that can be necessary when copying data from a website. These are not the original problem that this extension addresses. However, since it would make a good extra functionality, we kindly thank for this input and plan the ideas for a future version.

Category/Categories

Calc Extension

Current Release

CT2N - Convert Text To Number (and dates) - 1.5

Released Aug 13, 2016 — tested with:

LibreOffice 5.2,

Added Czech translation - thanks to Zdenek Crhone
More about this release…

converttexttonumber-1-5-0.oxt
File size: 48 kb

All Releases

Version

Released

Platform(s)

Compatibility

Description

License(s)

Status

1.5

Aug 13, 2016
    • LibreOffice 5.2
    Added Czech translation - thanks to Zdenek Crhone
    • LGPL-v3+ (GNU Lesser General Public License Version 3 and later)
    final

    1.4.0

    Mar 06, 2015
      • LibreOffice 3.3
      • LibreOffice 3.4
      • LibreOffice 3.5
      • LibreOffice 3.6
      • LibreOffice 4.0
      • LibreOffice 4.1
      • LibreOffice 4.2
      • LibreOffice 4.3
      • LibreOffice 4.4
      latest version some wishes for updating exist - still need to find time..
      • LGPL-v3+ (GNU Lesser General Public License Version 3 and later)
      final

      Legal Disclaimer and Limitations for Downloads

      The Document Foundation has not reviewed, and cannot review, all of the material, including computer software, available on or by means of The Document Foundation's
      websites, and cannot therefore be responsible for that material's content, use or effects. By operating its websites, The Document Foundation does not represent or imply that it endorses the material there available, or that it believes such material to be accurate, useful or nonharmful. You are responsible for taking precautions as necessary to protect yourself and your computer systems from viruses, worms, Trojan horses and other harmful or destructive content. The Document Foundation's websites may contain content that is offensive, indecent or otherwise objectionable, as well as content containing technical inaccuracies, typographical mistakes and other errors. The Document Foundation's websites may also contain material that violates the privacy or publicity rights, or infringes the proprietary rights, of third parties, or the downloading, copying or use of which is subject to additional terms and conditions, stated or unstated. The Document Foundation disclaims any responsibility for any harm resulting from the use by The Document Foundation's visitors of The Document Foundation's websites, or from any downloading by those visitors of content available on or by means of The Document Foundation's websites.

      Changes

      Content contained on The Document Foundation's websites, including these Legal Disclaimers and Limitations, may be changed at the sole discretion of The Document Foundation and without notice. You are bound by any such updates or changes, and so should periodically review these Legal Disclaimers and Limitations.

      If you believe any file is present on the site contrary to any TDF rule or applicable law, please supply full details to info@documentfoundation.org for impartial consideration.