The built-in function of the Hungarian-language Libreoffice Calc, which specifies the difference between two dates in days, does not work. Gives an #ÉRTÉK error signal. An example: A1 cell (Date type in hungarian format): 2022.12.05. A2 cell (Date type in hungarian format): 2022.10.23. The expression in numerical cell: =NAPOK(A1;A2) The result is #ÉRTÉK
Press Ctrl+F8. If do you see the date font in blue, it is a date; but if do you see the "date" in black, it is text, and the formula DAYS return #VALUE!.
After carefully setting the type of cells and pressing Ctrl + F8, nothing happened. I am using Ubuntu 20.04.
Created attachment 184094 [details] This is an example sheet. I attached an example...
Your date is formatted as text (black font). See comment 1. So the formula returns an error. Change the format of the cells to date.
Please believe me, I did. If I look at the field type (for me) it shows a date! Maybe I should reinstall Libreoffice? I am attaching a screenshot...
Created attachment 184099 [details] Screenshot from valid type
Created attachment 184100 [details] Bug 152464
Ok. In your sample file the values in cell A1 and A2 are formatted as text. In the dialogue they are shown formatted as date. I enter the same values and it works. See attached file. Can you exactly describe, how you enter the values and what you do.
Hi Lol, thanks for the attachment. Really useful. I opened it and the ones you entered work well for me, although the lines I originally entered are still not good. But, if I try to format my lines from your lines with the format brush, it doesn't work. Otherwise, I set the format manually by right-clicking on the cell, selecting cell formatting from the floating menu, then selecting the date as the type and 12.31.1999 as the format. Sincerely, Attila
(In reply to joubert.attila from comment #9) > I set the format manually by right-clicking on the cell, After changing the format cell to Date, you must edit each cell for the change to take on. An easy way to do that is with the Text to Columns tool (menu Data). In this cases, before reporting a bug, I suggest to search in the ask.libreoffice.org site for help. Changing status to Resolved - Not a bug. Regards.
(In reply to joubert.attila from comment #6) > Created attachment 184099 [details] > Screenshot from valid type See that the (text)dates, remain left aligned.