Export to Excel: option to export entity-typed values as hyperlink to corresponding Entity Master

[01es]

Description

The action to export the data from Entity Centres to Excel should be enhanced with an option to export entity-typed values as hyperlinks to corresponding Entity Masters, instead of simply exporting those values as is. This options should be unchecked by default.

Implementation details

EntityExportAction should be enhanced with boolean property exportWithHyperlinks and description "Option to export entity values as hyperlinks to their corresponding Entity Masters."

Enhance WorkbookExporter to recognise the new option, generate appropriate hyperlinks and associated them with cells upon exporting (cell.setHyperlink(openMasterHyperLink).

Expected outcome

Ability to export data to Excel with hyperlinks to Entity Masters, providing the ease of accessing the exported entities in an application.