Bugzilla – Bug List
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
Wed May 8 2024 06:21:44 UTC
Nothing is impossible in the free software world. You just have to do it!
Hide Search Description
Status:
UNCONFIRMED, NEW, ASSIGNED, REOPENED, NEEDINFO
Product:
vlookup
Component:
vlookup
Alias:
vlookup
Summary:
vlookup
Whiteboard:
vlookup
Content:
"vlookup"
48 bugs found.
ID
Product
Comp
▲
Assignee
▲
Status
▲
Resolution
Summary
Changed
▼
160893
LibreOff
Calc
libreoffice-bugs
UNCO
---
XLOOKUP problem with date as text
Thu 08:40
137147
LibreOff
Calc
libreoffice-bugs
NEW
---
Provide a way to cancel formula calculation in Calc (e.g., by hitting ESC key)
2024-04-25
158386
LibreOff
Calc
libreoffice-bugs
UNCO
---
Windows Excel File locks up Libre Calc vers. 7.6.2.1 while trying to open it.
2024-04-14
145994
LibreOff
Calc
libreoffice-bugs
NEW
---
references to named ranges in external files do not update on document open
2024-04-04
132780
LibreOff
Calc
libreoffice-bugs
NEW
---
Feature Request: Add Calc Tables with functionality similar to Excel's "Format as tables"
2024-03-15
160081
LibreOff
Calc
libreoffice-bugs
NEW
---
Performance: VLOOKUP is very slow even with 41670 rows of data
2024-03-07
159544
LibreOff
Calc
libreoffice-bugs
NEW
---
Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING
2024-03-02
63087
LibreOff
Calc
libreoffice-bugs
NEW
---
Detective "Trace Precedents" or "Trace Dependents" pointing to a different tab does not provide reference cell
2024-02-27
128329
LibreOff
Calc
libreoffice-bugs
UNCO
---
WORK: 'incomplete autocalculations' - cooperation of autocalculate and shared formulas / formulae still broken in LO calc ver. 6.2.7.1 with *threaded* calculation on
2024-02-26
151958
LibreOff
Calc
erack
ASSI
---
The COUNTIF and COUNTIFS functions mis-count on mixed numeric and text data and query by string
2024-02-23
35923
LibreOff
Calc
libreoffice-bugs
NEW
---
Calc - Standard Filter produces wrong display (Selection range is automatically expanded)
2024-02-22
159570
LibreOff
Calc
libreoffice-bugs
NEED
---
Function "SearchV" don't work well
2024-02-05
149940
LibreOff
Calc
libreoffice-bugs
NEW
---
Incorrect VLOOKUP result with OpenCL
2024-01-23
124710
LibreOff
Calc
libreoffice-bugs
NEW
---
IFS function erroneously propagates error results from functions within IFS (smallest reproducer in comment 6)
2023-12-06
131560
LibreOff
Calc
libreoffice-bugs
NEW
---
Data/Form provides access to cells that are protected
2023-11-29
158175
LibreOff
Calc
libreoffice-bugs
UNCO
---
FILEOPEN does not initialize some formulas/cells correctly
2023-11-28
74580
LibreOff
Calc
libreoffice-bugs
NEW
---
FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)
2023-10-01
154913
LibreOff
Calc
libreoffice-bugs
NEW
---
Poor performance for ODS with frozen rows and columns
2023-09-22
137846
LibreOff
Calc
libreoffice-bugs
NEW
---
FILEOPEN XLSX Defined name pointing to data table does not resolve source file name
2023-09-07
149356
LibreOff
Calc
libreoffice-bugs
NEW
---
Choose which adjacent column of a "double clicked" formula dictates the extent of the fill
2023-07-21
155551
LibreOff
Calc
libreoffice-bugs
NEW
---
Trim function making index/match or lookup functions calculate all spreadsheet rows instead of data interval
2023-06-03
154243
LibreOff
Calc
libreoffice-bugs
NEW
---
EDITING: copy lookup formula from other file does no longer work
2023-05-15
121488
LibreOff
Calc
libreoffice-bugs
NEW
---
ERROR.TYPE for "Search out of range" in Excel return 7 but in Calc #N/D
2023-05-11
72594
LibreOff
Calc
libreoffice-bugs
NEW
---
File links to range names don't work after re-opening file (unable to create VLOOKUP named range in another file)
2023-05-08
121386
LibreOff
Calc
libreoffice-bugs
NEW
---
LO Calc freezes when navigating in sheets
2023-04-12
109329
LibreOff
Calc
libreoffice-bugs
NEW
---
[META] VLookup function bugs and enhancements
2023-02-20
122394
LibreOff
Calc
libreoffice-bugs
NEW
---
changing named ranges content via vba macro will not update cell formula
2023-01-04
147916
LibreOff
Calc
libreoffice-bugs
NEW
---
When copying a cell to a newly inserted sheet, absolute sheet name reference is not reserved thus the pasted formula is broken
2022-12-20
152334
LibreOff
Calc
libreoffice-bugs
NEW
---
Autofilter doesn't work on a custom array function range
2022-12-18
152582
LibreOff
Calc
libreoffice-bugs
NEW
---
The autofilter outputs several values 0 and empty if data is the result of VLOOKUP function
2022-12-18
97427
LibreOff
Calc
libreoffice-bugs
NEW
---
After closing a comment mouse cursor is incorrect
2022-09-12
97101
LibreOff
Calc
libreoffice-bugs
NEW
---
Add a SPLIT() function for separating string cells based on a delimiter
2022-09-08
131944
LibreOff
Calc
libreoffice-bugs
NEW
---
FORMATTING Wrap text automatically not working when value inserted using vlookup() function
2022-08-14
89013
LibreOff
Calc
libreoffice-bugs
NEW
---
Regular expressions doesn't work with MATCH and VLOOKUP when searched range is in other file.
2022-07-30
105414
LibreOff
Calc
libreoffice-bugs
NEW
---
Blank cells formatted as numbers not treated as ZERO when pulled via VLOOKUP to external file
2022-07-27
113002
LibreOff
Calc
libreoffice-bugs
NEW
---
LibreOfficeCalc: Pivot Table recurring data field name will added a simple quotation marks before number
2022-06-21
108373
LibreOff
Calc
libreoffice-bugs
NEW
---
Conditional formatting changes format of dates and numbers
2022-06-17
109254
LibreOff
Calc
libreoffice-bugs
NEW
---
Allow toggling of absolute and relative references when working with Function Wizard
2022-06-14
140365
LibreOff
Calc
libreoffice-bugs
NEW
---
VLOOKUP slow on accessing search matrix in other files
2022-02-16
144643
LibreOff
Calc
libreoffice-bugs
UNCO
---
Defined name pointing to external worksheet does not work/cannot be created
2021-10-06
115935
LibreOff
Calc
libreoffice-bugs
NEW
---
PIVOT TABLE: add the option to link several tables as source on one pivot table.
2018-07-08
81788
LibreOff
Calc
libreoffice-bugs
NEW
---
LOOKUP returns often a mess due to definition
2018-03-05
83131
LibreOff
Calc
libreoffice-bugs
NEW
---
Provide ROWMAX, ROWMIN functions
2017-07-24
157778
LibreOff
Document
libreoffice-bugs
NEW
---
Add a note to Help about Calc's MATCH function's Type parameter (see comment 1)
2023-10-27
153206
LibreOff
Document
libreoffice-bugs
NEW
---
Better document de logic behind sorting data in Calc (alpha-numeric and mix of formats)
2023-03-07
145560
LibreOff
LibreOff
libreoffice-bugs
NEW
---
VLOOKUP does not work when calc file is imported from Lotus 1-2-3 release 4 for windows
2022-09-10
88964
LibreOff
LibreOff
libreoffice-bugs
NEW
---
Add SOUNDEX() and LEVELSHTEIN_DISTANCE() function in Calc
2018-03-05
149661
LibreOff
Writer
libreoffice-bugs
NEW
---
[Feature request] Automatic table-background-coloring ported from Calc to Writer.
2022-06-22
48 bugs found.
Change Columns
Edit Search
as
File a new bug in the "LibreOffice" product