[Libreoffice-bugs] [Bug 139421] Calc: calcuate weeknumber-year missing in 2021

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #9 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Robert Lacroix from comment #7)
> The question arose on how to select a mode/format with the TEXT function.

No, this question is more general: how to select it *in any format string*. The
format strings are used not only in TEXT spreadsheet function [1], but also in
other places: Format function in Basic [2]; cell format in Calc and Writer;
Field format in Writer [3]... And any of them might need this.

> There are 4 options:
> 1) add a new format code to TEXT was suggested. It's legacy compatible.
> 2) add a document option. It would be buried in options, so not nice to use.

Its discoverability is just the lesser of the problems of this option. The
greater one is that it would make it impossible to use different systems in
different places, e.g. when creating multilanguage documents with different
systems used in different parallel sections.

> 3) add an optional argument to TEXT, a-la WEEKNUM; default ISO mode for
> legacy compatibility?

This is absolutely not an option - see "not only in TEXT spreadsheet function,
but also in other places" above.

> 4) make meaning of current format depend on locale. Undesireable, causes
> global side effects if I need to change locale for one spreadsheet cell.

This option could likely be the best is we create some NatNum modifier
associated with ISO mode? Then no need in solution #1.


[1] https://help.libreoffice.org/latest/en-US/text/scalc/01/04060110.html
[2] https://help.libreoffice.org/latest/en-US/text/sbasic/shared/03120301.html
[3] https://help.libreoffice.org/7.1/en-US/text/shared/01/05020300.html

-- 
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/20210106/da842c96/attachment.htm>