<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Calc lacks several fields available in Writer"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132104#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Calc lacks several fields available in Writer"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132104">bug 132104</a>
from <span class="vcard"><a class="email" href="mailto:Spampot@gmx.net" title="Lenge <Spampot@gmx.net>"> <span class="fn">Lenge</span></a>
</span></b>
<pre>(In reply to Heiko Tietze from <a href="show_bug.cgi?id=132104#c6">comment #6</a>)
<span class="quote">> Is this a real use case?</span >
Yes.
<span class="quote">> Makes sense to have these information somewhere but
> what do you calculate with it?</span >
We primarily need it as descriptive text in group headlines/titles, subheads,
or within "normal" text (all inside the spreadsheet itself, not only in page
headers/footers).
Of course it would be even more flexible to use it in calculations, and because
of that ...
<span class="quote">> And if so wouldn't you expect it as function like
> =If(LastDocModificationDate()=DayOfTheWeek("Friday/13th"),close,continue).</span >
... I added the corresponding "Additional Info:" to the original bug report. ;)
However, as Writer offers it as fields, I thought the straightforward approach
was to just remove the corresponding restrictions in Calc.
But I'd also love to have functions like LastDocModificationDate() or
LastDocModificationTime() available in Calc. :)
<span class="quote">> And page number/count is not defined unless the "infinite" spreadsheet is
> divided in pages depending on the chosen printer. So it's also better suited
> for the header/footer.</span >
Writes offer all fields anywhere in the document, including (but not limited
to) page header and footers. I generally think that removing artificial
limitations is a good idea. I a Calc user wants to use it in headers/footers,
he can do it (just like in Writer, where you have the plus of free formatting).
If he wants it somewhere else, why disallow it? If a certain field is undefined
under certain circumstances, it can still have "not defined" as output.
(BTW: Page boundaries can also be specified on infinite spreadsheets, which
makes the numbers both defined and useful.)</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>