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