Bugzilla – Bug List
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
Wed May 8 2024 11:11:46 UTC
<noelgrandin> the thing that I really like about bison is that by the time you are done, you can no longer read either the embedded code, or the grammar, thus obscuring two things with one stroke!
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
▼
159570
LibreOff
Calc
libreoffice-bugs
NEED
---
Function "SearchV" don't work well
2024-02-05
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
137147
LibreOff
Calc
libreoffice-bugs
NEW
---
Provide a way to cancel formula calculation in Calc (e.g., by hitting ESC key)
2024-04-25
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
35923
LibreOff
Calc
libreoffice-bugs
NEW
---
Calc - Standard Filter produces wrong display (Selection range is automatically expanded)
2024-02-22
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
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
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
153206
LibreOff
Document
libreoffice-bugs
NEW
---
Better document de logic behind sorting data in Calc (alpha-numeric and mix of formats)
2023-03-07
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
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
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
149661
LibreOff
Writer
libreoffice-bugs
NEW
---
[Feature request] Automatic table-background-coloring ported from Calc to Writer.
2022-06-22
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
115935
LibreOff
Calc
libreoffice-bugs
NEW
---
PIVOT TABLE: add the option to link several tables as source on one pivot table.
2018-07-08
88964
LibreOff
LibreOff
libreoffice-bugs
NEW
---
Add SOUNDEX() and LEVELSHTEIN_DISTANCE() function in Calc
2018-03-05
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
160893
LibreOff
Calc
libreoffice-bugs
UNCO
---
XLOOKUP problem with date as text
2024-05-02
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
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
158175
LibreOff
Calc
libreoffice-bugs
UNCO
---
FILEOPEN does not initialize some formulas/cells correctly
2023-11-28
144643
LibreOff
Calc
libreoffice-bugs
UNCO
---
Defined name pointing to external worksheet does not work/cannot be created
2021-10-06
48 bugs found.
Change Columns
Edit Search
as
File a new bug in the "LibreOffice" product