https://bugs.documentfoundation.org/show_bug.cgi?id=173053
--- Comment #9 from ady <[email protected]> --- Created attachment 208064 --> https://bugs.documentfoundation.org/attachment.cgi?id=208064&action=edit Text in IF statements with VALUE.ods I am attaching a modified ods, based on attachment 208059 from comment 8. The new file uses the VALUE() function (A13:E16). To be clear, I do not know the real conditions that should be used and thus the correct or incorrect results are not meaningful in this attachment. The issue in this ticket regarding significant / meaningful decimal places is also not involved in this new attachment. The only aspect of this new attachment is the usage of the VALUE() function. The cells in which the VALUE() function is used would need relevant (display) cell formatting (e.g. number of decimal places). At first glance, this attachment seems to be unrelated to the main issue in this ticket, but it demonstrates the confusion between how the data is displayed vs the calculations. If the results of eventual calculations require specific meaningful decimal places, these would still require the (display) Cell Format to be set accordingly. The second aspect in relation to this ticket of these sample ods files is that it (hopefully) shows that the requested "setting" that would "use" the numeric values with their decimal places "as shown" is not really a setting for the _import_ action, but rather it is how spreadsheet tools perform calculations (and please also consider the link I posted in comment 1 about "Accuracy"). Let's assume that you could initially import numeric values "as-is" (instead of importing it as Text); as soon as you edit a (numeric) cell within Calc, the trailing zeroes would be deleted from the stored data. So the issue is not how the data is imported (or typed-in) initially, but rather how data is stored and how calculations are performed. How easy or how difficult the cell formatting would be depends on the layout of the data too. For instance, if each column has "similar" type of data, then it is easier to apply a consistent formatting. -- You are receiving this mail because: You are the assignee for the bug.
