Bug 76661 - EDITING cannot use 2 different basic functions in cell a1 and cell a2
Summary: EDITING cannot use 2 different basic functions in cell a1 and cell a2
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.2.1 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-03-26 21:31 UTC by a405362
Modified: 2015-01-24 14:28 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
cannot use 2 different basic functions in cell a1 and cell a2 (15.68 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-03-26 21:31 UTC, a405362 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description a405362 2014-03-26 21:31:26 UTC 
Created attachment 96428 [details]
cannot use 2 different basic functions in cell a1 and cell a2

If I have several user defined functions in basic I cannot do the following:
Cell A1: =function1()
Cell A2: =function2() cannot be entered, it is automatically changed to function1()

Version: 4.2.2.1
Build ID: 4.2.2.1-7.fc20
Comment 1 Dominique Boutry 2014-03-27 10:52:20 UTC 
Reproduced, with same libO version on Win7.

As is, occurs only in the column of the initial =molfe().

Rename the second macro to a radically different name "rdn" and set Cell B1: =rdn() :
Cell B2: =molfe() cannot be entered, it is automatically changed to rdn().

So tied to the "cell autocompletion with previous column values" feature, which wrongly processes macro names. Set to NEW
Comment 2 Kohei Yoshida 2014-05-08 13:13:58 UTC 
This needs to be re-verified with a more recent 4.2 build.
Comment 3 Kohei Yoshida 2014-05-09 02:35:59 UTC 
Yup, it's been fixed in the latest 4.2 build.