[Libreoffice-qa] question about a bug confirmation

[Markus Mohrhard]

Hey,

On Sun, Nov 23, 2014 at 4:51 PM, Lera Goncharuk
<lera.goncharuk at gmail.com> wrote:
> Hi all,
>
> Basically. I translate documentation and news to Russian, but also I explain
> the position of developers and QA team about confirmation and fixing bugs to
> Russian users who have a weak command of the English.
> My question is about a bug that I submitted yesterday (have a look at
> comments):
> https://bugs.freedesktop.org/show_bug.cgi?id=86576
> I do not complain or protest, but I need the position of QA team that I can
> explain to other users.
> Do I understand correctly, that we should consult with developers when a bug
> violates principles of mathematical calculations and we give the status NEW
> only when developers confirm than bug can be fixed?
> Do mathematical rules no longer apply to LibreOffice?
> What should I tell users?
> Thanks in advance for the clarification.
>

First a spreadsheet is not a math program and is not mathematically
correct and most likely will never be.

Now to the issue at hand. A number format is not a unit, it is a cell
property that tells the program how to format the numbers. In the end
they are still just numbers and have no internal unit. There are some
ideas around implementing a real unit system for spreadsheet cells in
calc but that is not even under development. That would then realize
that adding a currency to a time is just wrong. As you can try
yourself you can easily do that today as it is just a formatting and
not a unit.

Currently the seen behavior is correct that the number format (if none
is set yet to the cell) is taken from the source cells.

Regards,
Markus