Hello, Mikhail! I believe that what you are looking for is a user message that is attached to a cell, you can do that by specifying a row and a column in field string:
Hello. I'm working on cell that called "Discount" and I wanted put to cell value of discount in dollars and in tooltip - percentage, for example, or vice versa. I also tried to use UserMessage in the OnActivateCell event, but it also shows the message on the right of the form (in 8.2 interface) and the title of the tooltip is "Error". Maybe if it's not possible now, can it be made in future versions?
it is really a great way to show more information without compromising the readability. It is like in excel you can calculate total by selecting cells. The last one feature is also very welcome.
There is M+ button, that you can use to sum numbers in selected cells and when you will open a calculator, it will show you the sum.
Regarding the comment for cells let's add a requirement to show something like red corner for cells that have comments to notify a user that there is something to see and I'll send this feature request to our developers. But please note that there is that feature in Spreadsheet document. Do you really think that it is useful in daily work during data input, not in printed reports, for example?
To us the primary reason to use it is to enter some value which sometimes make more sense in percentage and sometimes in absolute value. For example, discount. The user may tend to enter discount by value or by value to know exactly how discount is. Also ii seems to me it is a great idea to permit to the user enter some values by percentages, in that case the value is automatically calculated by percentage of the previous cell (or defined cell).
Another example is when you want to consult how many boxes or containers this item is just by hovering its weight.
I guess that users would more like to see and be able to change both values, rather than waiting for a balloon to appear. So two columns would be easier to handle. Maybe you should try to do some usability research on that?
You can use ConditionalAppearance in Form to dinamically change text in cell like "7.99$ (12%)" Or you need to use SpreadsheetDocument.
With its help you can use a full functionality as in the MS Excell (including - dynamic calculation in row in case of change of data in cells and tooltips).
Also you can use ConditionalAppearance for control of visibility cells with different tooltips (for example - as in Filters). But consider that on a web client this method will be an unsuccessful (productivity will strongly fall).
Desktop version