Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Packages and Libraries
»
FPSpreadsheet
»
Bug in the formula MATCH, INDEX, IF
Free Pascal
Website
Downloads
Wiki
Documentation
Bugtracker
Mailing List
Lazarus
Website
Downloads (Laz+FPC)
Packages (OPM)
FAQ
Wiki
Documentation (RTL/FCL/LCL)
Bugtracker
CCR Bugs
GIT
Mailing List
Other languages
Foundation
Website
Useful Wiki Links
Project Roadmap
Getting the Source
Screenshots
How to use the forum
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
A circular / ring buffer ...
by
silvercoder70
[
Today
at 10:50:09 pm]
PAS2JS: VAL() - Incompati...
by
peter.dell
[
Today
at 10:35:08 pm]
PAS2JS: Error: Not suppor...
by
peter.dell
[
Today
at 10:30:27 pm]
UADE Library
by
TRon
[
Today
at 10:23:16 pm]
I set VertAxis.Range.Min:...
by
dvhx
[
Today
at 10:16:04 pm]
Column width with two WDa...
by
rca
[
Today
at 09:54:55 pm]
Form disappears after foc...
by
OC DelGuy
[
Today
at 08:58:00 pm]
Zebra printer and LazRepo...
by
tito_livio
[
Today
at 08:41:21 pm]
Load/Save form state to f...
by
GabrielMoraru.com
[
Today
at 08:19:09 pm]
AI usefulness discussion
by
TRon
[
Today
at 08:03:59 pm]
ToDoList package, support...
by
JuhaManninen
[
Today
at 07:58:04 pm]
Can't find unit unixsocke...
by
TCH
[
Today
at 07:57:09 pm]
Format text in cells of t...
by
wp
[
Today
at 07:50:18 pm]
GTK2 : assertion 'GTK_IS_...
by
Nel_Fie
[
Today
at 07:23:30 pm]
Bug if FileListBox.Sorted...
by
Bart
[
Today
at 07:20:57 pm]
Treeview: full-width back...
by
wp
[
Today
at 07:19:45 pm]
rayMedia
by
Guva
[
Today
at 07:15:57 pm]
Passing QWord in 32-bit p...
by
LemonParty
[
Today
at 06:06:45 pm]
Troubles with function de...
by
Remy Lebeau
[
Today
at 06:01:08 pm]
efficiency problem
by
ALLIGATOR
[
Today
at 05:16:37 pm]
Using events in a console...
by
xint
[
Today
at 04:55:24 pm]
PortAudio Configure Devic...
by
TRon
[
Today
at 04:20:52 pm]
Glowing Fractal Tree
by
TRon
[
Today
at 04:17:05 pm]
Reviving Interest in Pasc...
by
TRon
[
Today
at 04:12:31 pm]
How to use TCustomApplica...
by
Zvoni
[
Today
at 03:37:52 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: Bug in the formula MATCH, INDEX, IF (Read 706 times)
veb86
Jr. Member
Posts: 87
Bug in the formula MATCH, INDEX, IF
«
on:
January 18, 2025, 02:40:23 pm »
Error in return values:
MATCH - should return #N/A
INDEX - when receiving one of the #N/A values, should also return #N/A
IF - when receiving one of the #N/A values, should also return #N/A
Please see the attached picture and example.
Logged
veb86
Jr. Member
Posts: 87
Re: Bug in the formula MATCH, INDEX, IF
«
Reply #1 on:
January 29, 2025, 01:05:41 pm »
Hi.
I see that you have made many commits on this bug. Can I upgrade and start using the library?
Logged
wp
Hero Member
Posts: 12622
Re: Bug in the formula MATCH, INDEX, IF
«
Reply #2 on:
January 29, 2025, 08:21:59 pm »
Just writing some more unit tests, but I don't think that much will change here.
Logged
veb86
Jr. Member
Posts: 87
Re: Bug in the formula MATCH, INDEX, IF
«
Reply #3 on:
January 30, 2025, 06:48:25 am »
I will try. Thank you very much.
Logged
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Packages and Libraries
»
FPSpreadsheet
»
Bug in the formula MATCH, INDEX, IF
TinyPortal
© 2005-2018