https://bugs.documentfoundation.org/show_bug.cgi?id=77834
--- Comment #15 from DF <[email protected]> --- It's not quite the same as this issue. Here it's about keeping the number of decimals displayed the same as the number entered. Eg paste 01.00 and shows up as 01.00 instead of 1 in the cell. Could do this by having a setting in formatting options whereby the format adapts to the data entered. Eg paste 01.00 and would either preserve the formatting as was entered (eg similar to text or WYSIWYG), or set the formatting for that cell as '#0.00'. And/or could paste a list of values along with a format notation either beside or after in a 'format code edit mode' whereby the spreadsheet shows the format codes for each cell. For many cases this doesn't matter as typically a list of numbers will be formatted the same length so can select all data and apply single format code, however this issue is for a list of numbers whereby the number of leading or trailing zeros changes throughout and wants to be preserved (eg for scientific notation). Yet currently this requires manually formatting each individual cell which ranges from tedious to impractical for larger datasets. I had also proposed feature in #77951 https://bugs.documentfoundation.org/show_bug.cgi?id=77951 to add a format option for scientific notation, but could still imagine use cases where this issue still stands. But I would agree your case still seems like a bug, especially since =0.76+2.91+3.89+6.34 &" $" is still treated like a number when referencing that cell in other calculations, so formatting should treat it like a number too. However using format code 0.00 does nothing while @$ returns 13.9 $$ indicating the formatting treats it as text which is inconsistent behavior. What's even weirder is how =TEXT("13.9 $","0.00") returns 13.90 while =TEXT("13.9 $","@$") returns 13.9 indicating formatting that way treats the value as a number. Thus the cell formatting should remain consistent and also treat it like a number. Even better would be ability to format mixed text eg 0.00 @ would turn 13.9 $ to 13.90 $. In your case, one solution is to set the cell with =0.76+2.91+3.89+6.34 and use format code 0.00 "$" or 0.00 \$ or 0.00 $ to get 13.90 $ as per https://help.libreoffice.org/latest/lo/text/shared/01/05020301.html Or set the cell value as =TEXT(0.76+2.91+3.89+6.34,"0.00 $") or =TEXT(0.76+2.91+3.89+6.34,"0.00")&" $" as per https://help.libreoffice.org/latest/en-US/text/scalc/01/04060110.html -- You are receiving this mail because: You are the assignee for the bug.
