Ticket #298 (closed enhancement: fixed)

Opened 5 years ago

Last modified 5 years ago

Nice to have: interpret to some extend some excel 'functions'

Reported by: work@… Owned by: e.vansomeren@…
Priority: minor Milestone: 0.8.1
Component: Import wizard Version: 0.6.3
Keywords: Cc:
Hardware: Operating system:
Product: URL:


Eugene frequently uses the 'concatenate' functionality in Excel, which concatenates several columns into one. However, this is a function stored in the excel sheet.

After importing such a column in a text field you will see the actual function (e.g. CONCATENATE(N4,"_",AA4,"_",AL4,AM4,"_",X4) ). It would be a nice feature that some of these functions could be interpreted by the importer, if possible.

Other functions:


Perhaps the java library is able to interpret these automatically?

Change History

comment:1 Changed 5 years ago by robert@…

The poi website on http://poi.apache.org/spreadsheet/eval.html shows how to evaluate those functions. Probably you could use one of these methods

comment:2 Changed 5 years ago by work@…

  • Milestone changed from Should have to 0.8.1

comment:3 Changed 5 years ago by t.w.abma@…

  • Status changed from new to assigned
  • Owner changed from t.w.abma@… to e.vansomeren@…

Added in revision [1801], tested with some basic functions like =NOW() and concatenation (=A1&A2) seems to work. POI supports quite some functions, but good idea if this is tested by Eugene. Still we should be careful to support complex formulas. Preferably just copy/paste formula calculated values in Excel before importing.

comment:4 Changed 5 years ago by work@…

  • Status changed from assigned to closed
  • Resolution set to fixed
Note: See TracTickets for help on using tickets.