[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 Eike Rathke changed: What|Removed |Added Status|NEEDINFO|RESOLVED

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 Eike Rathke changed: What|Removed |Added Status|NEW |NEEDINFO ---

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 Eike Rathke changed: What|Removed |Added Hardware|x86-64 (AMD64) |All

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 Eike Rathke changed: What|Removed |Added Attachment #117671|application/zip

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 raal r...@post.cz changed: What|Removed |Added Status|UNCONFIRMED |NEW CC|

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #21 from Karl-W. Hoffmann k_w_hoffm...@onlinehome.de --- (In reply to Alexander Nolting from comment #11) Hello, I have an similiar issue with SUMME() (SUM in english) function. It does not summarize properly cells. It

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #22 from Alexander Nolting a.nolt...@almano.de --- Hello Karl, after updating this morning to LO 5.0.0.5-324.3 from tumbleweed the sum func is working again. There are only a small glitch where the app doesn't recognize that a

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #23 from Karl-W. Hoffmann k_w_hoffm...@onlinehome.de --- (In reply to Alexander Nolting from comment #15) Hello Karl, I digged into your issue and found that LO doesn't support the {COUNT,SUM,AVERAGE}IFS starting from

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #24 from Alexander Nolting a.nolt...@almano.de --- Hello Miguel, I got another update from tumbleweed again and the glitch where the cell is not calculated by a formula manually entered is also disappeared. So I'm fine now.

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #20 from m.a.riosv miguelange...@libreoffice.org --- Hi Alexander, comment#18, sent a PM to you. I think it's pending write the help for those functions. https://bugs.documentfoundation.org/show_bug.cgi?id=64773#c9 But you

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #14 from Karl-W. Hoffmann k_w_hoffm...@onlinehome.de --- I don't understand the last two Messages. As far as I understand, the last Part of the Formular shall write a M (for the man-only Chorus) in Columne G on the first side

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #18 from Alexander Nolting a.nolt...@almano.de --- Hello Miguel, After a quick search for bugs related to lo5 I thought there might be a relation between this bug and my issue. So I will file a new report. Are you able to

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #19 from Alexander Nolting a.nolt...@almano.de --- off topic: can you point to the documentation where SUMIFS etc. is described? As I can see SUMIF is support not SUMIFS. -- You are receiving this mail because: You are the

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #17 from m.a.riosv miguelange...@libreoffice.org --- 1. May be comments #13 and #14 are for other bug report. I **can't** see the relation of attached file with this. -- You are receiving this mail because: You are the

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #16 from m.a.riosv miguelange...@libreoffice.org --- Hi Alexander, 1. May be comments #13 and #14 are for other bug report. I can see the relation of attached file with this. 2. The SUMIFS COUNTIFS AVERAGEIFS are in

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #15 from Alexander Nolting a.nolt...@almano.de --- Hello Karl, I digged into your issue and found that LO doesn't support the {COUNT,SUM,AVERAGE}IFS starting from Excel 2007 onwards. Below you find an idea to substitute this

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #12 from Alexander Nolting a.nolt...@almano.de --- Forgot to say LO 5.0.0.5 on Linux -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #13 from Alexander Nolting a.nolt...@almano.de --- Created attachment 117741 -- https://bugs.documentfoundation.org/attachment.cgi?id=117741action=edit SUM Func not working example.ods -- You are receiving this mail

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #11 from Alexander Nolting a.nolt...@almano.de --- Hello, I have an similiar issue with SUMME() (SUM in english) function. It does not summarize properly cells. It doesn't what the cell format is set to. So I decided not to

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 Karl-W. Hoffmann k_w_hoffm...@onlinehome.de changed: What|Removed |Added Status|RESOLVED

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #3 from m.a.riosv miguelange...@libreoffice.org --- Please could you attach a sample file, without private data, as minimal as possible. -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #4 from Karl-W. Hoffmann k_w_hoffm...@onlinehome.de --- Created attachment 117671 -- https://bugs.documentfoundation.org/attachment.cgi?id=117671action=edit Error in CALC-Formula Hi, attached please find the File without

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #5 from Karl-W. Hoffmann k_w_hoffm...@onlinehome.de --- Created attachment 117673 -- https://bugs.documentfoundation.org/attachment.cgi?id=117673action=edit Error in Calc Formula -- You are receiving this mail because: You

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #6 from Karl-W. Hoffmann k_w_hoffm...@onlinehome.de --- I tried to send the original xxx.XLSX File, but it does not work. I converted the File to xxx.ODS Format and now the Cell H5 is empty, the Eroor on the other Cells are

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 m.a.riosv miguelange...@libreoffice.org changed: What|Removed |Added Status|REOPENED|NEEDINFO

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #8 from Karl-W. Hoffmann k_w_hoffm...@onlinehome.de --- This is the original Excel-Sheet. I just delete the Membersname (Mitglieder) and the names on some other pages. The Formular ( =SUMMEWENNS(Betrag;[0]!konto;2110;VA;M) )

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 m.a.riosv miguelange...@libreoffice.org changed: What|Removed |Added Status|NEEDINFO

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 --- Comment #10 from m.a.riosv miguelange...@libreoffice.org --- If it is a named range with sheet scope, as I know it is not supported by LibreOffice between different sheets. -- You are receiving this mail because: You are the assignee

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 m.a.riosv miguelange...@libreoffice.org changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED

[Libreoffice-bugs] [Bug 92915] Formular Error in Calc

https://bugs.documentfoundation.org/show_bug.cgi?id=92915 Karl-W. Hoffmann k_w_hoffm...@onlinehome.de changed: What|Removed |Added Version|unspecified