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
Export to XLSX file not working correctly
Moderators: Moderators, Tech Support
-
- Posts: 3
- Joined: Wed Jul 06, 2022 11:31 am
Re: Export to XLSX file not working correctly
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.AllenOsborne wrote: ↑Thu Nov 21, 2024 10:44 amWhen 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
I'll highlight this for the techs.
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
-
- Tech Support
- Posts: 3106
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Export to XLSX file not working correctly
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.
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.
-
- Posts: 3
- Joined: Wed Jul 06, 2022 11:31 am
Re: Export to XLSX file not working correctly
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.
-
- Posts: 3
- Joined: Wed Jul 06, 2022 11:31 am
Re: Export to XLSX file not working correctly
Thank you, Zorak. I searched for previous posts on this topic before submitting mine, but I missed that post.Zorak wrote: ↑Fri Nov 22, 2024 3:53 pmIt'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.