Phpspreadsheet: Invalid cell coordinate - VLOOKUP

[seltix5]

This is:

- [x ] a bug report
- [ ] a feature request
- [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet)

What is the expected behavior?

Get the calculated value ( "2" in the provided test.xlsx )

What is the current behavior?

error : PhpOffice\PhpSpreadsheet\Calculation\Exception: b!A1 -> Invalid cell coordinate A1+1

What are the steps to reproduce?

<?php

require __DIR__ . '/vendor/autoload.php';

$xlsx = \PhpOffice\PhpSpreadsheet\IOFactory::load($testxlsx);
$xlsx->getSheetByName('b')->getCell('A1')->getCalculatedValue();

test.xlsx

I did not find online how to add entry in the "Name Manager" with PhpSpreadsheet but the provided file is just :

• sheet "a" : A1 => "1"
• sheet "b" : A1 => "=vartest"

and in "Formulas > Name Manager" I created entry with :

• Name : vartest
• Refers to : =a!$A$1+1

Which versions of PhpSpreadsheet and PHP are affected?

PHP : 7.2
PhpSpreadsheet : 1.10.1

[seltix5]

no reply?

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
If this is still an issue for you, please try to help by debugging it further and sharing your results.
Thank you for your contributions.

[seltix5]

Bump

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
If this is still an issue for you, please try to help by debugging it further and sharing your results.
Thank you for your contributions.

[seltix5]

No reply?

[MarkBaker]

Named formulae currently aren't supported, only named ranges; but I've recently been working on improvements to the handling of ranges and named ranges, so I'll take a look and see how easy it is to implement named formulae

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
If this is still an issue for you, please try to help by debugging it further and sharing your results.
Thank you for your contributions.

[seltix5]

Any news?

[pich]

Named formulae currently aren't supported, only named ranges; but I've recently been working on improvements to the handling of ranges and named ranges, so I'll take a look and see how easy it is to implement named formulae

Any update on Named formulas? @MarkBaker please provide me with some code references, I may be able to help i would really like to have this feature.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
If this is still an issue for you, please try to help by debugging it further and sharing your results.
Thank you for your contributions.

[seltix5]

Any update on this?