https://bugs.documentfoundation.org/show_bug.cgi?id=145499
--- Comment #6 from Colin <[email protected]> --- (In reply to Mike Kaganski from comment #5) > (In reply to Colin from comment #4) > > It does. E.g., in the example that I suggested, if you round the formula in > K1755 like '=ROUND(IF(G1755>0;G1755-I1755;"");1)', the double '73.6' entry > in the autofilter list will disappear. Don't misunderstand - not a criticism. I developed the sheet in Libre because it is the more user friendly and intuitive package but in daily use, it has been converted to Excel and then uploaded to Google sheets - simply because Google doesn't play well with ods files. The only reason for the tortuous route is that the "open in google drive" doesn't work and for me, having the sheet on the GDrive absolves me of the issue of preserving a constantly changing sheet against mishap. Being able to access it from other locations is a bonus. My point is that the error doesn't manifest in the GSheets version - is their stuff "open source"? Can it be inspected for inspiration in the resolution of the long decimal anomaly? -- You are receiving this mail because: You are the assignee for the bug.
