MashZone NextGen 10.2 | Appendix | Legacy Presto components | Mashables and Mashups | Mashables | Types of Mashable Information Sources | Spreadsheet Mashables | Valid Labels and Values for Spreadsheet/CSV Mashables
 
Valid Labels and Values for Spreadsheet/CSV Mashables
Some labels and data that are valid in CSV files or Excel spreadsheets are not valid or not accessible in MashZone NextGen. In the following cases, MashZone NextGen may alter labels or transform or ignore the information:
*Formulas in spreadsheets are valid, but the formula itself is not exported to the mashable in MashZone NextGen. The result of the calculation (the data) is exported instead.
*Column labels:
*Are recommended, but optional, for each column that contains data.
If column labels are missing, MashZone NextGen automatically generates labels in the form Column1, Column2 and so on.
*Are limited to letters, numbers and underscores in the ISO-8859-1 character set, also known as Latin 1.
Spaces and most symbols or punctuation characters are either converted to an underscore or ignored.
*Must start with a letter (an alphabetical character) although they can contain numbers after that. Column labels that do not start with a letter are altered or overridden.
*If a column label starts with a number or is a formatted date, MashZone NextGen adds a prefix of Column_ to the label.
*Can only be provided by one row. For CSV files, this must be the first row.
For spreadsheets you can identify which row supplies the column labels when you register the mashable. If your spreadsheet has column names in two or more rows, you must choose a single row, allow MashZone NextGen to generate column labels or simplify your worksheet.
*Cannot span two or more cells in a spreadsheet. MashZone NextGen treats the second and subsequent columns as missing labels. You can allow MashZone NextGen to generate column names for the second and subsequent columns or you can update your worksheet.
*Charts, images or other objects in spreadsheets are ignored and not saved in mashable data.

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release