The Send to Excel function is working differently for different Page Types:
- if you use it a List you get the Dialog to Save the Excel file
- for all the other Page Types it's using the OpenXML to generate the file
Why is this an issue?
Because for Terminal Server Environments you can still Send the (List) Pages to Excel even if the application itself is not installed. Yes, you can use the Copy Rows functionality but it's not 100% because
- it cannot deal with linebreaks
- formats like decimal places, date etc.
Is there any way to use the same method (the first one where you get the dialog) for all the Page Type? Maybe some property or Cumulative Update?
I've tried with version 2015 from 2016 CU8