Description: Macro (Contabilidad.ods/Standard/Modules/macro) perfectly in LibreOffice Calc 6.4.7.2 but, in LibreOffice 7.1.5.2 doesn't run without error message. Steps to Reproduce: 1. Open the spreadsheet "Contabilidad.ods" 2. Enable macros 3. click "DATOS" / EJECUTAR LIBROS CONTABLES 4. click "OK" Actual Results: In LibreOffice Calc 7.1.5.2 spreadsheets "Diafil", "Diario" and "Mayor" are empty. Expected Results: In LibreOffice Calc 6.4.7.2 spreadsheets "Diafil", "Diario" and "Mayor" are with same data of "Alimentación del diario" Reproducible: Always User Profile Reset: No Additional Info: N/A
Created attachment 175099 [details] Spreedsheet for fill "Diario" and "Mayor"
Hello Juan P, I've tried the attached document with older versions of LibreOffice and spreadsheets "Diafil", "Diario" and "Mayor" are always empty. Can you make sure the document attached works in LibreOffice 6.4 on your end ? You can download it from https://downloadarchive.documentfoundation.org/libreoffice/old/6.4.7.2/
Hello. I'm pretty sure. The document attached "Contabilidad.ods" : 1) Open with Calc 6.4.7.2 : Enable macros / Click in button "Ejecutar Libros Contables" of sheet "DATOS" / OK in button "Fin del proceso V2.2" , and the sheets: "Diafil", "Diario" and "Mayor". are full of data (A6:H189). Close without save 2) Open the original archive with Calc 7.1.5.2 (without save with 6.4.7.2): Enable macros / Click in button "Ejecutar Libros Contables" of sheet "DATOS" / OK in button "Fin del proceso V2.2", and the sheets: "Diafil", "Diario" and "Mayor". are empty. I'm running CALC with this Linux configuration: Operating System: Kubuntu 21.04 KDE Plasma Version: 5.21.4 KDE Frameworks Version: 5.80.0 Qt Version: 5.15.2 Kernel Version: 5.11.0-34-generic OS Type: 64-bit Graphics Platform: X11 Processors: 2 × AMD Athlon Silver 3050U with Radeon Graphics Memory: 5,7 GiB of RAM Graphics Processor: AMD RAVEN2 Juan P.
Also empty for me in 6.4, so cannot reproduce. But there's a crash for me with 7.3+ when click "DATOS" / EJECUTAR LIBROS CONTABLES. Not clear when starter, I see from oldest to master.
Hello, I uninstalled my version of LibreOffice (7.1.5.2 installed automatically with Kubuntu 21.04) and installed this version of LibreOffice from the web, with Spanish compatibility: Version: 7.2.1.2 / LibreOffice Community Build ID: 87b77fad49947c1441b67c559c339af8f3517e22 CPU threads: 2; OS: Linux 5.11; UI Processing - Default; VCL: kf5 (cairo + xcb) Regional settings: es-CO (es_CO.UTF-8); UI: en-US Calc: threaded And my MACRO works perfectly. I think the problem was the compatibility of regional setting of my older version, specifically in the date (dd/mm/yyyy). Thank you very much for your attention. Sorry for this bogus bug report.
NotABug is when something can be explained. Here, nobody could confirm the problem, to be tested later if needed, so it's InsufficientData. Xisco, please check a crash with 7.3+.