<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - LibreOffice 5.3 hangs when opening/saving/running a macro containing "0." (zero followed by period)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109381">109381</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>LibreOffice 5.3 hangs when opening/saving/running a macro containing "0." (zero followed by period)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>BASIC
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>e.dijck@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
I found that after upgrading LibreOffice to version 5.3, Calc would hang and
stop responding during the "calculating" step of opening a specific ODS
spreadsheet that worked fine with Calc 5.2 (happened both on a Windows and an
openSUSE Linux system after upgrading). I let it run for a night and it hadn't
gotten any further the next morning.
I managed to isolate the problem to a macro containing something like "If x <>
0. Then". Note that the hang when opening the file occurred before the warning
whether macros should be run at all, it seems LibreOffice gets stuck scanning
the macro or something. Changing "0." on that line to "0" or "0.0" or removing
the macro makes the file open as usual.
I found an easier way to reproduce the problem, it seems LibreOffice gets stuck
on any macro containing "0.". Just writing "0." in a new macro and trying to
save or run it causes LibreOffice to stop responding (the problem is not
specific to Calc).
Note: I'm not sure whether "0." is actually a valid double constant in
LibreOffice BASIC, but it should not hang the program.
Steps to Reproduce:
1. Open a new LibreOffice document
2. Go to macro editing: Menu Tools / Macros / Edit Macros (or Organize Macros /
LibreOffice Basic / Edit)
3. Write "0." on an empty line (without the quotes, zero followed by period)
4. Press Ctrl+S or F5
Alternate (my original) way to reproduce problem
1. Open macrozerowithperiod.ods (attached) with Calc (I created this file with
Calc 5.2 where it works fine)
Actual Results:
LibreOffice hangs
Expected Results:
Macros are saved or run
macrozerowithperiod.ods file is opened
Reproducible: Always
User Profile Reset: Yes
Additional Info:
I have tested a couple of LO versions on different OSes.
I can reproduce the problem on Windows 10 (5.3.4.2 and 5.4.0.3), openSUSE Linux
(5.3.3.2) and Mac OS X (5.3.4.2).
The hang did not occur with 5.2 and earlier versions, I tested Windows 10
(5.2.7.2) and openSUSE Linux (5.2.5.1).
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
Firefox/52.0</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>