Hi,
Excel formula outputed through SQL are intepreted as text upon excel files opening and needs to be "activated" (select cell, press enter).
Woud be very nice to allow direct excel formula in report output.
Example : Create a clickable URL link in excel to an online place (sharepoint) where reports are stored.
-> Very useful in a "meta" report, that holds other reports name / description / type / count
Best regards
Guillaume Brochet
We will review this but it comes down to what's possible in Excel and the third party plugin we use to support Excel integration. We will investigate and see what is possible.
There is a product accelerator available to download via the support site that can integrate with Sharepoint, OneDrive, Teams from a file perspective already.
In the existing HELP/ INSTRUCTIONs tab options in excel integration the implmentation team can put these sharepoint links in their spreadsheet already.
Completely agree with Pedro.
Excel output should be more customizable : Auto Filter -> Must Have,
Add a logo, a date of report run, filename, colors etc ...
I understand Syniti rely on third party plugin -> What's the name ? i'll submit my ideas there ;)
Attachments Open full size
These are different asks, but sticking to the plot, excel downloaded data needs enhancement - level 1 spec here would simply ask for data types from underlying schema set being honored in excel formats. So format text as text, numerics as numerics, dates as date as a starting point for conversation.
supporting keywords like link: to ensure hyperlink is created would be a great 4th but over and above. Let's deal with the text PLEASE. Also setting AUTOFILTER automatically on header row AND freezing top row - TABLE STAKES!!!
Lots more to do here, but let's start with the basics.
Attachments Open full size
Hi,
Excel formula outputed through SQL are intepreted as text upon excel files opening and needs to be "activated" (select cell, press enter).
Woud be very nice to allow direct excel formula in report output.
Example : Create a clickable URL link in excel to an online place (sharepoint) where reports are stored.
-> Very useful in a "meta" report, that holds other reports name / description / type / count
Best regards
Guillaume Brochet
Attachments Open full size