Bug 108827
depends on
503
bugs:
view as bug list
-
108827:
[META] Calc functions bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
40975:
Add "differentiation" function to Calc
[NEW; assigned to libreoffice-bugs]
-
45765:
: Feature request: Function to generate input values for calculation based on spreadsheets
[NEW; assigned to libreoffice-bugs]
-
53146:
Proper Function Capitalizes Letters After Apostrophe
[NEW; assigned to libreoffice-bugs]
-
56789:
[Request] Enhancement: DATELASTSAVED()
[NEW; assigned to libreoffice-bugs]
-
60647:
FILESAVE: =CELL("filename") not updated
[NEW; assigned to libreoffice-bugs]
-
61512:
Calc ROUND() don't use default IEEE 754 method (-> statistical error).
[NEW; assigned to libreoffice-bugs]
-
65086:
Warn or do a suggestion when entering a function with trailing ';' in the cell range
[NEW; assigned to libreoffice-bugs]
-
68844:
Other: [Feature Request] =word(cellref,n,[delimiter]) function to extract the nth word
[NEW; assigned to libreoffice-bugs]
-
71170:
WEEKNUM needs corresponding YEAR functionality
[NEW; assigned to libreoffice-bugs]
-
71175:
Other: "Enhancement Bug", Design Suggestion, A More Intuitive Syntax for Array Outputs
[NEW; assigned to libreoffice-bugs]
-
73085:
Function TYPE returns value 8, but that value does not exist in specification
[NEW; assigned to libreoffice-bugs]
-
74101:
add NOPRINTROW and NOPRINTCOL functions
[NEW; assigned to libreoffice-bugs]
-
76447:
MULTIPLE.OPERATIONS() shows wrong results when some internal limit is reached
[NEW; assigned to libreoffice-bugs]
-
79257:
Other: pageNo() - a page number function request
[NEW; assigned to libreoffice-bugs]
-
81788:
LOOKUP returns often a mess due to definition
[NEW; assigned to libreoffice-bugs]
-
82212:
Additional "Category Spreadsheet" function(s)
[NEW; assigned to libreoffice-bugs]
-
83131:
Provide ROWMAX, ROWMIN functions
[NEW; assigned to libreoffice-bugs]
-
83653:
FILEOPEN - ODS - Formula (REPT) - cell shows no repeated value on German locale Windows
[NEW; assigned to libreoffice-bugs]
-
84745:
EDITING: recalculation issue with user defined function (it is not recalculated)
[NEW; assigned to libreoffice-bugs]
-
85539:
SUMPRODUCT not summing multiple sheets
[NEW; assigned to libreoffice-bugs]
-
85986:
CELL() Function does not re-evaluate a change in sheet name.
[NEW; assigned to libreoffice-bugs]
-
86174:
logic error with mod() and int() function
[NEW; assigned to libreoffice-bugs]
-
88061:
ROWS(),SHEETS(), COLUMNS() functions - relative path to other file
[NEW; assigned to libreoffice-bugs]
-
88490:
function CELL() errors - date, currency,coord InfoType
[NEW; assigned to libreoffice-bugs]
-
88498:
function Countif external reference - value not cached
[NEW; assigned to libreoffice-bugs]
-
88718:
Error in COUNTIF function - case sensitive to external file.
[NEW; assigned to libreoffice-bugs]
-
88964:
Add SOUNDEX() and LEVELSHTEIN_DISTANCE() function in Calc
[NEW; assigned to libreoffice-bugs]
-
89013:
Regular expressions doesn't work with MATCH and VLOOKUP when searched range is in other file.
[NEW; assigned to libreoffice-bugs]
-
89572:
Enhancement request: HYPERLINK Window to include cell containing a formula/numeric value to be linked
[NEW; assigned to libreoffice-bugs]
-
93627:
new version of DEC2BIN() and HEX2BIN() with support of more than 10 binary digits
[NEW; assigned to libreoffice-bugs]
-
94975:
Function for Sheet names
[NEW; assigned to libreoffice-bugs]
-
96623:
Add Data Analysis Expressions (DAX) functions to pivot table
[NEW; assigned to libreoffice-bugs]
-
97101:
Add a SPLIT() function for separating string cells based on a delimiter
[NEW; assigned to libreoffice-bugs]
-
97334:
[Numbers] Add iWorks' Numbers missing functions
[NEW; assigned to libreoffice-bugs]
-
97613:
EDITING: CELL() function doesn't work as array inside arrays or in array functions like SUMPRODUCT()
[NEW; assigned to libreoffice-bugs]
-
99308:
Amordegrc using obsolete values for degressive amortisation
[NEW; assigned to libreoffice-bugs]
-
100450:
Add ODFF1.2 ACCRINT function to Calc
[NEW; assigned to libreoffice-bugs]
-
101837:
EDITING: Calculation error for CHIINV function
[NEW; assigned to libreoffice-bugs]
-
103441:
[META] Functions deck/tab of the sidebar
[NEW; assigned to libreoffice-bugs]
-
104185:
Better Autoinput for functions (or different default than ENTER)
[NEW; assigned to libreoffice-bugs]
-
105032:
EDITING ENHANCEMENT Add an alias function "mean" for "average"
[NEW; assigned to libreoffice-bugs]
-
105582:
[META] Function wizard dialog bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
105811:
Enhancement to CELL() function
[NEW; assigned to libreoffice-bugs]
-
107366:
Bug in selection menu for active cell range functions
[NEW; assigned to libreoffice-bugs]
-
107370:
Enhancement to Calc function REPLACE
[NEW; assigned to libreoffice-bugs]
-
107779:
Sorting breaks rows data alignement when functions include columns with no data
[NEW; assigned to libreoffice-bugs]
-
109329:
[META] VLookup function bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
109330:
[META] Subtotal function bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
109352:
[META] Sum function bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
111675:
IFS() and SWITCH() should short-cut evaluation like IF() and CHOOSE()
[ASSIGNED; assigned to ahmedhamed3699]
-
113974:
Ability to parse/filter JSON data and extract fields
[NEW; assigned to libreoffice-bugs]
-
116040:
Under specific conditions OR is acting in formulas as a Boolean operator. Same with AND
[NEW; assigned to libreoffice-bugs]
-
116336:
HYPERLINK() used in a cell with 'Wrap text automatically' links only for the first line.
[NEW; assigned to libreoffice-bugs]
-
117893:
besselj gives error for negative order
[NEW; assigned to libreoffice-bugs]
-
118735:
Opening a spreadsheet with saved values of URI functions shows #VALUE! instead of cached values (see comment 7)
[NEW; assigned to libreoffice-bugs]
-
119573:
YIELD function shows inconsistent results for basis 3
[NEW; assigned to libreoffice-bugs]
-
120543:
[META] Bugs and enhancements around hyperlinks in Calc
[NEW; assigned to libreoffice-bugs]
-
35392:
FILESAVE: Hyperlinks in form field buttons lost in .xls
[NEW; assigned to libreoffice-bugs]
-
39910:
Text-Wrapping Doesn't Wrap Long HyperLinks Resulting in Cutoff Text
[NEW; assigned to libreoffice-bugs]
-
41328:
VIEWING: Active hyperlink area far away from rotated text with hyperlink
[NEW; assigned to libreoffice-bugs]
-
44189:
FORMATTING: visited hyperlinks do not change color
[NEW; assigned to libreoffice-bugs]
-
48803:
Hyperlink only accessible in left or justified aligned text
[NEW; assigned to libreoffice-bugs]
-
55953:
PDF Export of partial document destroys internal hyperlinks to other sheets
[NEW; assigned to libreoffice-bugs]
-
62289:
Adding hyperlinks via the GUI to other sheets with only a number for the name in the same workbook take you to the ROW number in the current sheet, instead of to the target_sheet.a1
[NEW; assigned to libreoffice-bugs]
-
74533:
EDITING hyperlink: column insert after hidden column with hyperlins creates a column with invisible and undelettable hyperlinks
[NEW; assigned to libreoffice-bugs]
-
80040:
FILESAVE: XLSX - Hyperlinks don't show up in Excel in blue or underlined
[NEW; assigned to libreoffice-bugs]
-
84449:
URL highlighting ignoring '|' character
[NEW; assigned to libreoffice-bugs]
-
85793:
Multiple links in a single cell work only with left text alignment
[NEW; assigned to libreoffice-bugs]
-
89468:
Automatic hyperlink creation to file system does not work as expected when editing existing text
[NEW; assigned to libreoffice-bugs]
-
89572:
Enhancement request: HYPERLINK Window to include cell containing a formula/numeric value to be linked
[NEW; assigned to libreoffice-bugs]
(*)
-
89633:
CALC does not properly import / edit Excel hyperlinked cells containing formula or numeric
[NEW; assigned to libreoffice-bugs]
-
89690:
Can not find and replace text in a hyperlink without losing links
[NEW; assigned to libreoffice-bugs]
-
91942:
DDE function should work with http
[NEW; assigned to libreoffice-bugs]
-
95600:
Modify a cell that contains URL in Calc; unable to modify hyperlink in formula bar
[NEW; assigned to libreoffice-bugs]
-
100197:
Scenario Hyperlinks do not work.
[NEW; assigned to libreoffice-bugs]
-
103447:
Cell containing hyperlink (URL or email), is not synchronized properly between cell and input line (mismatch in display, edit and selection)
[NEW; assigned to libreoffice-bugs]
-
103511:
Right-aligned hyperlink in shrinked cell contaminates following cells if they are empty
[NEW; assigned to libreoffice-bugs]
-
108395:
Links to media files function differently if they are in TEXT or BUTTON form
[NEW; assigned to libreoffice-bugs]
-
112397:
EDITING: Cannot change Hyperlink button to Hyperlink text
[NEW; assigned to libreoffice-bugs]
-
113337:
FILEOPEN: XLSX - Hyperlinks always displayed as blue, even if style uses different font colour
[NEW; assigned to libreoffice-bugs]
-
116336:
HYPERLINK() used in a cell with 'Wrap text automatically' links only for the first line.
[NEW; assigned to libreoffice-bugs]
(*)
-
117141:
SharePoint directory list in Calc loses all hyperlinks pointing to the files
[NEW; assigned to libreoffice-bugs]
-
118866:
Notify when hyperlink to hidden sheet is not possible
[NEW; assigned to libreoffice-bugs]
-
119361:
EDITING - the hyperlink dialog only retains the "Name" property in Writer (not editeng)
[NEW; assigned to libreoffice-bugs]
-
121035:
Mouse pointer does not change appearance to a hand over hyperlink with Ctrl pressed
[NEW; assigned to libreoffice-bugs]
-
125764:
hyperlink active region inaccurate in scaled sheet (truncated fractions?)
[NEW; assigned to libreoffice-bugs]
-
131851:
Ctrl-clicking a hyperlink in shape or text box does not work while editing a different object
[NEW; assigned to libreoffice-bugs]
-
131852:
Ctrl-clicking a hyperlink in shape or text box does not work while editing a cell
[NEW; assigned to libreoffice-bugs]
-
138356:
CALC Hyperlink button text corrupted with part of an embedded graphic image
[NEW; assigned to libreoffice-bugs]
-
142296:
Hyperlinks set on an object in Calc are not exported in PDF documents
[NEW; assigned to libreoffice-bugs]
-
142979:
Whole range's hyperlinks become inactive when formula with error pasted / filled in adjacent cell (steps in comment 8)
[NEW; assigned to libreoffice-bugs]
-
148976:
Add option to autodetect URLs on CSV import
[NEW; assigned to libreoffice-bugs]
-
149076:
LibreOffice Calc: Support Excel hyperlinks not tied to cells (feature request)
[NEW; assigned to libreoffice-bugs]
-
149090:
Excel kind hyperlink as cell-property produces invalid ODF
[NEW; assigned to libreoffice-bugs]
-
149483:
Copy/Paste of partial cell contents string with hyperlink in recent versions, string with link appears _twice_
[NEW; assigned to libreoffice-bugs]
-
149523:
EDITING: Copy/Paste does not work in Calc with URL Recognition if it is part of a link
[NEW; assigned to libreoffice-bugs]
-
150453:
[EDITING] Select all in formula bar only selects partially for URLs
[NEW; assigned to libreoffice-bugs]
-
151933:
Feature request: Calc URL recognition if URL pasted or imported from a cvs file
[NEW; assigned to libreoffice-bugs]
-
156611:
Calc: able to insert multiple hyperlinks into cell, but they wont be saved
[ASSIGNED; assigned to attila.szucs]
-
156849:
can't overwrite auto-applied formatting of Calc hyperlinks (underline, font colour...)
[NEW; assigned to libreoffice-bugs]
-
157780:
Calc: Web hyperlinks not preserved after export to PDF when using Whole Sheet Export
[NEW; assigned to libreoffice-bugs]
-
160137:
Following hyperlink to calc spreadsheet results in lost row and column freeze
[NEW; assigned to libreoffice-bugs]
-
33951:
Calc: Comment text defined as hyperlink doesn't display on mouseover.
[VERIFIED WORKSFORME; assigned to libreoffice-bugs]
-
43338:
LibreOffice calc hangs when opening document with inaccessible URL(s)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
45435:
XSLX format breaks relative hyperlink path when document is moved (comment 9)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
54204:
Hyperlinks between documents not works if link contains anchor at the end
[RESOLVED FIXED; assigned to tundeth]
-
55342:
Select a cell content by default if a Hyperlink is inserted not from Edit mode
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
62561:
FORMATTING / UI: Add "Remove hyperlink" to (context) menu in Calc
[RESOLVED FIXED; assigned to samuel.mehrbrodt]
-
66545:
FORMATTING: Disabling grey field shading of hyperlinks in CALC
[RESOLVED FIXED; assigned to erack]
-
75889:
Hyperlinks in formula cells cannot be edited
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
77644:
Inserting a hyperlink on text typed in cell and selected with Ctrl+A leads to doubled text
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
80043:
EDITING: Insert hyperlink dialog wont use text in highlighted cell as hyperlink text
[RESOLVED FIXED; assigned to andreas.heinisch]
-
87459:
CONTEXT MENU: Addition of 'Edit Hyperlink' entry in cell edit mode
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
91634:
FILESAVE : XLSX Image hyperlink is not exported after roundtrip.
[VERIFIED FIXED; assigned to tundeth]
-
97805:
Hyperlinks fail after file save to .xlsx format
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
98123:
Auto hyperlink in cell cannot be undone and causes many editing issues
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
103480:
EDITING: Hyperlink deleted when merging cells (if not in the first cell)
[VERIFIED FIXED; assigned to czeber.laszloadam]
-
106553:
Hyperlink to filename containing spaces or other URL-encodable characters is mangled upon examination with End key, if name is longer than input field
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
106759:
Not all linked spreadsheets are shown in 'Edit Links...' dialog
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
109147:
FILESAVE XLSX: Replacing a hyperlink makes it invalid in Excel
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
112325:
FILESAVE XLSX Hyperlinks disappear randomly
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
113840:
[Spreadsheet FORMATTING] Can not remove auto-hyperlink when text within a cell is selected
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
114403:
deleting URL inconsistent (cell vs text input field)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
115192:
FILESAVE XLSX Hyperlinks do not work from shapes after saving the file as XLSX
[RESOLVED FIXED; assigned to tundeth]
-
115317:
EDITING: Unable to paste URL when editing a cell
[VERIFIED FIXED; assigned to paul.trojahn]
-
116329:
EDITING Hyperlink disappears from a cell in LibreOffice Calc
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
119677:
In Calc Function 'Follow Hyperlink' does not Work Correctly in Several Cases
[RESOLVED INVALID; assigned to libreoffice-bugs]
-
120373:
Hyperlink removal functionality "hidden" by default
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
(*)
-
120544:
UNO commands to modify hyperlinks missing in Calc
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
121012:
Ctrl-click to follow hyperlink is not displayed inside shape or text box
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
121034:
Mouse pointer turns to hand over hyperlink even without Ctrl being pressed, hence cell not selectable by mouse
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
121038:
When in cell edit mode, Ctrl-clicking a hyperlink in another cell does not work
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
121039:
Ctrl-clicking a hyperlink in shape or text box does not work while editing the said object
[RESOLVED FIXED; assigned to samuel.mehrbrodt]
-
124202:
No possible to connect to Internet sites from Calc (hyperlinks)
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
126393:
Hard to select a cell which contains only a hyperlink
[RESOLVED FIXED; assigned to samuel.mehrbrodt]
-
127340:
FORMATTING: Hyperlink should wrap in cell like normal text
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
127341:
FORMATTING: Right-click on a cell with hyperlink should show 'Format Cells...' command
[VERIFIED FIXED; assigned to Armin.Le.Grand]
-
129493:
Inserting of hyperlink into cell adds net address near text in cell instead adding a hyperlink to existing text in cell
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
131853:
Ctrl-clicking a hyperlink in a cell does not work while editing a shape or text box
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
135545:
following the hyperlink to the sheet with numbers only in its name will jump to the row with the numbers, not to the sheet.
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
136390:
Hyperlink to Sheetname that is Number links to Cell
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
140361:
Calc: Edit Hyperlink in context menu doesn't work if link isn't selected (GTK3)
[RESOLVED FIXED; assigned to caolan.mcnamara]
-
145671:
EDITING: Calc URL open twice in browser. Cell Edit mode.
[RESOLVED FIXED; assigned to samuel.mehrbrodt]
-
153880:
Make Calc text hyperlinks stand out more
[VERIFIED FIXED; assigned to balazs.varga991]
-
120564:
EDITING Add mean absolute deviation from median
[NEW; assigned to libreoffice-bugs]
-
120577:
SUM and other functions taking NumberSequence ignore Text type cells, indicator about not matching cell content could enhance user experience.
[NEW; assigned to libreoffice-bugs]
-
121396:
FORECAST.ETS.PI functions produces different results with identical data.
[NEW; assigned to libreoffice-bugs]
-
121488:
ERROR.TYPE for "Search out of range" in Excel return 7 but in Calc #N/D
[NEW; assigned to libreoffice-bugs]
-
122158:
DAY(), MONTH() and YEAR() functions don't handle Gregorian cut-over
[NEW; assigned to libreoffice-bugs]
-
124201:
Completion of double quotes for HYPERLINK functions.
[NEW; assigned to libreoffice-bugs]
(*)
-
124710:
IFS function erroneously propagates error results from functions within IFS (smallest reproducer in comment 6)
[NEW; assigned to libreoffice-bugs]
-
126159:
Arguments' names of AGGREGATE function can be simpler
[NEW; assigned to libreoffice-bugs]
-
127210:
DDE function breaks if Item/range parameter is from another cell
[NEW; assigned to libreoffice-bugs]
-
129129:
Add IMAGE Function to Calc
[NEW; assigned to libreoffice-bugs]
-
130536:
[FEATURE] Add Ability to Retrieve Financial Data (Stocks)
[NEW; assigned to libreoffice-bugs]
-
130968:
UI: Auto generate function GETPIVOTDATA when referencing a cell in pivot table
[NEW; assigned to libreoffice-bugs]
-
131526:
Random number generator Option no duplicates
[NEW; assigned to libreoffice-bugs]
-
131652:
chained MULTIPLE.OPERATIONS leaves effects of first set in the cell preceding "FormulaCell"
[NEW; assigned to libreoffice-bugs]
-
131932:
Using OFFSET function makes Calc open file with changes to save although not edited
[NEW; assigned to libreoffice-bugs]
-
132003:
No way to enable external content for a newly created spreadsheet
[NEW; assigned to libreoffice-bugs]
-
132106:
CELL() function "format" should include more date formats to return "D1" (or a new "D0")
[NEW; assigned to libreoffice-bugs]
-
132136:
Request for a new spreadsheet function SHEETNAME()
[NEW; assigned to libreoffice-bugs]
-
133243:
Formatting cause random generated letters to be regenerated
[NEW; assigned to libreoffice-bugs]
-
133295:
OFFSET.NV and INDIRECT.NV non-volatile functions in Calc
[NEW; assigned to libreoffice-bugs]
-
133389:
Date & time functions in StarBasic and Calc return different results
[NEW; assigned to libreoffice-bugs]
-
134367:
CALC new formulas: Written down value & written down depreciation
[NEW; assigned to libreoffice-bugs]
-
136268:
Math function not evaluated correctly
[NEW; assigned to libreoffice-bugs]
-
137884:
IMPORTHTML function is not supported
[NEW; assigned to libreoffice-bugs]
-
138070:
CELL function does not work as described.
[NEW; assigned to libreoffice-bugs]
-
138388:
Calc functions ODDFPRICE and ODDFYIELD do not appear to work correctly
[NEW; assigned to libreoffice-bugs]
-
139421:
Calc: calcuate weeknumber-year missing in 2021
[NEW; assigned to libreoffice-bugs]
-
140708:
The REGEX function accepts all (ismx) but one (w) flags and only directly in the regular expression and does not allow all matches to be found at once
[UNCONFIRMED; assigned to libreoffice-bugs]
-
140722:
calc: storing of rounded values and recalculation on load harming display after reload | was: calc: save-load-cycle: some cells shown with wrong value until recalc (F9)
[NEW; assigned to libreoffice-bugs]
-
140784:
The WEBSERVICE function doesn't work on macOS
[NEW; assigned to libreoffice-bugs]
-
143888:
enhancement: CALCULATION: implement a function 'rawsum', working without prettyfying as rawsubtract does
[UNCONFIRMED; assigned to libreoffice-bugs]
-
144238:
External content disabled for WEBSERVICE call
[UNCONFIRMED; assigned to libreoffice-bugs]
-
144276:
WEBSERVICE function to certain external URL results in #VALUE! error
[NEW; assigned to libreoffice-bugs]
-
144678:
Functions MONTHS and YEARS give wrong results for pre-1582-10-15 dates when used with last argument set to 1
[NEW; assigned to libreoffice-bugs]
-
144687:
ISLEAPYEAR gives FALSE for years displaying Feb 29th
[NEW; assigned to libreoffice-bugs]
-
145131:
Wrong operations MINUTE() function
[NEW; assigned to libreoffice-bugs]
-
145966:
[PIVOTTABLE] Add =GETPIVOTDATA(...) formula when referencing data inside a pivot table
[NEW; assigned to libreoffice-bugs]
-
146017:
HYPERLINK() entry dies once it attempts to link to #N/A result and undo is applied
[NEW; assigned to libreoffice-bugs]
-
146686:
LINEST with empty parameter for KnownX has different results in LibreOffice than in Excel
[UNCONFIRMED; assigned to libreoffice-bugs]
-
146811:
COUNTIF(...; "") does not count empty string formula results
[NEW; assigned to libreoffice-bugs]
-
147671:
Only works to Excel generated ActiveCell in the first open file, failed after save and reopen
[NEW; assigned to libreoffice-bugs]
-
148094:
Calc Hangs and uses ever increasing amount of memory with lots of MATCH(1, ("X"=range) * ("Y"=range), 0) EDITING/OPENING
[NEW; assigned to libreoffice-bugs]
-
150019:
ACCRINT result is wrong when basis is 1
[NEW; assigned to libreoffice-bugs]
-
150099:
HYPGEOM.DIST function is not working properly
[NEW; assigned to libreoffice-bugs]
-
150782:
[FILEOPEN] NUMBERS filter misinterpreting DURATION function
[NEW; assigned to libreoffice-bugs]
-
150900:
[META] Excel Functions
[NEW; assigned to libreoffice-bugs]
-
44817:
FILESAVE: when saving as XLS, add explicit warning when file cannot be correctly represented (limit of 30 arguments in functions)
[NEW; assigned to libreoffice-bugs]
-
89976:
FEATURE REQUEST:Add PHONETIC function
[NEW; assigned to libreoffice-bugs]
-
96923:
Criteria evaluation of COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS
[NEW; assigned to libreoffice-bugs]
-
106151:
Add a new CELL() function for Excel compatibility
[NEW; assigned to libreoffice-bugs]
-
126573:
Add array functions in Calc: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY
[ASSIGNED; assigned to balazs.varga991]
-
127624:
Add Excel-compliant version of COUNTIF
[NEW; assigned to libreoffice-bugs]
-
129129:
Add IMAGE Function to Calc
[NEW; assigned to libreoffice-bugs]
(*)
-
129361:
YIELD function in Calc provides different result than Excel, when there is one coupon period or less until redemption.
[NEW; assigned to libreoffice-bugs]
-
137465:
YIELD function in Calc provides wrong result (different result than Excel), when bond settlement date is within one coupon period until maturity.
[NEW; assigned to libreoffice-bugs]
-
137543:
Add a LET function into Calc
[NEW; assigned to thb]
-
138749:
Add function LAMBDA for interoperability with MS Excel
[NEW; assigned to libreoffice-bugs]
-
150864:
Add TEXTBEFORE function to Calc
[NEW; assigned to libreoffice-bugs]
-
150865:
Add TEXTAFTER function to Calc
[NEW; assigned to libreoffice-bugs]
-
150866:
Add TEXTSPLIT function to Calc
[NEW; assigned to libreoffice-bugs]
-
150867:
Add VSTACK function to Calc
[NEW; assigned to libreoffice-bugs]
-
150868:
Add HSTACK function to Calc
[NEW; assigned to libreoffice-bugs]
-
150878:
Add TOROW function to Calc
[NEW; assigned to libreoffice-bugs]
-
150879:
Add TOCOL function to Calc
[NEW; assigned to libreoffice-bugs]
-
150880:
Add WRAPROWS function to Calc
[NEW; assigned to libreoffice-bugs]
-
150881:
Add WRAPCOLS function to Calc for interoperability with MS Excel
[NEW; assigned to libreoffice-bugs]
-
150997:
Add TAKE function to Calc for interoperability with MS Excel
[NEW; assigned to libreoffice-bugs]
-
150998:
Add DROP function to Calc for interoperability with MS Excel
[NEW; assigned to libreoffice-bugs]
-
150999:
Add CHOOSEROWS function to Calc for interoperability with MS Excel
[NEW; assigned to libreoffice-bugs]
-
151000:
Add CHOOSECOLS function to Calc for interoperability with MS Excel
[NEW; assigned to libreoffice-bugs]
-
151001:
Add EXPAND function to Calc for interoperability with MS Excel
[NEW; assigned to libreoffice-bugs]
-
46918:
CONFIGURATION: MS Excel Function compatibility with LO Calc
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
58874:
OFFSET function in array context compatibility with Excel
[RESOLVED FIXED; assigned to erack]
-
69569:
Implementation of YEARFRAC function inconsistent with Excel
[RESOLVED FIXED; assigned to winfrieddonkers]
-
97831:
Please add new functions IFS, MAXIFS, MINIFS, SWITCH, CONCAT, TEXTJOIN (new in Excel 2016 Jan16)
[RESOLVED FIXED; assigned to winfrieddonkers]
-
109409:
TEXTJOIN and CONCAT handle array/matrix column-wise instead of row-wise
[VERIFIED FIXED; assigned to erack]
-
127293:
Add XLOOKUP function in Calc
[RESOLVED FIXED; assigned to balazs.varga991]
-
128425:
Add XMATCH function in Calc
[RESOLVED FIXED; assigned to balazs.varga991]
-
131536:
FILEOPEN XLSX TEXT formula gives different result than in Excel
[VERIFIED FIXED; assigned to erack]
-
155369:
Formula Calculation: Indirect() returns #REF!
[VERIFIED FIXED; assigned to dennisfrancis.in]
-
159467:
XLOOKUP does not work if embedded in another XLOOKUP
[RESOLVED FIXED; assigned to balazs.varga991]
-
160711:
XLOOKUP function in search for empty cell
[VERIFIED FIXED; assigned to balazs.varga991]
-
160725:
XLOOKUP has different result for approximate search than Excel
[RESOLVED FIXED; assigned to balazs.varga991]
-
151426:
Feature request: extend IFERROR/IFNA to other predicates
[UNCONFIRMED; assigned to libreoffice-bugs]
-
151851:
Sorting array formula works differently in Calc compared to Excel
[UNCONFIRMED; assigned to libreoffice-bugs]
-
152148:
Polish localisation issues for MAKS.K(dane; rząd_K) ≡ LARGE(…; …) and MIN.K() ≡ SMALL()
[NEW; assigned to libreoffice-bugs]
-
152292:
LARGE() and SMALL(): inconsistencies between app and Help pages
[UNCONFIRMED; assigned to libreoffice-bugs]
(*)
-
152943:
GetErrCode() doesn't work as expected on RISC-V due to floating-point NaN payload not being propagated
[ASSIGNED; assigned to libreoffice-bugs]
-
153208:
Regression Analysis Error: LINEST array #VALUE! errors on specific dependent variables
[NEW; assigned to libreoffice-bugs]
-
153539:
EDITING Some Calc functions get extra leading space character every time the formula is edited (same with save + reload)
[NEW; assigned to libreoffice-bugs]
-
154163:
Change "Degrees freedom" to "Degrees of freedom"
[NEW; assigned to libreoffice-bugs]
-
155424:
LISTIF function
[UNCONFIRMED; assigned to libreoffice-bugs]
-
155551:
Trim function making index/match or lookup functions calculate all spreadsheet rows instead of data interval
[NEW; assigned to libreoffice-bugs]
-
157396:
When choosing Italian language, REPLACE function is translated as SUBSTITUTE and vice versa
[NEW; assigned to libreoffice-bugs]
-
158247:
Allow F1 in Formula Bar inside formulas to work as in Function Wizard's Formula
[NEW; assigned to libreoffice-bugs]
-
158789:
Allow SUMIF and SUBTOTAL to apply to arrays
[NEEDINFO; assigned to libreoffice-bugs]
-
159082:
Calc INDIRECT() links faulty in folders other than ~/documents on FILEOPEN
[NEW; assigned to libreoffice-bugs]
-
159544:
Function COUNTIFS empty cells are counted up to the nearest filled one, EDITING
[NEW; assigned to libreoffice-bugs]
-
159764:
Implement AVERAGE.WEIGHTED Function in LibreOffice Calc
[UNCONFIRMED; assigned to libreoffice-bugs]
-
160893:
XLOOKUP problem with date as text
[UNCONFIRMED; assigned to libreoffice-bugs]
-
33689:
Date format problem using the Dutch (NL) localization
[CLOSED FIXED; assigned to jumbo4444]
-
35567:
LibreOffice Calc does not have a nice Linear Regression tool
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
44132:
FILESAVE XLSX XLS =ISEVEN() formula does not work when saving in .xls and .xlsx formats
[CLOSED WONTFIX; assigned to libreoffice-bugs]
-
47106:
References, Adapt row hight and AutoCalculate slow down Calc dramatically due to OFFSET() function
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
48552:
Slow to process "VLOOKUP" formula
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
50488:
[META] several functions defined in ODFF1.2 are not available in calc
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
51442:
N() does not work with position dependent range intersection
[RESOLVED FIXED; assigned to erack]
-
51478:
T() does not work in array context
[RESOLVED FIXED; assigned to erack]
-
54854:
calc add-in functions are not evaluated as expected
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
58585:
IRR / MIRR functions should accept an array argument
[VERIFIED FIXED; assigned to andreas.heinisch]
-
59712:
Function ISNUMBER() displays wrong answer when referencing a cell in another file
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
60183:
Feature request: Allow regular expressions in cell functions like SUBSTITUTE()
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
60244:
Unique random number generator function
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
60912:
WEEKNUM_ADD fails when second parameter is omitted
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
61228:
TABLE: Function summe() does not sum up but returns last item
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
66409:
failure to correctly implement CELL
[RESOLVED FIXED; assigned to erack]
-
68930:
bin2dec function limited
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
70551:
WEEKS() function uses ISO weeknum and is not locale-dependent, which is not explained in the Help
[RESOLVED FIXED; assigned to rafael.palma.lima]
-
71109:
NORMDIST() gives a percent result instead of a probability
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
73078:
Function TYPE() returns error, when parameter is a reference to an empty cell
[CLOSED FIXED; assigned to m.weghorn]
-
73081:
COUNTIF with criterium <>number does not count empty cells.
[VERIFIED FIXED; assigned to erack]
-
77517:
COLUMN, ROW functions with reference to external file result in Err:504
[RESOLVED FIXED; assigned to winfrieddonkers]
-
81128:
Unusual time handling in TEXT call
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
85551:
LO Calc and MS Excel treat invalid OFFSET height and width parameters differently
[RESOLVED FIXED; assigned to erack]
-
88611:
LENB & co. wrong value for Cyrillic text
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
90433:
HYPERLINK() function, if present but not evaluated, wrongly forces cell to pretend being linked.
[CLOSED WONTFIX; assigned to libreoffice-bugs]
-
91206:
[1] - Mathematical function - interpre.hxx - Extend enum ScIterFuncIf by ifMAXIF and ifMINIF similar to SUMIF
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
91502:
The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)
[RESOLVED FIXED; assigned to erack]
-
93445:
[l10n, Russian] All CDFs for discrete distributions should be marked “in Western tradition”
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
94309:
SUMIFS function gives Err:504 for external references
[RESOLVED DUPLICATE; assigned to gang65]
-
94925:
Calc Hyperlink Error when opening MS Excel
[VERIFIED FIXED; assigned to erack]
-
94962:
The RSQ function returning values greater than one.
[RESOLVED FIXED; assigned to andreas.heinisch]
-
96666:
EDITING: Address Function incorrectly resolves when Sheet names is given to #REF
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
96821:
ROUND changes integers when it should not
[RESOLVED FIXED; assigned to winfrieddonkers]
-
96897:
Function window always displayed
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
97198:
Calc: incorrect formula text function result from Unicode's non-BMP characters. Functions LEN(), LEFT(), RIGHT(), MID(), SEARCH(), FIND(), REPLACE()
[RESOLVED FIXED; assigned to winfrieddonkers]
-
97253:
Cell function lost when copying chart from Calc to Impress
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
97815:
switching to English function names does not work with Add-In functions
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
98443:
MINUTE() SECOND() result differ from OpenFormula
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
98844:
SUM function does not take into account precision as shown for ranges with numbers only (comment #7).
[VERIFIED FIXED; assigned to erack]
-
100070:
UKENR (Norwegian WEEKNUM function) gives wrong week numbers.
[RESOLVED FIXED; assigned to andreas.heinisch]
-
100652:
ODFF function name and Add-In function name are swapped.
[RESOLVED FIXED; assigned to erack]
-
100818:
add ability to refer to local names in another worksheet to INDIRECT
[VERIFIED FIXED; assigned to erack]
-
103230:
SUMIF resulted wrong with blank cell criteria for data range on linked files.
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
103550:
JIS function
[RESOLVED FIXED; assigned to winfrieddonkers]
-
104186:
FILESAVE: XLSX - Export fails to comply with ECMA-376 paragraph 18.17.2 concerning forbidden space characters between function name and left parenthesis
[RESOLVED FIXED; assigned to erack]
-
104899:
Data Analysis T test error in formula for standard error of the difference of sample means
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
105120:
RANK.EQ function compatibility with excel2016 online
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
105174:
IsLeapYear function gives erratic results.
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
107369:
Enhancement to Calc function SUBSTITUTE
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
107459:
MATCH with third parameter MatchType=-1 fails if the SearchVector is passed directly as the result of an array-formula.
[RESOLVED FIXED; assigned to erack]
-
107955:
Implement an interpolation function
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
112529:
Simple function not calculated
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
113595:
Of multiple STYLE() calls as arguments to IFS() and SWITCH() the first one (last evaluated) is applied.
[CLOSED DUPLICATE; assigned to libreoffice-bugs]
-
113977:
Implement REGEX.* function(s)
[RESOLVED FIXED; assigned to erack]
-
115440:
Add help text for Calc function ROUNDSIG
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
116514:
yield function doesn't accept ref as 1st arg
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
116706:
AGGREGATE COUNTA with hidden rows
[VERIFIED FIXED; assigned to winfrieddonkers]
-
117382:
DATUMVERSCHIL is not working, instead must use DATUMALS (DATEDIFF)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
117433:
COUNTIF() doesn't properly count empty cells for empty ("" or "=") criteria
[VERIFIED FIXED; assigned to winfrieddonkers]
-
117459:
CELL() function does not recalculate on non-cell-content-changing events
[CLOSED DUPLICATE; assigned to libreoffice-bugs]
-
118800:
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)
[RESOLVED FIXED; assigned to winfrieddonkers]
-
118973:
Calc, HLOOKUP function doesn't report correct value in column 20 of 20 columns
[CLOSED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
119033:
ADDRESS function >> result of calculation is displayed instead of #VALUE! error if "ABS" argument is value in range from 5 to 8
[CLOSED WONTFIX; assigned to libreoffice-bugs]
-
119034:
ADDRESS function >> R1C1 style is used instead of A1 style, if "A1" argument is floating-point number with zero integer
[RESOLVED FIXED; assigned to erack]
-
119057:
ADDRESS function >> syntax of formula is changed after saving, if "ABS" argument is empty (hand input)
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
119533:
calculation of MINUTE() wrong in LibreOffice 6.1
[VERIFIED FIXED; assigned to erack]
-
119999:
Request Calc Function: A vlookup/sumif type of function that will access the Libreoffice base table or query
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
120887:
PV function returns wrong answer
[CLOSED INVALID; assigned to libreoffice-bugs]
-
120895:
SUBTOTAL function, doesn't work inside SUMPRODUCT while it works inside an SUM array
[VERIFIED FIXED; assigned to erack]
-
121090:
Change name (description) of 4th argument to VLOOKUP and HLOOKUP to "Sorted range lookup" in help and in function wizard (see comment 7, comment 9)
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
121105:
the current() function is confused if used inside or()
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
121696:
[EDITING] Usage of "Inequality" criteria in function SUMIF creates wrong result
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
121977:
Function for reversing string order
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
121978:
Problem with new function SECOND
[VERIFIED FIXED; assigned to winfrieddonkers]
-
122098:
FILEOPEN XLSX, Function with logic answer gives back 1 or 0 in LO
[RESOLVED FIXED; assigned to jluth]
-
122301:
FREQUENCY: force array mode on arguments and immediate caller
[VERIFIED FIXED; assigned to erack]
-
123001:
A little improvement to CONCATENATE/CONCAT, please?
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
123168:
Trim function should also apply to non-break spaces (U+00A0)
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
123811:
HYPERLINK Function includes everything written in the cell
[CLOSED WONTFIX; assigned to libreoffice-bugs]
-
124135:
function to convert the numbers to Roman numerals
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
124231:
Day function for creating date is off by one
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
124286:
ROUNDDOWN is inaccurate with decimal numbers
[VERIFIED FIXED; assigned to winfrieddonkers]
-
124728:
Function CHOOSE doesn't allow to create matrix
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
124753:
Function =Randbetween(10;99) updates value in cell every time when I paste it into another cell
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
125272:
CALC doesn’t detect an invalid entry for references in AGGREGATE and SUBTOTAL functions
[CLOSED WONTFIX; assigned to winfrieddonkers]
-
125365:
XIRR function doesn't work with concatenated ranges (using ~)
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
126228:
calc crashes if "SUMIFS" is used in formular
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
127359:
Match formula changes, when cells it looks to are cut and pasted.
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
127498:
TIMEVALUE() sometimes returns a slightly less or greater than expected value
[VERIFIED FIXED; assigned to erack]
-
127587:
hlookup and match fail for values outside defined range if range contains empty columns
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
128800:
INDEX function insufficiently documented (see comment 8)
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
129023:
FIND will match apostrophe in string constant but not cell reference
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
129464:
Formula() don't work with references to other documents
[CLOSED WONTFIX; assigned to libreoffice-bugs]
-
129681:
AGGREGATE doesn't ignore DIV/0 errors when using the options supplied, while using dynamically generated rows
[RESOLVED FIXED; assigned to erack]
-
130333:
LibreOffice Calc: Invalid reference result from INDIRECT() function when trying to reference a cell in another sheet
[CLOSED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
130823:
LibreOffice CALC TBILLYIELD function returns incorrect interest rate (Too low).
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
131516:
Use of WEBSERVICE function raises an "Illegal argument" exception
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
132105:
COUNTBLANK function fails with external references
[VERIFIED FIXED; assigned to erack]
-
132431:
Crash: "vector::_M_fill_insert" with large sumifs
[VERIFIED FIXED; assigned to dennisfrancis.in]
-
133260:
Inline arrays and functions returning array/matrix should propagate array mode to calling functions.
[VERIFIED FIXED; assigned to erack]
-
133286:
non correct working function MOD ("ОСТАТ" in Russian)
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
133353:
Function wizard for DCOUNT and DCOUNTA tells second parameter is required, but it is optional
[RESOLVED FIXED; assigned to winfrieddonkers]
-
133840:
Calc Math error on INTEGER function
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
135020:
LOWER(), UPPER(), PROPER() functions does not work correctly on Turkish character capital 'i' (İ)
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
135467:
EDITTING FUNCTIONS RANDBETWEEN.NV
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
135551:
=min() intolerance to text in fields
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
135718:
LOOKUP function stopped working
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
136209:
MINVERSE() returns err502
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
136794:
calc: ui: round: calc 'round' is erroneously limited to 20 decimal digits,
[VERIFIED FIXED; assigned to erack]
-
136848:
formula performs unpredictable behavior
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
137541:
External links in Calc via INDIRECT() always require an update to show values on file open
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
138313:
MONTHS() function gives the wrong result
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
138393:
Calc automatically evaluates arguments of if() function
[CLOSED INVALID; assigned to libreoffice-bugs]
-
139173:
Incorrect bounds on formula DEC2HEX
[VERIFIED FIXED; assigned to erack]
-
139540:
Function HYPERLINK used in formula creates hyperlink independent from conditional evaluation
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
140891:
Function MONTH does not properly display the correct information
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
141022:
Calc Financial Functions Should Not Require Negative Values
[CLOSED INVALID; assigned to libreoffice-bugs]
-
141042:
Feature request: add a new function REVERSE(string)
[RESOLVED INVALID; assigned to libreoffice-bugs]
-
141495:
CONFIGURATION = EOMONTH function corruption
[CLOSED DUPLICATE; assigned to libreoffice-bugs]
-
141590:
Crash if i insert values in the function FORECAST.ETS.PI.ADD
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
141609:
LibreCalc IF function incorrectly evaluates negative numbers
[CLOSED WONTFIX; assigned to libreoffice-bugs]
-
142293:
Spreadsheet functions implemented as AddIn may get saved with their programmatic name to OOXML Excel .xlsx instead of the function name (cause in comment 21)
[RESOLVED FIXED; assigned to erack]
-
142905:
LEFT() and empty space at the beginning in .xlsx
[RESOLVED FIXED; assigned to czeber.laszloadam]
-
144156:
Slight inaccuracy / deviation in SKEW() with uniform integer sequences for Calc pre-7.2
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
144159:
COUNTIFS() function performance regression
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
144692:
YEAR() / MONTH() / DAY() give results inconsistent with entered/displayed dates
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
145578:
The WEEKS() function gives an incorrect answer around January 4th
[RESOLVED FIXED; assigned to winfrieddonkers]
-
145587:
WEEKS spreadsheet add-in function needs optimizations
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
146167:
=INDEX returns unknown numbers when a column with date formatted data is in the cells.
[CLOSED WORKSFORME; assigned to libreoffice-bugs]
-
146377:
Error doesn't propagate as first parameter in IF when "IfFalse" contains ISERROR or IFERROR
[VERIFIED FIXED; assigned to erack]
-
146599:
XIRR produces incorrect value
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
146778:
Function wizard for DATAD.SE in pt-PT translates arguments incorrectly
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
148843:
AGGREGATE miscalculates a series of single referenced cells if error cells are involved
[VERIFIED FIXED; assigned to erack]
-
148863:
If a matrix created by RANDBETWEEN.NV function is transposed, it will not be random number.
[RESOLVED FIXED; assigned to erack]
-
150011:
Add Croatian Kuna to Euroconvert function
[VERIFIED FIXED; assigned to erack]
-
150648:
EAN13 function works in spreadsheet with LibreOffice 7.3 not 7.4
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
152014:
Wrong result with match function when multiple spreadsheets are opened
[VERIFIED FIXED; assigned to erack]
-
152774:
MATCH and HLOOKUP/VLOOKUP return incorrect result when searching for a string in a mixed numeric/string matrix
[RESOLVED FIXED; assigned to winfrieddonkers]
-
153297:
A complex formula does not work in Calc 7.4.x; (MATCH function)
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
155402:
FILEOPEN XLSX CELL() function gives different value compared to Excel with filename parameter
[RESOLVED FIXED; assigned to balazs.varga991]
-
155805:
Support for string concatenation with separator
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
157948:
Offset function using negative numbers for height or width works in Microsoft Excel, not in Calc
[RESOLVED NOTOURBUG; assigned to libreoffice-bugs]
-
159467:
XLOOKUP does not work if embedded in another XLOOKUP
[RESOLVED FIXED; assigned to balazs.varga991]
(*)
-
160616:
SUMPRODUCT calculation is broken in some cases, if the ranges are beyond the last cell with data
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
160753:
XMATCH function in search for empty cell is different to Excel
[RESOLVED FIXED; assigned to balazs.varga991]
view as bug list