https://bugs.documentfoundation.org/show_bug.cgi?id=148651
Bug ID: 148651
Summary: VBA runtime error with VBA.FormatPercent
Product: LibreOffice
Version: 7.2.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
Description:
I am somewhat abusing libreoffice by trying to open a VBA game for excel, which
I was fairly aware would be a brutal test of the VBA support in libreoffice.
There was actually another issue that prevents the file I'm using from getting
to the issue that will be described here, but I passed through that one by
blindly removing some offending lines and have not filed an issue for it yet
because I'm still fairly unsure of the exact cause.
The VBA.FormatPercent() function appears to raise a runtime error, '12'. The
original line that raises the error is:
Range("C45").Value = "LOCKED - Progress: " &
VBA.FormatPercent(StatTotalBossesKilled / 10, 2)
But I've been able to confirm that just doing
VBA.FormatPercent(0 / 10, 2)
Also generates the error. For reference, the nonsense that I tried to open in
libreoffice can be downloaded at https://carywalkin.itch.io/arenaxlsm
Steps to Reproduce:
1. Open the game downloadable at https://carywalkin.itch.io/arenaxlsm
2. Enable macros
3. There will be errors in Sub RestoreKeys(). Delete every line that raises an
error, I deleted the lines for characters [,'.pyu].
4. Click "New game"
Actual Results:
We hit a VBA runtime error, '12', and land on an achievements screen
Expected Results:
I wouldn't actually know as I don't know what the file is supposed to look like
when it works, but I assume it should begin some kind of game, and not raise
the error.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
I have fair confidence that this probably won't be the only VBA incompatibility
blocking this file from running. A game built inside a spreadsheet probably
isn't the primary target for support, but it'll probably raise a good amount of
items that can be addressed to get closer to full VBA compatibility.
--
You are receiving this mail because:
You are the assignee for the bug.
