[Solved] FIND Function from Excel not working in OO

Discuss the spreadsheet application

[Solved] FIND Function from Excel not working in OO

Postby larkinp » Tue Jun 24, 2008 5:31 pm

Hey all,

I am new to OO, and have a command that works in Excel and not Calc.

=left(A1,find(",",A1)-1)

This will read cell A1 and take everything from the left of the comma. (And not include the comma) I cannot get this to work in Calc. I assume it is just a wacky syntax thing, but i cannot figure it out. Anyone help?

cheers**
pete
larkinp
 
Posts: 2
Joined: Tue Jun 24, 2008 5:11 pm

Re: FIND Function from Excel not working in OO

Postby Villeroy » Tue Jun 24, 2008 5:37 pm

Just open your xls in Calc file and see how it converts the formula syntax. Mainly the semicolon as list-separator and the dot as sheet-separator.
=SUM(Sheet1!A1,Sheet1!A2) [in English Excel] becomes
=SUM(Sheet1.A1;Sheet1.A2) [in all Calc versions, independent from language]

...I cannot get this to work in Calc...

This would not help in more complex situations. You should mention what happens (error #NAME).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28851
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: FIND Function from Excel not working in OO

Postby larkinp » Tue Jun 24, 2008 5:40 pm

I got it

=LEFT(A1;FIND(",";A1)-1)

I missed a semicolon conversion.
OOo 2.4.X on openSuse 10 + SLED
larkinp
 
Posts: 2
Joined: Tue Jun 24, 2008 5:11 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 27 guests