Thank you for your feedback! You have rated this topic in the last 30 days.
Working with Spreadsheets in ReportPlus
Below are a couple of helpful tips and tricks for working with spreadsheets within ReportPlus.
ReportPlus expects your data to be organized in columns and will name fields after the spreadsheet’s first row. If your data is organized in rows instead, you can transpose the fields in ReportPlus.
When working with CSV files, avoid formatting the spreadsheet. Instead, apply any necessary formatting (1000 comma separators, currency signs, etc.) through ReportPlus.
The Quick Look option for an Excel or CSV file will only show data in the first sheet by default. You can select the specific sheet in the Parameters section.
For 2 or more series charts, the order in which you drop fields in "Columns", "Rows" and "Values" will determine how the chart is plotted, regardless of the column order in your Excel file.
If columns have different types of data combined (strings, numbers, etc.), ReportPlus will treat them as a column with strings only. This will affect, among other things, formatting.
Password-protected files and hidden ranges are not supported in ReportPlus.
Excel files allow you to select a custom range of data within your spreadsheet, while CSV do not. If you need to select specific data, make sure you always work with an Excel spreadsheet.
Excel formulas such as RAND and RANDBETWEEN will not generate random results in ReportPlus. In order to achieve dynamic results, you will need to use Math Calculated Fields.
If you want a date as a column header, make sure you include a ' so Excel will respect your format. The default date format for headers is the full-length format (YYYY-MM-DD 00:00:00 +0000).
Percentages in Excel sheets will be shown in a 0 to 1 scale unless the format is changed to "Percentage". For example, 39% will be displayed as 0.39.
This page has encountered an error. We've attempted to send the information to the server.
