Bug 361667 - Match function does not work
Summary: Match function does not work
Status: RESOLVED WORKSFORME
Alias: None
Product: calligrasheets
Classification: Applications
Component: functions (show other bugs)
Version: 2.9.11
Platform: Arch Linux Linux
: NOR major
Target Milestone: ---
Assignee: Calligra Sheets (KSpread) Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-04-12 13:12 UTC by Dimitrios Charalampidis
Modified: 2022-11-18 05:18 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments
The spreadsheets where the problem appears. (21.53 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-04-12 13:13 UTC, Dimitrios Charalampidis
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Dimitrios Charalampidis 2016-04-12 13:12:40 UTC
I recently switched to Calligra Sheets from LibreOffice.
I have a sheet with some calculations and in one cell I have the following function:
=SUM(INDEX(D6:D100;MATCH(1E+308;D6:D100)-6+1):D100)/6
It works in LibreOffice and Google Sheets (Online) but in Calligra Sheets it returns #PARSE!
 

Reproducible: Always
Comment 1 Dimitrios Charalampidis 2016-04-12 13:13:54 UTC
Created attachment 98354 [details]
The spreadsheets where the problem appears.
Comment 2 Justin Zobel 2022-10-19 22:10:47 UTC
Thank you for reporting this bug in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the issue with a recent software version?

If you can reproduce the issue, please change the status to "CONFIRMED" when replying. Thank you!
Comment 3 Bug Janitor Service 2022-11-03 05:08:08 UTC
Dear Bug Submitter,

This bug has been in NEEDSINFO status with no change for at least
15 days. Please provide the requested information as soon as
possible and set the bug status as REPORTED. Due to regular bug
tracker maintenance, if the bug is still in NEEDSINFO status with
no change in 30 days the bug will be closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

If you have already provided the requested information, please
mark the bug as REPORTED so that the KDE team knows that the bug is
ready to be confirmed.

Thank you for helping us make KDE software even better for everyone!
Comment 4 Bug Janitor Service 2022-11-18 05:18:22 UTC
This bug has been in NEEDSINFO status with no change for at least
30 days. The bug is now closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

Thank you for helping us make KDE software even better for everyone!