[Libreoffice-bugs] [Bug 132104] Calc lacks several fields available in Writer

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from Lenge <Spampot at gmx.net> ---
(In reply to Heiko Tietze from comment #6)
> Is this a real use case?
Yes.

> Makes sense to have these information somewhere but
> what do you calculate with it?
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 ...

> And if so wouldn't you expect it as function like
> =If(LastDocModificationDate()=DayOfTheWeek("Friday/13th"),close,continue).
... 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. :)

> 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.
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.)

-- 
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/20200423/d61f869a/attachment-0001.htm>