[Libreoffice-bugs] [Bug 121499] Wish: Add Number format for representation of school grades (Calc)

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |WONTFIX
             Status|NEW                         |RESOLVED

--- Comment #3 from Eike Rathke <erack at redhat.com> ---
Such things just can't be expressed by the common number format codes, which
have to stay somewhat compatible with what Excel uses, so if we'd come up with
an own syntax there it must be clear that it could never be saved to Excel file
formats. I doubt that dozens of teachers would accept that..

Also, you already gave two different examples of grading systems. There are
quite a few more in the world, see the wiki page you cited. So that would have
to be some free form associative array with range rules. Or something
completely different.

Anyone interested in this is better off with an Add-In function or extension
that implements the desired functionality than a cumbersome drilling of number
format codes.

Apart from that, the first original request's example can be easily done using
VLOOKUP() with range lookup, i.e. in B1:B16 have the sorted numbers
{0.67,1,1.33,...,6} and in C1:C16 have the associated grades
{"1+","1","1-",...,"6"}, then the formula =VLOOKUP(D1;B1:C16;2;TRUE()) yields
the grade of the value in D1.

-- 
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/20181210/99438ad5/attachment.html>