Libre Office
Version: 5.0.3.2
Build ID: 1:5.0.3~rc2-0ubuntu1~trusty2
Locale: en-GB (en_GB.UTF-8)
Calc A1 Formula Syntax Selected |
Excel A1 Formula Syntax Selected |
| In Calc, if you have already selected Calc A1 Formula Syntax (the
default), and you import a formula from MS Excel, an intersection
operator that was <SPACE> in Excel A1 format correctly converts to
the '!' operator. For example, the formula shown below was originally =A2:C2 B1:B3+3 when viewed in MS Excel on Windows (XP). |
In Calc, if you have already selected Excel A1 Formula Syntax, and you
import a formula from MS Excel, an intersection operator that was
<SPACE> in Excel A1
format should stay as a <SPACE>. However, it incorrectly displays
as the '!' operator as if it has converted to Calc Formula Syntax. For
example, the formula
shown below was originally =A2:C2 B1:B3+3 when viewed in MS Excel on Windows (XP). But when Calc is set to Excel A1 Formula Syntax, a '!' in this position should lead to an error. |
 |
 |
Still with Calc A1 Formula Syntax selected, if
you cut and re-paste the formula into the same cell, the '!' still
parses correctly. |
Still with Calc A1 Formula Syntax selected, if
you cut and re-paste the formula into the same cell, the '!' correctly
causes a #NAME? error. |