Bug in Libre Office Calc using the Intersection Operator in Excel A1 Formula Syntax

Libre Office
Version: 5.0.3.2
Build ID: 1:5.0.3~rc2-0ubuntu1~trusty2
Locale: en-GB (en_GB.UTF-8)

NB: Nothing in this bug is about import/export from MS Excel. It is solely about the Excel A1 formula syntax within native Calc. As long as the formulae are entered in Calc, the bug is independent of which format the sheet is saved in (it is even reproducible before saving the file).

Calc A1 Formula Syntax Selected

Excel A1 Formula Syntax Selected
With Calc A1 Formula Syntax, the '!' operator in a formula gives the intersection of two ranges. For example a cell containing the formula:
   =($B:$B!$2:$2)*2
should resolve to 28, if the contents of B2 is the number 14.		 With Excel A1 Formula Syntax (selected via Tools>Options>Formula), the <space> operator in a formula is meant to be equivalent, giving the intersection of two ranges. For example:
   =($B:$B $2:$2)*2
should be equivalent.
While typing '!' Intersection Operator in Calc A1 Formula Syntax
 While typing <space> Intersection Operator in Excel A1 Formula Syntax
With Calc A1 Formula Syntax selected, when typing the formula, Calc displays the two ranges as intersecting coloured boxes around the ranges and it colours the characters in the formula to match.

On pressing <ENTER>, it correctly displays 28.
 With Excel A1 Formula Syntax selected, when typing the formula, Calc displays the two ranges as expected; as intersecting coloured boxes around the ranges and it colours the characters in the formula to match.

However, on entering the formula (type <ENTER> or click the tick), the cell displays "Err:509" (missing operator)
'!' Intersection Operator in Calc A1 Formula Syntax <space> Intersection Operator in Excel A1 Formula Syntax
If the ranges are defined as names (using Insert>Names>Define),...
 When Excel A1 Formula Syntax is selected, the syntax of the names correctly auto-transforms to the appropriate syntax ($Sheet1. becomes Sheet1!), ...
'!' Intersection Operator in Calc A1 Formula Syntax using names
 <space> Intersection Operator in Excel A1 Formula Syntax using Names
... and the result is still correct, 28.
 ... however, the result this time is "Err:508" (pair missing)
'!' Intersection Operator in Calc A1 Formula Syntax using Names
 <space> Intersection Operator in Excel A1 Formula Syntax using Names
In Calc Formula Syntax, the intersection operator works fine without parentheses
 Nonetheless, in Excel Formula Syntax, if there are no parentheses in the formula, you get "Err:509" (missing operator), rather than "Err:508" (pair missing).
'!' Intersection Operator in Calc Formula Syntax without Parentheses
 <SPACE> Intersection Operator in Excel Formula Syntax without Parentheses

Incidentally, using the '!' operator if Excel A1 Formula Syntax is selected correctly gives a #NAME? error.
Attempting to use '!' as Intersection Operator in Excel A1 Formula Syntax correctly gives a #NAME? Error

Bob Briscoe, 11-Dec-2015