|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Not possible to enter macro call with NLR enabled | ||
|---|---|---|---|
| Product: | Calc | Reporter: | daniel.rentz |
| Component: | editing | Assignee: | AOO issues mailing list <issues> |
| Status: | CONFIRMED --- | QA Contact: | |
| Severity: | Trivial | ||
| Priority: | P3 | CC: | issues |
| Version: | OOo 3.0 | ||
| Target Milestone: | --- | ||
| Hardware: | All | ||
| OS: | All | ||
| Issue Type: | DEFECT | Latest Confirmation in: | --- |
| Developer Difficulty: | --- | ||
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... Possible dup of Issue 10357 Reset assigne to the default "issues@openoffice.apache.org". |
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".