We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

dottore's profile - activity

2020-08-02 12:08:07 +0200 marked best answer possible bug in addition of formula result if result is "" (blank)

I have a small spreadsheet that shows this problem and if I can figure out how to attach it or upload it I will.

The problem I'm seeing is this: I have a formula that generates either a blank or a number. The result of this formula is added to another number. If the formula generates a blank the result of cell+cell is #value, but the result of sum(cell:cell) is correct.

Looks like I can't upload an example SS so here goes a long and tedious explanation. Please enter the following and you will see the problem:

Cell A1 1
Cell A3 1
Cell A4 blank (i.e. nothing in this cell)
Cell A5 3
Cell A6 =A3+A4+A5

Cell B3 1
Cell B4 =if(A1=1,"",2)
Cell B5 3
Cell B6 =B3+B4+B5

Cell C3 1
Cell C4 =if(A1=1,"",2)
Cell C5 3
Cell C6 =sum(C3:C5)

If you get the same result I got then you will see the following:
A6 4
B6 #VALUE!
C6 4

This looks like a bug to me. Somehow when the formula evaluates to "", addition fails, though a simple, non-formulaic "" works fine.

I'm hoping someone will either verify the problem and I'll report a bug, or explain to me what I'm doing wrong.

2017-12-18 11:03:20 +0200 received badge  Famous Question (source)
2017-11-07 01:38:04 +0200 received badge  Famous Question (source)
2017-11-05 18:50:36 +0200 received badge  Notable Question (source)
2017-11-04 13:02:45 +0200 received badge  Popular Question (source)
2017-11-03 18:07:09 +0200 commented question getyahoo function returns "Forbidden"

tI downloaded the source code and figured out what a URL call would look like, entered it in my browser and got this bac

2017-11-03 17:46:02 +0200 edited question getyahoo function returns "Forbidden"

getyahoo function returns "Forbidden" I just encountered this and since I use this function almost daily, it could only

2017-11-03 17:44:13 +0200 asked a question getyahoo function returns "Forbidden"

getyahoo function returns "Forbidden" I just encountered this and since I use this function almost daily, it could only

2017-10-17 07:30:18 +0200 edited answer LibreOffice Extremely Slow in Mac OS Sierra

If this is indeed a memory allocation problem (i.e. the default memory allocations are too small) then the developers sh

2017-10-17 07:28:43 +0200 answered a question LibreOffice Extremely Slow in Mac OS Sierra

If this is indeed a memory allocation problem (i.e. the default memory allocations are too small) then the developers sh

2017-10-17 07:22:19 +0200 commented answer LibreOffice Extremely Slow in Mac OS Sierra

this is one of the best answers to a question I have ever seen. You are clear about what needs to be done and don't assu

2017-10-17 07:22:11 +0200 commented answer LibreOffice Extremely Slow in Mac OS Sierra

this is one of the best answers to a question I have every seen. You are clear about what needs to be done and don't ass

2017-08-09 18:47:07 +0200 commented answer possible bug in addition of formula result if result is "" (blank)

you hit on the exact problem. "conversion to number sequence is handled different..." Why doesn't + also convert the cel

2017-08-09 18:40:24 +0200 answered a question possible bug in addition of formula result if result is "" (blank)

I appreciate the effort you all have put into this. Seems like a "feature" vs "a bug", though that is poor consolation

2017-08-09 11:19:01 +0200 received badge  Notable Question (source)
2017-08-08 10:25:04 +0200 received badge  Popular Question (source)
2017-08-08 05:20:52 +0200 edited question possible bug in addition of formula result if result is "" (blank)

possible bug in addition of formula result if result is "" (blank) I have a small spreadsheet that shows this problem an

2017-08-08 05:20:41 +0200 edited question possible bug in addition of formula result if result is "" (blank)

possible bug in addition of formula result if result is "" (blank) I have a small spreadsheet that shows this problem an

2017-08-08 05:20:15 +0200 edited question possible bug in addition of formula result if result is "" (blank)

possible bug in addition of formula result if result is "" (blank) I have a small spreadsheet that shows this problem an

2017-08-08 05:19:51 +0200 received badge  Editor (source)
2017-08-08 05:19:51 +0200 edited question possible bug in addition of formula result if result is "" (blank)

possible bug in addition of formula result if result is "" (blank) I have a small spreadsheet that shows this problem an

2017-08-08 05:17:29 +0200 edited question possible bug in addition of formula result if result is "" (blank)

possible bug in addition of formula result if result is "" (blank) I have a small spreadsheet that shows this problem an

2017-08-08 05:10:39 +0200 asked a question possible bug in addition of formula result if result is "" (blank)

possible bug in addition of formula result if result is "" (blank) I have a small spreadsheet that shows this problem an

2017-06-02 18:39:07 +0200 commented answer I just updated to 5.2.7. I've been using the extension GETYAHOO.

sorry, I'm totally new to LO and to this community. as I posted above, this cause of this problem appears to be a change

2017-06-02 18:11:19 +0200 commented question I just updated to 5.2.7. I've been using the extension GETYAHOO.

I have the same problem. IMHO Yahoo changed something andhe original URL no longer works. One must find the file yahoo.p