Issue 62081 - Userdefined function doesn't work anymore after it appears as pure text in the spreadsheet
Summary: Userdefined function doesn't work anymore after it appears as pure text in th...
Alias: None
Product: App Dev
Classification: Unclassified
Component: api (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-02-15 10:54 UTC by stephan.wunderlich
Modified: 2017-05-20 11:27 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

mentioned document (6.67 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-02-15 10:56 UTC, stephan.wunderlich
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description stephan.wunderlich 2006-02-15 10:54:26 UTC
The attached document contains a function call "senseoflife".
If you go to an arbitrary Cell and type "=senseoflife()" in it then the number
42 will appear.

Now try
1. type "senseoflife" in a cell
2. type "=senseoflife()" in another Cell

=> you get an error message since calc changed your second entry to
"='senseoflife'()" and wonders what to do with that :-)
Comment 1 stephan.wunderlich 2006-02-15 10:56:55 UTC
Created attachment 34176 [details]
mentioned document
Comment 2 Joost Andrae 2006-02-16 14:21:02 UTC
JA: I can confirm that this is a valid problem. The automagic range detection
doesn't take into account that there might be a BASIC function having the same
identifier. In this case the function name is converted into a string.
Comment 3 niklas.nebel 2006-06-23 17:30:54 UTC
Changing target to 2.x
Comment 4 niklas.nebel 2007-12-04 18:11:39 UTC
retarget 2.x -> 3.x
Comment 5 terrye 2007-12-23 01:41:25 UTC
By the way, this is particularly a pitfall because (unlike Excel) this automagic
range detection is enabled by default.  It is a  bizarre feature that should
only be activated if the user requests it.  
Comment 6 Marcus 2017-05-20 11:27:53 UTC
Reset assigne to the default "".