Issue 62081

Summary: Userdefined function doesn't work anymore after it appears as pure text in the spreadsheet
Product: App Dev Reporter: stephan.wunderlich
Component: apiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, oc
Version: 3.3.0 or older (OOo)   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
mentioned document none

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 "issues@openoffice.apache.org".