https://bugs.documentfoundation.org/show_bug.cgi?id=170562
Bug ID: 170562
Summary: Adding IF statement causes Err 504 or #VALUE!
Product: LibreOffice
Version: 25.8.4.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Device Name SP
Processor Intel(R) Core(TM) i5-6500 CPU @ 3.20GHz 3.19 GHz
Installed RAM 16.0 GB (15.7 GB usable)
Storage 466 GB HDD HGST HTS725050A7E630, 238 GB SSD HFM256GDJTNI-82A0A
Graphics Card Intel(R) HD Graphics 530 (128 MB)
Device ID DDE3D60C-C5F1-48D4-B62F-644AF8E7645E
Product ID 00330-54938-32585-AAOEM
System Type 64-bit operating system, x64-based processor
Pen and touch No pen or touch input is available for this display
Just updated to:
Version: 25.8.4.2 (X86_64)
Build ID: 290daaa01b999472f0c7a3890eb6a550fd74c6df
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster;
VCL: win
Locale: en-CA (en_GB); UI: en-GB
Calc: CL threaded
Example: =IF(F10,"","",MEDIAN($F$10:$H$40)) Original: =MEDIAN($F$10:$H$40)
Did find this version returned a number: =IF(F10,"","",MEDIAN($F$10:$H$40)))
(extra right bracket)
Returned to previous sheet (monthly data) and found all tabulated Mean, Median
and Mode formulae changed to:
=IF(F10,"","",MEDIAN($F$10:$H$40)), except the original cell containing this
formula, which with some cells either side was stuck in a selected state.
Clicked back to current monthly sheet, then back to it to find the cells
deselected and all information deleted including borders.
Repeated the above and found all the tabulated cells correct.
RIGHT SET
Systolic Diastolic
Pulse Systolic
Diastolic Pulse
Mode: Err:504 Mode: #VALUE! Mode: 89 Mode:
#VALUE! Mode: #VALUE! Mode: #VALUE!
Median: Err:504 Median: 80 Median: 89
Median: #VALUE! Median: #VALUE! Median: #VALUE!
Average: 132 Average: 80 Average: 88
Average: #DIV/0! Average: #DIV/0!
Average: #DIV/0!
Right set Value!, DIV/0! results from no values entered yet. Left set #VALUE!
may be a result of insufficient entries
Steps to Reproduce:
1. =MEDIAN($F$10:$H$40)
2. =IF(F10,"","",MEDIAN($F$10:$H$40))
3. Err 504
Actual Results:
ER 504
Expected Results:
Initially blank cell
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Device Name SP
Processor Intel(R) Core(TM) i5-6500 CPU @ 3.20GHz 3.19 GHz
Installed RAM 16.0 GB (15.7 GB usable)
Storage 466 GB HDD HGST HTS725050A7E630, 238 GB SSD HFM256GDJTNI-82A0A
Graphics Card Intel(R) HD Graphics 530 (128 MB)
Device ID DDE3D60C-C5F1-48D4-B62F-644AF8E7645E
Product ID 00330-54938-32585-AAOEM
System Type 64-bit operating system, x64-based processor
Pen and touch No pen or touch input is available for this display
Version: 25.8.4.2 (X86_64)
Build ID: 290daaa01b999472f0c7a3890eb6a550fd74c6df
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster;
VCL: win
Locale: en-CA (en_GB); UI: en-GB
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
