Summary: | (Regression since 7.6) Optimal-width columns too small (shows '#' chars) | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Jim Avera <jim.avera> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | normal | CC: | miguelangelrv, stephane.guillou |
Priority: | medium | Keywords: | regression |
Version: | 24.2.0.0 alpha1+ | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=99584 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: | Tdemo.ods -- spreadsheet showing the problem |
Description
Jim Avera
2024-02-28 17:34:34 UTC
Created attachment 192850 [details]
Tdemo.ods -- spreadsheet showing the problem
Macro fails for me in line: 262: OptionExpDt = Left(Expiry,3) & " " & Mid(Expiry,4,2) & ", 20" & Mid(Expiry,7,2) Error: Inadmissible value or data type. Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 5234ef71c7459506236d4d0dfe7beb5f00d8cc41 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded >Macro fails for me in line: 262 ...
Hmm. Miguel, I'm wondering what might be different about your system or profile? You are using Windows, so I tried 24.2.0 (the official release build) on a Windows 10 machine but did not get any errors, and the bug reproduced as before. I also tried "safe mode" on Linux i.e. with a new profile, and still repro as before, with no macro errors.
Strange.
(In reply to m_a_riosv from comment #2) > Macro fails for me in line: > 262: Same for me, "data type mismatch". Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 5234ef71c7459506236d4d0dfe7beb5f00d8cc41 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Version: 24.2.1.1 (X86_64) / LibreOffice Community Build ID: 359ef544e625d2ffbfced462ab37bd593ca85fa7 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded MSFT sheet is still created, but only one row of data in the table. Using Optimal Width + 0 does not give me the ### issue. Can you test again and maybe provide a new version of the file? Is it possible we are running different versions of Java? I assume LO comes with it's own internal Java interpreter; however I have several other Java interpreters installed to support other applications, so if LO were to accidentally use one of those, then behavior might be different. Just an idea (shot in the dark). [Automated Action] NeedInfo-To-Unconfirmed |