asked 2012-08-30 19:17:36 +0200

Anonymous

Hi,

I have updated from libreoffice 3.4 to 3.6.1, and indirect formulas that where working before now show as result #REF!

=+vlookup($I6;INDIRECT("'worker "&$B6&"'!$g$8:$S$31");$Summary.J$4;0)

This formula would search in different worker sheets (number of worker being in this case in B6, from the table g8:s31 the position indicated at j4.

What has changed in the formula that now the result is wrong?

Thanks in advance for your help.

delete close flag offensive retag edit

2 Answers

Sort by » oldest newest most voted

answered 2012-08-30 22:01:51 +0200

mariosv

5034 ● 23 ● 50

=+vlookup($I6;INDIRECT("'worker "&$B6&"'!$g$8:$S$31");$Summary.J$4;0) =+vlookup($I6;INDIRECT("'worker "&$B6&"'.$g$8:$S$31");$Summary.J$4;0)

link delete flag offensive edit

answered 2012-09-02 21:05:32 +0200

Nando
1 ● 1

Thanks a lot for telling me how to correct it. Is there any special reason why the syntaxis changed?

Gracias por tu gran respuesta, sabes por qué se cambió la sintaxis?

link delete flag offensive edit

Comments

You have been using ExcelA1 syntax with 3.4. It seems that your user profile setting has not been migrated. If you just switch the formula syntax back again to ExcelA1 your formula will be correct again.

moggi ( 2012-09-02 23:56:08 +0200 )edit

Resources

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Stats

Asked: 2012-08-30 19:17:36 +0200

Seen: 203 times

Last updated: Sep 02 '12

Change in Indirect function