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+unsubscr...@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