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: Spreadsheet (show other bugs)
Version: 4.2.2.1 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
QA Contact:
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:
i915 platform:
i915 features:


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

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 (inactive) 2014-05-08 13:13:58 UTC
This needs to be re-verified with a more recent 4.2 build.
Comment 3 Kohei Yoshida (inactive) 2014-05-09 02:35:59 UTC
Yup, it's been fixed in the latest 4.2 build.


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.