Re: [libreoffice-users] Re: problem with formala inserted by macros when decimal separator is comma

Thank you very much,

This is exactly what I wanted to know. I was not able to run that test 
myself.

On 08/29/2013 06:21 AM, Mindaugas wrote:
> In 4.0 the properties Formula and FormulaLocal give the expected result:
>
> cell.Formula =  "=2.1*2"    => 4,2
> cell.Formula =  "=2,1*2"    => #NAME?
>
> cell.FormulaLocal =  "=2,1*2"   => 4,2
> cell.FormulaLocal =  "=2.1*2"   =>  #NAME?
>
> In 4.1 the both properties Formula and FormulaLocal give the same result:
>
> cell.Formula =  "=2,1*2"    => 4,2
> cell.Formula =  "=2.1*2"    => #NAME?
>
> cell.FormulaLocal =  "=2,1*2"   => 4,2
> cell.FormulaLocal =  "=2.1*2"   =>  #NAME?
>
> Best regards
>
> Mindaugas
>
> Best regards
>
>
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/problem-with-formala-inserted-by-macros-when-decimal-separator-is-comma-tp4072059p4072140.html
> Sent from the Users mailing list archive at Nabble.com.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted