Problem description: Time1+time2=time3 Time1+-time2=time1 Steps to reproduce: 1. ....D3=07:32:00 G3=-13 2. ....=D3+PERC(G3)-->07:32:00 3. ....=D3+IDŐ(0;G3;0)-->Hiba:502 Current behavior: Expected behavior: Operating System: Windows 7 Last worked in: 3.6.4.3 release
Hi Molnàr, Can you expose with the function names in English? To see the English names, change in Menu/Tools/Options/LibreOffice Calc/Formula - Use English function names. Thanks
2012.12.13. 3:08 keltezéssel, bugzilla-daemon@freedesktop.org írta: > mariosv <mailto:mariosv@miguelangel.mobi> changed bug 58217 > <https://bugs.freedesktop.org/show_bug.cgi?id=58217> > What Removed Added > Status UNCONFIRMED NEEDINFO > CC mariosv@miguelangel.mobi > Ever confirmed 1 > > *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=58217#c1> > on bug 58217 <https://bugs.freedesktop.org/show_bug.cgi?id=58217> from > mariosv <mailto:mariosv@miguelangel.mobi> * > Hi Molnàr, > > Can you expose with the function names in English? > > To see the English names, change in Menu/Tools/Options/LibreOffice Calc/Formula > - Use English function names. > Thanks > ------------------------------------------------------------------------ > You are receiving this mail because: > > * You reported the bug. > I'm using at Hungarian language.
Created attachment 71475 [details] Time calculation test After a look for the English name of the function, I can not see this error. Attached a little sample file. To know better how date and time works in calc, take a look in the help: Contents / Spreadsheets / General information / Instructions for use LibreOffice Calc / Calculating with Dates & Times or Calculating Time Difference.
2012.12.14. 0:58 keltezéssel, bugzilla-daemon@freedesktop.org írta: > > *Comment # 3 <https://bugs.freedesktop.org/show_bug.cgi?id=58217#c3> > on bug 58217 <https://bugs.freedesktop.org/show_bug.cgi?id=58217> from > mariosv <mailto:mariosv@miguelangel.mobi> * > Createdattachment 71475 <attachment.cgi?id=71475> [details] <attachment.cgi?id=71475&action=edit> > Time calculation test > > After a look for the English name of the function, I can not see this error. > Attached a little sample file. > > To know better how date and time works in calc, take a look in the help: > Contents / Spreadsheets / General information / Instructions for use > LibreOffice Calc / Calculating with Dates & Times or Calculating Time > Difference. > ------------------------------------------------------------------------ > You are receiving this mail because: > > * You reported the bug. > 7hour32minutes+(-13 minutes) not egal 7:32
> 7hour32minutes+(-13 minutes) not egal 7:32 Please Molnár take a look on this thread in ask. http://ask.libreoffice.org/en/question/7984/how-to-convert-a-number-into-minutes/
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/FDO/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team
MINUTES() / PERC() function does not return a time value, therefore it makes no sense to add it to a time value. Please refer to help or to http://ask.libreoffice.org/en/question/7984/how-to-convert-a-number-into-minutes/