Messages

1

Bug Report / Re: Custom column format not respected on excel export

« on: April 03, 2018, 11:15:58 pm »

Here it is.

2

Bug Report / Re: Custom column format not respected on excel export

« on: March 28, 2018, 02:58:01 pm »

My partner sent me some debugging data for you. Please find it attached.

3

Bug Report / Re: Custom column format not respected on excel export

« on: March 27, 2018, 02:19:03 pm »

This solution is good for displaying the German format the right way. But as it is String, our customers won't be able to use it for further calculation.

So question to you, Sir:
Would it be possible to provide a fix not needing this workaround? Eventually as a seperate .js file one could load after pqgrid.js so it works not only for the latest version?

Thank you in advance!

4

Bug Report / Re: Custom column format not respected on excel export

« on: March 20, 2018, 06:44:02 pm »

Thanks.

The data pqgrid gets are correctly formatted JSON values.

To make it easier for me to understand your code:
Could you please point out, which code (line number in pqgrid.dev.js ver 4.0.1) is executed to handle the "format" property of the colModel?
This would be great for my partners and me to study and understand.

Thanks again.

5

Bug Report / Custom column format not respected on excel export

« on: March 15, 2018, 11:02:51 pm »

Hi

On PQ 4.0.1 I'm using the German format for float cells "format = '#,###.00'".

This works in CSV but not in Excel.

The cells with 0,00 in Excel are formatted as "#,###00". What I need is: "#.##0,00".

Cells with values in Excel are formatted as "#,###00". What I need is: "#.###,00".

Any suggestions?

6

Help for ParamQuery Pro / Re: Flyout menu on the right

« on: October 06, 2017, 03:17:53 pm »

Have it now like so:

Code: [Select]

@import "../vendor/../js/vendor/jquery-ui-1.11.4/themes/smoothness/jquery-ui.min.css";
@import "../vendor/paramquery-4.0.1/pqgrid.min.css";
@import "../vendor/paramquery-4.0.1/pqgrid.ui.min.css";
@import "../vendor/paramquery-4.0.1/themes/office/pqgrid.min.css";

Its the same order as in the fiddles you post but it still looks the same. Even with my custom css removed.

7

Help for ParamQuery Pro / Re: Flyout menu on the right

« on: October 06, 2017, 02:28:38 pm »

Thanks. Now the markup is right but there seems to be a css issue (see screenshots).

This is my relevant css:

Code: [Select]

@import "../vendor/../js/vendor/jquery-ui-1.11.4/themes/smoothness/jquery-ui.min.css";
@import "../vendor/paramquery-4.0.1/pqgrid.dev.css";
@import "../vendor/paramquery-4.0.1/themes/office/pqgrid.min.css";

Seems I need to make some change to it, do I?

8

Help for ParamQuery Pro / Re: Flyout menu on the right

« on: October 05, 2017, 09:30:09 pm »

Thanks for you reply. JsFiddle would take some time if needed.

Theese are the versions and their loading order:

Code: [Select]

<!--#include virtual="../js/vendor/jquery-3.2.1.min.js" -->
<!--#include virtual="../js/vendor/jquery-migrate-1.4.1.min.js" -->
<!--#include virtual="../js/vendor/jquery-ui-1.12.1/jquery-ui.min.js" -->
<!--#include virtual="../js/vendor/jquery.ui.touch-punch.min.js" -->
<!--#include virtual="../vendor/paramquery-4.0.1/jsZip-2.5.0/jszip.min.js" -->
<!--#include virtual="../vendor/paramquery-4.0.1/pqgrid.dev.js" -->
<!--#include virtual="../vendor/paramquery-4.0.1/localize/pq-localize-de.min.js" -->

Thanks

9

Help for ParamQuery Pro / Translation question

« on: October 04, 2017, 09:53:00 pm »

The strings in the attachment aren't translated into German. How can I do this without modifying your source every release?

10

Help for ParamQuery Pro / Flyout menu on the right

« on: October 04, 2017, 09:48:22 pm »

For the flyout menu on the right (Merge cells, Fix colums, Grand summary) the markup differs from your examples in comparison to your downloadable JS.

How come (see attachments)?

11

Help for ParamQuery Pro / Re: Show sum of columns resp. selected cells at extra row

« on: October 03, 2017, 02:59:43 pm »

Thanks. ShowBottom was the culprit. Now it works as expected ;-)

12

Help for ParamQuery Pro / Re: Show sum of columns resp. selected cells at extra row

« on: October 02, 2017, 03:39:22 pm »

At first: I want to thank you very much for your kindful help and patience. I'm very grateful for that.

To my code:
As you see in post #7 I create an array of objects dynamically and give that to paramquery to create the colModel.
You wrote the first example looks correct to you.

I isolated one of this objects out of the array and added a screenshot of the object to this post.

For me it looks correct. But please have a look as it's still not working.

13

Help for ParamQuery Pro / Re: Show sum of columns resp. selected cells at extra row

« on: September 29, 2017, 09:15:21 pm »

Ah. I just modified the fiddle you posted in post 8.

14

Help for ParamQuery Pro / Re: Show sum of columns resp. selected cells at extra row

« on: September 29, 2017, 06:25:21 pm »

Made a simple test case out of you JsFiddle.

Also no summaries visible there. Please have a look if you can elaborate what's wrong.

Thanks.

15

Help for ParamQuery Pro / Re: Show sum of columns resp. selected cells at extra row

« on: September 29, 2017, 12:56:36 pm »

Latest 3 branch isn't working too.