Bug 47185 - FORMATTING Add text string formatting
Summary: FORMATTING Add text string formatting
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: x86 (IA32) Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-03-10 07:52 UTC by grofaty
Modified: 2015-01-08 14:26 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Formatting text sample (9.72 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-03-10 07:52 UTC, grofaty
Details

Note You need to log in before you can comment on or make changes to this bug.
Description grofaty 2012-03-10 07:52:07 UTC
Created attachment 58271 [details]
Formatting text sample

In cell A1 I typed in text: ABCDEF. Now I would like to have a formatting of this text like: AB-CD-EF (so minus sings every two letters). I have tried searching formatting in Format | Cells but no formatting for text is found. For example for numbers is very simple format just use Format | Cells | Numbers tab | Format code input box type in: ##-##-##. Please add support for formatting text the same way as numbers?
Comment 1 sasha.libreoffice 2012-05-31 04:50:58 UTC
Thanks for new idea
Use Edit->Find&Replace, set there option "Regular expression"
in Search for:
([A-Z]{2})([A-Z]{2})([A-Z]{2})
in Replace with:
$1-$2-$3
Then press "Replace all"
And this will format text cells as needed.
Comment 2 sasha.libreoffice 2012-09-04 08:54:22 UTC
Noel Grandin <noelgrandin@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
Comment 3 grofaty 2015-01-06 12:38:30 UTC
Retested in LibreOffice 4.3.5.2 and enhancement request is still valid.
Comment 4 Urmas 2015-01-08 14:26:20 UTC
This feature is not supported by ODF.