The zeros of a decimal number in a cell are truncated by default. Hence, precision is sacrificed!
That is very annoying and patently wrong, because e.g. 1.0 or 1.000 is not the same as 1. It would perhaps be acceptable if after the third consecutive zero in the fraction was truncated, e.g. 1.12300000 would be truncated to 1.123000.
Update of 2/15/2024: I discovered a simple way to do that. Under Range Edit Permissions you need to select "Show warning when editing this range" applied to the entire sheet.
I am a very intensive user of Google Sheets.
It seems to be ridiculous that you can not easily protect a sheet within a spreadsheet from yourself (owner, editor) (e.g. accidentally modifying it). What about e.g. a lookup sheet that you don't want to be modified easily or inadvertently.
The available "Protect sheet and ranges" functionality does not appear to allow this in a simple, straightforward manner.
I do some extensive Google Apps Script Javascript programming to manage my many Google Sheets spreadsheets. But I readily admit, I am not an expert senior or wizard programmer.
However, it is very irksome that you still can not directly and conveniently iterate over the cells contained in a range (like using the forEach()). Yes, you can easily iterate over the cell values of the range with the getValues() function.
What if you need to do more with some of the, but not all of the cells contained in a range like formatting or clear the value etc.
So I had to write my own function to retrieve all cells as an array from a 1 dimensional range.
Yesterday (4/26/2022), I also had to find out that Google Sheets apparently provides no straight forward and convenient way to filter cells whether they have a comment or not.
This should be part of the standard filter criteria, but it is obviously missing!
This is pretty bad and not easily explainable why such an important functionality is missing. For example, if you have a sheet with over 100,000 cells, most of them filled with data, and you want to know where your data validation rules failed (usually indicated by a comment), then what?
Just discovered that the COUNTA and the COUNTUNIQUE functions are not case sensitive if you apply them to text.
This is quite amateurish by Google!
This "feature" is undocumented and there is no parameter available to control it. Quite disappointing! It is a huge problem e.g. when you are looking for duplicates (e.g. AA is perhaps not the same as Aa).
Will be amended as time goes by! 😄
Data Validation
Update of 4/11/2022
Two related Javascript issues:
Posted: 1/11/2019 Updated: 2/25/2021, 1/14/2021, 7/12/2020, 5/23/2020, 5/22/20205/20/2020, 3/19/2019, 2/16/2019, 2/4/2019, 1/31/2019, 1/15/2019
Programming across multiple, open Spreadsheets is cumbersome! (4/20/2021) Usually, I have at least a half a dozen spreadsheets open at any time in Google Chrome browser. I believe it is e.g. currently not possible to enumerate all open Spreadsheets. E.g. how to copy data from one open Spreadsheet into another one in a simple straightforward way?
Scripting Error Messages not helpful: If you have added several libraries to your current project and an error occurs in one of your libraries, good luck finding the cause. Google script error message will only tell you the name of the script file and line number!
Cut and paste: For some time I noticed another bug! When you cut and paste the content of a cell (source) to another cell (target), then the formatting previously applied to the source cell is reset to default. (Not fixed as of 4/10/2021)
Paint format tool: Today, I finally realized that this tool comes with a bug. Unexpectedly, the cell content you choose as the source for the paint format tool copies the content of the cell to the clipboard. This is not a feature, but a very undesirable bug! I have wondered several times in the past why the content of the clipboard changed unexpectedly when I was working with Google sheets. (5/22/2020)
Query Function: Yesterday, I discovered and experimented with this powerful function. However, Google provides very few, basic functions to be used with the SQL select statement. This is very disappointing!!! Further, the use of column identifiers in the SQL select statement is unnecessary complicated! (5/22/2020)
Named Ranges: If you try to delete a named range that has #REF error you are still asked to confirm the deletion! (5/20/2020)
Google Sheet Open: Google Sheet allows twice or more in same instance of Google browser without warning!
This is terrible behavior! Very annoying! (3/19/2019)
Sorting functionality: Sorting on more than one column is cumbersome. Google sheets does not remember on which columns you have previously sorted. Very annoying! (3/19/2019)
Notes issues:
The notes box does not automatically adjust to the size of the content. Very annoying, especially if you have little text in the cell note (2/16/19)
Filter issues:
Difficult to see instantly whether any filter is enabled on a sheet
Cumbersome to remove a specific filter once you do not need it anymore
Built in functions:
Missing function to create unique ids (as a minimum unique at the single sheet level or better at the user level; does not have to be globally unique)
Formula entry field frequently turns on overwrite modus out of the blue. Very annoying!
Control Find (Search functionality) issues:
The find box to enter search terms of the Chrome browser and the Google sheet almost look the same and appear almost in the same location on the screen. If you are in a hurry, you are bound to mix them up. Very annoying!
If there a blank is the first character of the search term, search fails. This is very surprising and annoying (2/16/19)
Often it is not clear whether the search has actually completed. Preferably, there should be a message/signal (2/16/19)
No feedback on deleting rows. If you are deleting non contiguous rows (like filtered rows) from a large spreadsheet, then it helps if you learn how many rows were actually deleted (I believe Excel gives you this kind of feedback) (added 1/31/2019)
The right click menu when hovering over a cell or you have selected a single row extends often outside the visible screen when close to the visible screen margin. Very annoying! (added 1/31/2019)
Custom functions (added 2/4/2019):
The script editor is so primitive as to be quite useless. Anybody who worked with an IDE like Microsoft Visual Studio before, knows exactly what I mean
The official tutorials are so basic as to be useless
The documentation is ambiguous and very general
Activecell.getValue() and Activecell.getDisplayvalue return the same cell content although the cell contains a formula that was set by the custom function using activeCell.setFormula. Documentation on this is useless! Possibly a bug!
Inserting new rows at the bottom of the sheet loose existing formatting E.g. if you have chosen to apply text wrapping on the right hand side for an entire column, your new rows will be reset to default text wrapping (added 7/12/2020)
More annoyances will be added!
