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)
Version:
(earliest affected)
7.1.5.2 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:docx
Depends on:
Blocks: Writer-Tables-Formulas
  Show dependency tree / graph
 
Reported: 2021-09-03 22:10 UTC by Dave McKellar
Modified: 2021-09-04 21:23 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:

Attachments
An RTF doc made with Microsoft Word that uses SUM(ABOVE) (8.59 KB, application/msword)
2021-09-03 22:11 UTC, Dave McKellar 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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 
Description:
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: 7.1.5.2 (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.