Since 3.5.3,whenever I output results to Excel, any cell that is null outputs to the spreadsheet as "<null>". It used to and think should just be blank in the output.
I do not have access to an Oracle server since I suffered a hard disc crash some time ago. And as usual I did not get a new server to work quickly. So here is my question:
Would it be possible for you to create a Linux VM for Virtual Box (.vdi file) with a free Oracle version installed and a database table to reproduce the problem?
You could send me such a VM using some file sharing site like wetransfer.com
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I don't know how to create a Linux VM, and my experiences with installing Oracle have not been great, so I don't think I can be of help with that.
I git cloned Squirrel and imported the master branch into an Eclipse workspace to try and debug it, but I'm not seeing how to run it with the same UI and everything. Are there instructions for setting up a workspace and running it in Eclipse (does it require an Ant build to run)? I have JDK 1.8 u20 installed.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have an Oracle database for testing and tried to replicate this issue. I downloaded SquirreL 3.5.3 and exported a query with nulls. On the spreadsheet, they appeared as blank cells rather than <null>. What settings are you using for your export?
I did encounter an error with exporting to .xls format as Excel complained that the file was in a different format than the extension, however this was not related to the error you mention. For this error, it appears that the export is always .xlsx even when .xls is requested.
[cid:image001.png@01CFD89D.B27F8380]
I may be able to help replicate your issue if you provide more information.
--
Dr. Ramon Lawrence
Associate Professor, Computer Science
University of British Columbia
From: szeck87 [mailto:szeck87@users.sf.net]
Sent: Wednesday, September 24, 2014 4:53 PM
To: [squirrel-sql:bugs]
Subject: [squirrel-sql:bugs] #1158 Export to excel outputs null values as "<null>"
I don't know how to create a Linux VM, and my experiences with installing Oracle have not been great, so I don't think I can be of help with that.
I git cloned Squirrel and imported the master branch into an Eclipse workspace to try and debug it, but I'm not seeing how to run it with the same UI and everything. Are there instructions for setting up a workspace and running it in Eclipse (does it require an Ant build to run)? I have JDK 1.8 u20 installed.
Status: open
Group: 2.1final
Created: Fri Sep 19, 2014 03:23 PM UTC by szeck87
Last Updated: Wed Sep 24, 2014 07:12 PM UTC
Owner: nobody
Since 3.5.3,whenever I output results to Excel, any cell that is null outputs to the spreadsheet as "<null>". It used to and think should just be blank in the output.
Could you please give some details:
- Which database?
- Which column types?
Oracle. With the Oracle thin driver. Happens with any column type, varchar2, date, char, etc.
I do not have access to an Oracle server since I suffered a hard disc crash some time ago. And as usual I did not get a new server to work quickly. So here is my question:
Would it be possible for you to create a Linux VM for Virtual Box (.vdi file) with a free Oracle version installed and a database table to reproduce the problem?
You could send me such a VM using some file sharing site like wetransfer.com
I don't know how to create a Linux VM, and my experiences with installing Oracle have not been great, so I don't think I can be of help with that.
I git cloned Squirrel and imported the master branch into an Eclipse workspace to try and debug it, but I'm not seeing how to run it with the same UI and everything. Are there instructions for setting up a workspace and running it in Eclipse (does it require an Ant build to run)? I have JDK 1.8 u20 installed.
Hello,
I have an Oracle database for testing and tried to replicate this issue. I downloaded SquirreL 3.5.3 and exported a query with nulls. On the spreadsheet, they appeared as blank cells rather than <null>. What settings are you using for your export?
I did encounter an error with exporting to .xls format as Excel complained that the file was in a different format than the extension, however this was not related to the error you mention. For this error, it appears that the export is always .xlsx even when .xls is requested.
[cid:image001.png@01CFD89D.B27F8380]
I may be able to help replicate your issue if you provide more information.
--
Dr. Ramon Lawrence
Associate Professor, Computer Science
University of British Columbia
From: szeck87 [mailto:szeck87@users.sf.net]
Sent: Wednesday, September 24, 2014 4:53 PM
To: [squirrel-sql:bugs]
Subject: [squirrel-sql:bugs] #1158 Export to excel outputs null values as "<null>"
I don't know how to create a Linux VM, and my experiences with installing Oracle have not been great, so I don't think I can be of help with that.
I git cloned Squirrel and imported the master branch into an Eclipse workspace to try and debug it, but I'm not seeing how to run it with the same UI and everything. Are there instructions for setting up a workspace and running it in Eclipse (does it require an Ant build to run)? I have JDK 1.8 u20 installed.
[bugs:#1158]http://sourceforge.net/p/squirrel-sql/bugs/1158 Export to excel outputs null values as "<null>"
Status: open
Group: 2.1final
Created: Fri Sep 19, 2014 03:23 PM UTC by szeck87
Last Updated: Wed Sep 24, 2014 07:12 PM UTC
Owner: nobody
Since 3.5.3,whenever I output results to Excel, any cell that is null outputs to the spreadsheet as "<null>". It used to and think should just be blank in the output.
Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/squirrel-sql/bugs/1158/https://sourceforge.net/p/squirrel-sql/bugs/1158
To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/https://sourceforge.net/auth/subscriptions
Related
Bugs:
#1158I finally got the master branch to run last night. It looks like it's only an issue with 3.5.3. The snapshot works fine.
This can be closed, no longer an issue on 3.6
Fixed in 3.6.