Issue 100224 - Not possible to enter macro call with NLR enabled
Summary: Not possible to enter macro call with NLR enabled
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-03-16 10:11 UTC by daniel.rentz
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description daniel.rentz 2009-03-16 10:11:20 UTC 
In a new spreadsheet, create a simple macro function, such as

Function TEST() As Long
    TEST = 1
End Function

and insert the function name "Test" as text into a cell. Make sure that NLR is
enabled (Tools|Options|Calc|Calculate|Automatically find col/row labels). Then
try to call the function from a formula: =TEST(). This does not work because
Calc wants to refer a cell from the column "Test".
Comment 1 daniel.rentz 2009-03-20 22:16:06 UTC 
There is a related problem - if you have a valid macro call, and then add the
column header with the same name above, then save to ODF & reload, the macro
call turns into a NLR too...
Comment 2 Joe Smith 2009-06-04 06:35:27 UTC 
Possible dup of Issue 10357
Comment 3 Marcus 2017-05-20 11:11:09 UTC 
Reset assigne to the default "issues@openoffice.apache.org".