Hi all! I need help with the Cuba Report module. I have a CSV report template in which one of the columns contains data in the form of a string, for example “000001”. But after the report is created, the zeros are cut off and an integer remains. How can I make sure that the data remains in its original string form inside the CSV template?
I’ll add some information. If you escape the string as “="” + value + “"”. In the csv file, the column takes the required data format. But if there is a need to convert a CSV file using a Power query into Excel, the data types are determined by Excel. I would like to trick Excel in some way so that it detects the column type as text instead of a number.
Solution: append 5 spaces to the value at the end, then everything will be good. Magic is nothing more!