https://bugs.documentfoundation.org/show_bug.cgi?id=154101
Bug ID: 154101
Summary: Feature Request =A1 shows a 0 when A1 is blank
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
You All do a great job,
I notice if i have a function =A1 and A1 is blank, that function shows 0. That
messes up averages and counts downstream. Excel is the same way. It also messes
up reporting. If I do a test on lead in water, a function pulls it over to the
report(printout) area. If I did not run the test is will still show a zero, as
if the test was run and the water is safe. Why can't the function be blank w/o
if(isblank(a1)"",a1). Then LibreOffice Calc would be infinitely better than
Excel, Which is already better. In the file below shows a custom a function
with that. Look in B1
If only =A1 would be blank if Cell A1 is blank
Best yet, switch it so it works for one file.
Thanks for everything
I don't expect you to do this because rich Microsoft has not done it ,
just an idea.
Steps to Reproduce:
1.=a1 should be blank if a1 is blank
2.
3.
Actual Results:
if Cell a1 is blank, the function shows 0
Expected Results:
Ideally =a1 should show blank if a1 is blank.
Reproducible: Always
User Profile Reset: No
Additional Info:
I really do not expect you to do this, Excel doesn't do it, and you have no
money.
--
You are receiving this mail because:
You are the assignee for the bug.
