The new Information Rights Management (IRM) is great to protect workbooks from being opened or edited by non authorized users.
Unfortunately it also deactivates all ad-ins. In principle this makes sense as add-ins can access and modify information within the workbook. However, current restrictions go a bit too far as even as an owner/author of the workbook with FULL CONTROL my add-ins are deactivated. Should I not have full rights to do anything with the workbook? In our company thousands of users across EMEA use a self developed add-in to calculate service costs. Now they cannot use IRM as it would block this add-in.

FEATURE REQUEST:

Under "Additional permissions for users" can you please add any of the following options

"allow all add-ins"
"select a specific add-in to be allowed"
"allow all users with FULL CONTROL to use add-ins"

Thank you!

So this has been an issue for a long time and no improvement here.
I want to highlight a cell in a certain light green color that i like. None of the colors you provide for standard or recently used or your theme colors are what i like. The recently used colors dont last long. We need a strip there that has the colors we want to save forever, not just for a day. Please add that. i always have to go to the More Colors and find it. That is ridiculous and time consuming. why not let us save the ones we use most??? strange that it is not available. Every time i have to go find that color. that is a waste of time.

Spreadsheets needs a radical improvement, no spreadsheets at the moment allows subcolumns creating subcells. This would improve the formatting dramatically. We should not have just letters, A, B, C, D... we should be able to divide these columns (letters) in subcolumns and subcells A, A1, A2... but...
How these spreadsheets would be read? Easy.
As they are right now (classic style).No subcolumn, no subcell, Column A, Row 2: Read: A2
Advanced style (subcolumn and subcells), subcolumn A1 Row 2: Read A1#2
Just columns could be divided with subcolumns, this generates a subcell (comprised with the subcolumn and the row)
Rows cannot be divided with subrows
With this, the resolution of the cells would increase and the formatting would improve dramatically
As far as I know LibreOffice is researching this.
Please, click on the attached picture to see subcells in action
Remember you can drag subcells separators, the same you do with columns separators, so the formatting possibilities are unlimited.

From time to time, users need to remove multiple characters from a string. For example, you might want to remove all punctuation, or all accented characters.

Right now, you have to do that with a lengthy nested formula using the SUBSTITUTE function. Such formulas are hard to read and challenging for a novice to debug. Or you could write a VBA user-defined function that performs each of the substitutions for you.

The better approach would be a SUBSTITUTES function that works like SUBSTITUTE but accepts an array (or range of cells) for the Find parameter, and possibly also for the Replace parameter.
=SUBSTITUTES(text, OldTextArray, NewTextArray, optional InstanceNum)

If NewTextArray is a single value, then each of the values in OldTextArray would be replaced with that single value.

If NewTextArray matches OldTextArray in dimensions, then an element of OldTextArray is replaced with the corresponding element of NewTextArray.

If InstanceNum is omitted, then all matches are replaced. If InstanceNum is a positive integer, then just that instance is replaced. If InstanceNum is a negative integer, then just that instance (counting from the end of the string) is replaced. If the absolute value of InstanceNum exceeds the number of matches, then all matches are replaced.

To remove punctuation from the text, you might use:
=TRIM(SUBSTITUTES(A2, {",",".","?","!",";",":","_","-"}," "))

To replace the last comma with an ampersand, you might use:
=SUBSTITUTES(A2, ", ", " & ",-1)
This formula would turn "dog, horse, mouse" into "dog, horse & mouse"

Hello team,
I would like to suggest an idea in excel. since I am using Microsoft Office for a long time, my work was going well unless I discovered a problem. it is actually not a problem but I think a feature can be added.
Suppose, when I calculate a value from multiple cells and get the result in the decimal form we can use place value to round off the value and see the value, but it would be great efficient if somehow exact value (after round off) could be generated by the system itself.
Example:
497*45% = 223.65, using the facility of round off (decrease/increase decimal) value can be generated exactly as 223.65 but if we want to use 224 (exact data) we need to manually enter the value.
It would be a great help if you can add the facility.
Thank You.

Correção na documentação da função SOMA.

Correção da documentação na função SOMA, como neste exemplo anexo informa que se deve informar de 1 a 255 "números" mas que na verdade são argumentos, podendo dentro delas constar números, célula, intervalo de células, funções ou fórmulas e não somente números, para um usuário que está começando e lê isto pode, e já
foi presenciado, inserir de forma manual números nos argumentos por não ter o conhecimento e não estar especificado de forma correta a diversas formas que pode ser aplicada.
Como sugestão alterar o "núm1;núm2"... para arg1;arg2... e de 1 a 255 "números"para de 1 a 255 argumentos que podem ser números, célula, intervalo de células, funções ou fórmulas.