https://bugs.documentfoundation.org/show_bug.cgi?id=89030
Bug ID: 89030
Summary: RIGHT, LEFT, FIND text function combination not
working properly
Product: LibreOffice
Version: 4.2.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 113038
--> https://bugs.documentfoundation.org/attachment.cgi?id=113038&action=edit
Split column A into 3 columns based on key words "Country: ", "Postal code: ",
"City :"
Hi,
With column A contents as follow:
Country: France (FR)Postal code: 34230City: Le Pouget
If I want to explode this texte string into 3 different columns based on
Keywords "Country: ", "Postal code: ", "City :", I can make it work on line 2
but trying to drag it down or copy/paste to next lines in ordre to apply to
full colmumns for each line the resukt is different, results being shifted 1
digit on the right for each line.
Thanks for your help,
Regards,
Georges
--
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
