Menu ▾ ▴

#1532 Export to XLSX broken?

Snapshot
open
nobody
export (7) xlsx (3)
medium
2024-12-20
2024-12-04
Vikaash Mahabir
No

Export to XLSX appears to be broken. Clicking ok in the dialogue box closes the box, but there's no export confirmation prompt after. There is however a file on the file system with size zero.
Export to XLS still works though.

Version: snapshot-20241201_2102
Java: 23.0.1+11-39

2 Attachments
Schermafbeelding 2024-12-04 141933.png
Schermafbeelding 2024-12-04 142034.png

Discussion

  • Stepan RYBAR

    Stepan RYBAR - 2024-12-05

    Hello, I tested XLSX export right now in version 20241201_2102 and it works fine for me. I am using Adoptium Java OpenJDK 17.0.12 on MS Windows. I tried the same settings as Vikaash, but Java version. Stepan

    My test select is: 

    --H2 2.3.232 InMemory 
drop table if exists "t"; 
create table "t" ("id" int, "name" varchar(256)); 
insert into "t" ("id", "name") values (1, 'aaa'), (2, 'bbb'), (3, 'ccc'); 
select * from "t";
     

  • Vikaash Mahabir

    Vikaash Mahabir - 2024-12-09

    Thanks for checking. Perhaps the XLSX export is not (yet) compatible with Java 23. I've just installed 20241208_2056 and retested exporting XLSX, but unfortunately no dice..

     

  • Stepan RYBAR

    Stepan RYBAR - 2024-12-09

    Hello, Vikaash, I also tried Eclipse Adoptium OpenJDK Runtime Environment 23.0.1+11 on Windows Server 2016 and squirrel-sql-snapshot-20241208_2056-standard.jar and export to CSV nad XLSX works for me OK. Files are created, dialogue is responsive, files are opened in LibreOffice and MS Excel both OK. So it may be a problem in some configuration, I guess. Regards, Stepan

    --H2 2.3.232 InMemory 
drop table if exists "t" ; 
create table "t" ("price" numeric (10, 2), "purchaseDate" timestamp); 
insert into "t" ("price", "purchaseDate") values (1234567.89, current_timestamp()); 
insert into "t" ("price", "purchaseDate") values (9876543.21, current_timestamp()); 
select "price", "purchaseDate" from "t";
     

    • Vikaash Mahabir

      Vikaash Mahabir - 2024-12-10

      I've also installed (unzipped) Eclipse Adoptium OpenJDK Runtime Environment 23.0.1+11 on my company managed laptop (MS Surface 5) running on Windows 11, but the export to XLSX still doesn't work for me. Must be a local issue then..

       

      • Stepan RYBAR

        Stepan RYBAR - 2024-12-18

        Hello, I tested export to CSV on another (my private) comp Win11 just now, running under no admin, the latest Adoptium JDK 23 and CSV and XLSX works for me fine. Yes, I have JDK, no JRE and inside it Java FX from Gluon, but it should not affect this behaviour, I hope. Regards, Stepan

         

        • Vikaash Mahabir

          Vikaash Mahabir - 2024-12-18

          Hi Stepan,

          I was wondering if clicking on OK in the dialog having XLSX selected would trigger an error in the log and it did! Hopefully devs can decipher it and diagnose what's going on.

          Logged by net.sourceforge.squirrel_sql.client.Main at 18-12-2024, 10:59:

 Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(124,486),absolute(2726,842),button=1,modifiers=Button1,clickCount=1] on win0

          Clicked on the stack trace button:

          java.lang.NoSuchMethodError: 'org.apache.logging.log4j.LogBuilder org.apache.logging.log4j.LogBuilder.withThrowable(java.lang.Throwable)'
    at org.apache.poi.util.XMLHelper.logThrowable(XMLHelper.java:331)
    at org.apache.poi.util.XMLHelper.trySet(XMLHelper.java:288)
    at org.apache.poi.util.XMLHelper.getDocumentBuilderFactory(XMLHelper.java:116)
    at org.apache.poi.util.XMLHelper.<clinit>(XMLHelper.java:85)
    at org.apache.poi.ooxml.util.DocumentHelper.newDocumentBuilder(DocumentHelper.java:47)
    at org.apache.poi.ooxml.util.DocumentHelper.<clinit>(DocumentHelper.java:36)
    at org.apache.poi.openxml4j.opc.internal.ContentTypeManager.save(ContentTypeManager.java:429)
    at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:569)
    at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1531)
    at org.apache.poi.ooxml.POIXMLDocument.write(POIXMLDocument.java:227)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.DataExportExcelWriter.afterWorking(DataExportExcelWriter.java:322)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.DataExportExcelWriter.write(DataExportExcelWriter.java:98)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.ExportFileWriter.export(ExportFileWriter.java:52)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.Exporter.writeExport(Exporter.java:203)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.Exporter.export(Exporter.java:132)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.Exporter.exportDialogClosed(Exporter.java:99)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.Exporter.export(Exporter.java:76)
    at net.sourceforge.squirrel_sql.fw.gui.action.fileexport.TableExport.export(TableExport.java:27)
    at net.sourceforge.squirrel_sql.fw.gui.TablePopupMenu$ExportAction.actionPerformed(TablePopupMenu.java:495)
    at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1972)
    at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2314)
    at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:407)
    at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
    at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:374)
    at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1029)
    at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1073)
    at java.desktop/java.awt.Component.processMouseEvent(Component.java:6621)
    at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3404)
    at java.desktop/java.awt.Component.processEvent(Component.java:6386)
    at java.desktop/java.awt.Container.processEvent(Container.java:2266)
    at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:4996)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2324)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4828)
    at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4948)
    at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4575)
    at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4516)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2310)
    at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2780)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4828)
    at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:775)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:720)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:714)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:87)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:98)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:747)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
    at java.base/java.security.AccessController.doPrivileged(AccessController.java:400)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:87)
    at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:744)
    at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:101)
    at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
           

Log in to post a comment.

MongoDB Logo MongoDB