<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:oliver.brinzing@gmx.de" title="Oliver Brinzing <oliver.brinzing@gmx.de>"> <span class="fn">Oliver Brinzing</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: removing rows: formula with leading "+", e.g. =+G41*F41 become =+G#REF!*F#REF!"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131065">bug 131065</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>oliver.brinzing@gmx.de
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Version</td>
<td>6.4.0.3 release
</td>
<td>4.4.7.2 release
</td>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>After removing few lines in XLSX, some formula became #REF, though formula did not referenced into deleted lines
</td>
<td>EDITING: removing rows: formula with leading "+", e.g. =+G41*F41 become =+G#REF!*F#REF!
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: removing rows: formula with leading "+", e.g. =+G41*F41 become =+G#REF!*F#REF!"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131065#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: removing rows: formula with leading "+", e.g. =+G41*F41 become =+G#REF!*F#REF!"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131065">bug 131065</a>
from <span class="vcard"><a class="email" href="mailto:oliver.brinzing@gmx.de" title="Oliver Brinzing <oliver.brinzing@gmx.de>"> <span class="fn">Oliver Brinzing</span></a>
</span></b>
<pre>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: <a href="https://bugs.documentfoundation.org/attachment.cgi?id=158302">https://bugs.documentfoundation.org/attachment.cgi?id=158302</a>
- 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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>