[Bug 158386] Windows Excel File locks up Libre Calc vers. 7.6.2.1 while trying to open it.
https://bugs.documentfoundation.org/show_bug.cgi?id=158386 --- Comment #8 from Armondo Lopez --- (In reply to Mike Kaganski from comment #7) > Created attachment 193670 [details] > The file (version 2.909) from > https://neverwintervault.org/project/nwn1/other/tool/ > characterbuildcalculator-cbc > (https://neverwintervault.org/sites/all/modules/pubdlcnt/pubdlcnt. > php?fid=262052) > > (In reply to Armondo Lopez from comment #6) > > Just chiming in to say that I was able to successfully open the file > > Attaching the correct version of problematic file, still giving the same > problem both > > in Version: 24.2.2.2 (X86_64) / LibreOffice Community > Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01 > CPU threads: 24; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: > win > Locale: en-GB (ru_RU); UI: en-GB > Calc: CL threaded > > and in Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community > Build ID: fce1fb034d282dc6e0434bf16c49d5f602d813bd > CPU threads: 24; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: > win > Locale: ru-RU (ru_RU); UI: en-US > Calc: CL threaded > > (of course, you need to enable and accept macros in the file). My apologies. You're correct. In enabling macros, I do get the same behavior that you listed. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158386] Windows Excel File locks up Libre Calc vers. 7.6.2.1 while trying to open it.
https://bugs.documentfoundation.org/show_bug.cgi?id=158386 --- Comment #7 from Mike Kaganski --- Created attachment 193670 --> https://bugs.documentfoundation.org/attachment.cgi?id=193670=edit The file (version 2.909) from https://neverwintervault.org/project/nwn1/other/tool/characterbuildcalculator-cbc (https://neverwintervault.org/sites/all/modules/pubdlcnt/pubdlcnt.php?fid=262052) (In reply to Armondo Lopez from comment #6) > Just chiming in to say that I was able to successfully open the file Attaching the correct version of problematic file, still giving the same problem both in Version: 24.2.2.2 (X86_64) / LibreOffice Community Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01 CPU threads: 24; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: en-GB (ru_RU); UI: en-GB Calc: CL threaded and in Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: fce1fb034d282dc6e0434bf16c49d5f602d813bd CPU threads: 24; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL threaded (of course, you need to enable and accept macros in the file). -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158386] Windows Excel File locks up Libre Calc vers. 7.6.2.1 while trying to open it.
https://bugs.documentfoundation.org/show_bug.cgi?id=158386 Armondo Lopez changed: What|Removed |Added CC||armlo...@csumb.edu --- Comment #6 from Armondo Lopez --- Just chiming in to say that I was able to successfully open the file without problems in Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: a2265e8faa099d9652efd12392c2877c2df1d1eb CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded and Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158386] Windows Excel File locks up Libre Calc vers. 7.6.2.1 while trying to open it.
https://bugs.documentfoundation.org/show_bug.cgi?id=158386 --- Comment #5 from Mike Kaganski --- Right; so it seems that the question is, should we allow the non-standard extension that Excel allows; and if yes, then to what extent (question in comment 3). See also: https://learn.microsoft.com/en-us/office/vba/Language/Reference/user-interface-help/constant-expression-required -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158386] Windows Excel File locks up Libre Calc vers. 7.6.2.1 while trying to open it.
https://bugs.documentfoundation.org/show_bug.cgi?id=158386 Stéphane Guillou (stragu) changed: What|Removed |Added CC||stephane.guillou@libreoffic ||e.org --- Comment #4 from Stéphane Guillou (stragu) --- For reference, the Visual Basic documentation that Andreas quoted is: https://learn.microsoft.com/en-us/dotnet/visual-basic/programming-guide/language-features/procedures/optional-parameters Also in VBA documentation[1]: "defaultvalue: Any constant or constant expression." So even MS Office shouldn't allow an argument default that uses a function, right? [1]: https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/function-statement -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 158386] Windows Excel File locks up Libre Calc vers. 7.6.2.1 while trying to open it.
https://bugs.documentfoundation.org/show_bug.cgi?id=158386 --- Comment #3 from Andreas Heinisch --- The documentation states that "The default value for an optional parameter must be a constant expression." Does Excel allow other functions apart from the CVErr function? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 158386] Windows Excel File locks up Libre Calc vers. 7.6.2.1 while trying to open it.
https://bugs.documentfoundation.org/show_bug.cgi?id=158386 Mike Kaganski changed: What|Removed |Added CC||andreas.heini...@yahoo.de --- Comment #2 from Mike Kaganski --- (In reply to Jeffry from comment #0) > you get a "Basic Syntax Error Code" that locks up the > program and Windows Task Manager is the only way to end the program. It doesn't lock up, it just shows it tens of times. Pressing Esc and holding it for a minute would dismiss all those message boxes, and finally allow you to use the document. The suggestion of m.a.riosv is best. The offending code is Function VLOOKUP2(ByRef values As range, ByRef matrix As range, column As Integer, Optional default As Variant = CVErr(xlErrNA)) As Variant where 'Optional default As Variant = CVErr(xlErrNA)' seems to be unsupported, we may not allow defaults to be defined by a function, only by a literal. Andreas, what do you think? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 158386] Windows Excel File locks up Libre Calc vers. 7.6.2.1 while trying to open it.
https://bugs.documentfoundation.org/show_bug.cgi?id=158386 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #1 from m.a.riosv --- The file has excel macros, that seems not compatible with LibreOffice. In Menu/Tools/Options/LibreOffice/Security/Macro Security/Macro Security/ to medium. LO ask to enable or not the macros at opening the file. Disable it and you can open the file, and take a look to the macros. -- You are receiving this mail because: You are the assignee for the bug.
