https://bugs.freedesktop.org/show_bug.cgi?id=63365
Priority: medium
Bug ID: 63365
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: : Elementari VBA formatting statement fails
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: sergio.calleg...@gmail.com
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.2.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
A macro containing the following code
Range("J19:R30,N32:R33").Select
Selection.NumberFormat = "$ #,##0.00;[Red]-$ #,##0.00"
fails with error
-------8<-------------------------------
BASIC runtime error.
'1'
Type: com.sun.star.uno.RuntimeException
Message:
-------8<-------------------------------
Steps to reproduce:
1. Create an excel document
2. Prepare a macro with
-------8<-------------------------------
Sub Dollaro()
Range("J19:R30,N32:R33").Select
Selection.NumberFormat = "$ #,##0.00;[Red]-$ #,##0.00"
Range("A1").Select
End Sub
-------8<-------------------------------
3. Save the excel document, open it with libreoffice
Current behavior:
The macro fails with the error above
Expected behavior:
The macro should work fine in libreoffice
Operating System: Ubuntu
Version: 4.0.2.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
