https://bugs.documentfoundation.org/show_bug.cgi?id=132104
--- Comment #7 from Lenge <Spampot@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 on the CC list for the bug.
Context
- [Libreoffice-ux-advise] [Bug 132104] Calc lacks several fields available in Writer · bugzilla-daemon
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.