| Max Depth: |
Bug 108827 depends on 216 open 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]
-
41902:
Can't block select a range of cells in the function wizard using the keyboard.
[NEW; assigned to libreoffice-bugs]
-
52928:
[UI] Give complex number functions its own category
[NEW; assigned to libreoffice-bugs]
-
70513:
EDITING: Function Wizard locks other open spreadsheets
[NEW; assigned to libreoffice-bugs]
-
71102:
UI: Category location of AREAS function
[NEW; assigned to libreoffice-bugs]
-
71225:
EDITING: AREAS function input error.
[NEW; assigned to libreoffice-bugs]
-
94278:
[UI HELP] the second time request the help on the function from the function wizard does not work
[NEW; assigned to libreoffice-bugs]
-
109254:
Allow toggling of absolute and relative references when working with Function Wizard
[NEW; assigned to libreoffice-bugs]
-
114827:
FILESAVE of Letter Wizard is complaining about existing file if you cancel saving
[NEW; assigned to libreoffice-bugs]
-
124201:
Completion of double quotes for HYPERLINK functions.
[NEW; assigned to libreoffice-bugs]
-
132065:
Ease formula editing using multiline-block editing
[NEW; assigned to libreoffice-bugs]
-
136558:
Function Wizard Structure tree should correspond to interactions with formula
[NEW; assigned to libreoffice-bugs]
-
142341:
F4 shortcut for switching between relative and absolute cell references doesn't work in range pickers
[NEW; assigned to libreoffice-bugs]
-
144536:
Calc 'Function Wizard' provide alternative-linked non-localized version of the Function name
[NEW; assigned to libreoffice-bugs]
-
146623:
Enhance Function Wizard Structure Tab for Better Formula Debugging
[NEW; assigned to libreoffice-bugs]
-
155316:
Function Wizard should remember the Category field selection from its prior use, at least per session (RFE)
[UNCONFIRMED; assigned to libreoffice-bugs]
-
158301:
Calc Function Wizard: Make searching in descriptions optional, not forced
[ASSIGNED; assigned to ahmedhamed3699]
-
160835:
Unclear meaning of "a basic total population"
[NEW; assigned to libreoffice-bugs]
-
41902:
Can't block select a range of cells in the function wizard using the keyboard.
[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]
-
105414:
Blank cells formatted as numbers not treated as ZERO when pulled via VLOOKUP to external file
[NEW; assigned to libreoffice-bugs]
-
109254:
Allow toggling of absolute and relative references when working with Function Wizard
[NEW; assigned to libreoffice-bugs]
(*)
-
131944:
FORMATTING Wrap text automatically not working when value inserted using vlookup() function
[NEW; assigned to libreoffice-bugs]
-
140365:
VLOOKUP slow on accessing search matrix in other files
[NEW; assigned to libreoffice-bugs]
-
105414:
Blank cells formatted as numbers not treated as ZERO when pulled via VLOOKUP to external file
[NEW; assigned to libreoffice-bugs]
-
109330:
[META] Subtotal function bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
55870:
When copying filtered table, which contains subtotals, from calc and pasting as GDI Metafile into writer, wrong values are pasted.
[NEW; assigned to libreoffice-bugs]
-
61634:
Calc: Strange data subtotals auto range selection issue
[NEW; assigned to libreoffice-bugs]
-
88793:
EDITING, subtotals don't apply formatting
[NEW; assigned to libreoffice-bugs]
-
88794:
EDITING, editing subtotal function options adds columns group
[NEW; assigned to libreoffice-bugs]
-
118678:
Subtotals results moved left when saving in ODS format (steps in comment 12)
[NEW; assigned to libreoffice-bugs]
-
120457:
Support subtotal drop-down formula menu in Calc
[NEW; assigned to libreoffice-bugs]
-
140322:
Calc subtotals: can't only show the last line (grand sum)
[NEW; assigned to libreoffice-bugs]
-
55870:
When copying filtered table, which contains subtotals, from calc and pasting as GDI Metafile into writer, wrong values are pasted.
[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]
-
35392:
FILESAVE: Hyperlinks in form field buttons lost in .xls
[NEW; assigned to libreoffice-bugs]
-
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]
-
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]
-
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]
-
40975:
Add "differentiation" function to Calc
[NEW; assigned to libreoffice-bugs]
Bug 108827 blocks 2 open bugs:
view as bug list| Max Depth: |