Excel table export from Summary page

[ebruchez]

This is a spinoff of #1057.

What we'd like to do is provide the end user with the ability to output the Form Runner Summary table as they see it. This must include:

• field values shown
• rows filtered by search
• sort order
• metadata

Remaining tasks:

• [x] honor show properties
• [x] format dates, etc. should show as on page
• [x] show document id as first column (we could have an option to omit it)
  • entered issue #6329
• [x] can we/should we show Label headings?

[ebruchez]

We should use the same formats that the Summary page uses, at least by default.

• [x] Summary truncates textareas: export should not do that, unless reaching the max cell size
  • currently not truncated in the export, nor checking the maximum size
• [x] Selection controls: use tokens
• [x] Secret: output value?
  • currently exporting the value as is, but this is very rarely used
• [x] Date/Time/Date and Time: use Summary formats in language
• [x] Day Time Duration: any use?
  • currently no use, not done
• [x] What about numbers?
  • entered issue #6330
• [ ] Alignments?

[ebruchez]

The regular Excel Export uses its own formats for date and times (see also #6324). Here, we'd like to match what's shown in the columns, which are custom formats from the resources.

However, this means we'd need to convert from the XPath format to the Excel format. In French:

• Le [D] [Mn] [Y] (not sure why we use "Le", probably not needed)
• [H01]:[m01]:[s01]
• [D] [Mn] [Y] à [H01]:[m01]:[s01]

Tasks:

• [x] Handle date and time formats:
• [x] Q: Should we show control labels as headings, or control names?
  • Headings: human-readable
  • Names: machine-readable, like for the import feature (which would need to be adjusted too: ignore metadata, in particular)
  • or could show two rows?

[ebruchez]

Current Excel format	Current XPath format	Summary page
yyyy-mm-dd hh:mm:ss	[MNn] [D], [Y] [H01]:[m01]:[s01	May 14, 2024 14:27:15

The equivalent Excel format to match the Summary page format would be (tentatively):

mmmm d, yyyy hh:mm:ss

[ebruchez]

At first, until we can generate Excel formats from XPath formats, we could use meaningful defaults. For English:

• mmmm d, yyyy
• hh:mm:ss
• mmmm d, yyyy hh:mm:ss

[ebruchez]

For MVP:

• [x] Make "Last Modified", etc. human-readable headers for consistency

[ebruchez]

• [x] current language is not passed

[ebruchez]

• [x] doc
• [x] enter follow-up issue(s)
• [x] 2023.1-pe branch: fix issue where metadata order is incorrect

[ebruchez]

Documented