https://bugs.documentfoundation.org/show_bug.cgi?id=52602
--- Comment #13 from Óvári <ovari...@zoho.com> --- Created attachment 180703 --> https://bugs.documentfoundation.org/attachment.cgi?id=180703&action=edit Excel_VBA_Test_Working.xls It seems that LibreOffice Calc Macros are case-sensitive. Change: d → D m → M y → Y h → H m → M s → S Does it work for you? Thank you (In reply to Tor24_1975314 from comment #0) Modified Excel test file with macro Modified Excel Visual Basic Date/time formatting to make it work, Excel macro code examples: Example macro: Sub Test_NumberFormat_DateTime() ' Preparing Test: Range("A3").FormulaR1C1 = "40969.6388888889" Range("B3").FormulaR1C1 = "40969.6388888889" Range("C3").FormulaR1C1 = "40969.6388888889" Range("D3").FormulaR1C1 = "40969.6388888889" Range("E3").FormulaR1C1 = "40969.6388888889" Range("F3").FormulaR1C1 = "40969.6388888889" Range("A3").Select ' Testing Excel VBA Code in Libre Office: Range("A3").NumberFormat = "HH:MM" Range("B3").NumberFormat = "MM/DD/YYYY HH:MM" Range("C3").NumberFormat = "MM/DD/YYYY HH:MM:SS" Range("D3").NumberFormat = "D/M/YY H:MM" Range("E3").NumberFormat = "D/ MMMM YYYY" Range("F3").NumberFormat = "D/ MMM YYYY" End Sub -- You are receiving this mail because: You are the assignee for the bug.
