<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><table border="1" cellspacing="0" cellpadding="8">
        <tr>
          <th>Bug ID</th>
          <td><a class="bz_bug_link 
          bz_status_UNCONFIRMED "
   title="UNCONFIRMED - Wish: Add Number format for representation of school grades (Calc)"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=121499">121499</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>Wish: Add Number format for representation of school grades (Calc)
          </td>
        </tr>

        <tr>
          <th>Product</th>
          <td>LibreOffice
          </td>
        </tr>

        <tr>
          <th>Version</th>
          <td>Inherited From OOo
          </td>
        </tr>

        <tr>
          <th>Hardware</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>OS</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>Status</th>
          <td>UNCONFIRMED
          </td>
        </tr>

        <tr>
          <th>Severity</th>
          <td>enhancement
          </td>
        </tr>

        <tr>
          <th>Priority</th>
          <td>medium
          </td>
        </tr>

        <tr>
          <th>Component</th>
          <td>Calc
          </td>
        </tr>

        <tr>
          <th>Assignee</th>
          <td>libreoffice-bugs@lists.freedesktop.org
          </td>
        </tr>

        <tr>
          <th>Reporter</th>
          <td>mikafar@gmx.de
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
I bet that dozens of teachers will switch over to LibreOffice as soon as Calc
can cope with grades as follows:

Value - German/English Representation (Shown)
0.67 - 1+/A+
1 - 1/A
1.33 - 1-/A-
1.67 - 2+/B+
2 - 2/B
...
5 - 5
5.33 - 5
[5.67 - 6+]
6-6

I tried to create such representation as custom format, but it doesn't work
out.


Steps to Reproduce:
Entering 1- as number will interpret it as negative.
But to discriminate 1+ from 1, one has to switch to text format.


Actual Results:
Text format: This takes all chances to calculate straight forward. Plus it
tends to add + or minus (auto completion) where it is not wanted.

Expected Results:
cf. e.g. <a href="https://en.wikipedia.org/wiki/Academic_grading_in_Germany">https://en.wikipedia.org/wiki/Academic_grading_in_Germany</a>


Reproducible: Always


User Profile Reset: Yes



Additional Info:
<a href="https://www.scholaro.com/pro/Countries/Germany/Grading-System">https://www.scholaro.com/pro/Countries/Germany/Grading-System</a></pre>
        </div>
      </p>


      <hr>
      <span>You are receiving this mail because:</span>

      <ul>
          <li>You are the assignee for the bug.</li>
      </ul>
    </body>
</html>