Hey, On Sun, Nov 23, 2014 at 4:51 PM, Lera Goncharuk <lera.goncha...@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 _______________________________________________ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/