Bug 89030 - RIGHT, LEFT, FIND text function combination not working properly
Summary: RIGHT, LEFT, FIND text function combination not working properly
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: lowest trivial
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-02-01 22:39 UTC by Georges
Modified: 2015-02-01 23:30 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Split column A into 3 columns based on key words "Country: ", "Postal code: ", "City :" (85.60 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-02-01 22:39 UTC, Georges 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Georges 2015-02-01 22:39:26 UTC 
Created attachment 113038 [details]
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
Comment 1 Georges 2015-02-01 22:44:41 UTC 
Sorry for this, but I eventuallyu checked the contents of column A which is coming form a web application and foudn out taht there are hidden characters.

If I reproduce cell AZ all the way down the results in columns C is consistent, so there is no LibreOffice bug involved.

Sorry for the disturbance,
Regards,
Georges