Bug 66950

Summary:	FORMULA: CONVERT formula not working
Product:	LibreOffice	Reporter:	Mikeyy - L10n HR <mihovil>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	jbfaure
Priority:	medium
Version:	4.1.0.2 rc
Hardware:	Other
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description Mikeyy - L10n HR 2013-07-16 06:36:22 UTC

Correct me if I'm wrong, but CONVERT formula doesn't seam to work, at least on 4.1 RC2 croatian locale, Win7.

Used this:
=CONVERT(100;"ha";"m2")

Which should work according to this:
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018496_715980110

RESULT: #N/A

If I use Excel version of formula:
=CONVERT_ADD(100;"ha";"m2")
RESULT: 1000000

So Excel version of formula works. Maybe I used it in wrong way, in which case, please correct me.

Best regards,
Mihovil

Comment 1 Jean-Baptiste Faure 2013-08-15 16:53:42 UTC

Hmm, you should use the right function: CONVERT_ADD. ;-)
Please use the function wizard to see a description of the functions available in LibreOffice.

Closing as NOTABUG. Feel free to reopen if you have new data showing that it is the wrong choice.

Best regards. JBF