Issue 35689 - Suggest comments in spreadsheet formulae
Summary: Suggest comments in spreadsheet formulae
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-10-18 09:47 UTC by bobharvey
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description bobharvey 2004-10-18 09:47:59 UTC
I would like to suggest that it would be useful to be allowed formulae to
contain simple comments.  For example:

"=SQRT(A3^2+B3^2) ; pythagoras.  Only valid for eastings/northings"

I used to be able to do this in dos based spreadsheets, and found it useful.  

I have no opinion about what the comment delimiter should be.

In an ideal world, there would also be an option such that formulae were/were
not copied without the comment.
Comment 1 frank 2004-10-18 10:43:52 UTC

from my point of view this is not really usefull as it makes reading of formulas
very inconveniend. Also Notes for cells are possible and if only special things
should be entered into a cell we have Data Validity. Nevertheless the User
Experience has to decide.

Comment 2 daniel.rentz 2004-11-10 17:55:15 UTC
Works already (quote the comment):

=SQRT(A3^2+B3^2) ; "pythagoras.  Only valid for eastings/northings"

Note that this is an undocumented side effect and behaviour may change in future
versions of OOo. So I recomment using cell notes.
Comment 3 bobharvey 2006-07-01 10:32:59 UTC
It's over 18 months now.  How about a yes/no decision?  If this isn't going to 
happen, then the proposal should be closed.
Comment 4 bettina.haberer 2010-05-21 15:09:24 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".