https://bugs.documentfoundation.org/show_bug.cgi?id=173053
--- Comment #7 from [email protected] --- Thanks Ady I have included a csv file to help explain, this has different numbers of trailing zeros. There are two scenarios; 1. Manually entering data. If the data is typed in, then the cells are selected and the format changed to TEXT @ then the corruption of the data has already occurred and the entered 1.200 is forevermore 1.2 . If the cells are changed to TEXT @ first then the entered data remains as input, there is a caveat. 2. Importing externally generated data, the CSV file. When it is imported the import box shows the actual numbers as written, I've just noticed that I can change the columns individually from standard to text. That works as well, there is a caveat. Caveat: Some of the historic issues of doing Maths with TEXT cells appear to have been resolved. However if the Maths or function depends on an IF statement then it fails and more concerning, it doesn't fail with an error, it fails with the wrong result. See second file uploaded after this is submitted. We are back to the core issue. The requirement to maintain the decimal places as entered in order to use the spread sheet to do mathematical functions and be used in other areas of Libreoffice. If it was required that the number of decimal places were required to be read using for instance =LEN(A20) - FIND(".", A20) then this results in a failure so a condition can not be applied. The fact that the number is not a number creates a problem, the fact that Libreoffice automatically strips trailing zeros is the issue. I have not found a solution, I have read forums for years and I know other Engineers and Scientists have an issue with this. The only viable solution I can see is a format switch that does not strip the trailing zeros, hence my enhancement request. There is progressively more external data being generated in our automated world that could be usefully manipulated in Libreoffice calc and then accurately presented in writer or impress. As is stands, it can not safely be dealt with. -- You are receiving this mail because: You are the assignee for the bug.
