Ticket #298 (closed enhancement: fixed)
Nice to have: interpret to some extend some excel 'functions'
|Reported by:||work@…||Owned by:||e.vansomeren@…|
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.
Perhaps the java library is able to interpret these automatically?