https://bugs.freedesktop.org/show_bug.cgi?id=87050
Bug ID: 87050
Summary: Editing characters in a cell formatted as a telephone
number
Product: LibreOffice
Version: unspecified
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 110509
--> https://bugs.freedesktop.org/attachment.cgi?id=110509&action=edit
List of numbers with periods and hyphens unreplaceable in batch
After importing an XL spreadsheet, I found the author had used periods to note
telephone numbers (eg. 999.999.9999). As I needed unbroken numbers for my
purposes, I attempted to remove the periods using Find and Replace and found I
could not. I attempted to turn the numbers into text using the
Format->Cell->Text menu items. I tried removing Direct Formatting. No joy. It
appears that there is no way to bulk edit these periods or (I later discovered)
hyphens from a cell once it is formatted that way.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
