What worked consistently for me was to write the following formula: The format doesn’t change the value and the Excel driver ignore the format. I did some testing today and found that you can’t simply format the column to TEXT format. Unfortunately the only way to get this is to change the data in the column. The problem is usually that people need ALL the values and they want them all to be strings. So if the first 8 data rows have 5 numbers and 3 strings, the column will be called a numeric and all strings are NULL. The Excel driver (by default) will scan the first 8 rows of the spreadsheet and each column will be assigned the data-type of the majority of the values in those 8 rows (excluding the header row). But with a bit of research and testing I now feel I have a handle on it. The problem for me has been that I could never find the rules for the decision. Once it decides on a type, all values that are NOT that type become null. Crystal has to decide (guess) the data type of the column based on the data that it sees. The problems start when you have columns with mix of data types, usually a string column that has some numeric values mixed in. Excel columns don’t have a data type so Crystal (or more specifically the Excel driver) has to guess the data types of each column. But there is one huge headache that I have had repeatedly over the years. People love to work with Excel, and Crystal does a decent job of reading Excel tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |