<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:sdc.blanco@youmail.dk" title="sdc.blanco@youmail.dk">sdc.blanco@youmail.dk</a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Inserting a variable with time format gives "Expression is faulty" - locale problem"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=129966">bug 129966</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>Inserting a variable with time format gives "Expression is faulty"
</td>
<td>Inserting a variable with time format gives "Expression is faulty" - locale problem
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Inserting a variable with time format gives "Expression is faulty" - locale problem"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=129966#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Inserting a variable with time format gives "Expression is faulty" - locale problem"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=129966">bug 129966</a>
from <span class="vcard"><a class="email" href="mailto:sdc.blanco@youmail.dk" title="sdc.blanco@youmail.dk">sdc.blanco@youmail.dk</a>
</span></b>
<pre>Additional information.
I believe problem is with how "locale" interacts with variables.
Can now reproduce problem in both 6.3.4.2 and 6.5.0.0 (but with different
effects in the two versions.)
Revised procedure.
In LO 6.3.4.2
0. Set locale setting to Danish (Alt-F12-Language-Language Settings -locale)
(or any other locale that uses , before decimal numbers)
0.1 Open a document where the language of the document is set to English.
(or any other language that uses . before decimal numbers)
1. Ctrl-F2 – Variable tab.
2. Select Set Variable
3. Under Format, click on Additional Formats
4. In ‟Format Number” dialog, select category ‟Time” and Format ‟13:37”,
click OK
5. In ‟Fields” dialog, give 13:30 as value.
6. ‟Insert”
Actual result: ** Expression is faulty **
7. Double-click on inserted variable (or edit in Variable tab of Fields
dialog).
8. Note that value is: 0,5625 (if you used 13:30)
9. Change "," to "."
All is right with the world again. Apparently, the Danish locale was used to
convert 13:30 into 0,5625 -- which was inserted into the English document,
which could not interpret the number, hence "Expression is faulty"
In 6.5.0.0.alpha --
Steps 0-6 as above.
7. Show Variable, and insert the variable you just created.
Actual result: Inserted variable only has shading (if turned on with Ctrl-F8)
Show Variable: 00:00
8. As before, edit the variable field. Change , to .
Good to go...</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>