Messages

1

Help for ParamQuery Pro / Sort by time locally

« on: May 06, 2015, 01:27:38 am »

I see there is a custom sort option "sortType" available in 2.4.0.  Anything similar to this on 2.3.0 or do we have to upgrade to get the custom sort option?

I'm looking for a way to sort date and time locally.  Thanks!

ryan

2

ParamQuery Pro Evaluation Support / Sort by time locally

« on: May 05, 2015, 12:02:01 am »

I see that there is a way to sort locally by date.  Is there a way to sort locally by time as well?  Or do I have to do a remote ajax call to sort by time?

3

ParamQuery Pro Evaluation Support / Re: Excel export not working with hidden columns

« on: April 16, 2015, 11:08:15 pm »

1) So the Excel export works best with an .xml file extension?  Is there any plans to optimize this with the default Excel format .xlsx (which is in .xml format)?  It's a vastly better user experience to have an .xlsx extension as no regular user (and most advanced users for that matter) would think to open an .xml file in Excel.  That and warnings always scare users.  Highly recommend changing this.  We removed this function from our grid because of this.

2) No difference between display/non-displayed columns on a Mac for exports.  Mac in general simply doesn't work well for Excel exports.  CSV is fine.

4

ParamQuery Pro Evaluation Support / Re: Excel export not working with hidden columns

« on: April 02, 2015, 02:44:16 am »

Thanks for this.  I just applied the workaround and it works, but now I get a different error.  On a Windows machine I see the following error message when attempting to open the spreadsheet:

"The file format and extension of 'Test_export.xls' don't match.  The file could be corrupted or unsafe.  Unless you trust the source, don't open it.  Do you want to open it anyway?"

I open it anyway and it opens fine...why the format warning??  Didn't have this before we had hidden columns.

And on a Mac I can open the file just fine, but most of the columns are empty (13 of 14 actually).  Is there some kind of known bug for the excel export on a Mac (with Excel)?  I've actually always seen this...not specific to the addition of hidden columns.

thanks!
ryan

5

ParamQuery Pro Evaluation Support / Excel export not working with hidden columns

« on: March 16, 2015, 09:27:08 pm »

I have a need to hide certain columns in the GUI, but when a user chooses to export to csv or excel ALL of the columns need to be exported (including hidden ones).  An export to CSV works just fine, but Excel doesn't.

Excel won't open the workbook and I see this error in a log file when trying to open the .xls file:
XML ERROR in ExcelWorkbook description
REASON: Bad Value
FILE:   Test_Leads.xlsyan:downloads:test_leads.xls
GROUP:  Table
TAG:    Column
ATTRIB: Width
VALUE:  undefined

The raw .xls file opened in a regular text editor shows this snippet:
<Column ss:AutoFitWidth="1"  ss:Width="110" />
<Column ss:AutoFitWidth="1"  ss:Width="undefined" />

...and I can tell that the "undefined" column is one that's marked as hidden.  So it looks like the excel export doesn't grab the predefined column width for a hidden column.  Any suggestions? 

Thanks!