Bug 108253
depends on
195
bugs:
view as bug list
-
108253:
[META] Calc cell formula bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
38304:
EDITING : Calc doesn't highlight referenced cells when creating a formula or when adding a reference to an existing formula
[NEW; assigned to libreoffice-bugs]
-
40626:
Err:522 when chaining multiple.operations
[NEW; assigned to libreoffice-bugs]
-
41915:
named cells not highlighted when editing formulae
[NEW; assigned to libreoffice-bugs]
-
42496:
Calc EDITING: improve functionality when Formula gets in a way while editing and prevents selection of the adjacent cell.
[NEW; assigned to libreoffice-bugs]
-
46094:
enhanced Math-Calc integration
[NEW; assigned to libreoffice-bugs]
-
54022:
Iteration Default Minimum (0.001) Causes Error 523
[NEW; assigned to libreoffice-bugs]
-
54311:
Calc EDITING: add auto-adjusting of formulas during deleting of row
[NEW; assigned to libreoffice-bugs]
-
55737:
Names of cells when clicking on it
[NEW; assigned to libreoffice-bugs]
-
57210:
: Feature Request:: Better interpretation of formulas including numbers containing commas.
[NEW; assigned to libreoffice-bugs]
-
58947:
The color of the cell text in formula can be same as background
[NEW; assigned to libreoffice-bugs]
-
60164:
Copying range of cells from Lotus 1-2-3 to Calc loses formulas
[NEW; assigned to libreoffice-bugs]
-
62767:
EDITING: mouse over a formula - box
[NEW; assigned to libreoffice-bugs]
-
63091:
applying formula to a cell range
[NEW; assigned to libreoffice-bugs]
-
69479:
Formula is getting corrupted after input with certain UI languages or locales
[NEW; assigned to libreoffice-bugs]
-
75904:
References get updated differently whether it's copied or cut within the same columns
[NEW; assigned to libreoffice-bugs]
-
79735:
VIEWING: new request: highlighted cells referenced by names in editing formula
[NEW; assigned to libreoffice-bugs]
-
79812:
When enable "Freeze Window", sheet do not scroll when selecting cell range crossing the freeze border
[NEW; assigned to libreoffice-bugs]
-
80265:
Request: Calc should accept and auto-correct full-width brackets "()" to half-width "()"
[NEW; assigned to libreoffice-bugs]
-
80347:
Enhancement request: change Arguments and Outputs to English when Formulas are set to English names
[REOPENED; assigned to libreoffice-bugs]
-
81913:
Navigating with arrow keys disables cell highlighting (in text and in spreadsheet)
[NEW; assigned to libreoffice-bugs]
-
85318:
Cronbach's alpha
[NEW; assigned to libreoffice-bugs]
-
87212:
Enhancement: realtime formula highlighting
[NEW; assigned to libreoffice-bugs]
-
87739:
FILEOPEN : XLSX - formulas linked to other sheets are not refreshed when opening file (hard recalc needed)
[NEW; assigned to libreoffice-bugs]
-
88436:
CALC: R1C1 formula broken by worksheets names started by number
[NEW; assigned to libreoffice-bugs]
-
89207:
Cannot change only part of an array
[NEW; assigned to libreoffice-bugs]
-
92075:
FORMATTING: When using =cell in a cell the number formatting becomes set but shows wrong
[NEW; assigned to libreoffice-bugs]
-
92543:
add ability to use non-native formulas (such as using English formulas in Italian locale)
[NEW; assigned to libreoffice-bugs]
-
92628:
EDITING: Double click in formula sometimes gets wrong word boundaries
[NEW; assigned to libreoffice-bugs]
-
93123:
VIEWING: Split/frozen sheet not redrawn properly when formula with manual range selection causes page to scroll
[NEW; assigned to libreoffice-bugs]
-
93202:
When merging cells formula is lost
[NEW; assigned to libreoffice-bugs]
-
94220:
UI: Formula bar and cell edit show line break after hyphen
[NEW; assigned to libreoffice-bugs]
-
96756:
JAHRE (german) - YEARS (engl.): Err:502 with date 01.01.0001, works with 02.01.0001
[NEW; assigned to libreoffice-bugs]
-
96981:
All cells selector button not functional when in formula mode
[NEW; assigned to libreoffice-bugs]
-
98221:
EDITING Formula gets cut down after entering
[NEW; assigned to libreoffice-bugs]
-
98320:
EDITING: Colored frames of adjoined cells are hard to distinguish
[NEW; assigned to libreoffice-bugs]
-
99956:
In formulas with circular references are not always showed the Error 522 with all calc functions. (Deactivated Iterations option)
[NEW; assigned to libreoffice-bugs]
-
101238:
MULTIPLE.OPERATIONS fails with Err:522 - not a duplicate of 40626
[NEW; assigned to libreoffice-bugs]
-
104559:
UI When editing a formula cell, the formula hides referenced cells
[NEW; assigned to libreoffice-bugs]
-
109178:
[META] Named Cell Ranges and Formula Expressions bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
111508:
Text to number conversion on concatenation with direct references ends with number as text
[NEW; assigned to libreoffice-bugs]
-
111920:
Cells no automatically recalculated when formula is dependent of language and this is changed
[NEW; assigned to libreoffice-bugs]
-
114559:
Wrong cell contents when embedding Calc spreadsheet containing array formulas into Writer document
[NEW; assigned to libreoffice-bugs]
-
114929:
Make =-3^2 unambiguous by automatically adding brackets
[NEW; assigned to libreoffice-bugs]
-
116145:
Inserting columns using selected (grouped) sheets causes calculation error.
[NEW; assigned to libreoffice-bugs]
-
118177:
Truncating 8*27/27 equals 7 on FILEOPEN if a cell is formatted other than General
[NEW; assigned to libreoffice-bugs]
-
118843:
calc incorrectly handles cells with a REF error
[NEW; assigned to libreoffice-bugs]
-
121398:
Powers of negative numbers highly inconsistent
[NEW; assigned to libreoffice-bugs]
-
121436:
CALC editing: Shifting Cells when inserting a cut column breaks formulas after the cut column
[NEW; assigned to libreoffice-bugs]
-
123865:
Search for a cell used in a CALC formula should return also results in ranges
[NEW; assigned to libreoffice-bugs]
-
126970:
Calc: calculation: cancellation and operand ordering effects in calc | was: Function "SUM()" work doesn't correct if final result is zero
[NEW; assigned to libreoffice-bugs]
-
127227:
Calc formula should use a color palette as highlight color
[NEW; assigned to libreoffice-bugs]
-
131065:
EDITING: removing rows: formula with leading "+", e.g. =+G41*F41 become =+G#REF!*F#REF!
[NEW; assigned to libreoffice-bugs]
-
131186:
Faulty behavior on Inserting rows/colums in a table by dragging
[NEW; assigned to libreoffice-bugs]
-
139985:
Problem with rept() in combination with randbetween.nv()
[NEW; assigned to libreoffice-bugs]
-
140286:
CALC formula =INFO("OSVERSION") gives wrong output
[NEW; assigned to libreoffice-bugs]
-
140909:
calc: calculation: basic macro: wrapping function (rawsubtract) wrong result - different than use in sheet
[NEW; assigned to libreoffice-bugs]
-
141001:
4 digits year in dates by default or user defined default date format in calc
[NEW; assigned to libreoffice-bugs]
-
143816:
Bug? Dragging formulae drags value as well
[NEW; assigned to libreoffice-bugs]
-
143962:
EDITING range reference should update when edge cell is moved in same column (drag and drop or cut and paste)
[NEW; assigned to libreoffice-bugs]
-
146790:
Problème avec la fonction NB.SI() COUNTIF()
[NEW; assigned to libreoffice-bugs]
-
147879:
Cell formula reference (in specific XLSX file) is broken when I delete several columns which are not referenced by the formula
[NEW; assigned to libreoffice-bugs]
-
148127:
When selecting parts of a formula referencing cells ranges from another opened window of the same spreadsheet, highlights do not update until the other window is clicked / focused
[NEW; assigned to libreoffice-bugs]
-
148488:
Calc reporting an erroneous result in a formula comprising a fractional power of a negative number
[NEW; assigned to libreoffice-bugs]
-
148983:
MULTIPLE.OPERATIONS fail with Err:504 when the input cell is *part* of the range used in formula cell directly
[NEW; assigned to libreoffice-bugs]
-
149941:
Display boolean TRUE or FALSE centered
[NEW; assigned to libreoffice-bugs]
-
151701:
Enable acceptance of the suggestion when entering formulas also with Tab (Tabulator) key
[NEW; assigned to libreoffice-bugs]
-
151958:
The COUNTIF and COUNTIFS functions mis-count on mixed numeric and text data and query by string
[ASSIGNED; assigned to erack]
-
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]
-
156572:
tbillyield() calculation returns incorrect yields for some dates
[NEW; assigned to libreoffice-bugs]
-
156766:
Complex formula with WEEKNUM result restarts after 31st week of year
[NEW; assigned to libreoffice-bugs]
-
157116:
Pre-calculating formulae as they are entered
[NEW; assigned to libreoffice-bugs]
-
157794:
Calc - loss of imaginary part in IMPOWER() result
[NEW; assigned to daniel]
-
158190:
Calc ROUND() function issue in specific range
[NEW; assigned to libreoffice-bugs]
-
159842:
Multiple.Operations does not work
[NEW; assigned to libreoffice-bugs]
-
159871:
Pasting formulas to text editor by View Formulas (Ctrl+`) mode skips sheet address
[NEW; assigned to libreoffice-bugs]
-
33801:
WW format returns wrong result compared correct weeknum() / 'locale setting' related
[CLOSED DUPLICATE; assigned to libreoffice-bugs]
-
40993:
Calc: Pulling down formula over merged cells unmerges them
[VERIFIED FIXED; assigned to attila.szucs]
-
41304:
EDITING: Cell formula shown without colors, colored frames missing around referenced cells (see comment 17)
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
42990:
EDITING Spreadsheet: Different handling of Text Cells in Calculations with SUM or addition of multiple cells
[CLOSED FIXED; assigned to libreoffice-bugs]
-
44076:
=(-8)^(1/3) should return -2
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
44089:
Calc FILEOPEN: Problem with opening file xml 2003 with DateTime value (data shown correctly, but time zeroed)
[RESOLVED FIXED; assigned to kohei]
-
44383:
Copy plus paste special with shift cells updates formulas after cells are shifted (per Comment 9 and 10)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
44587:
export or import of formulas from xlsx using range names in matrix formulas is broken
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
47349:
EDITING: Can't point and select cell from sheet (to set formula reference) with split column/row enabled (comment 20 / 31)
[RESOLVED FIXED; assigned to jluth]
-
50172:
Request for "Convert to values..." function
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
52510:
Calc removes trailing semicolon in custom format , breaking Excel compatibility
[CLOSED FIXED; assigned to erack]
-
54255:
MATCH does not find empty cells
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
56564:
ADAPT ROW HEIGHT: Excessive resources consumption
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
59309:
One cell containing text in a string of addends causes calc to return #VALUE!.
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
64132:
Calc operators and built-in functions use different algorithm for string-to-number coercion
[CLOSED NOTABUG; assigned to winfrieddonkers]
-
67581:
Copying cells with named ranges from one spreadsheet to another corrupts formula references to preexisting named ranges in target spreadsheet
[CLOSED FIXED; assigned to libreoffice-bugs]
-
68976:
Formulas change after cut and paste special action with Transpose
[VERIFIED FIXED; assigned to info]
-
71058:
EDITING: Cut and paste special with transposing does not shift formula links
[VERIFIED FIXED; assigned to info]
-
81408:
There is a bug when creating a formula starting from “-” or “+”.
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
82633:
a new document has regular expression enabled in formulas by default
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
85101:
FILEOPEN: *.xlsx weird characters in defined names not supported in formulas
[CLOSED WONTFIX; assigned to libreoffice-bugs]
-
86141:
EDITING (improvement): making matrix formula edition easier and more user-friendly
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
91801:
Calculations in tables with variables would cut off part of the calculation upon print
[RESOLVED FIXED; assigned to mikekaganski]
-
93936:
Creating a formula using Ctrl can incorrectly append a comma at the beginning of the function argument
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
93951:
Changing a formula calculation to include § causes truncation
[VERIFIED FIXED; assigned to erack]
-
95156:
Incorrect calculations on large spreadsheet
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
97791:
Calc:: Copying formulas DIVIDES prior combined Cells
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
99313:
FILEOPEN: XLSX - Validity check based on a formula produces faulty result
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
100970:
Formula edit not hightlighting cells when value in sheet with uncommon name (with "-" or "," values)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
101124:
MERGE and centre cells loses formula
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
102851:
Err 522 (Circular Reference) when formula replaced with numeric value (intermittent but repeatable)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
105622:
Highlight more than 64 cells in Calc formula
[RESOLVED FIXED; assigned to 22shubh22]
-
106177:
Paste special of Only Formulas unmerges cells (steps in Comment 9)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
108851:
Libre Office Calc allocates memory endlessly after copy-and-paste of formula definition
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
112434:
incorrect formula calculation after pasting when some of pasted cells would result in a REF result
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
113027:
Editing F4 (Sheet - Cycle Cell Reference Types) doesn't cycle remote references with space in sheet name
[RESOLVED FIXED; assigned to andreas.heinisch]
-
113896:
EDITING: Formula should be extended to a newly inserted row/column
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
113902:
Cells referenced in formula are not highlighted after moving cursor in formula text to check range.
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
115654:
EDITING: Column labels copied to cell range reference wrong cell until file is reloaded
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
116100:
MATCH applied to a search array introduced by an OFFSET subexpression results in Err:504.
[VERIFIED FIXED; assigned to erack]
-
118654:
strange behaviour when typing formula containing named cell '_C'
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
119021:
Finalized configuration item Calc - Formula - Syntax still editable
[RESOLVED FIXED; assigned to kelemeng]
-
119137:
MAXIFS, MINIFS, SUMIFS, AVERAGEIFS: error in parameters list (Err:504) for scalar value (non-reference, non-array) as main range
[RESOLVED FIXED; assigned to erack]
-
119904:
Spreadsheet formula corrupt with 6.1.1.2
[VERIFIED FIXED; assigned to dennisfrancis.in]
-
120948:
Deleting large number of rows/cells breaks group formula
[RESOLVED FIXED; assigned to deena.francis]
-
123000:
Regular expression match function, please?
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
123477:
Array formula with COLUMN() function evaluates to #VALUE error
[VERIFIED FIXED; assigned to erack]
-
123662:
EDITING: matrix formula fails if filter is applied
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
124036:
Calc cells with formula's don't highlight cells in the presence of a % symbol
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
124102:
Display components of formula without edit
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
124326:
Undo after drag&drop changes the original formula
[VERIFIED FIXED; assigned to dennisfrancis.in]
-
124585:
balans error bookkeeping
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
132026:
Entering "-" in a cell formatted as text puts Calc into formula-entering mode
[RESOLVED FIXED; assigned to baole.fang]
-
136537:
Cell formulas get corrupted with Drag & Drop
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
136544:
formulas get corrupted when deleting columns
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
138220:
calc: calculation: roundup: rounddown: fail in 7.1 alpha
[RESOLVED FIXED; assigned to erack]
-
139974:
Data Corruption with more than 16367 characters in one paragraph in cell if edited
[RESOLVED FIXED; assigned to erack]
-
142065:
EDITING: Cut paste transposed with formula reference within range leads to #REF
[VERIFIED FIXED; assigned to info]
-
142201:
EDITING: Cut paste transposed: formula references from wrong cells adjusted
[VERIFIED FIXED; assigned to info]
-
145812:
Cell reference are highlighted black when putting = into a cell and clicking a different cell
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
153790:
Unnecessary 3D sheet reference in end part of reference after cut and paste
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
154852:
CELL() function does not update after worksheet rename
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
156357:
Cannot copy formula by copying cell when displaying with Show Formula
[VERIFIED FIXED; assigned to heiko.tietze]
-
159687:
Cutting rows from specific file with whole column references in formula is slow
[RESOLVED FIXED; assigned to balazs.varga991]
-
159858:
COUNTIFS doesn't count empty cells at the end of the 1st range if there is non-empty cells before
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
160282:
Ranges references text colors for in-cell editing of formulas are too dark for dark mode, causing low contrast
[RESOLVED FIXED; assigned to heiko.tietze]
-
160874:
Calc fails to suggest correction for formula cell without equal sign
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
161223:
basic HTML cell render
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
view as bug list