https://bugs.documentfoundation.org/show_bug.cgi?id=167216
Bug ID: 167216
Summary: Calc. AutoFit does not work if
Application.ScreenUpdating is False
Product: LibreOffice
Version: 25.2.4.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
Description:
Good day to you.
AutoFit method does not work if Application.ScreenUpdating set to False. Tested
on 6.3, 7.5, 24.2, and 25.2.4.3.
You can just set some long enough string to Cell "A1" and check it.
```basic
Option VBASupport 1
Public Sub VBAMain()
Application.ScreenUpdating = False
Rows(1).AutoFit
Application.ScreenUpdating = True
End Sub
```
Moreover, if I forget to set Application.ScreenUpdating to True then I'm not
able to autofit even using interface, double-clicking on a bottom border of a
row.
Actual Results:
No results
Expected Results:
Actual row height autofit
Reproducible: Always
User Profile Reset: No
Additional Info:
It's either I don't know how to write it correctly in LibreOffice Basic, or
ThisComponent.LockController works perfectly.
--
You are receiving this mail because:
You are the assignee for the bug.