Hi!
In Writer 7.4.5.1 when I enter calculations in the formula bar, I have to use point as decimal separator instead of comma, which is what my locale says should be used a separator. I do not have this problem in Calc. Is this a known problem with a solution, or should I file a bug request?
Writer is not Calc. Formulas are offered as a limited courtesy feature for very simple cases.
That said, there is bug: you have the possibility to specify the language when you right-click and Edit Fields
on the formula. When a specific language is selected, the sample box shows the correct decimal separator (not sure about the entry box which is probably hard-wired to en_US). However, after clicking OK for both dialogs, it has no effect and formula result is still displayed with period separator.
I found nevertheless a workaround for display:
- ensure your text has been correctly tagged for your language (either with
Tools
>Language
>For All Text
>…) or in the paragraph style(s) - once this is done,
Edit Fields
on the formula, set any language and OK (there is no need to specify the exact language as it is not honoured; you must change the language anyway, so that there is a refresh)
New formulas display correctly in the text language.
File a bug report on Bugzilla and mention the bug number here in the form tdf#<bug_number>. Tak.
This is correct, of course. However…
There are many reasons not to use number formats or even formulas in text tables. But the decimal separator is not one of them.
As I also state in my answer below, in Writer as in Calc it is critical whether you use the text area of the keyboard or the numberpad for input.
I can’t see a bug here.
I may have tilted the discussion in a bad direction with my screenshot, I am sorry for that.
My issue is not with the display format, but how I need to enter the calculation in the formula bar for it to work. I am in Sweden and we use comma as decimal separator, but the formula will not calculate if I adhere to the Swedish nototion, I have to use point notation in the formula bar in order to get the calculation to perform at all, even when interface language and locale is set to Swedish. Of course, it is easy to work around, and just use point instead of comma, but still… it’s 2023…
(in a different matter, what kind of forum format is this? I cannot find a way to reply to the thread itself, I have to choose a subthread which is not ideal when the answer may be in relation to everything that has been said already in all subthreads… weird.)
Submit a bug report in Bugzilla
Simply, it is not a forum. It is a Question & Answer site. Every topic is supposed to ask one question and receive possibly several answers. You can comment each “answer” individually". When you remark is general, comment under the question.
Contrary to forums, every post is editable. Thus if your question is not accurate enough, you can always improve it. In addition, this is contributor friendly as, if the rule is followed, new contributors need only read the question, without the pain to follow a conversation to grab all details.
Sorry. I didn’t study the screenshot sufficiently.
Of course this looks weird. If I choose Swedish (Sweden) as the locale, I get immediately the comma in the NumPad acts on it. That’s with version 7.5.0.3.
If your issue is a bug of 7.4.5, it is already fixed. If it depends on your OS or on OS-related settings, I don*t know help.
I didn’t check again with oilder versions, but…
The setting should only concern the respective key in the numeric panel of the kjeyboard. After alklk you need a way to insert commas otherwise, even between digits.
My V 7.5.0.3 works exactly this way.
The answer is obsolete. See comments above.
An unsolicited recommendation: Remove the bad slashed Date recognition patterns. They tend to cause misinterpretations.
I (Gerrman, Germany, UI en-CA, locale en-CA) am using for shorthand input D.M..
(Regard the second point behind the M
!) If in Sweden, you may prefer D/M//
to be nearer to tradition.
(I’m told in Sweden ISO 8601 extended
is actually regarded. Be happy! In Germany this is also official standard, but nobody seems to know that. Least of all it’s known among typists.)