[Libreoffice-bugs] [Bug 131065] EDITING: removing rows: formula with leading "+", e.g. =+G41*F41 become =+G#REF!*F#REF!

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131065

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oliver.brinzing at gmx.de
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1
            Version|6.4.0.3 release             |4.4.7.2 release
            Summary|After removing few lines in |EDITING: removing rows:
                   |XLSX, some formula became   |formula with leading "+",
                   |#REF, though formula did    |e.g. =+G41*F41 become
                   |not referenced into deleted |=+G#REF!*F#REF!
                   |lines                       |

--- Comment #4 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
reproducible with:

Version: 4.4.7.2
Build-ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Gebietsschema: de_DE

Version: 7.0.0.0.alpha0+ (x64)
Build ID: f2db813374b8d65e1edec1387fa0c534b40885e1
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: threaded

but *not* reproducible with:

Version 3.6.7.2 (Build ID: e183d5b)

steps to reproduce:
- open attachment: https://bugs.documentfoundation.org/attachment.cgi?id=158302
- H41 contains formula: =+G41*F41
- delete rows 9:40
- H9 (former H41) formula changed to: =+G#REF!*F#REF!

This will not happen if one removes the leading "+" from H41 formula before.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200302/f8ff16c0/attachment.htm>