[Libreoffice-bugs] [Bug 109381] New: LibreOffice 5.3 hangs when opening/saving/ running a macro containing "0." (zero followed by period)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=109381

            Bug ID: 109381
           Summary: LibreOffice 5.3 hangs when opening/saving/running a
                    macro containing "0." (zero followed by period)
           Product: LibreOffice
           Version: 5.3.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: e.dijck at gmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170726/372ad2bb/attachment.html>