120005
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
Feature request: Allow VolatileResult to be different for subsequent function calls with same arguments. (XVolatileResult)
|
2012-06-17
|
96196
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Crash when date field box replaced by combo box
|
2013-01-29
|
103826
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Utilization of cubic spline function
|
2013-01-29
|
85646
|
Calc
|
programm
|
issues
|
CONF
|
---
|
not correct result when macro write the single value to cell and after read the one
|
2013-01-29
|
87353
|
Calc
|
programm
|
issues
|
CONF
|
---
|
RANK sometimes gives a rank to text
|
2013-01-29
|
107680
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Numeric field alignment flags are ineffective
|
2013-01-29
|
101942
|
Calc
|
programm
|
issues
|
CONF
|
---
|
save and open file too slow
|
2013-01-29
|
101735
|
Calc
|
programm
|
issues
|
CONF
|
---
|
OOo 3.1.0 Calc (Stable) Error Copying Custom Styles Between Templates
|
2013-01-29
|
117220
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Columns and Rows functions on external referenced ranges return wrong values
|
2013-01-29
|
115799
|
Calc
|
programm
|
issues
|
CONF
|
---
|
BASE(): support two's complement negative binary numbers (like DEC2BIN and HEX2BIN)
|
2013-01-29
|
106958
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Build GRG Method into solver
|
2013-01-29
|
92042
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Provide Non-parametric Correlation Functions
|
2013-01-29
|
94968
|
Calc
|
programm
|
issues
|
CONF
|
---
|
oo3 calc: MOD(3^36;15) = 640
|
2013-01-29
|
100971
|
Calc
|
programm
|
issues
|
CONF
|
---
|
header/footer CJK font name inconsistent with global settings
|
2013-01-29
|
114061
|
Calc
|
programm
|
issues
|
CONF
|
---
|
If Date in Functions DAYSINNONTH、DAYSINYEAR、ISLEAPYEAR、WEEKSINYEAR are more than 8, hangs OOo
|
2013-01-29
|
96201
|
Calc
|
programm
|
issues
|
CONF
|
---
|
ip2long() builtin ip address conversion function
|
2013-02-07
|
89192
|
Calc
|
programm
|
issues
|
CONF
|
---
|
formula evaluation
|
2013-02-07
|
94205
|
Calc
|
programm
|
issues
|
CONF
|
---
|
MATCH function doesn't work on DDE link on a date with special format using minus character
|
2013-05-10
|
95537
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Excel sheet with many macros stops OOCalc
|
2013-05-23
|
111319
|
Calc
|
programm
|
issues
|
CONF
|
---
|
pasting cell name reference produces #name error
|
2013-06-13
|
118405
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Performance (speed) of opening of file
|
2013-07-05
|
111471
|
Calc
|
programm
|
issues
|
CONF
|
---
|
calc, record macro, cells with function written manually not recorded
|
2013-07-29
|
71455
|
Calc
|
programm
|
issues
|
CONF
|
---
|
How to handle OOo -> xls -> OOo for incompatible functions (eg INDIRECT/INDIRECT_XL)
|
2013-07-30
|
39278
|
Calc
|
programm
|
issues
|
CONF
|
---
|
after freezing a calc sheet via a form control, horizontal scroll hides sheet tabs.
|
2013-08-07
|
42247
|
Calc
|
programm
|
issues
|
CONF
|
---
|
an unchanging date stamp, time stamp, filename stamp, path stamp are all needed by the world
|
2013-08-07
|
50263
|
Calc
|
programm
|
issues
|
CONF
|
---
|
setDataArray on large arrays completely locks OOo and windows
|
2013-08-07
|
55141
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Auto Filter list option don't contain all the values
|
2013-08-07
|
56400
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Macro recorder For Inserting New Sheet Doesn't Work Always
|
2013-08-07
|
62694
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Across sheet parameter to custom function
|
2013-08-07
|
65574
|
Calc
|
programm
|
issues
|
CONF
|
---
|
New Function: sheet number -> sheet name
|
2013-08-07
|
68515
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Calc - Subtotals can't be automated with the macro
|
2013-08-07
|
79571
|
Calc
|
programm
|
issues
|
CONF
|
---
|
link to range in external workbook containing reference does not evaluate
|
2013-08-07
|
75642
|
Calc
|
programm
|
issues
|
CONF
|
---
|
better python integration
|
2013-08-07
|
72590
|
Calc
|
programm
|
issues
|
ACCE
|
---
|
ISEVEN_ADD, ISODD_ADD functions incorrect
|
2013-08-07
|
97407
|
Calc
|
programm
|
issues
|
CONF
|
---
|
IDL states long for property FormulaResultType
|
2013-08-07
|
74069
|
Calc
|
programm
|
issues
|
ACCE
|
---
|
ODFF: YEARFRAC with basis=1 actual/actual calculation slightly incorrect
|
2013-08-07
|
97520
|
Calc
|
programm
|
issues
|
ACCE
|
---
|
API for sheet protection password & options
|
2013-08-07
|
118343
|
Calc
|
programm
|
issues
|
CONF
|
---
|
word HIGH appearing in text string causes logic error
|
2013-08-07
|
104531
|
Calc
|
programm
|
issues
|
CONF
|
---
|
File, Print, Options, Quality
|
2013-08-13
|
116178
|
Calc
|
programm
|
issues
|
CONF
|
---
|
SUMIF Bug when Comparing Against "" (For Blank Cells)
|
2013-08-22
|
107184
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Cellrange.Filter incorrect for values 66 and 67
|
2013-08-30
|
123056
|
Calc
|
programm
|
issues
|
CONF
|
---
|
After/during execution of particular Basic macros, hyperlinks to cells will not work
|
2013-10-08
|
101654
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Sort options
|
2013-10-29
|
123700
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Calc does not have the function AGGREGATE (function Excel2010)
|
2013-11-17
|
117463
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Enable backward search in functions (MATCH, LOOKUP, VLOOKUP ...)
|
2013-11-18
|
111762
|
Calc
|
programm
|
issues
|
CONF
|
---
|
getCellRangeByName("Name1:Name2") causes exception
|
2013-11-26
|
104755
|
Calc
|
programm
|
issues
|
CONF
|
---
|
VBA: Missing WScript support
|
2013-12-03
|
94089
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Find and Replace Functionality
|
2013-12-13
|
116395
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Opening spreadsheet produces "BASIC runtime error 423 OperatingSystem"
|
2013-12-13
|
89046
|
Calc
|
programm
|
issues
|
CONF
|
---
|
conditional cell layout
|
2013-12-24
|
120414
|
Calc
|
programm
|
issues
|
CONF
|
---
|
can't run VBA macros from command line
|
2013-12-26
|
118026
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Option for RANK function to issue sequential numbers on duplicates
|
2013-12-26
|
108991
|
Calc
|
programm
|
issues
|
CONF
|
---
|
COUNTIF gives inconsistent counts of empty arrays
|
2013-12-29
|
64605
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Creating a "transposed" summary list
|
2014-01-02
|
120004
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
Feature request: Allow identification of calling cell in (Java) UNO add-in (like Application.Caller in Excel/VBA).
|
2014-01-09
|
103580
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Add Sensitivity Analysis to Linear Solver
|
2014-01-12
|
93534
|
Calc
|
programm
|
issues
|
CONF
|
---
|
ODFF: PRICEDISC et al.: Basis 0 NASD implementation
|
2014-01-13
|
104102
|
Calc
|
programm
|
issues
|
CONF
|
---
|
increased flexibility of ADDRESS function
|
2014-01-15
|
124115
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Solver does not identify a linear model as infeasible
|
2014-01-31
|
93527
|
Calc
|
programm
|
issues
|
CONF
|
---
|
ODFF: INTRATE and RECEIVED functions different to Excel
|
2014-01-31
|
121904
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Esc key does not abort XRangeSelectionListener
|
2014-02-07
|
110678
|
Calc
|
programm
|
issues
|
CONF
|
---
|
circular reference iteration stop before convergence
|
2014-02-18
|
117393
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Implement regular expressions on arrays.
|
2014-03-07
|
91651
|
Calc
|
programm
|
issues
|
CONF
|
---
|
VDB function: Calc and Excel produce different results; both wrong
|
2014-03-25
|
117633
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
ChartDataChangeEvent object does not provide Row and Column information
|
2014-04-01
|
118031
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Allow to declare a Constant dependent of a Public Constant declared in another module.
|
2014-04-05
|
124723
|
Calc
|
programm
|
issues
|
CONF
|
---
|
calc macro using goal seek doesn't work
|
2014-04-23
|
113709
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Hyperlink Context Menu
|
2014-05-21
|
124964
|
Calc
|
programm
|
issues
|
CONF
|
---
|
RATE function blows up
|
2014-05-23
|
88491
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
optional string parameter default value is "0" and ismissing not working
|
2014-07-24
|
125306
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Sorting not stable from Basic macro
|
2014-07-26
|
125441
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
validity options enhancement : formula,Text only
|
2014-08-15
|
125647
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
JNI exception occurred
|
2014-09-20
|
71059
|
Calc
|
programm
|
issues
|
CONF
|
---
|
ODFF: Add optional workdays/weekend parameter to NETWORKDAYS and WORKDAY
|
2014-10-28
|
126255
|
Calc
|
programm
|
issues
|
CONF
|
---
|
DDE does not trigger XModifyListener
|
2015-04-29
|
112771
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Open Office RTD development
|
2015-07-16
|
126440
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
Editing of Formula TRANSPOSE impossible
|
2015-08-04
|
111519
|
Calc
|
programm
|
issues
|
CONF
|
---
|
ODFF: BINARY MATH
|
2015-11-22
|
110857
|
Calc
|
programm
|
issues
|
REOP
|
---
|
unexpected differences in application char vs basic chr functions
|
2015-12-18
|
126951
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
Subtotal function fails to respond to filter settings
|
2016-05-08
|
127050
|
Calc
|
programm
|
issues
|
CONF
|
---
|
I use API to generate a .ods file with chart, but the "LineDash" propert setting doesn't work
|
2016-07-28
|
127115
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
Solver gives non-optimal solution
|
2016-09-15
|
117389
|
Calc
|
programm
|
issues
|
CONF
|
---
|
OFFSET of external reference doesn't work with expressions as arguments for rows, columns, height, width.
|
2017-05-20
|
114992
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Calc inserts a wrong, warped formula
|
2017-05-20
|
98149
|
Calc
|
programm
|
issues
|
CONF
|
---
|
[F-NAME] Old addin "astroadd.dll" will not work correctly since 3.0
|
2017-05-20
|
71000
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Functions are never case-sensitive, wording of application setting is misleading
|
2017-05-20
|
104241
|
Calc
|
programm
|
issues
|
CONF
|
---
|
ODFF: LOOKUP, MATCH, VLOOKUP, HLOOKUP in a range lookup should not find last numeric value if queried for string
|
2017-05-20
|
87268
|
Calc
|
programm
|
issues
|
CONF
|
---
|
labels doesn't work in array formulas
|
2017-05-20
|
74705
|
Calc
|
programm
|
issues
|
CONF
|
---
|
API: crash when default cell style is removed
|
2017-05-20
|
80873
|
Calc
|
programm
|
issues
|
CONF
|
---
|
preview shows interblended fields in header/footer
|
2017-05-20
|
90060
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Wrong result of nested IF() functions in array context.
|
2017-05-20
|
93915
|
Calc
|
programm
|
issues
|
CONF
|
---
|
ISFORMULA fails in array-context and SUMPRODUCT
|
2017-05-20
|
97733
|
Calc
|
programm
|
issues
|
CONF
|
---
|
errors counted as 0 by countif(...,"=0)
|
2017-05-20
|
88967
|
Calc
|
programm
|
issues
|
CONF
|
---
|
ODFF: PROB, FORECAST functions: scalar parameter evaluated as array
|
2017-05-20
|
67135
|
Calc
|
programm
|
issues
|
ACCE
|
---
|
Array calculation with volatile subexpression paths
|
2017-05-20
|
87219
|
Calc
|
programm
|
issues
|
CONF
|
---
|
ISLOGICAL fails in array formula
|
2017-05-20
|
109140
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Adding named range with operators (':', '+', ...) in name is possible using the API
|
2017-05-20
|
32345
|
Calc
|
programm
|
issues
|
REOP
|
---
|
ODFF: Make LARGE() and SMALL() return an array if the second parameter is an array.
|
2017-05-20
|
108232
|
Calc
|
programm
|
issues
|
CONF
|
---
|
ODFF: FREQUENCY with no data should return zero for all bins
|
2017-05-20
|
86283
|
Calc
|
programm
|
issues
|
CONF
|
---
|
DELTA/GESTEP functions with non-numeric args are inconsistent
|
2017-05-20
|
71610
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Argument type sequence<sequence<string>> in add-ins doesn't work with formula results
|
2017-05-20
|
82330
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Column and row label bugs
|
2017-05-20
|
58802
|
Calc
|
programm
|
issues
|
CONF
|
---
|
DDE in OOo 2.0 doesn't open the another spreadsheet. Reading "big" arrays by formula DDE in OOo 2.0 takes a long time.
|
2017-05-20
|
89546
|
Calc
|
programm
|
issues
|
CONF
|
---
|
=MAX(0,+range) should import as =MAX(0;0+range)
|
2017-05-20
|
102957
|
Calc
|
programm
|
issues
|
CONF
|
---
|
ODFF: FLOOR and CEILING should work with a single argument.
|
2017-05-20
|
104714
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Remove undocumented AND and OR infix operators
|
2017-05-20
|
50384
|
Calc
|
programm
|
issues
|
CONF
|
---
|
API: XPropertySet of SpreadsheetDocument does not throw Exception
|
2017-05-20
|
57839
|
Calc
|
programm
|
issues
|
ACCE
|
---
|
Value of the function is out of scope.
|
2017-05-20
|
76098
|
Calc
|
programm
|
issues
|
CONF
|
---
|
FileName text field does not handle FileFormat property correctly in header / footer
|
2017-05-20
|
112638
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Matrix expressions of scalar arguments are not initialized properly
|
2017-05-20
|
115075
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Funktion N() does not handle matrix
|
2017-05-20
|
88245
|
Calc
|
programm
|
issues
|
CONF
|
---
|
The old window will show current function information in tip help!
|
2017-05-20
|
101386
|
Calc
|
programm
|
issues
|
CONF
|
---
|
[F-NAME] addin function doesn't work in OOo3.0 after document is closed and reopened
|
2017-05-20
|
115577
|
Calc
|
programm
|
issues
|
CONF
|
---
|
[non-pro] XMLShapeExport, exception caught
|
2017-05-20
|
125286
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
Unintentionally Copy&Paste on all sheets
|
2017-05-20
|
118942
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Can't read more than 6 Columns
|
2017-05-20
|
125076
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
Unexpected localization of boolean values
|
2017-05-20
|
127442
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
Wrong time-frame calculation
|
2017-06-14
|
127479
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
MATCH function error when sheets are re-ordered and indirect addressing is used
|
2017-07-17
|
127898
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
Array reference indirected to a nonexistent sheet is silently redirected to first sheet.
|
2018-09-19
|
128278
|
Calc
|
programm
|
issues
|
REOP
|
---
|
sorting a calc table by a custom sort rule
|
2020-02-09
|
128309
|
Calc
|
programm
|
issues
|
CONF
|
---
|
FIXED formula bug
|
2020-03-03
|
103883
|
Calc
|
programm
|
issues
|
CONF
|
---
|
ODF 1.2 type of stored errors is wrong
|
2020-11-15
|
127829
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
"define range" makes some cells look empty
|
2021-01-24
|
79864
|
Calc
|
programm
|
issues
|
CONF
|
---
|
COUNTBLANK won't handle discontinuous or external ranges
|
2021-06-01
|
128494
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Match function error when sheets are re-ordered
|
2023-04-28
|
61802
|
Calc
|
programm
|
issues
|
CONF
|
---
|
Bad behaviour deleting a worksheet with Modify Event attached
|
2023-05-11
|
128577
|
Calc
|
programm
|
issues
|
UNCO
|
---
|
Sorting tables misplaces/loses/mixes data in large files 1Mb+ sheets 2000 lines x 30 columns
|
2023-10-03
|
92677
|
Calc
|
programm
|
issues
|
CONF
|
---
|
ODFF: implement IFERROR and IFNA
|
2024-01-26
|
49467
|
Calc
|
programm
|
issues
|
CONF
|
---
|
function datedif() is missing
|
2024-02-06
|
105140
|
Calc
|
programm
|
issues
|
CONF
|
---
|
12 new functions in excel 2007 not found in calc
|
2024-02-18
|