o-spreadsheet icon indicating copy to clipboard operation
o-spreadsheet copied to clipboard

[FIX] xlsx: export array formula

Open LucasLefevre opened this issue 2 years ago • 2 comments

Strange Excel Online behavior: =TRANSPOSE(A1:A10) seem to be exported as {=TRANSPOSE(A1:A10)} and the array can't be modified. Same behavior if exporting from GSheet and importing to excel online

When exporting from Excel Online, the cell has properties in a futureMetadata tag, looks like they are using a more recent file format version.

Description:

description of this task, what is implemented and why it is implemented that way.

Task: : TASK_ID

review checklist

  • [ ] feature is organized in plugin, or UI components
  • [ ] support of duplicate sheet (deep copy)
  • [ ] in model/core: ranges are Range object, and can be adapted (adaptRanges)
  • [ ] in model/UI: ranges are strings (to show the user)
  • [ ] undo-able commands (uses this.history.update)
  • [ ] multiuser-able commands (has inverse commands and transformations where needed)
  • [ ] new/updated/removed commands are documented
  • [ ] exportable in excel
  • [ ] translations (_lt("qmsdf %s", abc))
  • [ ] unit tested
  • [ ] clean commented code
  • [ ] track breaking changes
  • [ ] doc is rebuild (npm run doc)
  • [ ] status is correct in Odoo

LucasLefevre avatar Aug 16 '23 15:08 LucasLefevre

@LucasLefevre the target branch 'saas-16.4' has been disabled, you may want to close this PR.

robodoo avatar Jul 02 '24 10:07 robodoo