Messages

1

Bug Report / Tab name lengths over 31 chars corrupt Excel export

« on: November 10, 2022, 11:54:51 pm »

Export functionality in getWBook() should limit sheet names to 31 characters so that when the spreadsheet is opened in Excel, it does not cause an error. Excel requires tab names < 32 characters long.

I modified getWBook to call a getUniqueSheetName function that keeps track of used names and returns:

verylongnamethatcrashesexcelverylongnamethatcrashesexcel
anotherverylongnamethatcrashesexcelverylongnamethatcrashesexcel
athirdverylongnamethatcrashesexcelverylongnamethatcrashesexcel
-->
verylongnamethatcrashesexcelver
verylongnamethatcrashesexcelve2
verylongnamethatcrashesexcelve3

2

Bug Report / Re: Large Excel export causes browser crash

« on: October 29, 2022, 05:26:18 am »

Actually, that was breaking on very very large exports. I had to rewrite things to take advantage of JSZip3's support for Node streams in the file creation function.

3

Bug Report / Re: Large Excel export causes browser crash

« on: October 26, 2022, 10:00:45 am »

Hello again. I was able to get it working by removing all .join("") calls and modifying getSheet() to return buffered content as shown here: https://stackoverflow.com/a/46888173

4

Bug Report / Re: Large Excel export causes browser crash

« on: October 25, 2022, 01:49:07 am »

Hello, yes.
https://www.stats.govt.nz/assets/Uploads/International-trade/International-trade-June-2022-quarter/Download-data/international-trade-june-2022-quarter-csv.zip
In that zip file, the output_csv_full.csv can be imported but when exported in Excel format it crashes the browser tab.
Thank you.

5

Bug Report / Re: Large Excel export causes browser crash

« on: October 19, 2022, 06:06:55 am »

Upon further review, it looks like the crash happens before the zip, in getBody().

6

Bug Report / Large Excel export causes browser crash

« on: September 28, 2022, 04:22:46 am »

Previous topic: https://paramquery.com/forum/index.php?topic=3908.0

I believe the crash with large data sets may be caused because of the JSZip.generate function used. According to https://stuk.github.io/jszip/documentation/faq.html the generateAsync function would do better at avoiding browser crashes.

Would you be able to update the JSZip version used to take advantage of generateAsync?

7

Bug Report / Caret and plus characters in tab names break formula reference

« on: September 13, 2022, 05:15:23 am »

Steps to replicate:
1) Go to https://paramquery.com/pro/demos
2) Click "Tabbed spreadsheet" demo
3) Click "+" to add a new tab
4) In the first tab (PQ Invoice) add a formula that references the new tab, like in cell A11 enter "=sheet1!a1"
5) Rename the new tab to include a caret "^" and/or a plus "+"
6) In the first tab (PQ Invoice) enter a formula, like in cell A12 enter "=c3"

The formula entered in step 4 that references the new tab breaks after step 6. This only happens if the new tab has a caret or plus.

Bonus issue: Change a tab's name so that it contains a double quote ("). Then try to edit the tab name. Any characters after the double quote disappear.

8

Bug Report / Cut/paste of cell value does not update references to that cell

« on: September 13, 2022, 04:13:55 am »

Steps to replicate:
1) Go to https://paramquery.com/pro/demos
2) Click "Cut copy paste" demo
3) In cell A1 enter "=B1" so that A1 references B1's value
4) Select cell B1 and click "Cut"
5) Select cell B2 and click "Paste"

The formula in cell A1 is not updated to point to the new location of B2. In Excel and Google Sheets cutting and pasting updates any references to cut/pasted cells.

9

Bug Report / Copy/paste of incongruent columns pastes everything to one column

« on: September 10, 2022, 03:26:43 am »

There is already this issue, but I"m not sure if I should continue posting there or not:
https://paramquery.com/forum/index.php?topic=2569.msg9912#msg9912

Steps to replicate:
1) Go to https://paramquery.com/pro/demos
2) Click "Cut copy paste" demo
3) Hold down Command/Alt key and select column A and C or any columns not next to one another in Grid A
4) Click "Copy" in Grid A
5) In Grid B click "Paste"

Note, data for both columns is pasted into one column, with data for column C below the data for column A.

When copying data from adjacent columns the data looks like this:
a1     b1
a2     b2
a3     b3

But when copying from non-adjacent columns the copied data looks like this:
a1
a2
a3
b1
b2
b3

So I believe the issue is in copying, not pasting.

10

Bug Report / Re: Deleting column causes formulas to stop working

« on: September 02, 2022, 05:12:37 am »

Thank you! In the mean time, is there any chance you could provide a patch to fix the issue? I've been trying to fix it myself, but no luck so far.

11

Bug Report / Deleting column causes formulas to stop working

« on: August 27, 2022, 12:21:31 am »

ParamQuery Pro 8.5.0 and earlier versions, at least since 8.3.0.

Steps to replicate:
1) Go to https://paramquery.com/pro/demos/context_menu
2) Enter a formula in a cell [like "=1+1" in cell A1]
3) Delete the column where the formula was entered [use context menu on cell A1 to delete column]
4) Enter a formula that references another cell [like in cell A1 enter "=D4" and press Enter]

Note, formula does not work and error in console. Cannot get any new formula to work.

Thank you.

12

Help for ParamQuery Pro / Re: Excel like Data Bars

« on: April 09, 2022, 08:45:56 pm »

Wow. Simply amazing! Thank you.

13

Help for ParamQuery Pro / Excel like Data Bars

« on: April 07, 2022, 08:54:26 pm »

I'm looking to implement an Excel like DataBars feature for numeric columns. Please see the attached screenshot. For the row containing the max value in the column, it would fill the entire cell's background color. For the row containing the minimum value it would be empty. However for the values in-between it would only fill a certain portion appropriately. Any advice on how we could approach this?

14

Help for ParamQuery Pro / Re: Pivot Help. How to create multiple aggregates from the same column

« on: March 29, 2022, 05:47:29 pm »

I see. Thanks for that example. Is it possible to do this without explicitly creating a new columns in the drag and drop selector? The use case I'm targeting would contain a few dozen columns. While this approach would work, it would explode the number of columns seen by the user.

15

Help for ParamQuery Pro / Pivot Help. How to create multiple aggregates from the same column

« on: March 28, 2022, 09:11:09 pm »

Can you please provide an example on how can I change the following pivot demo to be able to allow the use to display multiple aggregates for the same column? For example I want to be able to use the Pivot Mode to display max, min, avg at the same time for any column like Gold.

https://paramquery.com/pro/demos/pivot