<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Calc: calcuate weeknumber-year missing in 2021" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139421#c17">Comment # 17</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Calc: calcuate weeknumber-year missing in 2021" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139421">bug 139421</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>(In reply to Robert Lacroix from <a href="show_bug.cgi?id=139421#c15">comment #15</a>) > To parry this issue, how about a new WEEKNUM-type function that matches a > given formatting code (whatever that turns out to be). Doesn't seem to be a good idea to me. First, it would not work if its argument was not a cell reference, i.e. all calculated arguments would lack the necessary information. Second, it would have to recalculate if a cell format changed, display format changes *never* lead to recalculation (and you actually don't want that).</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>