view as bug list
-
108917:
[META] Cell references bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
45802:
LibreOffice fails to update cell reference field after changing between A1/R1C1
[NEW; assigned to libreoffice-bugs]
-
48765:
Remote ref to cells in LibO-Calc spreadsheet denied in tool (function)
[NEW; assigned to libreoffice-bugs]
-
54175:
Behavior of references should always be the same, moving or inserting or deleting cells/columns/rows, in any place where references are used.
[NEW; assigned to libreoffice-bugs]
-
54481:
EDITING: inconsistant label reference
[NEW; assigned to libreoffice-bugs]
-
56217:
Use formatting of referenced cell in target cell
[NEW; assigned to libreoffice-bugs]
-
59391:
Naming a cell causes certain references using labeled ranges to go undefined; recalculate/autocalculate
[NEW; assigned to libreoffice-bugs]
-
60385:
Formulae which subtract remote references to sheets with a space in the name return an error 509
[NEW; assigned to libreoffice-bugs]
-
61743:
Wrongly Absolute Path Referencing to named Ranges Across Documents
[NEW; assigned to libreoffice-bugs]
-
63087:
Detective "Trace Precedents" or "Trace Dependents" pointing to a different tab does not provide reference cell
[NEW; assigned to libreoffice-bugs]
-
64131:
EDITING: DDE function does not work for Name Ranges with Local Scope
[NEW; assigned to libreoffice-bugs]
-
64228:
Request for Calc: Create a variable name to a cell and reference that name by clicking on it
[NEW; assigned to libreoffice-bugs]
-
74899:
EDITING: Paste content and move cells downwards changes a fixed reference (with a workaround in comment 3)
[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]
-
83932:
EDITING: NAMES: Automatic replacement on references
[NEW; assigned to libreoffice-bugs]
-
87687:
Merging cells does not move references in equations (Comment 6)
[NEW; assigned to libreoffice-bugs]
-
88498:
function Countif external reference - value not cached
[NEW; assigned to libreoffice-bugs]
-
91424:
handling of relative references in OOXML range names
[NEW; assigned to libreoffice-bugs]
-
92301:
If a filename in DDE function is a reference to other cell, old DDE link is not deleted after filename change
[NEW; assigned to libreoffice-bugs]
-
99986:
EDITING: formula use in LO and save as XSLX give error in excel (function IF accept invalid reference)
[NEW; assigned to libreoffice-bugs]
-
100154:
FILEOPEN: XLSX - Pointer to sheet with dotted name in cyrillic has incorrect reference format
[NEW; assigned to libreoffice-bugs]
-
100609:
EDITING: add the ability to link local names in other files (now available in other sheets in the same file)
[NEW; assigned to libreoffice-bugs]
-
101312:
Referencing cells from another Calc window results in error 508 or 509 when file name contains an apostrophe
[NEW; assigned to libreoffice-bugs]
-
104452:
"Cut, add row, paste" doesn't update references
[NEW; assigned to libreoffice-bugs]
-
104559:
UI When editing a formula cell, the formula hides referenced cells
[NEW; assigned to libreoffice-bugs]
-
105683:
Allow expressions with references in inline arrays, not only constants
[NEW; assigned to libreoffice-bugs]
-
121626:
When copying sheets or objects (checkboxes/charts) references in the objects are not updated
[NEW; assigned to libreoffice-bugs]
-
132455:
REF error after undo sheet deletion. Hard recalculate doens't fix it
[NEW; assigned to libreoffice-bugs]
-
144252:
Compatibility issues with cell summation formulas across worksheets
[NEW; assigned to libreoffice-bugs]
-
144643:
Defined name pointing to external worksheet does not work/cannot be created
[UNCONFIRMED; assigned to libreoffice-bugs]
-
147916:
When copying a cell to a newly inserted sheet, absolute sheet name reference is not reserved thus the pasted formula is broken
[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]
-
154075:
Calc's F4 absolute cycle is sub-optimal when starting from a sheet-only absolute reference
[NEW; assigned to libreoffice-bugs]
-
41304:
EDITING: Cell formula shown without colors, colored frames missing around referenced cells (see comment 17)
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
62902:
'Show references in color' doesn't work across sheets, when the sheet name contains a space
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
63859:
Highlight Referenced Cell Live (or immediately during creating the formula)
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
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]
-
78476:
EDITING: Calc fails to do automatic reference in cell edit mode when the window is frozen.
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
84056:
EDITING: Dependent cells not updated if reference in another sheet changed
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
85538:
Copying sheet to new document (or somewhere in same document) causes formula error if cells have relative reference to other sheets
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
90799:
Create absolute sheet references instead of relative when clicking while building formulas
[VERIFIED FIXED; assigned to erack]
-
92419:
delete referenced cell - raise error to warn (inexperienced) users
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
93328:
Editing circular reference causes #VALUE! error
[VERIFIED FIXED; assigned to dennisfrancis.in]
-
96915:
add ability to refer to local names in another worksheet
[RESOLVED FIXED; assigned to erack]
-
97123:
data range created by drag'n drop from base window loses database name on save
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
97552:
unexpected changes in formula references
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
106133:
Calc Fails To Select Cell When Referencing Another Sheet and That Sheet Has Column/Row Freeze Enabled
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
106440:
Inserting a row/column before a frozen row/column does not shift the referenced frozen row/column location as expected
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
106763:
Problems with references when new columns/rows are inserted
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
108673:
FILESAVE XLSX: Copy-pasting cell validation may result in a sheet reference error saved as invalid xlsx content
[VERIFIED FIXED; assigned to serge.krot]
-
108924:
copy + paste cell with absolute reference offset the reference
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
126821:
Linked cell path broken when saving xlsx file
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
127633:
Relative Cells
[CLOSED WONTFIX; assigned to libreoffice-bugs]
-
137937:
FILESAVE XLSX External cell reference path is extended by user home dirs path
[VERIFIED FIXED; assigned to attila.szucs]
-
138824:
FILESAVE XLSX Link to external file loses parent directory part if it points to file in parent directory
[VERIFIED FIXED; assigned to attila.szucs]
-
138832:
FILESAVE XLSX Updating external link used in formula does not save the updated link
[VERIFIED FIXED; assigned to attila.szucs]
-
145812:
Cell reference are highlighted black when putting = into a cell and clicking a different cell
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
153548:
F4 Absolute Cell Referencing not working for cross-sheet reference when using freeze rows / columns
[RESOLVED FIXED; assigned to jluth]
view as bug list