Exporting a date column with the ability to filter in a levels tree #3281

Open
opened 2025-02-02 07:17:38 +00:00 by evgenirovinsky · 0 comments

Hello,

I have a question and hopefully you will have a quick answer.

I am exporting a date column and want to be able to filter it in a recursive tree.

I have an example Excel Sheet where it works (28 EP pivot.xlsx)

image

I am using the same formula:

[$-en-US]mm"/"dd"/"yyyy

Setting the cell:

{
v: '11/20/2013',
t: 'd',
z: '[$-en-US]mm"/"dd"/"yyyy'
}

And it works, but the underlying values also get a time extension:

image

image

As a result, 3 additional levels of selection are added to the tree.

I attached also the Excel generated with XLSX-JS (28 EP 2025-01-28 (18).xlsx)

I tried setting a date object in the v fields, as well as ISO strings - same result.

I don't need seconds, minutes and hours. Only the date - for values and for the filter.

Can you suggest what would be the best way to achieve this (same as in the other excel) ?

Hello, I have a question and hopefully you will have a quick answer. I am exporting a date column and want to be able to filter it in a recursive tree. I have an example Excel Sheet where it works (28 EP pivot.xlsx) ![image](/attachments/d04786c9-b2bc-4f4b-ae1a-3035913c849e) I am using the same formula: [$-en-US]mm"/"dd"/"yyyy Setting the cell: { v: '11/20/2013', t: 'd', z: '[$-en-US]mm"/"dd"/"yyyy' } And it works, but the underlying values also get a time extension: ![image](/attachments/913d7564-d654-4732-9c10-8ff6abe08106) ![image](/attachments/45b59f63-4e2a-4a17-9ef4-43cf031ae6c2) As a result, 3 additional levels of selection are added to the tree. I attached also the Excel generated with XLSX-JS (28 EP 2025-01-28 (18).xlsx) I tried setting a date object in the v fields, as well as ISO strings - same result. I don't need seconds, minutes and hours. Only the date - for values and for the filter. Can you suggest what would be the best way to achieve this (same as in the other excel) ?
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#3281
No description provided.