https://bugs.documentfoundation.org/show_bug.cgi?id=168187
Bug ID: 168187
Summary: Calc's macro state got "stuck"
Product: LibreOffice
Version: 25.2.5.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
While testing to determine the boundaries and operation of bugs
https://bugs.documentfoundation.org/show_bug.cgi?id=168169 and
https://bugs.documentfoundation.org/show_bug.cgi?id=168186 I had a _very_ weird
situation occur. The macro state of one of the sheets involved in the above
bugs got stuck and persisted across several opens and closes.
Closing all open sheets caused the situation to be cleared.
I apologise here for the vagueness of what's coming, but it's the best I can
do.
Note: My investment spreadsheet contains code I've written. Since I don't want
to pay for an expensive code-signing certificate I have instead turned on the
workaround of "trust sheets in this directory". This turns out to mean, any
filepath in that directory tree, so includes all of these CDS Tax Breakdown
sheets in all the subdirectories too. Fine, that's a security risk I didn't
know about, but these sheets are, in general, trusted.
What this means is that I'm not manually enabling macros every open. I don't
think that's a factor in this issue, but, I don't know it's not either.
I had my investment tracking spreadsheet open.
I am opening the above two spreadsheets, causing the internal errors and
closing them.
My investment tracking sheet remains open the entire time.
A usual reproduction of the above bug is open the sheet, click a non-selected
cell, dismiss the error dialogs (several each time for the same error) then
close the sheet.
One time I open the sheet and am greeted by the sheet's builtin "blue screen of
macro disablement". This is a message from the sheet's author(s) to any of the
companies filling this sheet out to file their tax breakdowns, because the
sheet uses a lot of macros to assist the filers in doing the filling out, and,
to eliminate human error.
So the macros for this sheet were somehow turned off. See the above note about
the sheet being in a trusted directory tree so this shouldn't have even been
possible. Fine, I close the sheet and reopen it. Same "blue screen of macro
disablement"! I checked the macro settings, they were still at "Medium" and
"trust in this location", so nothing had changed.
This stuck state persisted across sheet close/open cycles, forever as far as I
know.
Then I closed my investment tracking sheet, and made sure Calc was fully closed
(no windows left running, in particular the macro editor window was closed as
well). Then opened the "stuck" sheet, and it was back to normal!
Steps to Reproduce:
Have a second unrelated sheet open.
Open and close one of the sheets from the mentioned bugs over and over.
Actual Results:
A) Macros were disabled in the sheet even though that shouldn't have been
possible.
B) The macros disabled state persisted across close/open cycles.
Expected Results:
A) Macros cannot be disabled when in a trusted directory tree.
B) Closing and reopening a sheet should reset *everything* about the sheet,
independently of other open sheets.
Reproducible: Couldn't Reproduce
User Profile Reset: No
Additional Info:
Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 16; OS: Linux 6.14; UI render: default; VCL: gtk3
Locale: en-US (C.UTF-8); UI: en-US
Ubuntu package version: 4:25.2.5~rc2-0ubuntu0.24.04.1~lo1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
