<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - FORMATTING: LO Calc Date as Number lost in saving"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116106">bug 116106</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;">Priority</td>
<td>medium
</td>
<td>low
</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;">OS</td>
<td>Linux (All)
</td>
<td>All
</td>
</tr>
<tr>
<td style="text-align:right;">Severity</td>
<td>normal
</td>
<td>minor
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - FORMATTING: LO Calc Date as Number lost in saving"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116106#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - FORMATTING: LO Calc Date as Number lost in saving"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116106">bug 116106</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>If a cell has the General format and a formula expression yields a date or time
or boolean result then a corresponding number format of type Date or Time or
Boolean is assigned to that cell. Format General effectively means no specific
format applied.
Deriving a format on recalculation after load is done because Calc does not
know whether the General format is carried over from an older version saved
document where these formula result formats where not applied but recalculated
on the fly each time the formula was calculated, which led to other problems..
I'm not sure if this situation can be solved at all other than doing hacks
depending on the version with which a document was saved, which is quite
ill-advised.
Best if you want to force a numeric format in any case then assign a format of
type Number other than General, for example 0 for date serial numbers.</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>