Show Posts
1
Help for ParamQuery Pro / Exported Excel Issues with Merged Cells and SUM in WPS/MS Office
« on: June 19, 2025, 12:36:42 pm »
Hi,
I'm facing a couple of issues with Excel files exported from ParamQuery Grid:
The exported Excel file is downloaded with a .xls extension, which doesn't open properly in Microsoft Office. To work around this, I renamed it to .xlsx, and it opens fine.
However, I'm encountering a problem with merged cells in the exported file. When using the SUM() function on merged cells:
In WPS Office and Microsoft Excel, the sum includes duplicate values from the merged regions (i.e., it adds hidden values under the merged cells).
In LibreOffice, it works correctly and only includes the value from the visible (top-left) cell in the merged range.
This issue appears only in Excel files exported from ParamQuery Grid. If I manually unmerge and remerge the cells in Excel, the problem is resolved — which suggests the initial export includes hidden values in all cells of the merged range.
Is there a way to modify the export logic in ParamQuery so that:
Only the top-left cell of a merged range contains a value,
The other cells in the merged range are left blank (like LibreOffice expects)?
Thanks!
I'm facing a couple of issues with Excel files exported from ParamQuery Grid:
The exported Excel file is downloaded with a .xls extension, which doesn't open properly in Microsoft Office. To work around this, I renamed it to .xlsx, and it opens fine.
However, I'm encountering a problem with merged cells in the exported file. When using the SUM() function on merged cells:
In WPS Office and Microsoft Excel, the sum includes duplicate values from the merged regions (i.e., it adds hidden values under the merged cells).
In LibreOffice, it works correctly and only includes the value from the visible (top-left) cell in the merged range.
This issue appears only in Excel files exported from ParamQuery Grid. If I manually unmerge and remerge the cells in Excel, the problem is resolved — which suggests the initial export includes hidden values in all cells of the merged range.
Is there a way to modify the export logic in ParamQuery so that:
Only the top-left cell of a merged range contains a value,
The other cells in the merged range are left blank (like LibreOffice expects)?
Thanks!