Apache OpenOffice (AOO) Bugzilla – Issue 91546
Introduce warning notes
Last modified: 2014-01-17 13:04:31 UTC
The cells should get the ability to show a warning note. The user can delete the note if he thinks, that it is not relevant for him or can fix the reason of that warning. The warning should have the possibility to include a link to the help text or to an external URL (for the Wiki). You should be able to search for warnings and mark those cells and to travel from warning to warning. Excel 2007 has got something similar. Such warning could be set, for example - If a function is called with a parameter which leads to low accuracy, but it is not a real error like !DIV/0. - If a function uses a range with text cells, but is not designed to use text. - If an iteration does not converge. It would be better to show the last result and a warning note, than an error message as it is now.
Critical issue! The future potential of this feature is enormous.
reassigning features and enhancements to user requirements@openoffice.org which will be the default owner for those tasks (was introduced some time ago)
I personally find this Excel feature annoying.