Page 1 of 1
Export to XLSX file not working correctly
Posted: Thu Nov 21, 2024 10:44 am
by AllenOsborne
When I save a Fund Accounting report as a file and select "Excel spreadsheet (XLXS)" as the Export file type, the report is saved as an XLS file rather than an XLSX file.
Can anyone offer a solution to this issue? Is there a setting I need to change in order to have PowerChurch save the file as XLSX rather than XLS?
System Info:
PowerChurch Plus 14.4 with latest Maintenance Release
Microsoft Excel for Microsoft 365 MSO (Version 2411 Build 16.0.18227.20002) 64-bit Desktop
Windows 11 23H2
Re: Export to XLSX file not working correctly
Posted: Fri Nov 22, 2024 3:47 pm
by NeilZ
AllenOsborne wrote: ↑Thu Nov 21, 2024 10:44 am
When I save a Fund Accounting report as a file and select "
Excel spreadsheet (XLXS)" as the Export file type, the report is saved as an
XLS file rather than an
XLSX file.
Can anyone offer a solution to this issue? Is there a setting I need to change in order to have PowerChurch save the file as XLSX rather than XLS?
System Info:
PowerChurch Plus 14.4 with latest Maintenance Release
Microsoft Excel for Microsoft 365 MSO (Version 2411 Build 16.0.18227.20002) 64-bit Desktop
Windows 11 23H2
FWIW ... there may be a 'bug' that needs to be reported, however, Excel should be able to read the XLS file without an issue for now.
I'll highlight this for the techs.
Re: Export to XLSX file not working correctly
Posted: Fri Nov 22, 2024 3:53 pm
by Zorak
It's basically Microsoft's Excel converter failing and not reporting an error occurred. Here is a post from a user that previously reported the same behavior:
viewtopic.php?p=61934#p61934
We rearranged the code to make LibreOffice the priority if it is installed, to use its converter, which is much more reliable than Microsoft's.
Re: Export to XLSX file not working correctly
Posted: Mon Dec 09, 2024 12:21 pm
by AllenOsborne
NeilZ wrote: ↑Fri Nov 22, 2024 3:47 pm
FWIW ... there may be a 'bug' that needs to be reported, however, Excel should be able to read the XLS file without an issue for now.
I'll highlight this for the techs.
Thank you, NeilZ!
Yes, you're correct, Excel can read the XLS file. Sometimes I need to open the exported PowerChurch file in Google Sheets, which only allows XLXS files, so I have to go through the extra step of converting the exported PC file before opening it in Google Sheets.
Re: Export to XLSX file not working correctly
Posted: Mon Dec 09, 2024 12:24 pm
by AllenOsborne
Zorak wrote: ↑Fri Nov 22, 2024 3:53 pm
It's basically Microsoft's Excel converter failing and not reporting an error occurred. Here is a post from a user that previously reported the same behavior:
viewtopic.php?p=61934#p61934
We rearranged the code to make LibreOffice the priority if it is installed, to use its converter, which is much more reliable than Microsoft's.
Thank you, Zorak. I searched for previous posts on this topic before submitting mine, but I missed that post.