Export to XLSX file not working correctly

Got a question or comment about PowerChurch that doesn't belong anywhere else? Why not post it here!?

Moderators: Moderators, Tech Support

Post Reply
AllenOsborne
Posts: 3
Joined: Wed Jul 06, 2022 11:31 am

Export to XLSX file not working correctly

Post 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

NeilZ
Posts: 10440
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Export to XLSX file not working correctly

Post 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.
Neil Zampella

Using PC+ since 1999.

Zorak
Tech Support
Tech Support
Posts: 3106
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: Export to XLSX file not working correctly

Post 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.

AllenOsborne
Posts: 3
Joined: Wed Jul 06, 2022 11:31 am

Re: Export to XLSX file not working correctly

Post 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.

AllenOsborne
Posts: 3
Joined: Wed Jul 06, 2022 11:31 am

Re: Export to XLSX file not working correctly

Post 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.

Post Reply