Bug 34853 - Function Wizard does not generate some functions with External Reference
Summary: Function Wizard does not generate some functions with External Reference
Status: RESOLVED DUPLICATE of bug 34356
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.1 RC1
Hardware: Other Windows (All)
: medium normal
Assignee: Kohei Yoshida
URL:
Whiteboard: target:3.4
Keywords:
Depends on:
Blocks:
 
Reported: 2011-02-28 18:36 UTC by hmoi
Modified: 2011-03-02 12:22 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
OFFSET_External_Ref (8.19 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-02-28 18:36 UTC, hmoi
Details
OFFSET_main (9.81 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-02-28 18:37 UTC, hmoi
Details

Note You need to log in before you can comment on or make changes to this bug.
Description hmoi 2011-02-28 18:36:35 UTC
Created attachment 43949 [details]
OFFSET_External_Ref

Hi,
I Use LibreOffice3.3.1RC1 - Windows XP JA

When I input the OFFSET/DSUM/DGET functions with External Reference Function by manual, the functions works normally.
But, when I try to use the Function Wizard for OFFSET/DSUM/DGET functions with External Reference, LibreO returns error msg.

Steps to reproduce:
(1) Open attached "OFFSET_External_Ref.ods"
(2) Open attached "OFFSET_main.ods"
(3) In the "OFFSET_main.ods", select cell A5 of sheet1.
(4) Use the function wizard to enter function OFFSET.
Set 
a) the 'reference' field to 'file:///C:/OFFSET_External_Ref.ods'#reffered_sheet.A1'
(cell A1 of reffered_sheet in "OFFSET_External_Ref.ods")
b) the 'rows' filed to 2
c) the 'column' field to 2.

at this timing, the right value is displayed in the 'Result' field.

(5) And Click OK on the function wizard.

(6) Then, get LibreOffice error msg:
LibreOffice Calc found an error in the formula entered. Do you want to accept the correction proposed below?:
  =OFFSET(2,2)
  Yes/No

(7) DSUM/DGET function with External Reference are same as abaove mentioned.

It seems this problem occurs in association with Function Wizard.
Comment 1 hmoi 2011-02-28 18:37:10 UTC
Created attachment 43950 [details]
OFFSET_main
Comment 2 Kohei Yoshida 2011-02-28 19:06:04 UTC
This may be the same issue as Bug 34356.
Comment 3 Kohei Yoshida 2011-03-02 11:51:21 UTC
This is fixed on master, along with Bug 34356.
Comment 4 Kohei Yoshida 2011-03-02 12:22:47 UTC

*** This bug has been marked as a duplicate of bug 34356 ***