[Libreoffice-bugs] [Bug 149531] Excel Visual Basic compatibility issue in LibreOffice Calc: .ColumnWidth
https://bugs.documentfoundation.org/show_bug.cgi?id=149531
--- Comment #4 from Óvári ---
Created attachment 180687
--> https://bugs.documentfoundation.org/attachment.cgi?id=180687=edit
CellsDelete3.xls does not crash as .ColumnWidth lines are commented out
Only change from CellsDelete.xls are apostrophes (') to comment out lines with:
.ColumnWidth
With this change LibreOffice Calc does not crash.
Thank you
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149531] Excel Visual Basic compatibility issue in LibreOffice Calc: .ColumnWidth
https://bugs.documentfoundation.org/show_bug.cgi?id=149531
--- Comment #3 from Óvári ---
Created attachment 180686
--> https://bugs.documentfoundation.org/attachment.cgi?id=180686=edit
CellsDelete2.xls does not crash as .Cells.Delete line commented out
Only change from CellsDelete.xls is an apostrophe (') to comment out:
.Cells.Delete
With this change LibreOffice Calc does not crash.
Thank you
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149531] Excel Visual Basic compatibility issue in LibreOffice Calc: .ColumnWidth
https://bugs.documentfoundation.org/show_bug.cgi?id=149531 Óvári changed: What|Removed |Added Status|RESOLVED|UNCONFIRMED Resolution|WORKSFORME |--- -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149531] Excel Visual Basic compatibility issue in LibreOffice Calc: .ColumnWidth
https://bugs.documentfoundation.org/show_bug.cgi?id=149531 --- Comment #2 from Óvári --- Created attachment 180685 --> https://bugs.documentfoundation.org/attachment.cgi?id=180685=edit CellsDelete.xls which crashes 1. Open attachment in LibreOffice Calc. 2. Click on "ColumnWidth" button in Sheet1. 3. LibreOffice Calc show a MsgBox with the text: Here I am! Next line crashes with LibreOffice Calc! 4. Click "OK" 5. Crash There is no crash is the following line is removed: .Cells.Delete Likewise there is no crash if .Cells.Delete remains and the .ColumnWidth lines are removed Are you able to reproduce this strange behavior? Thank you -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149531] Excel Visual Basic compatibility issue in LibreOffice Calc: .ColumnWidth
https://bugs.documentfoundation.org/show_bug.cgi?id=149531 Óvári changed: What|Removed |Added Blocks||108908 Resolution|--- |WORKSFORME See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||9325 Status|UNCONFIRMED |RESOLVED --- Comment #1 from Óvári --- Sorry, ColumnWidth does work. It was the previous lines' code that doesn't work, i.e. .Cells.Delete Closing this issue Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108908 [Bug 108908] [META] Visual Basic for Applications (VBA) macro issues -- You are receiving this mail because: You are the assignee for the bug.
