Bug 144288 - SUM(ABOVE) is turned into SUM(<A3:A1>)
Summary: SUM(ABOVE) is turned into SUM(<A3:A1>)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected) release
Hardware: All All
: medium minor
Assignee: Not Assigned
Keywords: filter:docx
Depends on:
Blocks: Writer-Tables-Formulas
  Show dependency treegraph
Reported: 2021-09-03 22:10 UTC by Dave McKellar
Modified: 2023-09-07 20:19 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

An RTF doc made with Microsoft Word that uses SUM(ABOVE) (8.59 KB, application/msword)
2021-09-03 22:11 UTC, Dave McKellar

Note You need to log in before you can comment on or make changes to this bug.
Description Dave McKellar 2021-09-03 22:10:09 UTC
When I open a Microsoft Word RTF document that has a formula of SUM(ABOVE)
it is changed into SUM(<A3:A1>) in LibreOffice Writer.
This is ok for read the document in.  But it changes the meaning.
For example if we add a row, then want more columns automatically included in the sum.  I seems LibreOffice needs to support ABOVE for good fidelity.

Steps to Reproduce:
1.  Make a RTF doc in MS Word that uses SUM(ABOVE)
2.  Read it with LibreOffice Writer
3.  Right click on to Edit Field and its no longer SUM(ABOVE)

Actual Results:
Its now SUM(<A3:A1>) or other numbers

Expected Results:
Should preserve SUM(ABOVE)

Reproducible: Always

User Profile Reset: No

Additional Info:
Version: (x64) / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 1 Dave McKellar 2021-09-03 22:11:05 UTC
Created attachment 174767 [details]
An RTF doc made with Microsoft Word that uses SUM(ABOVE)
Comment 2 Roman Kuznetsov 2021-09-04 16:45:21 UTC
this workaround was implemented in bug 123355. But I agree LO should save ABOVE, BELOW, etc. table's MS Word function arguments.
Comment 3 QA Administrators 2023-09-05 03:13:22 UTC Comment hidden (obsolete)
Comment 4 Dave McKellar 2023-09-07 20:19:40 UTC
I retested this with LibreOffice   Its still there.  When I right-click on the field and select Edit Formula from the context menu it says "=SUM(<A3:A1>)" when it should say "=SUM(above)"