https://bugs.documentfoundation.org/show_bug.cgi?id=161470
Bug ID: 161470
Summary: Implicit intersection operator: @
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
What is implicit intersection?
Implicit intersection logic reduces many values to a single value. Excel did
this to force a formula to return a single value, since a cell could only
contain a single value. If your formula was returning a single value, then
implicit intersection did nothing (even though it was technically being done in
the background). The logic works as follows:
* If the value is a single item, then return the item.
* If the value is a range, then return the value from the cell on the same row
or column as the formula.
* If the value is an array, then pick the top-left value.
With the advent of dynamic arrays, Excel is no longer limited to returning
single values from formulas, so silent implicit intersection is no longer
necessary. Where an old formula could invisibly trigger implicit intersection,
dynamic array enabled Excel shows where it would have occurred with the @.
Steps to Reproduce:
1. In cell C1 enter: 10
2. In cell C2 enter: 20
3. In cell C3 enter: 30
4. In cell C4 enter: 40
5. In cell A2, enter: =@C:C
Actual Results:
Err:509
Expected Results:
20
Reproducible: Always
User Profile Reset: No
Additional Info:
https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34
https://bettersolutions.com/excel/formulas/implicit-intersection-operator.htm
https://benf.org/excel/spill_performance/
SINGLE Function (Removed in 365)
This function was only provided in Excel 2021 for backwards compatibility and
was removed in Excel 365.
SINGLE - Returns the value from a cell range which is the intersection of a row
OR a column.
If you try and use this function you will see a warning pop up message and the
function will be automatically replaced with the "@" character.
You will no longer get implicit intersection of your formulas, instead, where
it detects an implicit intersection, the "@" character or this function will be
added.
--
You are receiving this mail because:
You are the assignee for the bug.
