[Libreoffice-bugs] [Bug 74677] empty Cells in SUMPRODOCT(...) are evaluated as 1

2015-01-23 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=74677

Michael Stahl mst...@redhat.com changed:

   What|Removed |Added

  Attachment #93614|application/octet-stream|application/vnd.oasis.opend
  mime type||ocument.spreadsheet

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 74677] empty Cells in SUMPRODOCT(...) are evaluated as 1

2014-02-09 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=74677

Kohei Yoshida libreoff...@kohei.us changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |DUPLICATE

--- Comment #4 from Kohei Yoshida libreoff...@kohei.us ---


*** This bug has been marked as a duplicate of bug 74479 ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 74677] empty Cells in SUMPRODOCT(...) are evaluated as 1

2014-02-08 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=74677

Julien Nabet serval2...@yahoo.fr changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||er...@redhat.com,
   ||kyosh...@slickedit.com,
   ||markus.mohrhard@googlemail.
   ||com, serval2...@yahoo.fr
 Ever confirmed|0   |1

--- Comment #1 from Julien Nabet serval2...@yahoo.fr ---
On pc Debian x86-64 with master sources updated today, I can reproduce this.

Kohei/Markus/Eike: one for you?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 74677] empty Cells in SUMPRODOCT(...) are evaluated as 1

2014-02-08 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=74677

--- Comment #2 from Jacques Guilleron guillero...@aol.com ---
Hi karolus, Julien,

I reproduce too with LO 4.2.0.4 and LO 4.2.1.0.0+
Build ID: 7a7ef5a915f7e4f4a9a21b819ab1013d6333a8d8
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-01-28_05:46:06

In this case we have an option to set to True:
In Tools  Options  LibreOffice Calc  Formula  Custom  Details :

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 74677] empty Cells in SUMPRODOCT(...) are evaluated as 1

2014-02-08 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=74677

Jacques Guilleron guillero...@aol.com changed:

   What|Removed |Added

 CC||guillero...@aol.com

--- Comment #3 from Jacques Guilleron guillero...@aol.com ---
Treat empty string as zero.
This leave confuse this case where a empty cell is always treated as 1, but
understood by any user as 0.

Sorry for the message in two parts,
Kind regards,

Jacques

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 74677] empty Cells in SUMPRODOCT(...) are evaluated as 1

2014-02-07 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=74677

Björn Michaelsen bjoern.michael...@canonical.com changed:

   What|Removed |Added

   Keywords||regression

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs