Bug 34356 - reference to external data via function wizard is not possible
Summary: reference to external data via function wizard is not possible
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.3.1 RC1
Hardware: Other All
: medium normal
Assignee: Kohei Yoshida (inactive)
QA Contact:
URL:
Whiteboard: target:3.4
Keywords:
: 34853 (view as bug list)
Depends on:
Blocks:
 
Reported: 2011-02-16 12:50 UTC by Jacqueline Rahemipour
Modified: 2011-03-02 12:23 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:

Attachments

Description Jacqueline Rahemipour 2011-02-16 12:50:53 UTC 
Using the function wizard e.g. for inserting the VLOOKUP-function, its not possible anymore to insert a reference on a different calc-file.

If I select the cell range in an other file via mouse, the reference is inserted correctly. But after finishing the wizard with "OK" the reference is gone. The inserted formula looks like =VLOOKUP(D1;;2;0), the inserted reference for the parameter "array" is missing. This happens with other functions using the wizard, too.

The VLOOKUP-function is very often used for comparing lists in different files, so if possible please consider this issue for the 3.3.1-release.
Comment 1 Kohei Yoshida (inactive) 2011-03-02 08:33:47 UTC 
Jacqueline,

Is the document that contains externally referenced data open at the time this happens?  If so, try closing it and enter the reference again via Function Wizard.  Does that make any difference?
Comment 2 Kohei Yoshida (inactive) 2011-03-02 11:49:21 UTC 
This is hopefully fixed on master, for 3.4.  Sorry I couldn't make it for 3.3.1.
Comment 3 Kohei Yoshida (inactive) 2011-03-02 12:22:47 UTC 
*** Bug 34853 has been marked as a duplicate of this bug. ***
Comment 4 Kohei Yoshida (inactive) 2011-03-02 12:23:20 UTC 
*** Bug 34938 has been marked as a duplicate of this bug. ***

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.