Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

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:

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:


Old behavior (LO 4.0 and older). In cell I get result 4,2 (and formula

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:


In cell I get value 2,1 (LO 4.0, LO 4.1)
It's bug or new feature?

Best regards


View this message in context:
Sent from the Users mailing list archive at

Andrew Pitonyak
My Macro Document:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.