5/20/2023 0 Comments Libre office calcA string with leading/trailing spaces around a number would indeed loose the spaces.like 44,567.00 when incrementing decimals. A string like 1/6 would become (en-US), and shown e.g.A string like 555e456789 would become 2E+308 ( e being interpreted as exponent separator, resulting in maximum representable value, having nothing in common with original text).A string like 1234 567 (ru-RU) or 1234,567 (en-US) - maybe some coordinates? - would become 1234567 (the placement of character separating two numbers, that happen to co-incide with group (thousand) separator, is lost).A fraction-like text entered like 1 7/14 would become number 1.5, shown as 1 1/2 (you can’t reconstruct the original denominator).More examples of texts that could be ruined by automatic conversion to number: Please don’t waste time submitting that there were a plenty of such requests, which indeed seem reasonable at a first glance, as long as one only considers the simplest cases, and doesn’t consider the fact that spreadsheets are designed to handle thousands of rows of data. Cell data is only defined at input time, not at formatting time. You do not want to discover that when you applied bulk-formatting, you also inadvertently destroyed some cell data (which you discover a week later).įormatting and data are orthogonal. And when you select that whole column, you may have selected some intermediate heading cells (imagine a heading cell with some ID consisting of 20 digits, which would happily convert to a number if it were allowed, but would only keep 15 digits of precision then). E.g., select a whole column, and apply another format, to see if that fits your liking. You may apply formatting to large portions of sheet. Formatting a cell must never change the cell data. Any reasonable person that selects a cell or cells containing data, right-clicks “Format Cells,” selects Number > General, should reasonably expect that data to be re-evaluated whether it is a number/formula or not.
0 Comments
Leave a Reply. |