[Libreoffice-bugs] [Bug 108827] [META] Calc functions bugs and enhancements

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Blocks| |108252


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108252
[Bug 108252] [META] Cell-related bugs and enhancements

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |105582


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=105582
[Bug 105582] [META] Function wizard dialog bugs and enhancements

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Yousuf Philips (jay) <***@hotmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |105120


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=105120
[Bug 105120] RANK.EQ function compatibility with excel2016 online

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Yousuf Philips (jay) <***@hotmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |104186


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=104186
[Bug 104186] FILESAVE: XLSX - Export fails to comply with ECMA-376 paragraph
18.17.2 concerning forbidden space characters between function name and left
parenthesis

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 104186, which changed state.

Bug 104186 Summary: FILESAVE: XLSX - Export fails to comply with ECMA-376 paragraph 18.17.2 concerning forbidden space characters between function name and left parenthesis
https://bugs.documentfoundation.org/show_bug.cgi?id=104186

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Pénzes Dávid <***@yahoo.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |109299


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=109299
[Bug 109299] Empty cells are not copied to external application

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Pénzes Dávid <***@yahoo.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |109298


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=109298
[Bug 109298] Ctrl+Cursor jumps incorrectly after pasting data

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Pénzes Dávid <***@yahoo.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |109220


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=109220
[Bug 109220] App. one second delay when using Page UP/DOWN and switching
between tabs

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Pénzes Dávid <***@yahoo.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |109206


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=109206
[Bug 109206] FILESAVE Calc takes a disproportionately long time to save a
relatively small spreadsheet

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Yousuf Philips (jay) <***@hotmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |109329


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=109329
[Bug 109329] [META] VLookup function bugs and enhancements

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 107955, which changed state.

Bug 107955 Summary: Implement an interpolation function
https://bugs.documentfoundation.org/show_bug.cgi?id=107955

What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |WONTFIX

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Pénzes Dávid <***@yahoo.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |89572


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=89572
[Bug 89572] Enhancement request: HYPERLINK Window to include cell containing a
formula/numeric value to be linked

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |56789


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=56789
[Bug 56789] [Request] Enhancement: DATELASTSAVED()

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |112529


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=112529
[Bug 112529] Simple function not calculated

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Yousuf Philips (jay) <***@hotmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |33689


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=33689
[Bug 33689] Date format problem using the Dutch (NL) localization

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |35567


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=35567
[Bug 35567] LibreOffice Calc does not have a nice Linear Regression tool

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 33689, which changed state.

Bug 33689 Summary: Date format problem using the Dutch (NL) localization
https://bugs.documentfoundation.org/show_bug.cgi?id=33689

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 105120, which changed state.

Bug 105120 Summary: RANK.EQ function compatibility with excel2016 online
https://bugs.documentfoundation.org/show_bug.cgi?id=105120

What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Buovjaga <***@suomi24.fi> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |113595


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=113595
[Bug 113595] STYLE(foo) inside some functions behaves strangely

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 96897, which changed state.

Bug 96897 Summary: Function window always displayed
https://bugs.documentfoundation.org/show_bug.cgi?id=96897

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |WORKSFORME

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 97198, which changed state.

Bug 97198 Summary: Calc: incorrect formula text function result from Unicode's non-BMP characters. Functions LEN(), LEFT(), RIGHT(), MID(), SEARCH(), FIND(), REPLACE()
https://bugs.documentfoundation.org/show_bug.cgi?id=97198

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 50488, which changed state.

Bug 50488 Summary: [META] several functions defined in ODFF1.2 are not available in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=50488

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 96821, which changed state.

Bug 96821 Summary: ROUND changes integers when it should not
https://bugs.documentfoundation.org/show_bug.cgi?id=96821

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Winfried Donkers <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on|105226 |


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=105226
[Bug 105226] AM/PM locale for it_IT incorrect

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 105223, which changed state.

Bug 105223 Summary: TIMEVALUE (ORARIO.VALORE in IT) Calc function
https://bugs.documentfoundation.org/show_bug.cgi?id=105223

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |DUPLICATE

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Winfried Donkers <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on|105223 |


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=105223
[Bug 105223] TIMEVALUE (ORARIO.VALORE in IT) Calc function

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 103550, which changed state.

Bug 103550 Summary: JIS function
https://bugs.documentfoundation.org/show_bug.cgi?id=103550

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Winfried Donkers <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |115440


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=115440
[Bug 115440] Add help text for Calc function ROUNDSIG

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 94309, which changed state.

Bug 94309 Summary: SUMIFS function gives Err:504 for external references
https://bugs.documentfoundation.org/show_bug.cgi?id=94309

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |DUPLICATE

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 94309, which changed state.

Bug 94309 Summary: SUMIFS function gives Err:504 for external references
https://bugs.documentfoundation.org/show_bug.cgi?id=94309

What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |NEW
Resolution|DUPLICATE |---

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 94309, which changed state.

Bug 94309 Summary: SUMIFS function gives Err:504 for external references
https://bugs.documentfoundation.org/show_bug.cgi?id=94309

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |DUPLICATE

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 58874, which changed state.

Bug 58874 Summary: OFFSET function in array context compatibility with Excel
https://bugs.documentfoundation.org/show_bug.cgi?id=58874

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 97253, which changed state.

Bug 97253 Summary: Cell function lost when copying chart from Calc to Impress
https://bugs.documentfoundation.org/show_bug.cgi?id=97253

What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 115440, which changed state.

Bug 115440 Summary: Add help text for Calc function ROUNDSIG
https://bugs.documentfoundation.org/show_bug.cgi?id=115440

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 105174, which changed state.

Bug 105174 Summary: IsLeapYear function gives erratic results.
https://bugs.documentfoundation.org/show_bug.cgi?id=105174

What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |INSUFFICIENTDATA

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |81788


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=81788
[Bug 81788] LOOKUP returns often a mess due to definition

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |88964


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=88964
[Bug 88964] Add SOUNDEX() and LEVELSHTEIN_DISTANCE() function in Calc

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |89013


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=89013
[Bug 89013] Regular expressions doesn't work with MATCH and VLOOKUP when
searched range is in other file.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 111675, which changed state.

Bug 111675 Summary: UI: Functions IFS does not work together with function CURRENT
https://bugs.documentfoundation.org/show_bug.cgi?id=111675

What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 111675, which changed state.

Bug 111675 Summary: UI: Functions IFS does not work together with function CURRENT
https://bugs.documentfoundation.org/show_bug.cgi?id=111675

What |Removed |Added
----------------------------------------------------------------------------
Status|CLOSED |REOPENED
Resolution|NOTABUG |---

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 113595, which changed state.

Bug 113595 Summary: Of multiple STYLE() calls as arguments to IFS() and SWITCH() the first one (last evaluated) is applied.
https://bugs.documentfoundation.org/show_bug.cgi?id=113595

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |DUPLICATE

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |104899


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=104899
[Bug 104899] Data Analysis T test error in formula for standard error of the
difference of sample means

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 116514, which changed state.

Bug 116514 Summary: yield function doesn't accept ref as 1st arg
https://bugs.documentfoundation.org/show_bug.cgi?id=116514

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |WORKSFORME

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

--- Comment #1 from Winfried Donkers <***@libreoffice.org> ---
@Thomas :
What is the difference between bug#108827 and bug#108253?

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

--- Comment #2 from Thomas Lendo <***@gmail.com> ---
(In reply to Winfried Donkers from comment #1)

Post by b***@bugs.documentfoundation.org
What is the difference between bug#108827 and bug#108253?

This is for issues with function logic. The other one is for e.g. formula
appearemce issues and others not directly related with a function.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

--- Comment #3 from Winfried Donkers <***@libreoffice.org> ---
(In reply to Thomas Lendo from comment #2)

Post by b***@bugs.documentfoundation.org
(In reply to Winfried Donkers from comment #1)

Post by b***@bugs.documentfoundation.org
What is the difference between bug#108827 and bug#108253?

This is for issues with function logic. The other one is for e.g. formula
appearemce issues and others not directly related with a function.

Ah, thank you. Then I will be monitoring bug#108827 closely and bug#108253
loosely .

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |116706


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=116706
[Bug 116706] AGGREGATE COUNTA with hidden rows

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 116706, which changed state.

Bug 116706 Summary: AGGREGATE COUNTA with hidden rows
https://bugs.documentfoundation.org/show_bug.cgi?id=116706

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |117382


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=117382
[Bug 117382] DATUMVERSCHIL is not working, instead must use DATUMALS
(DATEDIFF)

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |117433


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=117433
[Bug 117433] count.if doesn't work

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |117459


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=117459
[Bug 117459] CELL() function does not recalculate on non-cell-content-changing
events

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 117433, which changed state.

Bug 117433 Summary: COUNTIF() doesn't properly count empty cells for empty ("" or "=") criteria
https://bugs.documentfoundation.org/show_bug.cgi?id=117433

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |48552


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=48552
[Bug 48552] Slow to process "PROCV" formula

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 48552, which changed state.

Bug 48552 Summary: Slow to process "VLOOKUP" formula
https://bugs.documentfoundation.org/show_bug.cgi?id=48552

What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |WORKSFORME

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 93445, which changed state.

Bug 93445 Summary: [l10n, Russian] All CDFs for discrete distributions should be marked “in Western tradition”
https://bugs.documentfoundation.org/show_bug.cgi?id=93445

What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |INSUFFICIENTDATA

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 117433, which changed state.

Bug 117433 Summary: COUNTIF() doesn't properly count empty cells for empty ("" or "=") criteria
https://bugs.documentfoundation.org/show_bug.cgi?id=117433

What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|FIXED |---

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 117433, which changed state.

Bug 117433 Summary: COUNTIF() doesn't properly count empty cells for empty ("" or "=") criteria
https://bugs.documentfoundation.org/show_bug.cgi?id=117433

What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 77517, which changed state.

Bug 77517 Summary: Function of reference to external file Error 504
https://bugs.documentfoundation.org/show_bug.cgi?id=77517

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 112529, which changed state.

Bug 112529 Summary: Simple function not calculated
https://bugs.documentfoundation.org/show_bug.cgi?id=112529

What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |INSUFFICIENTDATA

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 90433, which changed state.

Bug 90433 Summary: HYPERLINK() function, if present but not evaluated, wrongly forces cell to pretend being linked.
https://bugs.documentfoundation.org/show_bug.cgi?id=90433

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |WONTFIX

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 96666, which changed state.

Bug 96666 Summary: EDITING: Address Function incorrectly resolves when Sheet names is given to #REF
https://bugs.documentfoundation.org/show_bug.cgi?id=96666

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

raal <***@post.cz> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |118800


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=118800
[Bug 118800] HOUR function>> 24 is displayed instead of 0(zero) if Number
argument in the range from -0.000001 to min negative number.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 118800, which changed state.

Bug 118800 Summary: HOUR, MINUTE and SECOND function return value that is 1 too high, when seconds value of time >= 59.5 (HOUR, MINUTE) or >= xx.5 (SECOND)
https://bugs.documentfoundation.org/show_bug.cgi?id=118800

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 91502, which changed state.

Bug 91502 Summary: The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)
https://bugs.documentfoundation.org/show_bug.cgi?id=91502

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 35567, which changed state.

Bug 35567 Summary: LibreOffice Calc does not have a nice Linear Regression tool
https://bugs.documentfoundation.org/show_bug.cgi?id=35567

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |WORKSFORME

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

raal <***@post.cz> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |119034


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=119034
[Bug 119034] ADDRESS function >> R1C1 style is used instead of A1 style, if
"A1" argument is floating-point number with zero integer

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Xisco Faulí <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |119033


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=119033
[Bug 119033] ADDRESS function >> result of calculation is displayed instead of
#VALUE! error if "ABS" argument is value in range from 5 to 8

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 119034, which changed state.

Bug 119034 Summary: ADDRESS function >> R1C1 style is used instead of A1 style, if "A1" argument is floating-point number with zero integer
https://bugs.documentfoundation.org/show_bug.cgi?id=119034

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 119533, which changed state.

Bug 119533 Summary: calculation of MINUTE() wrong in LibreOffice 6.1
https://bugs.documentfoundation.org/show_bug.cgi?id=119533

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Thomas Lendo <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |119573


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=119573
[Bug 119573] YIELD function shows inconsistent results for basis 3

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 73078, which changed state.

Bug 73078 Summary: Function TYPE() returns error, when parameter is a reference to an empty cell
https://bugs.documentfoundation.org/show_bug.cgi?id=73078

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 100652, which changed state.

Bug 100652 Summary: ODFF function name and Add-In function name are swapped.
https://bugs.documentfoundation.org/show_bug.cgi?id=100652

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 91206, which changed state.

Bug 91206 Summary: [1] - Mathematical function - interpre.hxx - Extend enum ScIterFuncIf by ifMAXIF and ifMINIF similar to SUMIF
https://bugs.documentfoundation.org/show_bug.cgi?id=91206

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 73081, which changed state.

Bug 73081 Summary: COUNTIF with criterium <>number does not count empty cells.
https://bugs.documentfoundation.org/show_bug.cgi?id=73081

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 47106, which changed state.

Bug 47106 Summary: References, Adapt row hight and AutoCalculate slow down Calc dramatically due to OFFSET() function
https://bugs.documentfoundation.org/show_bug.cgi?id=47106

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |WORKSFORME

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Roman Kuznetsov <***@mail.ru> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |120895


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=120895
[Bug 120895] SUBTOTAL function, doesn't work inside SUMPRODUCT while it works
inside an SUM array

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 104899, which changed state.

Bug 104899 Summary: Data Analysis T test error in formula for standard error of the difference of sample means
https://bugs.documentfoundation.org/show_bug.cgi?id=104899

What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |INSUFFICIENTDATA

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 120895, which changed state.

Bug 120895 Summary: SUBTOTAL function, doesn't work inside SUMPRODUCT while it works inside an SUM array
https://bugs.documentfoundation.org/show_bug.cgi?id=120895

What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution|--- |FIXED

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 107369, which changed state.

Bug 107369 Summary: Enhancement to Calc function SUBSTITUTE
https://bugs.documentfoundation.org/show_bug.cgi?id=107369

What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |WONTFIX

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827
Bug 108827 depends on bug 121696, which changed state.

Bug 121696 Summary: [EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result
https://bugs.documentfoundation.org/show_bug.cgi?id=121696

What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |NOTABUG

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Roman Kuznetsov <***@mail.ru> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |121396


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=121396
[Bug 121396] FORECAST.ETS.PI functions produces different results with
identical data.

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

--- Comment #4 from ***@us.es ---
In relation to error bug#121978
(https://bugs.documentfoundation.org/show_bug.cgi?id=121978)
SECOND before rounds -> SECOND("00:00:08,99") -> result 9, and now result 8.

I think of two possible solutions, or have two functions: SECOND("00:00:08,99")
with result 9 and SECONDNOTROUNDED("00:00:08,99") that return 8. Or a function
with a second parameter optional rounding (with backward compatibility):
=SECOND("00:00:08,99" [, BOOLEAN ROUND]), default BOOLEAN ROUND is TRUE.

=SECOND("00:00:08,99") = SECOND("00:00:08,99",TRUE) = 9
=SECOND("00:00:08,99", FALSE) = 8

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108827

Roman Kuznetsov <***@mail.ru> changed:

What |Removed |Added
----------------------------------------------------------------------------
Depends on| |121978


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=121978
[Bug 121978] Problem with new function SECOND