Use the correct namespace when converting ODF formulas to MS Excel 2003 XML,
so that R1C1 formula is used instead of leaving broken "of:=[.A1]" style
references.

Patch by: me
Fixes: https://bz.apach

Use the correct namespace when converting ODF formulas to MS Excel 2003 XML,
so that R1C1 formula is used instead of leaving broken "of:=[.A1]" style
references.

Patch by: me
Fixes: https://bz.apache.org/ooo/show_bug.cgi?id=96018

(cherry picked from commit b045a72bbf8ebfd2ea5838734aa14f879ef23ec9)

show more ...

added test spreadsheet for single line comments and added it to test

updated to enable macro execution.

Refs #i112383# and #i117960#. backporting to AOO41X .

Can't cherry-pick due to file changes.

Original commit messages and links follow:

Found-by: andrew
Patch-by: Damjan Jovanovic
https://github.c

Refs #i112383# and #i117960#. backporting to AOO41X .

Can't cherry-pick due to file changes.

Original commit messages and links follow:

Found-by: andrew
Patch-by: Damjan Jovanovic
https://github.com/apache/openoffice/commit/323c350123d05cd9f450aebd421b7bfa74c331d2

i92642 added the ability to use certain keywords as variable names (eg. name = 1, line = 'hi'),
but also caused a regression where "Line Input" is broken in single-line If statements.
This patch fixes that by allowing Then and Else to also be the start-of-line tokens expected to
immediately preceed the 'Line' token in order for that 'Line' token to be recognized a keyword instead
of a variable name. Also added FVT spreadsheet tests for 'Line' as both a variable name and as 'Line Input'.
Patch by: Damjan Jovanovic
https://github.com/apache/openoffice/commit/725d867363770a4c47c4b3c6dbe1f359c296604a

show more ...