Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 04 Dec 2019 09:27:53 +0100Help with Err 508 in Calchttps://ask.libreoffice.org/en/question/142686/help-with-err-508-in-calc/I am using a Calc macro to insert a vlookup formula into a cell but obtain an Err 508. The macro works with a simple formula like = J6 or =(J6) or = SUM(J3+J6) but not with the lookup formula. I have got round this by placing the vlookup formula for example in J6 and then pasting =J6 into J3. However, I would appreciate help with what I am doing wrong. Thank you.Wed, 10 Jan 2018 10:33:05 +0100https://ask.libreoffice.org/en/question/142686/help-with-err-508-in-calc/Comment by Luis_s for <p>I am using a Calc macro to insert a vlookup formula into a cell but obtain an Err 508. The macro works with a simple formula like = J6 or =(J6) or = SUM(J3+J6) but not with the lookup formula. I have got round this by placing the vlookup formula for example in J6 and then pasting =J6 into J3. However, I would appreciate help with what I am doing wrong. Thank you.</p>
https://ask.libreoffice.org/en/question/142686/help-with-err-508-in-calc/?comment=219884#post-id-219884Thank You JohnSUN!! WorksWed, 04 Dec 2019 09:27:53 +0100https://ask.libreoffice.org/en/question/142686/help-with-err-508-in-calc/?comment=219884#post-id-219884Comment by Mike Kaganski for <p>I am using a Calc macro to insert a vlookup formula into a cell but obtain an Err 508. The macro works with a simple formula like = J6 or =(J6) or = SUM(J3+J6) but not with the lookup formula. I have got round this by placing the vlookup formula for example in J6 and then pasting =J6 into J3. However, I would appreciate help with what I am doing wrong. Thank you.</p>
https://ask.libreoffice.org/en/question/142686/help-with-err-508-in-calc/?comment=142687#post-id-142687https://help.libreoffice.org/Calc/Error_Codes_in_CalcWed, 10 Jan 2018 10:37:14 +0100https://ask.libreoffice.org/en/question/142686/help-with-err-508-in-calc/?comment=142687#post-id-142687Comment by JohnSUN for <p>I am using a Calc macro to insert a vlookup formula into a cell but obtain an Err 508. The macro works with a simple formula like = J6 or =(J6) or = SUM(J3+J6) but not with the lookup formula. I have got round this by placing the vlookup formula for example in J6 and then pasting =J6 into J3. However, I would appreciate help with what I am doing wrong. Thank you.</p>
https://ask.libreoffice.org/en/question/142686/help-with-err-508-in-calc/?comment=142691#post-id-142691Do you write comma as delimiter of parameters? Try semicolonWed, 10 Jan 2018 11:37:02 +0100https://ask.libreoffice.org/en/question/142686/help-with-err-508-in-calc/?comment=142691#post-id-142691Answer by JonNew for <p>I am using a Calc macro to insert a vlookup formula into a cell but obtain an Err 508. The macro works with a simple formula like = J6 or =(J6) or = SUM(J3+J6) but not with the lookup formula. I have got round this by placing the vlookup formula for example in J6 and then pasting =J6 into J3. However, I would appreciate help with what I am doing wrong. Thank you.</p>
https://ask.libreoffice.org/en/question/142686/help-with-err-508-in-calc/?answer=142826#post-id-142826Thank you, JohnSun, semicolons work.
Also, found the answer thanks to question by homester@gmail.com and answer by Ratslinger:
https://ask.libreoffice.org/en/question/77399/setting-a-formula-in-macro-basic/
Thu, 11 Jan 2018 21:15:41 +0100https://ask.libreoffice.org/en/question/142686/help-with-err-508-in-calc/?answer=142826#post-id-142826