Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Business Analysts generate reports involving calculations, graphing tools and pivot grids and they usually share the results in the .xls or .xslx file format. The user mostly ends up opening multiple applications like a database server, excel, email client. Now this becomes time-consuming and tedious, if the user has to poll external databases, analyze the results, make a spreadsheet and e-mail these on a regular basis to a list of Business Analysts / Developers. Enhancements to the Query Analyzer has made this task so simple. We've made it easier to execute queries, get results, generate pivot grids and email it to users with the View as Spreadsheet, Email Excel Attachment buttons.
A button in the Grid Results toolbar allows you to either View as Spreadsheet, or Email as Excel Attachment (with email smtp settings entered in File-> Options-> Email) the selected cells and rows in the grid.
Configurable Excel Format
Excel 2007 is now available as an option in "Save Results As" or "View as Spreadsheet", and as a format for generating Pivot Grid and Pivot Grid Charts. Files can be saved as .xls or as .xlsx. Anywhere you can generate Excel results or use the View in Excel Viewer feature within the application you can now select which version of Excel (2003 or 2007) you would like for your output from within File -> Options - > General -> General -> Default Spreadsheet Format.
| Save Results As Excel 2007 |
Excel Version Defaults Options |
Excel interoperability is also equally supported in Aqua Open APIs.