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

I am not properly set to test this, but, can you test the following in 
older and newer LO?
cell.FormulaLocal = "=2,1*2"
cell.FormulaLocal = "=2.1*2"

I am a very unhappy about that I think. That is a pretty major change in 
behavior. I had documented it as follows:

When setting a cell’s formula, you must include the leading equals sign 
(=) and the formula must be in English. To set a formula using your own 
local language, use the FormulaLocal property shown in Table 166.

It sounds like things changed so that setting the formula now acts like 
setting FormulaLocal. Off hand I would call it a bug.



On 08/28/2013 11:41 AM, Mindaugas wrote:
> Hello,
>
> The problem is in LO 4.1 and LO4.1.1 with lt_LT locale but i think the same
> must be in all locales with decimal separated by comma.
>
>
> I want to  insert formula to Calc cell by Basic macros:
>
> cell.setFormula("=2.1*2")
>
> Old behavior (LO 4.0 and older). In cell I get result 4,2 (and formula
> "=2,1*2")
>
> New behavior (LO 4.1). In cell I get error "#NAME?" (and formula "2.1*2")
>
>
> But if I want insert value,  decimal separator is translated correctly:
>
> cell.setValue(2.1)
>
> In cell I get value 2,1 (LO 4.0, LO 4.1)
>    
>
> It's bug or new feature?
>
>   
>
> Best regards
>
> Mindaugas
>
>
>
>
>
>
>   
>
>
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/problem-with-formala-inserted-by-macros-when-decimal-separator-is-comma-tp4072059.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