Exporting a date column with the ability to filter in a levels tree #3281
Labels
No Label
DBF
Dates
Defined Names
Features
Formula
HTML
Images
Infrastructure
Integration
International
ODS
Operations
Performance
PivotTables
Pro
Protection
Read Bug
SSF
SYLK
Style
Write Bug
good first issue
No Milestone
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: sheetjs/sheetjs#3281
Loading…
Reference in New Issue
Block a user
No description provided.
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
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)
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:
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) ?