| Max Depth: |
Bug 108252 depends on 2048 bugs:
-
108252:
[META] Cell-related bugs and enhancements (including formatting)
[NEW; assigned to libreoffice-bugs]
-
31205:
Apply fill patterns to cell backgrounds
[NEW; assigned to libreoffice-bugs]
-
32950:
FILEOPEN XLS: Cell height may be wrong because 'Optimal height" of rows is not re-calculated at load time.
[NEW; assigned to libreoffice-bugs]
-
34689:
UI scroll problem: Cell with dimensions exceeding screen dimensions impossible to work with
[NEW; assigned to libreoffice-bugs]
-
36864:
Calc cell format for Bytes
[NEW; assigned to libreoffice-bugs]
-
38003:
Calc doesn't print the content of a cell until you go out this cell
[NEW; assigned to libreoffice-bugs]
-
38281:
EDITING Enable pasting one line/word from clipboard to multiple cells at once
[NEW; assigned to libreoffice-bugs]
-
38446:
Text orientation<> 0 + particlar 'Reference Edge' destroys horizontal text alignment
[NEW; assigned to libreoffice-bugs]
-
39274:
Add ability to set highlight color for text (Calc)
[NEW; assigned to libreoffice-bugs]
-
39969:
Applying formatting doesn't work correctly if cell contains multiple direct formatting sequences
[NEW; assigned to libreoffice-bugs]
-
40389:
Re-formatting as text fails if previously contained apparently valid cell reference
[NEW; assigned to libreoffice-bugs]
-
40685:
FORMATTING Request for wrapping long Date and Time formats
[NEW; assigned to libreoffice-bugs]
-
40917:
UI: Calc currently scrolling only by full row height
[NEW; assigned to libreoffice-bugs]
-
41477:
EDITING: Snap objects/pictures to cell boundaries
[NEW; assigned to libreoffice-bugs]
-
43275:
Tooltips leave elements behind when dismissed; tooltips don't dismiss when application switch occurs
[NEW; assigned to libreoffice-bugs]
-
46738:
FILESAVE Cell background and border color formatting of empty cells lost after export to xls or xlsx (steps in comment 36)
[NEW; assigned to libreoffice-bugs]
-
47561:
EDITING: Cell content that overlaps left cell border inaccessible with mouse click
[NEW; assigned to libreoffice-bugs]
-
48274:
EDITING: Fill disabled if hidden (or filtered) cells in range instead of filling omitting invisible cells
[NEW; assigned to libreoffice-bugs]
-
49047:
CONFIGURATION: Dimensional Analysis Wish
[NEW; assigned to libreoffice-bugs]
-
49206:
VIEWING: Tooltip for cell with partially hidden content
[NEW; assigned to libreoffice-bugs]
-
50504:
EDITING: Can not add characters at the beginning of a cell which have a very long first line
[NEW; assigned to libreoffice-bugs]
-
51697:
EDITING: Cell format for date is not taken into account when entering data
[NEW; assigned to libreoffice-bugs]
-
51729:
EDITING: Previously copied cells are incorrectly highlighted as still in clipboard after no longer in clipboard
[NEW; assigned to libreoffice-bugs]
-
51935:
Break Link turn cell into #Ref except first cell
[NEW; assigned to libreoffice-bugs]
-
53075:
[EDITING] Calc radio button sends text and not number
[NEW; assigned to libreoffice-bugs]
-
53536:
EDITING: Inserting text as centered jumps to another cell position.
[NEW; assigned to libreoffice-bugs]
-
53602:
Copy value from cell above by one button click
[NEW; assigned to libreoffice-bugs]
-
59284:
[META] Calc cell border related issues
[NEW; assigned to libreoffice-bugs]
-
34837:
Merged Cell's borders vanishes when changing sheet direction to (Right-To-Left)
[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]
-
42339:
EDITING and VIEWING cell borders differs from expected and PRINTING
[NEW; assigned to libreoffice-bugs]
-
47078:
Empty page with cell borders gets printed out when "Suppress output of empty pages" is enabled
[NEW; assigned to libreoffice-bugs]
-
56894:
FORMATTING: Cell borders drawn using (python) scripts do not draw as expected in all cases
[NEW; assigned to libreoffice-bugs]
-
57564:
UI: Impossible to view Cursor when the borders of table has the same aspect as the cursor
[NEW; assigned to libreoffice-bugs]
-
60173:
Need a way to format every nth border
[NEW; assigned to libreoffice-bugs]
-
81165:
in xls spreadsheet FILESAVE - dotted lines round cells print but then do not save
[NEW; assigned to libreoffice-bugs]
-
84129:
SIDEBAR: Cell appearance border line styles not previewed correctly
[NEW; assigned to libreoffice-bugs]
-
86903:
UI: Format > Cells > Borders preview is missing shaded ends of some diagonal line positions
[NEW; assigned to libreoffice-bugs]
-
87787:
Improve cell border assignment
[NEW; assigned to libreoffice-bugs]
-
91005:
Cell border should be hidden when text crosses over cell border
[NEW; assigned to libreoffice-bugs]
-
91007:
FILEOPEN: XLS - Cell borders not present
[NEW; assigned to libreoffice-bugs]
-
91997:
PRINTING PDF text overflows cell borders
[NEW; assigned to libreoffice-bugs]
-
92736:
Toolbar: make cell border attributes easier to set and understand at a glance
[NEW; assigned to libreoffice-bugs]
-
100548:
Reorganizing “Border” tab on “Format Cells” window in Calc
[NEW; assigned to libreoffice-bugs]
-
104036:
Hidden grid lines shouldn't print if not visible, even if print grid lines is checked
[NEW; assigned to libreoffice-bugs]
-
104129:
Cell borders freehand drawing tool
[NEW; assigned to libreoffice-bugs]
-
107901:
Format Cells dialog overwrites user selection
[NEW; assigned to libreoffice-bugs]
-
113654:
[META] Toolbar border controls bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
58349:
Turn Border button into a split button and remember recent border style
[NEW; assigned to libreoffice-bugs]
-
66008:
TABLE: Redesign borders button on the Table toolbar
[NEW; assigned to libreoffice-bugs]
-
69305:
TABLE: Proposal to improve Table border formatting toolbar controls
[NEW; assigned to libreoffice-bugs]
-
87787:
Improve cell border assignment
[NEW; assigned to libreoffice-bugs]
(*)
-
89734:
TOOLBAR: Border line width control
[NEW; assigned to libreoffice-bugs]
-
90806:
CALC: Borders should be automatically added when border style or color are set
[NEW; assigned to libreoffice-bugs]
-
91742:
TOOLBAR: Vertical toolbar doesnt have border
[NEW; assigned to libreoffice-bugs]
-
93975:
Toolbar table borders control causes spacing to content issues (see comment #6)
[NEW; assigned to libreoffice-bugs]
-
103770:
UI: No way to set outer borders of selected range with the tool bar, without affecting inner borders of that range at the same time
[NEW; assigned to libreoffice-bugs]
-
113606:
TOOLBAR: Handling of icon "borders" in the table toolbar should be improved (see comment 4)
[NEW; assigned to libreoffice-bugs]
-
146466:
Inconsistent choices of borders between toolbar and sidebar
[NEW; assigned to libreoffice-bugs]
-
146468:
Use same border preset tooltips between toolbar and sidebar
[NEW; assigned to libreoffice-bugs]
-
90805:
TOOLBAR: Enabling border color on an image should enable border
[VERIFIED FIXED; assigned to jluth]
-
138156:
Border widget does not allow to keep settings
[VERIFIED FIXED; assigned to caolan.mcnamara]
-
146407:
Writer - Dysfunction of Diagonal & Criss-Cross Border.
[RESOLVED FIXED; assigned to bayram.cicek]
-
58349:
Turn Border button into a split button and remember recent border style
[NEW; assigned to libreoffice-bugs]
-
120166:
Cell border style works differently in Microsoft Excel and LibreOffice Calc
[NEW; assigned to libreoffice-bugs]
-
120902:
inconsistent behaviour of the menu icons regarding Cell Background and cell border
[NEW; assigned to libreoffice-bugs]
-
121071:
FORMATTING - Double Table Borders When Copied from Calc and Pasted in Gmail
[NEW; assigned to libreoffice-bugs]
-
121268:
UI: Cell borders go far beyond the calc cell
[NEW; assigned to libreoffice-bugs]
-
121614:
Calc: FORMATTING changing orientation of text causes corruption of cell borders
[NEW; assigned to libreoffice-bugs]
-
122841:
[UI] Dotted line cell border rendered incorrectly onscreen
[NEW; assigned to libreoffice-bugs]
-
125259:
FILEOPEN:XLS: Image overlaps border
[NEW; assigned to libreoffice-bugs]
-
130675:
Calc: Cell borders protruded at joint angle
[NEW; assigned to libreoffice-bugs]
-
132915:
Missing cell border line after deleting a row above of a row with merged cells
[NEW; assigned to libreoffice-bugs]
-
135510:
FILEOPEN Tables cells in XLSX files made by MacOS Numbers are shown without borders
[NEW; assigned to libreoffice-bugs]
-
141588:
FILEOPEN XLSX Cell borders missing
[NEW; assigned to libreoffice-bugs]
-
141774:
Make cell border dropdown from Sidebar available for Toolbar
[UNCONFIRMED; assigned to libreoffice-bugs]
-
143839:
Border removed after merge cells
[NEW; assigned to libreoffice-bugs]
-
144141:
Remember last used line width (and other settings) for cell borders
[NEW; assigned to libreoffice-bugs]
-
145726:
EDITING: Borders around 100+ rows in spreadsheet don't appear in print preview
[NEW; assigned to libreoffice-bugs]
-
145948:
In an RTL sheet, merged cell borders don't show until save or direction change (see comment 2)
[NEW; assigned to libreoffice-bugs]
-
146466:
Inconsistent choices of borders between toolbar and sidebar
[NEW; assigned to libreoffice-bugs]
(*)
-
146760:
FORMATTING - Frames on cells not displayed correctly - line width of 0.75pt is same as 1.25pt
[NEW; assigned to libreoffice-bugs]
-
149208:
[XLSX] Excessive border weight in imported Excel files
[NEW; assigned to libreoffice-bugs]
-
151373:
EDITING: Coloured borders of referenced cells missing when more than 128 references in formula expression
[NEW; assigned to libreoffice-bugs]
-
152558:
Calc Cell Borders are inconsistent with the drop-down graphic selector. Also, No help page for manual definitions
[NEW; assigned to libreoffice-bugs]
-
153388:
Calc UI: Incorrect rendering of cell borders
[NEW; assigned to libreoffice-bugs]
-
153660:
Single Undo should remove all diagonal borders created with Toolbar>Borders
[NEW; assigned to libreoffice-bugs]
-
153782:
Line width name "Double hairline" is duplicated for two different format commands
[NEW; assigned to libreoffice-bugs]
-
48622:
Line thickness specification - too many choices, nonintuitive
[VERIFIED FIXED; assigned to samuel.mehrbrodt]
-
51901:
Different line border format between Openoffice and LibreOffice
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
52112:
UI: Borders doesn't have ready option for Thick Outside Border
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
53011:
FORMATTING: Default table border width is very thin
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
55266:
FORMATTING: Some cell borders (double line) don't work
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
57345:
FILEOPEN: cell borders width of double line is no longer clear as with old version
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
61054:
FORMATTING: Extend borders toolbar dialog with border formatting
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
73896:
UI default cell frame defined from sidebar is too thick
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
76166:
VIEWING: 0.05pt dashed cell borders are always shown solid
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
76461:
Merged cells border format doesn't work when selecting a row
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
77369:
Dashed and dotted Calc borders appear solid at some zoom factor
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
79787:
Normal cell borders are showing dashed/dotted when export to xlsx/xls and reopen in MSO
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
88827:
FILESAVE: double lined cell borders get lost due after saving as ODS and reopen
[VERIFIED FIXED; assigned to jluth]
-
98176:
active cell border color stays black
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
98317:
FORMATTING - No dotted lines available for the formatting of cells
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
99027:
[FORMATTING] Default table border width is useless
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
99190:
Calc cell border thickness is not shown correctly on screen
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
100518:
Border line style issues in Calc
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
100549:
Reorganizing “Borders” group button on “Formatting Toolbar”
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
100644:
change the behavior of changing line thickness with "format cells"
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
103924:
border style duplicated / changed by new borders when round-tripping
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
112671:
EDITING: Table border thickness seems to change for some borders depending on zoom-level
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
113751:
Borders for Merged Cells are Partially Shown
[RESOLVED FIXED; assigned to Armin.Le.Grand]
-
116031:
Calc grid lines don't print when the spreadsheet have a PNG image.
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
116237:
When selecting certain Border formats and a Border Style from the toolbar button, the style is not correct.
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
119496:
LibreCalc - Cell border drawing issue, when the neighbour column is hidden
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
123033:
Calc (default) cell borders not drawn in a certain case
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
124496:
Adding diagonal borders to cells while EDITING calc file messes the file
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
124744:
xlsx - Border and Comments
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
126407:
Copying tables from Calc to ACAD on LibreOffice 6.2.5
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
127770:
Freeze/crash on a cell formatted with rotation 180° and dashed borders
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
127986:
cell border doesn't disappear automatically if the content exceeds it (and there is no content in the next cell).
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
130919:
The line thickness of a border of a cell in Calc
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
132859:
Thick borders (and more) do not exist
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
133434:
When merging cells that have a border applied, right border will reset
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
135957:
Excel and Calc borders not cross-compatible
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
137790:
Calc: Minimal line width for different line styles
[RESOLVED FIXED; assigned to serge.krot]
-
139139:
[EDITING] Selecting Border Style from the toolbar changes Line Width.
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
140032:
Double-line cell borders not exported to XLSX and XLS
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
140185:
XLSX file doesn't save cell border padding
[RESOLVED INVALID; assigned to libreoffice-bugs]
-
147388:
Cell cursor should take cell border width into account
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
149213:
Cell's borders are not shown
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
150005:
Default Cell Borders thickness not customizable using the toolbar buttons
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
150100:
UI Calc Double cell border has minimum width at import
[VERIFIED FIXED; assigned to balazs.varga991]
-
151755:
FILESAVE XLS/X: contentless cells at row end are losing their borders on export
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
157447:
Calc does not preserve cell padding in XLSX
[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]
-
34837:
Merged Cell's borders vanishes when changing sheet direction to (Right-To-Left)
[NEW; assigned to libreoffice-bugs]
-
61962:
When only a small letter changed to a big letter, calc do not execute modifying a cell, if there is an another occurrence in the same row
[NEW; assigned to libreoffice-bugs]
-
64028:
Enhancement: option to retain cell formating in Calc when <Ctrl> X is used to cut contents of a cell
[NEW; assigned to libreoffice-bugs]
-
65200:
FORMATTING: Autofit width not behave properly if cell(s) contain text wrapping
[NEW; assigned to libreoffice-bugs]
-
71324:
EDITING: can't un-bold selection if it crosses hidden lines of an auto-filter
[NEW; assigned to libreoffice-bugs]
-
74391:
Double byte characters not shown after highlighting single byte characters
[NEW; assigned to libreoffice-bugs]
-
76095:
FORMATTING: Expand "Automatic Row Break" by include automatic hyphenation
[NEW; assigned to libreoffice-bugs]
-
80744:
FILEOPEN: row height cuts off the top of the text in .xls file
[NEW; assigned to libreoffice-bugs]
-
84447:
Calc: cell format: Wrap text automatically incompatible with option vertically stacked
[NEW; assigned to libreoffice-bugs]
-
84747:
EDITING typed characters inserted into wrong sheet when defined name selected
[NEW; assigned to libreoffice-bugs]
-
87341:
FORMATTING: Wrong cells formating
[NEW; assigned to libreoffice-bugs]
-
87773:
FILESAVE: Numbers not saved properly
[NEW; assigned to libreoffice-bugs]
-
89931:
Feature request: FORMATTING with returns
[NEW; assigned to libreoffice-bugs]
-
92829:
Black smears when cell content dragged
[NEW; assigned to libreoffice-bugs]
-
92865:
Row Height "use-optimal-row-height" differences in OO and LIBO: rows collapsed in XLS
[NEW; assigned to libreoffice-bugs]
-
94499:
FORMATTING: "Expand formatting" affects non-empty adjacent cell
[NEW; assigned to libreoffice-bugs]
-
95007:
Optimizing using of the space of the cells
[NEW; assigned to libreoffice-bugs]
-
96544:
Text inserts in wrong place when cell contains a URL
[NEW; assigned to libreoffice-bugs]
-
96571:
number-rows-repeated dosn't repeat all cells
[NEW; assigned to libreoffice-bugs]
-
97106:
FORMATTING: Calc wrap text setting in Cell Formatting not saved in XLS
[NEW; assigned to libreoffice-bugs]
-
99859:
[Calc] Font color not correct in DOCUMENT VIEW (see comment #22)
[NEW; assigned to libreoffice-bugs]
-
102868:
No "jump back" option, after jump to another cell (with Cell Name box, TLHC of the sheet), to return to the previous cell address
[NEW; assigned to libreoffice-bugs]
-
107153:
DISPLAY: row headers misaligned with data (wrap text, vertical: top)
[NEW; assigned to libreoffice-bugs]
-
107332:
[META] Calc cell and page styles bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
34914:
page border in Calc works incorrect
[NEW; assigned to libreoffice-bugs]
-
45056:
PRINTING: define different scale modes for different tabs in Calc
[NEW; assigned to libreoffice-bugs]
-
57086:
FORMATTING: in a spreadsheet with partial protection: allow modifying cell styles that are not used on a protected sheet
[NEW; assigned to libreoffice-bugs]
-
57102:
FORMATTING: in a spreadsheet with partial protection: give warning that cell styles cannot be changed
[NEW; assigned to libreoffice-bugs]
-
58759:
FORMATTING: Excluding attributes from custom cell styles
[NEW; assigned to libreoffice-bugs]
-
60575:
When one protected sheet is present it's impossible to edit styles
[NEW; assigned to libreoffice-bugs]
-
62925:
FORMATTING: enhancement: implement "chart styles"
[NEW; assigned to libreoffice-bugs]
-
79298:
FORMATTING: Copy/paste: importing of strikethrough attribute doesn't work
[NEW; assigned to libreoffice-bugs]
-
80040:
FILESAVE: XLSX - Hyperlinks don't show up in Excel in blue or underlined
[NEW; assigned to libreoffice-bugs]
-
81397:
FORMATTING: When the Default cell style's font size is modified, new sheets do not use corresponding row height
[NEW; assigned to libreoffice-bugs]
-
82798:
FORMATTING: Select New style from another document / template not available for spreadsheets
[NEW; assigned to libreoffice-bugs]
-
85998:
Usability improvements to "Choose Themes" (table styles in Calc): Add theme, delete theme, format cells according to theme
[NEW; assigned to libreoffice-bugs]
-
89369:
Introduce Drawing object styles (shapes, textboxes...) to Writer & Calc like in Impress/Draw
[NEW; assigned to libreoffice-bugs]
-
90931:
'Apply Style' drop down doesnt show accurate style previews
[NEW; assigned to libreoffice-bugs]
-
92144:
Calc styles cannot have percentage sizes for fonts
[NEW; assigned to libreoffice-bugs]
-
93807:
Updating cell style while in edit mode doesnt refresh text
[NEW; assigned to libreoffice-bugs]
-
93844:
SIDEBAR: Style previews in Styles and Formatting tab in Calc
[NEW; assigned to libreoffice-bugs]
-
96852:
Calc: Add option in "Move/Copy Sheet..." for copying page format to another workbook
[NEW; assigned to libreoffice-bugs]
-
105429:
Names of new default set of cell styles not localized
[NEW; assigned to libreoffice-bugs]
-
106952:
Update cell style can bypass cell protection
[NEW; assigned to libreoffice-bugs]
-
107381:
Default cell style colors shouldnt be included as document colors
[NEW; assigned to libreoffice-bugs]
-
108220:
Add Character styles in Calc cells
[NEW; assigned to libreoffice-bugs]
-
108681:
[META] Cell formatting/style dialog bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
42989:
FORMATTING: Selecting Multiple Cells with Different Formats Show as Same Format and Can't Be Changed as a Group
[NEW; assigned to libreoffice-bugs]
-
45952:
Format Cells: Binary and Hex with digit grouping
[NEW; assigned to libreoffice-bugs]
-
47896:
Prepend small short-list of likely/more-relevant languages in language selection lists
[NEW; assigned to libreoffice-bugs]
-
73955:
Table with merged rows does not respect "Do not break across pages" setting
[NEW; assigned to libreoffice-bugs]
-
76311:
CALC: If differently formatted cells are selected, Format Cells should register it and not mark any format, so that user may set it
[NEW; assigned to libreoffice-bugs]
-
86704:
GUI: CALC: Alignment tab of Format Cells dialogue should provide information about language settings, i.e. if Hyphenation can actually be excecuted
[NEW; assigned to libreoffice-bugs]
-
90708:
Support display of SI units (like Gnumeric)
[NEW; assigned to libreoffice-bugs]
-
91281:
Show color picker recently used background colour list in the "FORMAT CELLS -> BACKGROUND" dialog as well
[NEW; assigned to libreoffice-bugs]
-
91816:
FORMATTING indent right greyed out
[NEW; assigned to libreoffice-bugs]
-
107901:
Format Cells dialog overwrites user selection
[NEW; assigned to libreoffice-bugs]
(*)
-
108383:
[META] Borders dialog tab bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
46583:
borders tabpage UI doesn't display border properties nicely when lines are different
[NEW; assigned to libreoffice-bugs]
-
85860:
OLE object frame properties and styles: border lines and spacing should optionally increase frame size rather than reduce content to fit
[NEW; assigned to libreoffice-bugs]
-
97019:
Feature to use an image as borders
[NEW; assigned to libreoffice-bugs]
-
98316:
FORMATTING Dotted border lines should really be dots and not short dashes
[NEW; assigned to libreoffice-bugs]
-
126649:
Line style presets arrangement and additional one.
[NEW; assigned to libreoffice-bugs]
-
136054:
Border line width isn't reset in page style dialog after pressing reset
[NEW; assigned to libreoffice-bugs]
-
54266:
UI: Table border tool (dialog Table, tab Border) too easily picks two borders near conjunction
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
58218:
Put Paragraph Border Styles In Consistent Order
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
95247:
Borders accesibility
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
101886:
Border line style control not a11y accessible
[RESOLVED FIXED; assigned to m.weghorn]
-
102960:
weird selection in format cells - borders - line arrangement
[RESOLVED FIXED; assigned to vmiklos]
-
108255:
"Remove Border" checkbox adds confusion, but no functionality
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
116621:
UI: No description for the different border line-styles
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
127807:
Make Border in Writer dialog Table Properties HIG conform
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
128431:
Synchronize padding in header borders it is not working
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
135753:
UI: Table properties borders has no drop down for 'cell' 'row' or table
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
138127:
Border control in property dialogs use black color even on dark theme
[RESOLVED FIXED; assigned to heiko.tietze]
-
145211:
Object Border Shadow distance is always rounded to 0.10 cm and can not be smaller
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
150273:
Solid Line Style preview in Borders dialog is not seen using dark mode in Ubuntu 22.04 and OpenSuse
[RESOLVED FIXED; assigned to caolan.mcnamara]
-
152800:
Changes to border format in cell style should persists even if no border is set, so it can be used as a default for new borders (comment 2)
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
46583:
borders tabpage UI doesn't display border properties nicely when lines are different
[NEW; assigned to libreoffice-bugs]
-
108555:
Add line spacing feature to cell properties
[NEW; assigned to libreoffice-bugs]
-
108736:
[META] Font text preview bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
113438:
[META] Font name combobox bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
42003:
Ctrl W and Ctrl Q don't work in Font Name, Font Size, or Apply Style combo boxes
[NEW; assigned to libreoffice-bugs]
-
62063:
FORMATTING: Font textbox ignores keyboard layout change to RTL language
[NEW; assigned to libreoffice-bugs]
-
90161:
Make font selection dropdown list center on the most recently used font
[NEW; assigned to libreoffice-bugs]
-
91130:
Smaller default font name list
[NEW; assigned to libreoffice-bugs]
-
91407:
Hard to type name of uninstalled font due to zealous auto-completion
[NEW; assigned to libreoffice-bugs]
-
92286:
Selection in font name dropdown has to reflect the source
[NEW; assigned to libreoffice-bugs]
-
94909:
Font name won't be selected when font list has recently used font section
[NEW; assigned to libreoffice-bugs]
-
108181:
Font selection ignored in dropdown, if you click on the size dropdown immediately after
[NEW; assigned to libreoffice-bugs]
-
112174:
Limit the maximum accepted length of input in the font name field (see comment 4)
[NEW; assigned to libreoffice-bugs]
-
114764:
List users' locale fonts in group first in the font selection dropdown list
[NEW; assigned to libreoffice-bugs]
-
121301:
FILEOPEN DOCX Writer unable to recognize the font when it is defined as “Times New Roman félkövér” (Times New Roman Bold)
[NEW; assigned to libreoffice-bugs]
-
122649:
Fontbox empty after selecting some symbols (all of the related to the same font)
[NEW; assigned to libreoffice-bugs]
-
127123:
Recently Used Fonts are not stored across sessions when sidebar is used
[NEW; assigned to libreoffice-bugs]
-
136943:
TOOLBAR: Can't see last font name due to font name toolbar combobox having wrong height (Win, Linux kf5/kf6 with X11)
[NEW; assigned to libreoffice-bugs]
-
151119:
Font (family) selection UI elements should allow searching by substring
[NEW; assigned to libreoffice-bugs]
-
151122:
Need way to avoid selecting fonts which don't cover the relevant language Unicode range
[NEW; assigned to libreoffice-bugs]
-
152987:
"Font Name" drop-down list protrudes from the screen in Qt environment (VCL: qt , kf5)
[NEW; assigned to libreoffice-bugs]
-
154504:
Font and Paragraph style drop-downs remain visible after minimizing or resizing the window
[NEW; assigned to libreoffice-bugs]
-
157044:
Font drop down has Linux Biolinum G selected, while the font being Verdana
[NEW; assigned to libreoffice-bugs]
-
157875:
Selecting text that uses several font families does not show a blank name in Font Name combobox in Impress
[NEW; assigned to libreoffice-bugs]
-
157876:
When selection only has variants of same font family, don't show empty box
[NEW; assigned to libreoffice-bugs]
-
66792:
UI: Better integration of font styles into the toolbar
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
68808:
EDITING: Font name combobox shows wrong font for fields when paragraph is RTL
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
80694:
Improvement to Font List
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
82259:
Font dropdown language hint is nonsensical for some fonts
[RESOLVED FIXED; assigned to caolan.mcnamara]
-
87871:
UI: Font drop-down is cluttered (UX)
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
88484:
Sample text in font name combobox doesn't display
[RESOLVED FIXED; assigned to khaled]
-
88542:
display field for font in standard toolbar is too short
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
108012:
Clicking in the font field should select the contents
[VERIFIED FIXED; assigned to nicksonthanda10]
-
109253:
FONT NAME list: Scrolling through the list causes a crash. "Bad allocation" error message
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
112973:
Some font families getting split in English locale
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
113642:
Narad hindi font preview in font drop down is incorrect
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
119199:
Selected choice of available fonts
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
119915:
Make it easier to work with different fonts
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
127406:
UI: Typeface and style names are not fully readable in GTK3
[RESOLVED FIXED; assigned to heiko.tietze]
-
130396:
Improvement of font list
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
132435:
Font selection drop down menu expands right and button is too narrow
[VERIFIED FIXED; assigned to caolan.mcnamara]
-
134601:
Missing font is not indicated using italics in font selector
[VERIFIED FIXED; assigned to caolan.mcnamara]
-
143021:
Show font names used first
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
144757:
In Options - LibreOffice - Fonts - Font Settings for HTML, Basic and SQL Sources - font list not-displayed in dropdown menu unless tickbox "Non-proportional fonts only" is unticked.
[VERIFIED FIXED; assigned to chris.sherlock79]
-
148169:
Font selection in format toolbar is very slow to respond
[RESOLVED NOTOURBUG; assigned to libreoffice-bugs]
-
150720:
UI: Font drop down shows fonts before the select font initially, but fails after font change
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
154547:
Hebrew fonts in drop-down list don't show the full expected phrase
[RESOLVED FIXED; assigned to khaled]
-
156110:
When typing in expanded font family combo box, don't collapse the list
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
42003:
Ctrl W and Ctrl Q don't work in Font Name, Font Size, or Apply Style combo boxes
[NEW; assigned to libreoffice-bugs]
-
143367:
Font tabs in style dialogs: when Font Color is white there is no preview
[NEW; assigned to libreoffice-bugs]
-
158069:
Scroll through font selection listbox using arrow keys and preview change on document canvas
[UNCONFIRMED; assigned to libreoffice-bugs]
-
99896:
Implement "Live Preview" for font size in Calc
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
108611:
EDITING: Hovering through different font with preview enabled is slowish and CPU hogging
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
108735:
MathJax font preview rendered crammed in Character dialog
[RESOLVED NOTOURBUG; assigned to libreoffice-bugs]
-
108738:
Braille font appears blank in font and style previews
[RESOLVED NOTOURBUG; assigned to libreoffice-bugs]
-
110077:
Font name preview in dialog appears as black bar
[RESOLVED FIXED; assigned to caolan.mcnamara]
-
112324:
Instant Preview not applicable for Fonts in Writer
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
112857:
Cooper Hewitt OTF font not rendered correctly on Windows and Linux
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
113243:
Previews with white text is blank on white background
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
115009:
A feature request - language and unicode use enhancement
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
152533:
Font preview in Characters dialog uses the wrong font for common characters
[RESOLVED FIXED; assigned to khaled]
-
152737:
Font preview in Characters dialog uses the wrong font for first Complex character
[RESOLVED FIXED; assigned to khaled]
-
158320:
No more font live preview (on hovering) in Calc
[VERIFIED FIXED; assigned to caolan.mcnamara]
-
159673:
Selection of fonts, their efficiency, and compatibility with the Arabic language.
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
113438:
[META] Font name combobox bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
122119:
UI checkbox is not fully displayed in Font features (Format cells dialog)
[NEW; assigned to caolan.mcnamara]
-
125327:
Padding to text labels of the tabs on the Format Cells or Character dialogs need a bit more space before and after the label
[NEW; assigned to libreoffice-bugs]
-
127934:
Make Cell Format dialog HIG conform
[NEW; assigned to libreoffice-bugs]
-
132215:
.uno:EditStyle should open the "format cells" dialog
[NEW; assigned to libreoffice-bugs]
-
138221:
Mixed currency formatting being changed to only one currency type after adding decimal place to an interval
[NEW; assigned to libreoffice-bugs]
-
53654:
FORMATTING: Format Cells dialog; Alignment tab; Text orientation
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
60127:
Allow Empty Rotation-Degrees-Pane
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
63551:
FORMATTING: Format cell dialogue in Calc wait very long (8 second) to pop up
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
84195:
UI: Inconsistent behaviour "Wrap text automatically" and "Shrink to fit cell size"
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
97251:
Unhide text direction cell/paragraph attribute
[RESOLVED FIXED; assigned to philipz85]
-
115950:
EDITING: Crash while selecting cell format with double-click
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
120476:
UI : cell formatting dialog too big and not resizable
[VERIFIED FIXED; assigned to caolan.mcnamara]
-
122356:
Double-click on format in Format Cells:Number format closes dialog without doing anything
[VERIFIED FIXED; assigned to caolan.mcnamara]
-
153913:
FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
156710:
GTK3: Cell format dialog not resizable and its height increases each time the border tab is used.
[RESOLVED FIXED; assigned to andreas.heinisch]
-
42989:
FORMATTING: Selecting Multiple Cells with Different Formats Show as Same Format and Can't Be Changed as a Group
[NEW; assigned to libreoffice-bugs]
-
112358:
EDITING: Undo of style formatting doesn't show affected cells
[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]
-
119455:
can't change cellstyles properties (soft format) if a sheet is protected
[NEW; assigned to libreoffice-bugs]
-
123428:
FILESAVE XLSX Saving as xlsx in Calc creates new styles from the default ones
[NEW; assigned to libreoffice-bugs]
-
124852:
Heading characters much too big when copy-paste as GDI metafile
[NEW; assigned to libreoffice-bugs]
-
138506:
Retain modified style format (instead of using the default built-in style format) when copy cell range and paste as GDI format in Draw
[NEW; assigned to libreoffice-bugs]
-
138863:
Superordinate object of cells should be sheet, not page
[UNCONFIRMED; assigned to libreoffice-bugs]
-
143100:
Disable cell style commands and sidebar when sheet is protected
[REOPENED; assigned to libreoffice-bugs]
-
143349:
Introduce style to unprotect cells
[NEW; assigned to libreoffice-bugs]
-
149227:
duplicate style in styles tab of sidebar
[NEW; assigned to libreoffice-bugs]
-
150414:
Cell / font formatting lost when data linked from external data
[NEW; assigned to libreoffice-bugs]
-
155714:
Calc: when selecting the whole row and change the font size, some contents covered by other styles wouldn't be changed
[NEW; assigned to libreoffice-bugs]
-
156689:
Deleting empty column(s) removes styling / formatting of adjacent column
[NEW; assigned to libreoffice-bugs]
-
158601:
Page direction not the same as sheet direction
[UNCONFIRMED; assigned to libreoffice-bugs]
-
159603:
link the scaling-factor with the sheet-name
[UNCONFIRMED; assigned to libreoffice-bugs]
-
161006:
[UI] Calc - Format - Page Style has problems for KF5 and GEN VCL_PLUGINS
[NEW; assigned to libreoffice-bugs]
-
61086:
Style error in calc
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
77569:
Add entry "Choose Themes" to menu "Format" to actually make Calc feature accessible to users
[RESOLVED FIXED; assigned to philipz85]
-
82654:
FILESAVE, FILEOPEN: style name prefixed with "Excel Built-in"
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
90937:
Default set of calc cell styles
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
105429:
Names of new default set of cell styles not localized
[NEW; assigned to libreoffice-bugs]
(*)
-
103330:
SIDEBAR: Unable to modify new default cell styles
[RESOLVED FIXED; assigned to markus.mohrhard]
-
103331:
Child styles not inheriting from parent
[VERIFIED FIXED; assigned to kohei]
-
103332:
New default cell styles dont appear in TDF builds
[RESOLVED FIXED; assigned to markus.mohrhard]
-
103380:
New default cell styles shouldnt be deletable but should be hideable
[RESOLVED FIXED; assigned to markus.mohrhard]
-
105429:
Names of new default set of cell styles not localized
[NEW; assigned to libreoffice-bugs]
-
103331:
Child styles not inheriting from parent
[VERIFIED FIXED; assigned to kohei]
(*)
-
107333:
'Apply Style' drop down only lists the 'Default' cell style
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
107964:
'Choose Themes' command no longer works
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
108016:
Calc: Insert Row Above should use format of selected row instead of previous row
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
108188:
PageStyle property "isInUse" is always true
[RESOLVED FIXED; assigned to andreas.heinisch]
-
112559:
FILESAVE: ODS - Default cell style font size not set
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
115588:
Calc refers to non-existing N2 data style
[RESOLVED FIXED; assigned to quikee]
-
117871:
add ability to import/load of styles in Calc as there is in Writer
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
118523:
Perf: Sidebar: Opening style page with many cell styles is slow
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
122110:
FILESAVE XLSX, One of the cell changes its textcolor to blue for no apparent reason.
[VERIFIED FIXED; assigned to erack]
-
122593:
UI: Focus off. Not able to enter the style name immediately after style creating
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
133717:
enhancement request - FORMATTING calc sheet-specific page orentation
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
141607:
FILEOPEN XLSX Cell background colour missing (patternFill)
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
143532:
Dragging date with Ctrl and filter bottom-up overwrites invisible values
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
152800:
Changes to border format in cell style should persists even if no border is set, so it can be used as a default for new borders (comment 2)
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
(*)
-
153510:
Conditional formatting with STYLE and incorrect (case) style name -> continuous CPU consumption, menus not drawn in some UI renders
[RESOLVED FIXED; assigned to mikekaganski]
-
153514:
STYLE finds wrong style with different case
[RESOLVED FIXED; assigned to mikekaganski]
-
154067:
Cell styles cannot have other than Default as top level parent
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
158254:
Can not apply any cell styles to the right of area with content
[VERIFIED FIXED; assigned to mikekaganski]
-
159042:
crash after changing cell style (if some cells already have direct formatting)
[VERIFIED FIXED; assigned to serval2412]
-
34914:
page border in Calc works incorrect
[NEW; assigned to libreoffice-bugs]
-
107450:
[META] Cell and sheet protection bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
45191:
Add option for message "Protected Cells Cannot be Modified" also for Delete key (as for Backspace)
[NEW; assigned to libreoffice-bugs]
-
48762:
FORMATTING: Pasting rich text into unprotected cell changes the cell to protected
[NEW; assigned to libreoffice-bugs]
-
55969:
BASIC: API methods for select-protected-cells
[NEW; assigned to libreoffice-bugs]
-
57086:
FORMATTING: in a spreadsheet with partial protection: allow modifying cell styles that are not used on a protected sheet
[NEW; assigned to libreoffice-bugs]
(*)
-
57091:
FORMATTING: Allow more options for Allow all users when the sheet is protect
[NEW; assigned to libreoffice-bugs]
-
57102:
FORMATTING: in a spreadsheet with partial protection: give warning that cell styles cannot be changed
[NEW; assigned to libreoffice-bugs]
(*)
-
67352:
Editing: Permit to change cell width/height on protected cell
[NEW; assigned to libreoffice-bugs]
-
70379:
Cannot resize columns with protected cells / Calc does not respect users' permissions
[NEW; assigned to libreoffice-bugs]
-
78862:
Feature request: Cell protection with strong encryption and other file security possibilities
[NEW; assigned to libreoffice-bugs]
-
79419:
set password for specific range of cells
[NEW; assigned to libreoffice-bugs]
-
87476:
EDITING: "Validity..." functional to unprotected cells when sheet is protected
[NEW; assigned to libreoffice-bugs]
-
88108:
Feature request - Option to lock formatting on cells and/or entire sheet, while allowing editing
[NEW; assigned to libreoffice-bugs]
-
96157:
After multiple select of cells, it is possible to copy on a protected cell
[NEW; assigned to libreoffice-bugs]
-
102162:
FORMATTING: Protected cell can be unprotected copy pasting them to a new document
[NEW; assigned to libreoffice-bugs]
-
106952:
Update cell style can bypass cell protection
[NEW; assigned to libreoffice-bugs]
(*)
-
118907:
Password creation dialogs do not warn if CapsLock is on
[NEW; assigned to libreoffice-bugs]
-
120680:
Menu entries for shapes should be disabled in protected mode
[NEW; assigned to libreoffice-bugs]
-
122921:
EDITING XLSX The sheet protection allows different options in Calc and Excel
[NEW; assigned to libreoffice-bugs]
-
123974:
Paste into a protected Calc sheet should not paste the cell Protected status
[NEW; assigned to libreoffice-bugs]
-
139608:
Calc Named range: add option to be protected with sheet
[NEW; assigned to libreoffice-bugs]
-
139883:
Calc refuses to edit an unprotected cell in a protected worksheet when the selected range includes protected cells
[NEW; assigned to libreoffice-bugs]
-
140571:
Hide Formula NOT compatible with FORMULA function name
[NEW; assigned to libreoffice-bugs]
-
140787:
Introduce an option for cell formatting on protected sheets
[NEW; assigned to libreoffice-bugs]
-
141913:
Bypass cell protection selection via Name box
[NEW; assigned to libreoffice-bugs]
-
143349:
Introduce style to unprotect cells
[NEW; assigned to libreoffice-bugs]
(*)
-
144292:
Cannot select and adjust image in unprotected cell of protected sheet
[NEW; assigned to libreoffice-bugs]
-
149497:
Add option to allow sorting content in protected sheets
[NEW; assigned to libreoffice-bugs]
-
150505:
Whole-row protections are inconsistent between LO 7.3 and 7.4
[NEW; assigned to libreoffice-bugs]
-
150910:
[EDITING] Protected status only is pasted if the source cells belong to one row.
[NEW; assigned to libreoffice-bugs]
-
152327:
"Select unprotected cells" when no cells are unprotected makes data entry impossible
[NEW; assigned to libreoffice-bugs]
-
152371:
Hidden cells create a new empty page
[NEW; assigned to libreoffice-bugs]
-
158682:
Calc: Move rows with protected cells does not give warning
[NEW; assigned to libreoffice-bugs]
-
159191:
"Select Unprotected Cells" does not work if selection active
[NEW; assigned to libreoffice-bugs]
-
160740:
cell styles in protected sheets lose background colours
[NEW; assigned to libreoffice-bugs]
-
43087:
UI: Missing message "cell protected" when Trying to modify or delete protected contents
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
43720:
Calc: Cells background color is printed even when cell protection is "hide from printing"
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
51181:
Pasting from data source changes cell protection
[RESOLVED INVALID; assigned to libreoffice-bugs]
-
71532:
EDITING: Ctrl+; insert current date/time although cell and sheet is locked.
[CLOSED DUPLICATE; assigned to libreoffice-bugs]
-
95883:
CALC: Add option to clear all unprotected cells in protected sheet
[VERIFIED FIXED; assigned to gulsah.1004]
-
99884:
Printing a file which protected cells with too much content get printed in the cell above
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
104250:
FILEOPEN XLSX: password is not required for unlocking protected sheet
[RESOLVED FIXED; assigned to erack]
-
106965:
Copy/Paste can bypass cell protection after multiple select of cells or sheets
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
107240:
EDITING Insert > Date | Time inserts some content into protected cells
[RESOLVED FIXED; assigned to xiscofauli]
-
119190:
Protecting sheets removes the all cell comments in LibreOffice Calc if the file format had been given as 'xlsx'
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
120873:
KDE5: Flag 'Cell protection' is removed, but cell is still protected
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
133257:
The protection icon does not show in front of sheeet name when lock a sheet from LibreOffice BASIC.
[RESOLVED FIXED; assigned to anshukhare50]
-
136003:
PROTECT SHEET: Can't delete rows, despite of allow to deletes
[RESOLVED FIXED; assigned to sahil]
-
136092:
Sheet protection function
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
144097:
FILEOPEN generated XLSX: Inconsistent handling of protection in the presence of fonts
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
151752:
Calc: Crash after copy and paste all unprotected cells
[VERIFIED FIXED; assigned to mattkse]
-
156793:
Can't remove cell protection from all cells (steps in comment 10)
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
45191:
Add option for message "Protected Cells Cannot be Modified" also for Delete key (as for Backspace)
[NEW; assigned to libreoffice-bugs]
-
107575:
[META] Number format bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
33962:
Add feature that replaces numbers and dates, formatted as text, with real numbers (formerly: Add CT2N Extension)
[NEW; assigned to libreoffice-bugs]
-
37755:
FORMAT: formats genering text strings (from cell content) doesn't adhere to text alignment format.
[NEW; assigned to libreoffice-bugs]
-
42607:
Help + Docu should explain importance of settings 'Calc-Calculate-Date base setting' for document import and copy dates
[NEW; assigned to libreoffice-bugs]
-
44453:
FILESAVE FILEOPEN .xls: EXCEL Leap year bug has to be mentioned
[NEW; assigned to libreoffice-bugs]
-
45952:
Format Cells: Binary and Hex with digit grouping
[NEW; assigned to libreoffice-bugs]
(*)
-
46448:
Allow custom locale settings for decimal separator, group separator, default date and time formats
[NEW; assigned to libreoffice-bugs]
-
52929:
[EDITING] Special number format for complex numbers
[NEW; assigned to libreoffice-bugs]
-
55960:
Filling cells with incremental numbers – wrong numbers
[NEW; assigned to libreoffice-bugs]
-
60777:
FORMATTING sum of different currencies should not be one of these currencies
[NEW; assigned to libreoffice-bugs]
-
63536:
Add Accounting format code to currency list
[NEW; assigned to libreoffice-bugs]
-
63848:
Better default formatting after user editing of a cell
[NEW; assigned to libreoffice-bugs]
-
66183:
FORMATTING: Save/store User Defined Formats for Future Use
[NEW; assigned to libreoffice-bugs]
-
66319:
returned complex numbers use decimal point regardless of locale
[NEW; assigned to andreas.heinisch]
-
68045:
User defined date acceptance patterns are used only for default language
[NEW; assigned to libreoffice-bugs]
-
75627:
General number format change leads to inconsistent/lost formatting
[NEW; assigned to libreoffice-bugs]
-
76245:
Other: Support IEEE 754-2008 (ISO/IEC/IEEE 60559:2011) binary128 quadruple precision
[NEW; assigned to libreoffice-bugs]
-
77834:
FORMATTING: Option to keep numeric precision (significant figures) as entered
[NEW; assigned to libreoffice-bugs]
-
77951:
FORMATTING: Enhancement Request - Specify number of significant figures, not just decimal places.
[NEW; assigned to libreoffice-bugs]
-
84641:
Standard Date Format cannot be permanently changed to dd.mm.yyyy or yyyy-mm.dd
[NEW; assigned to libreoffice-bugs]
-
85410:
Remove Decimal Space button causes 10 decimals before it decreases one at a time
[NEW; assigned to libreoffice-bugs]
-
89944:
Please unify indication of "[NatNum5]#, ## 0"
[NEW; assigned to libreoffice-bugs]
-
90791:
Accounting format broken for Thai Baht (THB) [$฿-41E]
[NEW; assigned to libreoffice-bugs]
-
91038:
Importing xls with cell format on money, after changing page layout and saving, formating is changed do decimal values
[NEW; assigned to libreoffice-bugs]
-
91124:
Numbers in base other than ten
[NEW; assigned to libreoffice-bugs]
-
96954:
setting General number format does not work with selected cells if they are formatted to different number formats
[NEW; assigned to libreoffice-bugs]
-
100593:
Add fraction number format option to reduce forced denominator
[NEW; assigned to libreoffice-bugs]
-
101808:
no option to set length in settings of cells as TEXT
[NEW; assigned to libreoffice-bugs]
-
103414:
Allow decimal place commands to modify additional number formats
[NEW; assigned to libreoffice-bugs]
-
107993:
FORMATTING: Free space filling broken with thousands separator
[NEW; assigned to libreoffice-bugs]
-
108373:
Conditional formatting changes format of dates and numbers
[NEW; assigned to libreoffice-bugs]
-
112631:
[META] Number format content panel of the Properties deck/tab of the sidebar
[NEW; assigned to libreoffice-bugs]
-
95385:
Sidebar : category General does not exist and inconsistent with cell formatting dialog (see comment 7, comment 8, comment 21)
[NEW; assigned to libreoffice-bugs]
-
112472:
"Number" number format listbox entry should toggle the format as number uno command
[NEW; assigned to libreoffice-bugs]
-
95019:
SIDEBAR: Add "Format as number" icon to sidebar
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
114216:
Thousands separator check box incorrect after change from scientific to number
[RESOLVED FIXED; assigned to raykowj]
-
114516:
Selecting Date in sidebar number format dropdown disables cell input on double click
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
114519:
Sidebar Number Format drop down does not update cell contents on number format selection change
[RESOLVED FIXED; assigned to raykowj]
-
95385:
Sidebar : category General does not exist and inconsistent with cell formatting dialog (see comment 7, comment 8, comment 21)
[NEW; assigned to libreoffice-bugs]
-
113072:
[META] Numbering format presets for lists, pages, etc
[NEW; assigned to libreoffice-bugs]
-
36574:
[FORMATTING] Can't make default Writer bullet types locale dependent (french bullets / dash bullets)
[NEW; assigned to libreoffice-bugs]
-
37610:
More bullet sizes would be helpful
[NEW; assigned to libreoffice-bugs]
-
52048:
FORMATTING: Support user-defined identifier sequences (numbering) for ordered lists (refer comment 4)
[NEW; assigned to libreoffice-bugs]
-
98086:
FORMATTING: Support reduced Latin numbering style for lists, without q, w, y
[NEW; assigned to libreoffice-bugs]
-
124608:
Add a spellout outline numbering style
[NEW; assigned to libreoffice-bugs]
-
128640:
Numbering List Presets in Bulgarian (4x), Russian (4x), Serbian (4x)
[NEW; assigned to libreoffice-bugs]
-
138462:
Adding bullet/footnote/endnote/page number in Bengali language
[NEW; assigned to libreoffice-bugs]
-
160042:
numbering style bugs
[NEW; assigned to libreoffice-bugs]
-
42558:
FORMATTING: Missing Arabic Abjad numerals for page numbers
[RESOLVED FIXED; assigned to erack]
-
57337:
FORMATTING: Impossible to configure the default bullet styles
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
66212:
Hebrew Numbering incorrect above value ten (seeing Kaf instead of Yod Aleph)
[RESOLVED FIXED; assigned to yossizahn]
-
77803:
Implement separate numbering styles for Chinese and Japanese (they're similar, but not the same)
[RESOLVED FIXED; assigned to suokunlong]
-
103345:
FILEOPEN: Non-English numbering characters "①, ②, ③", "α, β, γ" are converted to digits (1,2,3)
[VERIFIED FIXED; assigned to samuel.mehrbrodt]
-
106507:
Add 4 more default bullet types to toolbar split button and dialog
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
113356:
Numbering formats appearing as blank entries
[RESOLVED FIXED; assigned to caolan.mcnamara]
-
114078:
Numbering format strings no longer found in pootle
[RESOLVED FIXED; assigned to caolan.mcnamara]
-
114622:
add static list of available Native Numbering entries, for example Persian / Arabic-Indic / Hindi numbers
[RESOLVED FIXED; assigned to xsoh.k7]
-
115679:
FORMATTING: can not make a zero-padded numbered list format
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
115951:
Arabic alphabet page number format is not showing correctly
[RESOLVED FIXED; assigned to caolan.mcnamara]
-
120214:
Grammatical gender concordance for "spell out" numbering feature
[RESOLVED NOTOURBUG; assigned to libreoffice-bugs]
-
120629:
FILESAVE DOC: Hebrew numbering sequence choice reverted to 1,2,3... when saving as .doc
[RESOLVED FIXED; assigned to jluth]
-
143433:
When inserting a FOOTNOTE or ENDNOTE, allow user to chose an alternative anchor character style
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
145239:
Customize footnote symbols
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
36574:
[FORMATTING] Can't make default Writer bullet types locale dependent (french bullets / dash bullets)
[NEW; assigned to libreoffice-bugs]
-
113307:
Conditional formatting: false cell number format displayed that's defined by a cell style
[NEW; assigned to libreoffice-bugs]
-
115078:
Automatically insert a decimal point like in Excel
[NEW; assigned to libreoffice-bugs]
-
115335:
Formatted cell text is not exposed to assistive technologies
[NEW; assigned to libreoffice-bugs]
-
116106:
FORMATTING: LO Calc Date as Number lost in saving
[NEW; assigned to libreoffice-bugs]
-
117365:
Decimal separator is not updated on language change
[NEW; assigned to libreoffice-bugs]
-
118337:
Evenly fill space between repeated character-fill in number formats
[NEW; assigned to libreoffice-bugs]
-
118345:
FILESAVE: Decimal part of scientific numbers not correctly saved in ODF with '?'
[NEW; assigned to libreoffice-bugs]
-
119509:
FORMATTING: cells with a General format are formatted to the result type and calculation not as desired in ODS (OK in XLSX)
[NEW; assigned to libreoffice-bugs]
-
121851:
Calc loses time zone information for datetime cells
[NEW; assigned to libreoffice-bugs]
-
122756:
Unable to clone currency and other cell Number format in a Writer table
[NEW; assigned to libreoffice-bugs]
-
123113:
type french date with field correctly (first day = "1ER")
[NEW; assigned to libreoffice-bugs]
-
124807:
Cell formatting and calculations of Sexagesimal (base 60) angular measurement, aka DMS
[NEW; assigned to libreoffice-bugs]
-
127473:
Regression: Formatting error using format "TT.MM.JJJJ HH:MM:SS,000000000000000000"
[NEW; assigned to libreoffice-bugs]
-
128273:
FORMATTING Calc changes a number format
[NEW; assigned to libreoffice-bugs]
-
129826:
Storing language based user defined format codes of cells does not work for color code based entries.
[NEW; assigned to libreoffice-bugs]
-
132111:
Initial cell's number format in Writer table is reported wrong
[NEW; assigned to libreoffice-bugs]
-
132244:
Support ‰ (per mille) number format
[NEW; assigned to libreoffice-bugs]
-
135541:
Dates are entered inconsistently, switching between day and month.
[NEW; assigned to libreoffice-bugs]
-
135826:
EDITING: Copy and paste a cell changes the content from '27-Jul-93' to '27-Jul-89' (1904 vs 1900 epoch nulldate)
[NEW; assigned to libreoffice-bugs]
-
139517:
Calc: Date values toggle between date and text when changed
[NEW; assigned to libreoffice-bugs]
-
141303:
Style of page numbering isn't applied on PDF page number display on PDF viewer
[NEW; assigned to libreoffice-bugs]
-
141870:
Fractional formatting: Sequence of preferred denominators (Base 2 mainly); also Writer TextFields
[UNCONFIRMED; assigned to libreoffice-bugs]
-
142093:
EDITING: Paste Special Date&Time inconsistent for no option, transpose and as link
[NEW; assigned to libreoffice-bugs]
-
146404:
Number Format Code: Not all color codes are saved
[NEW; assigned to libreoffice-bugs]
-
149898:
Calculating datetime differences - different results depending on number format
[NEW; assigned to libreoffice-bugs]
-
150264:
FORMATTING: UI improvements to add automatic data validation of dates
[NEW; assigned to libreoffice-bugs]
-
153010:
Inconsistency and confusing strings when numeric field's numbering format is not available for a language
[NEW; assigned to libreoffice-bugs]
-
153213:
[NatNum12] does not handle fractions properly
[NEW; assigned to libreoffice-bugs]
-
153495:
Make an easier workflow for Calc cell user-defined formats cleanup
[NEW; assigned to libreoffice-bugs]
-
154131:
Add option to not detect numbers in scientific notations (like 1E1 or 5E2) at text paste / import
[ASSIGNED; assigned to jumbo4444]
-
157612:
Calc blank digit ('?') format have the wrong width
[NEW; assigned to libreoffice-bugs]
-
159930:
Minus sign mis-placed with format ".00" until save/reload
[NEW; assigned to libreoffice-bugs]
-
33689:
Date format problem using the Dutch (NL) localization
[CLOSED FIXED; assigned to jumbo4444]
-
42518:
No warning when wrong decimal separators are used, resulting in bad outcome for formulas in tables
[RESOLVED FIXED; assigned to erack]
-
46452:
Default formatting can not be changed
[CLOSED DUPLICATE; assigned to libreoffice-bugs]
-
49540:
Writer tables loosing numbers when switching the language in the number format
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
51059:
Formatting: Allow Thin Space as alternative thousands separator for all languages
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
62128:
FORMATTING: Allow replacing comma with anything else in number format #,##0
[CLOSED DUPLICATE; assigned to libreoffice-bugs]
-
66089:
FORMATTING: Wrong currency (and number) format from file created with Excel (see comment #17 for instructions to reproduce!)
[VERIFIED FIXED; assigned to aron.budea]
-
66584:
EDITING: Format cell..
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
67822:
Digits in number formatting are lost
[CLOSED FIXED; assigned to libreoffice-bugs]
-
69356:
FORMATTING: DDDDD ordinal day date format not yet available
[CLOSED FIXED; assigned to libreoffice-bugs]
-
73713:
FILESAVE: when saving as .XLS cell formatting of blank cells is not remembered
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
76441:
FORMATTING: MM:SS time input if formatted as such
[RESOLVED FIXED; assigned to erack]
-
83301:
Allow more than 3 conditional format codes
[CLOSED WONTFIX; assigned to libreoffice-bugs]
-
84964:
Number Format: Currency does not follow System Preferences (OSX 10.9.5)
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
86119:
TOOLBAR: Number Format Decimal and Standard doesnt show toggle correctly
[RESOLVED FIXED; assigned to gulsah.1004]
-
86132:
TOOLBAR: Improvement to number format tooltips
[RESOLVED FIXED; assigned to philipz85]
-
86700:
Add more Number Formats
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
90684:
Hide decimal separator if number has no decimal part and no trailing zeroes are to be shown
[CLOSED WONTFIX; assigned to libreoffice-bugs]
-
90826:
number format with text gives sign at wrong position
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
91405:
calc does not save explicitly defined cell formatting for date functions
[CLOSED WORKSFORME; assigned to libreoffice-bugs]
-
93469:
FILESAVE: ODS - User defined number formats with question marks not retained
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
96578:
EDITING and FILESAVE xlsx file shows wrong number/format (with Polish locale..?)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
96711:
Add russian rouble new format to money formats
[CLOSED FIXED; assigned to erack]
-
96723:
FILESAVE: custom cell number format with embedded text in decimal part not saved in ods
[VERIFIED FIXED; assigned to jumbo4444]
-
98362:
Behavior interpreting input: 1-, 1+ are treated as number, not as text
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
98590:
Confusing behavior when cell with number is changed to format Text: no indication if cell value type is number or text
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
100822:
FILEOPEN: xlsx file: imported DateTime cells are empty with certain non-en_US locales (Excel 2010 compatible)
[RESOLVED FIXED; assigned to erack]
-
102075:
FILEOPEN: XLSX - Date shown as "[$-F400]H:MM:SS AM/PM" instead of according to locale
[RESOLVED FIXED; assigned to erack]
-
103173:
FILESAVE: XLSX - Calc doesn't save/load cell's Number Format language/locale
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
104158:
Crash upon opening Table -> Number Format... in Writer
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
105720:
Left-aligned currency symbols in currency fields are displayed in the middle of the preceding cell (in some builds)
[VERIFIED FIXED; assigned to mrcekets]
-
106322:
Applying a number format changes textual content to 0 (happens also when applying a table style)
[RESOLVED FIXED; assigned to erack]
-
108338:
Numeric formatting using the _ does not work
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
108588:
FILEOPEN: XLSX - Incorrect cell date formatting when locale is en-GB
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
112844:
FORMATTING Decimal places should be reset when value is 0
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
114927:
In the Austrian localization of Calc the German word "Januar" isn't recognized as a date.
[VERIFIED FIXED; assigned to erack]
-
115093:
FORMATTING: Copying date formats in cells changes date for all cells in column
[VERIFIED FIXED; assigned to dennisfrancis.in]
-
115528:
Datetime2 extension gives error in LO 6.0.0.3 (locale-dependent)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
116450:
CONVERSION FORMAT DATE
[CLOSED WONTFIX; assigned to libreoffice-bugs]
-
116579:
Date format setting not recognised
[RESOLVED FIXED; assigned to erack]
-
117575:
Number formats: Thousands separator should be space if not preceded by a digit.
[RESOLVED FIXED; assigned to jumbo4444]
-
118324:
Blank digit ('?') in integer not saved correctly in ODF spreadsheets (works in .xlsx)
[RESOLVED FIXED; assigned to jumbo4444]
-
118338:
Character-fill doesn't work with space thousand separators
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
118682:
FILESAVE DOCX formula field exported as plain text, losing the formula
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
119586:
FORMATTING: Changing the thousands separator in number format loses separators for digit grouping in numbers from million and above
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
120648:
Character format not preserved in Writer table when saved. TABLE
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
121499:
Wish: Add Number format for representation of school grades (Calc)
[CLOSED WONTFIX; assigned to libreoffice-bugs]
-
123752:
EDITING: Regression in handling of the group separator in formula context
[VERIFIED FIXED; assigned to erack]
-
124209:
AM/PM time notation in CALC
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
124994:
Cell Formatting for URL websites, or other URI schemes
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
127363:
Add Sept as an abbreviation of September
[VERIFIED FIXED; assigned to erack]
-
128314:
Obscure and unmanageable long month name capitalization rules in date formats (ru-RU)
[RESOLVED FIXED; assigned to erack]
-
129613:
NEW FORMAT:Some characters with the any symbol
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
131312:
calc: funny / odd / wrong display of value in scientific format
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
133342:
FORMATTING Preserve space in French percentage when Add/Delete decimal places
[RESOLVED FIXED; assigned to jumbo4444]
-
135103:
Decimal precision fail in addition
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
136050:
Calc changes the cell type from time to date when the format-code is changed
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
138288:
Formatting numbers to currency (ZAR) not functional
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
140052:
FORMATTING, FILEOPEN, FILESAVE: Custom number cell format changed after save/open file
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
142186:
Cell formatting code #,##0"." receives input field 123.45 as 12345
[VERIFIED FIXED; assigned to erack]
-
142216:
FILEOPEN XLSX Excel default time formats don’t match in Calc with Hungarian locale
[VERIFIED FIXED; assigned to erack]
-
143526:
Korean NumberFormats are missing and wrong on the Code
[RESOLVED FIXED; assigned to sungdh86]
-
145827:
'Standard' cell format turns to Date if it's the first cell in a column
[CLOSED DUPLICATE; assigned to libreoffice-bugs]
-
146367:
SUM() does not use approx summation anymore since Kahan summation is used
[RESOLVED FIXED; assigned to erack]
-
148184:
FORMATTING create a means to represent an integer as an IP Address
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
148434:
LibreOffice Calc Formatting Option for Leading Zeros in Numbers Does Not Format Correctly
[CLOSED INVALID; assigned to libreoffice-bugs]
-
148792:
Add currency from Mozambique - MZN
[VERIFIED FIXED; assigned to erack]
-
149428:
Formatting of number AFTER the decimal point not saved in .ods
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
150028:
Err:502 on formats with absolute seconds and millis
[VERIFIED FIXED; assigned to jumbo4444]
-
152724:
FILESAVE FORMATTING Cell custom Format Code with _- (UI visible space width) is not saved correctly
[RESOLVED FIXED; assigned to jumbo4444]
-
153023:
NatNum12 number format (spell out): thousand separator should be disabled
[RESOLVED FIXED; assigned to jumbo4444]
-
153993:
FORMATTING: ODF do not preserve embedded text and lowercase in scientific format
[RESOLVED FIXED; assigned to jumbo4444]
-
154218:
variable and user field input field mishandles datetime when locale uses decimal commas
[VERIFIED FIXED; assigned to erack]
-
154286:
Changing value of date fields fails as MM/DD/YYYY format is not recognized as date after last LibreOffice update
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
156449:
Number format: scientific notation do not respect '?' (blank) in exponent
[RESOLVED FIXED; assigned to jumbo4444]
-
158265:
Cell Format Date changes cell value in case of high resolution date/time values
[RESOLVED FIXED; assigned to erack]
-
158890:
FORMATTING: Custom number format trailing 0 replaced with figure space
[RESOLVED FIXED; assigned to jumbo4444]
-
159621:
Highlighting Positve Numbers Libre Office Calc
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
160319:
Calc: add constraints on Format Cells - Format Code
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
33962:
Add feature that replaces numbers and dates, formatted as text, with real numbers (formerly: Add CT2N Extension)
[NEW; assigned to libreoffice-bugs]
-
108013:
Unlike Excel, Calc fails to invert color of selection box and cursor to make them visible against a black background
[NEW; assigned to libreoffice-bugs]
-
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]
-
35296:
Defining Name to multiple selection in Calc
[NEW; assigned to libreoffice-bugs]
-
72594:
File links to range names don't work after re-opening file (unable to create VLOOKUP named range in another file)
[NEW; assigned to libreoffice-bugs]
-
87058:
column label functions do not update after inserting rows below title - needs save and reload including a hard recalc
[NEW; assigned to libreoffice-bugs]
-
94627:
FILEOPEN: CALC do not recognise cell names on .xlsb files
[NEW; assigned to libreoffice-bugs]
-
97967:
Highlighting of cell range just flash and disappear
[NEW; assigned to libreoffice-bugs]
-
103711:
The Eurosign € is not allowed in the name of an area inside the table
[NEW; assigned to libreoffice-bugs]
-
104990:
Named ranges do not follow the sort order.
[NEW; assigned to libreoffice-bugs]
-
108516:
Enhancement Request: allow for comments when defining named range
[NEW; assigned to libreoffice-bugs]
-
113237:
UI: autocomplete / suggest cell (range) names in cell range pickers
[NEW; assigned to libreoffice-bugs]
-
113680:
FILEOPEN XLS Named Ranges in form controls are dropped on open
[NEW; assigned to libreoffice-bugs]
-
123004:
EDITING: Sheet/Named ranges/Insert - Paste all, only pastes named ranges with global scope
[NEW; assigned to libreoffice-bugs]
-
127300:
[META] Issues with import/export/display of Excel built-in defined names
[NEW; assigned to libreoffice-bugs]
-
113596:
Default name of XLSX print ranges is displayed as _xlnm.Print_Area
[NEW; assigned to libreoffice-bugs]
-
118592:
FILEOPEN XLSX AutoFilter import erroneously requires FilterDatabase defined name
[NEW; assigned to libreoffice-bugs]
-
100034:
Impossible to persistently remove print-range restrictions in .xlsx spreadsheet
[VERIFIED FIXED; assigned to czeber.laszloadam]
-
109240:
FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing compatibility issue with Excel 2016 (file cannot be opened in Excel 2016)
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
112567:
FILESAVE XLSX Rows to Repeat and Columns to Repeat properties in XLSX files created with Calc are saved as incorrect Named ranges (w Hungarian locale)
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
112571:
FILESAVE XLSX New named range is created every time an Excel made spreadsheet that contains print ranges is saved as XLSX
[RESOLVED FIXED; assigned to aron.budea]
-
115159:
FILESAVE XLSX Print Titles are duplicated every time we export an XLSX file
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
127301:
FILESAVE XLSX Adjusting autofilter range creates extra name range
[VERIFIED FIXED; assigned to varga.balazs3]
-
154449:
Calc should support hidden Named Ranges for better MSO compatibility
[RESOLVED FIXED; assigned to rafael.palma.lima]
-
113596:
Default name of XLSX print ranges is displayed as _xlnm.Print_Area
[NEW; assigned to libreoffice-bugs]
-
131938:
If a data range is defined in a document, it is partly translated in formulas into the normal cell range after saving and re-opening the document
[REOPENED; assigned to libreoffice-bugs]
-
132358:
Part of content of window "Manage Names" not refreshed after deletion of named ranges
[NEW; assigned to libreoffice-bugs]
-
137577:
UI: resolve ambiguity for 'named ranges' with identical name and different scope
[NEW; assigned to libreoffice-bugs]
-
145185:
Name box -> Manage Names -> Range Options -> 'Filter' is not persisted when saved in xlsx format (Steps in comment 6)
[NEW; assigned to libreoffice-bugs]
-
145994:
references to named ranges in external files do not update on document open
[NEW; assigned to libreoffice-bugs]
-
156673:
Merged cells defined name display and creation differs in version 7.x to previous versions
[NEW; assigned to libreoffice-bugs]
-
159432:
Sort and/or filter Named Ranges And Expressions from Manager
[NEW; assigned to libreoffice-bugs]
-
159633:
UI: tables in which items can be "matched" by typing characters don't allow hyphen or underscore searches (- and _)
[NEW; assigned to libreoffice-bugs]
-
160255:
Named Ranges Should Be Able to be Used in Conditional Formatting Dialog Box
[UNCONFIRMED; assigned to libreoffice-bugs]
-
64086:
Fileopen: named cell ranges from MSO are not imported in charts (because not supported in LO)
[VERIFIED FIXED; assigned to varga.balazs3]
-
64595:
: When importing an Excel file named ranges duplicated across sheets corrupted
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
64885:
EDITING: range name completion doesn't understand that names can contain underscores
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
66250:
Use a Named range as data source for Chart
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
67007:
UI: Name Box does not show a name in sheet scope when selecting a range
[VERIFIED FIXED; assigned to erack]
-
67492:
No support for named range subaddressing
[CLOSED FIXED; assigned to libreoffice-bugs]
-
81293:
The dialog “manage names” forgets size and column width settings
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
81295:
Name Scope Handling is Incorrect
[CLOSED WONTFIX; assigned to libreoffice-bugs]
-
81435:
Names lose reference information when copying cell ranges (re-open at comment 16)
[CLOSED FIXED; assigned to libreoffice-bugs]
-
82211:
Manage Names pop-up re-size re-sizes wrong element
[VERIFIED FIXED; assigned to andreas.heinisch]
-
94423:
UNO/Java: cannot retrieve Named Ranges from .ods, but can from .xls/.xlsx
[RESOLVED NOTOURBUG; assigned to libreoffice-bugs]
-
99991:
UI: dialog Manage Names loses set individual size when Range Options is chosen
[RESOLVED FIXED; assigned to andreas.heinisch]
-
108989:
Add contextual UNO commands for name ranges and data validity to context menu
[VERIFIED FIXED; assigned to gulsah.1004]
-
109240:
FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing compatibility issue with Excel 2016 (file cannot be opened in Excel 2016)
[RESOLVED FIXED; assigned to libreoffice-bugs]
(*)
-
113991:
Named ranges without sheet reference are exported as corrupted XLS(X)
[RESOLVED FIXED; assigned to jluth]
-
114487:
Importing HTML creates questionable named ranges
[RESOLVED FIXED; assigned to jluth]
-
116670:
Manage Names Dialog does not repaint after resize
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
123724:
EDITING: sheet local named ranges become corrupt during deletion of sheet
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
148072:
Sheet-local named expression destroyed with Cut-Paste-Undo
[RESOLVED FIXED; assigned to erack]
-
157318:
Named ranges defined at the sheet level are not exported to XLSX
[RESOLVED FIXED; assigned to rafael.palma.lima]
-
160064:
Named ranges created by the Solver should be hidden by default
[RESOLVED FIXED; assigned to rafael.palma.lima]
-
35296:
Defining Name to multiple selection in Calc
[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]
(*)
-
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]
-
108364:
[META] Table/Row/Column/Cell management function bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
39936:
UI: Right Click on Row/Column -> Insert Copied Cells... (paste + shift cells in one click)
[ASSIGNED; assigned to balazs.varga991]
-
46930:
[UI] moving rows or columns by Drag and Drop of Row / Column Headings should be possible
[NEW; assigned to libreoffice-bugs]
-
49258:
EDITING TABLES: No easy way to move
[NEW; assigned to libreoffice-bugs]
-
52359:
"Show Details" won't work as expected
[NEW; assigned to libreoffice-bugs]
-
53072:
Format > Columns should insert columns PRIOR to cursor paragraph i.e., in keeping with Insert > Section
[NEW; assigned to libreoffice-bugs]
-
55963:
UI: option 'Shift cells up/left' not available for 'Delete cells' when Track Changes on
[NEW; assigned to libreoffice-bugs]
-
56105:
FILEOPEN Column width shown wrong, if observed before selecting whole column and column includes merged cells (see comment 7)
[NEW; assigned to libreoffice-bugs]
-
57361:
Can't resize wide columns; mouse scrolling is also broken
[NEW; assigned to libreoffice-bugs]
-
58440:
EDITING: Moving cells/columns/rows with drag and drop and modifier keys do not work as advertised (see comment #48)
[NEW; assigned to libreoffice-bugs]
-
59345:
merging complete columns or rows
[NEW; assigned to libreoffice-bugs]
-
66472:
A suggestion for better ergonomics for column, row, and cell actions in Calc
[NEW; assigned to libreoffice-bugs]
-
70379:
Cannot resize columns with protected cells / Calc does not respect users' permissions
[NEW; assigned to libreoffice-bugs]
(*)
-
70618:
Rows modified by spellchecking function
[NEW; assigned to libreoffice-bugs]
-
73468:
Splitting cell with 2 or more paragraphs horizontally should move part of text into newly created row(s)
[NEW; assigned to libreoffice-bugs]
-
74403:
EDITING: Drag-and-drop rows with Alt or Ctrl+Alt could allow better set of destination rows
[NEW; assigned to libreoffice-bugs]
-
80390:
EDITING: No INSERT ROWS ... (dialog box that allows adding a set number of rows)
[ASSIGNED; assigned to sahil]
-
81397:
FORMATTING: When the Default cell style's font size is modified, new sheets do not use corresponding row height
[NEW; assigned to libreoffice-bugs]
(*)
-
81480:
Show menuitem has no function in some cases
[NEW; assigned to libreoffice-bugs]
-
83568:
FORMATTING: Row Height not changing below 10pt since LO 4.2 (see also comment 9)
[NEW; assigned to libreoffice-bugs]
-
87873:
Merged cells still allow resizing between them in Writer
[NEW; assigned to libreoffice-bugs]
-
88071:
Disable sheet manipulation functions when in edit mode
[NEW; assigned to libreoffice-bugs]
-
88460:
EDITING: Problem inserting cell when tracing dependents (recalculate F9 needed)
[NEW; assigned to libreoffice-bugs]
-
88476:
Justify changes cell height from 0,53 to 0,61 cm
[NEW; assigned to libreoffice-bugs]
-
88753:
LibreOffice Calc - Insert Row inherits styling but not calculation functions in new cells as exist in adjacent cells
[NEW; assigned to libreoffice-bugs]
-
89333:
EDITING: Cannot shift cells (left or up) from a non contiguous selection when deleting
[NEW; assigned to libreoffice-bugs]
-
90439:
EDITING : Unhide of first column is impossible by mouse
[NEW; assigned to libreoffice-bugs]
-
90440:
EDITING : Unhide of columns improvements
[NEW; assigned to libreoffice-bugs]
-
92570:
Provide multiple display views in Calc
[NEW; assigned to libreoffice-bugs]
-
96694:
No visual cue if first rows/columns are hidden
[NEW; assigned to libreoffice-bugs]
-
97494:
Row/column gets not always selected
[NEW; assigned to libreoffice-bugs]
-
98440:
Copy and Paste of table rows un-does merging
[NEW; assigned to libreoffice-bugs]
-
99457:
Ability to move rows, columns using one hand and preserving all existing content
[NEW; assigned to libreoffice-bugs]
-
99584:
Optimal-width columns too small to print (data appears as '#' chars)
[NEW; assigned to libreoffice-bugs]
-
103757:
FILESAVE, FORMATTING: Overflow error for column width and row height
[NEW; assigned to libreoffice-bugs]
-
108320:
[META] Calc cells merging and splitting bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
34837:
Merged Cell's borders vanishes when changing sheet direction to (Right-To-Left)
[NEW; assigned to libreoffice-bugs]
(*)
-
40061:
Merge-Cells doesn't work when recording changes
[NEW; assigned to libreoffice-bugs]
-
47778:
EDITING: Filling down or across through merged cells undoes the merge
[NEW; assigned to libreoffice-bugs]
-
53850:
EDITING: Implement "Merge across" Excel feature - merge all cells in each row inside selection
[NEW; assigned to libreoffice-bugs]
-
56294:
EDITING: Comment lost when in right one of 2 merged cells
[NEW; assigned to libreoffice-bugs]
-
57150:
Calc FORMATTING: "Optimal column width" works incorrectly when column includes a merged cell and wrap-text cells and non-wrap cells (see comment 6 about A20)
[NEW; assigned to libreoffice-bugs]
-
60208:
FILTER / UI / VIEWING : Using autofilter, when filtering, merged cells related to row not drawn (second result onwards)
[NEW; assigned to libreoffice-bugs]
-
63766:
EDITING: Merging of merged cell and unmerged cell fails with error message
[NEW; assigned to gokul.cdac]
-
74586:
EDITING: Content seems to be lost when sort data with header in merged cells
[NEW; assigned to libreoffice-bugs]
-
85807:
Remove merged cell restriction on sorting
[NEW; assigned to libreoffice-bugs]
-
87687:
Merging cells does not move references in equations (Comment 6)
[NEW; assigned to libreoffice-bugs]
-
89049:
Data Bar on merged cells
[NEW; assigned to libreoffice-bugs]
-
89951:
EDITING: format removed when merging formatted with non-formatted cells
[ASSIGNED; assigned to tibor.nagy.extern]
-
90458:
FORMATTING: When a row selection includes a merged column, only border changes which are specific to the row are applied
[NEW; assigned to libreoffice-bugs]
-
93202:
When merging cells formula is lost
[NEW; assigned to libreoffice-bugs]
(*)
-
101033:
Clicking on merged cell in Page break view picks up the page break for a move operation
[NEW; assigned to libreoffice-bugs]
-
101121:
Formatting a merged cell with Merge and Center does a split operation
[NEW; assigned to libreoffice-bugs]
-
103959:
Merged cell contents do not overflow cell boundaries, but still affect print range calculations
[NEW; assigned to libreoffice-bugs]
-
104108:
LibreOffice Calc does not allow you to merge cells into different rows and columns.
[NEW; assigned to libreoffice-bugs]
-
116513:
CALC: Format-Merge Cells-Merge Cells or "Merge Cells" icon mark "Merge and Center Cells" icon (per Comment 4)
[NEW; assigned to libreoffice-bugs]
-
117779:
CALC: Change case in merged cells isn't immediately refreshed until sheet recalculated or revisited
[NEW; assigned to libreoffice-bugs]
-
117947:
The object position doesn’t return by “Undo”
[NEW; assigned to libreoffice-bugs]
-
120984:
Merged cells imported as DDE from Calc are not merged in Writer
[NEW; assigned to libreoffice-bugs]
-
121519:
GUI glitch with Format Brush and merged cells
[NEW; assigned to libreoffice-bugs]
-
122024:
merged cells become unmerged when deleting first row or column
[NEW; assigned to libreoffice-bugs]
-
126208:
Text not displayed, after hiding first row of merged cell
[NEW; assigned to libreoffice-bugs]
-
132915:
Missing cell border line after deleting a row above of a row with merged cells
[NEW; assigned to libreoffice-bugs]
(*)
-
134751:
Cell access error when merged cell is duplicated
[NEW; assigned to libreoffice-bugs]
-
137391:
Filling of merged cells should handle more accuracy
[NEW; assigned to libreoffice-bugs]
-
137589:
Repeat: Merge Cells (Shift-Ctrl-Y) doesn't do same as Merge
[NEW; assigned to libreoffice-bugs]
-
139561:
End key moves a cursor not to the last cell with data in the row but moves to next cell if last cell is in merged cell range
[NEW; assigned to libreoffice-bugs]
-
140135:
Merged Cell Copy and Find issue
[NEW; assigned to libreoffice-bugs]
-
142440:
Merge cells with different border styles create unexpected result
[NEW; assigned to libreoffice-bugs]
-
143477:
Can not merge cells if some cells has been merged
[NEW; assigned to libreoffice-bugs]
-
145776:
FILEOPEN XLSX When applying Text Orientation to a merged cell, side borders become slanted
[NEW; assigned to libreoffice-bugs]
-
145948:
In an RTL sheet, merged cell borders don't show until save or direction change (see comment 2)
[NEW; assigned to libreoffice-bugs]
(*)
-
147837:
When merging cells, it is not good that 'Keep the contents of the hidden cell' is the default
[NEW; assigned to libreoffice-bugs]
-
149084:
[FILEOPEN] WK4 "merge cells" dropped
[NEW; assigned to libreoffice-bugs]
-
150335:
Angle rotated text in merged cells missing on open or scroll of ODS
[NEW; assigned to libreoffice-bugs]
-
150816:
Sparklines in merged cells are missing options
[NEW; assigned to libreoffice-bugs]
-
150906:
If merged cell in RTL sheet is wider than window, a portion of the text disappears
[NEW; assigned to libreoffice-bugs]
-
155466:
Calc: Merging cells with outside border only would make the right (and bottom) border disappeared
[NEW; assigned to libreoffice-bugs]
-
155804:
Row-wise and/or column-wise merge in 2D area
[UNCONFIRMED; assigned to libreoffice-bugs]
-
158034:
Feature request: Editing, Formatting, UI. Option to add linebreaks when merging cells into one.
[NEW; assigned to libreoffice-bugs]
-
158288:
When you select part of a column with merged cells, all columns that are part of the merged cell are selected
[NEW; assigned to libreoffice-bugs]
-
158751:
Pasting text in vertically merged cells does not show the entire text
[NEW; assigned to libreoffice-bugs]
-
158979:
Remember last option at Merge Cells
[NEW; assigned to libreoffice-bugs]
-
159598:
Merging a whole column increases file size unnecessarily (comment 8)
[NEW; assigned to libreoffice-bugs]
-
159712:
Sparklines don't take the space of the whole merged cell
[NEW; assigned to libreoffice-bugs]
-
159846:
Calc: Disappearing borders on tall merged cells
[NEW; assigned to libreoffice-bugs]
-
161019:
Visual fidelity issues when exporting spreadsheets with merged cells to PDF after changes to cell data management
[NEW; assigned to libreoffice-bugs]
-
30456:
UI: Enhance Merge Cell Dialog with options"shift content", "keep content in covered cell", "empty covered cell"
[RESOLVED FIXED; assigned to jumbo4444]
-
31805:
Deleting a column or row from merged cells
[CLOSED FIXED; assigned to kohei]
-
34214:
EDITING - selecting merged cells
[RESOLVED FIXED; assigned to kohei]
-
34719:
EDITING: Undoing column delete operation with merged cells is very slow and scrolls the document
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
37210:
UI: Calc usability improvement: Merge cells on right mouse click
[RESOLVED FIXED; assigned to greggory.hz]
-
37901:
EDITING: Undo not available for Merge Cells in Calc
[VERIFIED FIXED; assigned to markus.mohrhard]
-
40993:
Calc: Pulling down formula over merged cells unmerges them
[VERIFIED FIXED; assigned to attila.szucs]
(*)
-
41113:
EDITING: Using "Paste special" in merged cells loses cell content
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
41842:
FORMATTING: Transfering format with brush affects wrong cells
[RESOLVED DUPLICATE; assigned to attila.szucs]
-
43104:
[UI]Warning Message for merging cells with contents should reflect application's behaviour more accurately
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
43958:
EDITING: Dashed border (CTRL+c) does not cover whole merged cell
[RESOLVED FIXED; assigned to attila.szucs]
-
45925:
EDITING: HANG when copy - paste cells including merged ones to column
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
49638:
FORMATTING: Edit Fill Down mishandles merged cells
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
49704:
UI: Calc usability improvement: Unmerge cells on right mouse click
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
51368:
EDITING: CRASH when Merge Cells with "move contents" and first of merged Cells is involved in calculation
[VERIFIED FIXED; assigned to markus.mohrhard]
-
55466:
Problem with bottom edge in merged cells in xls format
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
59585:
EDITING: Enhancement request: Create merged cells by dragging the handle
[RESOLVED FIXED; assigned to attila.szucs]
(*)
-
73390:
Paste Special issue with merged cells
[RESOLVED DUPLICATE; assigned to attila.szucs]
-
75907:
Column is showing the wrong width with merged cells
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
76461:
Merged cells border format doesn't work when selecting a row
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
(*)
-
81499:
Not possible to merge cells
[RESOLVED FIXED; assigned to markus.mohrhard]
-
86143:
Dragging merged from the corner puts it in a single cell
[RESOLVED DUPLICATE; assigned to attila.szucs]
-
87381:
EDITING: Pasting unmerges copied cells when pasted to a correctly sized selected area
[RESOLVED DUPLICATE; assigned to attila.szucs]
-
87382:
Improper display of selected merged cells when left most cell is not in the visible window.
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
88782:
EDITING spreadsheet: autofill using fill handle inserts incorrect data when used with merged cells
[VERIFIED FIXED; assigned to attila.szucs]
-
89244:
AutoFilter on merged cells is empty
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
90457:
Enhancement: Merging cells by rows and by columns
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
90943:
During merge, don't ask to move cells if they are empty
[RESOLVED FIXED; assigned to jumbo4444]
-
92960:
Calc doesn't merge cells correctly when pasting merged content from HTML
[RESOLVED FIXED; assigned to erack]
-
93664:
filter a list with merged cells does not work
[VERIFIED FIXED; assigned to tundeth]
-
97247:
Focus goes strange when typing UP/LEFT at merged cell at top-left corner
[RESOLVED FIXED; assigned to tabe]
-
99386:
Undo with merged cell, needs hard recalculate, no automatic update
[RESOLVED FIXED; assigned to markus.mohrhard]
-
101124:
MERGE and centre cells loses formula
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
(*)
-
101313:
Copy-paste a Table With Merged Cells from Writer to Calc: Cells Placed in Wrong Position (Wrong cell offsets)
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
101835:
UI request for 'Merge Cells' control in 'Format - Cells' window
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
103480:
EDITING: Hyperlink deleted when merging cells (if not in the first cell)
[VERIFIED FIXED; assigned to czeber.laszloadam]
-
104934:
VIEWING Cell being edited not redrawn/rendered correctly when activating horizontal split
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
106177:
Paste special of Only Formulas unmerges cells (steps in Comment 9)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
(*)
-
106544:
Calc: Merge cells dialog is difficult to understand for new/infrequent users
[VERIFIED FIXED; assigned to heiko.tietze]
-
107255:
Merging cells where only one is not empty should be done without confirmation
[RESOLVED FIXED; assigned to kohei]
-
109119:
Formated number and date calc cell formats don't respect automatic cell wrap
[CLOSED DUPLICATE; assigned to libreoffice-bugs]
-
111782:
Wrong rendering of image radiobutton on Split Cells dialog
[RESOLVED FIXED; assigned to koruhelygabor]
-
117601:
Crash in: libstdc++.so.6.0.22 on merge cells in writer with TDF .debs on Debian 9
[VERIFIED FIXED; assigned to caolan.mcnamara]
-
120798:
LO Calc: Cell Format "Center on Columns" impossible without cell merging
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
127256:
EDITING: Marching ants when copying merged cells only around first cell
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
131471:
Rendering of background changes due to conditional formatting fails in merged cells across multiple rows in some cases in Calc.
[RESOLVED FIXED; assigned to tibor.nagy.extern]
-
132629:
can't spell check using right click in merged cells
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
134757:
Text formatting is removed on merge when content is not in first cell
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
136173:
Calc: No text displayed if part of merged cells where not all cells are visible
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
138082:
Merged Cells adopt the format of the first cell instead of the cell with contents
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
141944:
Copy paste from Google Sheet work bad for merged cell
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
142515:
Optimal width/height of merged cells
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
149430:
Clone formatting de-merges cells rather than considering the merged cells as a single cell
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
153224:
Border of combined cells with inclined text is inclined in each cell, not continuous
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
155533:
Conditional Formating at Merged Cells
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
156655:
Long text in merged cells not painted
[VERIFIED FIXED; assigned to tibor.nagy.extern]
-
160399:
Print Preview freezes with whole row merged in large spreadsheet
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
34837:
Merged Cell's borders vanishes when changing sheet direction to (Right-To-Left)
[NEW; assigned to libreoffice-bugs]
-
108601:
FORMATTING Value of Format - Rows - Optimal Height is not saved
[NEW; assigned to libreoffice-bugs]
-
109139:
[META] Cell selection bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
35806:
EDITING navigation through previously accessed cells
[NEW; assigned to libreoffice-bugs]
-
38994:
EDITING: improve single cell selection for Drag and Drop (by click on cell border?)
[NEW; assigned to libreoffice-bugs]
-
39180:
UI: missing visual cursor-hint when a cell is draggable.
[NEW; assigned to libreoffice-bugs]
-
42261:
display of selected cells incorrect after inserting row/column above/left of selection
[NEW; assigned to libreoffice-bugs]
-
44934:
Select row; maximize spreadsheet; only part of the row is highlighted
[NEW; assigned to libreoffice-bugs]
-
58929:
Paste action disables cell navigation with Enter and Tab (aka Tab / Enter should exit a one-cell selection)
[NEW; assigned to libreoffice-bugs]
-
62827:
EDITING: Problem selecting cells
[NEW; assigned to libreoffice-bugs]
-
68617:
UI: Row/Column Highlight of current selection not showing correctly
[NEW; assigned to libreoffice-bugs]
-
74373:
UI: Slightly increased Xorg CPU usage with 'marching ants' on hidden Calc window
[NEW; assigned to libreoffice-bugs]
-
74374:
UI: 'marching ants' doesn't stay with copied cells when rows are inserted
[NEW; assigned to libreoffice-bugs]
-
74951:
UI: Make it possible through a setting to select hidden cells using the keyboard
[NEW; assigned to libreoffice-bugs]
-
82404:
CALC: Focus/selected cell does not change to A1 when corner selection button pressed to select whole spreadsheet
[NEW; assigned to libreoffice-bugs]
-
90458:
FORMATTING: When a row selection includes a merged column, only border changes which are specific to the row are applied
[NEW; assigned to libreoffice-bugs]
(*)
-
94929:
Selection stays current location even after selecting or modifying a cell outside selection
[NEW; assigned to libreoffice-bugs]
-
95730:
Jumping to block margin is broken after selecting cells
[NEW; assigned to libreoffice-bugs]
-
99541:
'.uno:GoToCell' call selects an entire column IF the target cell is in column C.
[NEW; assigned to libreoffice-bugs]
-
102700:
UI - data selection
[NEW; assigned to libreoffice-bugs]
-
115185:
Selection is displayed incorrectly after window maximize.
[NEW; assigned to libreoffice-bugs]
-
115983:
findAll and replaceAll methods have an unexpected behavior when they are called from the com.sun.star.sheet.SheetCellRanges service.
[NEW; assigned to libreoffice-bugs]
-
123490:
Keyboard-alternative to selecting various dispersed cells in Calc
[NEW; assigned to libreoffice-bugs]
-
123496:
Make .uno:GoToCell respect selection mode
[NEW; assigned to libreoffice-bugs]
-
127188:
FORMATTING adding decimal places changes format
[NEW; assigned to libreoffice-bugs]
-
129420:
Decrease performance when select many aleatory cells with Ctrl pressed.
[NEW; assigned to libreoffice-bugs]
-
130425:
Shift+Space and Ctrl+Space don’t work with multiple selections
[NEW; assigned to libreoffice-bugs]
-
135855:
Apply Recalcule F9 to the selection rather than the active cell
[NEW; assigned to libreoffice-bugs]
-
144411:
Allow using "insert time" and "insert date" for multiple cells at once
[NEW; assigned to libreoffice-bugs]
-
144593:
Keep active cell focused on col/row selection (if it is part of the resulting selection)
[NEW; assigned to libreoffice-bugs]
-
145201:
UI: Context Menu does not appear if user clicks on the top-left sheet corner.
[NEW; assigned to libreoffice-bugs]
-
152327:
"Select unprotected cells" when no cells are unprotected makes data entry impossible
[NEW; assigned to libreoffice-bugs]
(*)
-
155796:
Deselecting merged cells using Shift+⬆ doesn't work in some cases
[NEW; assigned to libreoffice-bugs]
-
155799:
Selecting merged cells for formula doesn't select the complete merged cell
[NEW; assigned to libreoffice-bugs]
-
157235:
OS highlight colour not picked up for row/column and cursor, red used instead (gen/x11 VCL plugin)
[NEW; assigned to libreoffice-bugs]
-
157747:
Calc select all rows and columns corner should hint at its function
[NEW; assigned to libreoffice-bugs]
-
159191:
"Select Unprotected Cells" does not work if selection active
[NEW; assigned to libreoffice-bugs]
(*)
-
159192:
Copy visible cells from a selected range
[NEW; assigned to libreoffice-bugs]
-
160596:
[EDITING] "Not responding" message displayed by Calc on large array selection that has conditional formatting
[NEW; assigned to libreoffice-bugs]
-
160946:
In Calc, when moving content with drag and drop, destination area is no longer shown
[NEW; assigned to libreoffice-bugs]
-
45958:
Only Copy Visible Cells (after a filter) doesn't work when only unfiltered columns are selected
[VERIFIED FIXED; assigned to info]
-
47818:
EDITING: extending selection after pasting selects from top left
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
54824:
[RFE] Simplifying the Drag&Drop of one individual cell
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
56846:
Current Cell Should Turn White When Border Is Bold
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
68703:
EDITING: Selecting the cells with keyboard is broken if the cell one starts from is already selected after Paste
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
74387:
UI: When row(s) selected, make context menu consistent between row & individual cells
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
94099:
Calc performance degradation after selecting cells in an Excel document and activating font chooser with previews enabled
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
94420:
Selection of adjacent columns has changed to Excel variant, very laborious.
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
95883:
CALC: Add option to clear all unprotected cells in protected sheet
[VERIFIED FIXED; assigned to gulsah.1004]
(*)
-
97143:
Only latest range highlighted when selecting multiple cell ranges using CTRL modifier (see comment 3)
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
108240:
Selection box hides borders (unlike Excel)
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
109298:
Ctrl+Cursor jumps incorrectly after pasting data
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
115781:
The edit cursor should move to the newly added row
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
117458:
Selection doesn't move left nor right by pressing ENTER
[VERIFIED FIXED; assigned to erack]
-
119189:
Calc: PDF export or Print "Selected cells" doesn't print last page if cells selected from multiple pages ( steps in comment 10 )
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
124030:
libreoffice crashes, when selecting a MTRANS generated range
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
126393:
Hard to select a cell which contains only a hyperlink
[RESOLVED FIXED; assigned to samuel.mehrbrodt]
-
128678:
EDITING Unable to unselect merged cells using arrows keys when selecting from bottom or right
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
131092:
High CPU usage and slow performance with column selection
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
133228:
Moving a cell with mouse shows only black dot instead of helpful cell highlightning
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
137030:
Crash in Calc: Select a column title and right click: Crash (see report)
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
140599:
EDITING Row and column highlight cleared when selection moves over a filtered row
[VERIFIED FIXED; assigned to tundeth]
-
142121:
Cell focus rectangle must not use font color
[VERIFIED FIXED; assigned to nataligavrilova8]
-
143733:
Make selection border wider
[RESOLVED FIXED; assigned to heiko.tietze]
-
145080:
make sure cell selection colors use good contrast when following system highlight color on macOS
[VERIFIED FIXED; assigned to heiko.tietze]
-
145812:
Cell reference are highlighted black when putting = into a cell and clicking a different cell
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
(*)
-
147388:
Cell cursor should take cell border width into account
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
(*)
-
154815:
UI: Cell cursor width has increased
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
155621:
Input cell A1="Aa", select two cells B1:B2, right click B1, cell B2 is deselected
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
156800:
No way to change selection colour in Libo on 7.6.0 release ?
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
156884:
Selection box lags navigation with keyboard arrows
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
157038:
Auto Spell Checker Prevents Cell Selection Right Click
[RESOLVED FIXED; assigned to jluth]
-
160787:
Calc active cell cursor has small transparent corners
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
35806:
EDITING navigation through previously accessed cells
[NEW; assigned to libreoffice-bugs]
-
109412:
FORMATTING - Column Insert does not always insert a New column
[NEW; assigned to libreoffice-bugs]
-
115930:
[META] Adding and deleting cells / rows / columns
[NEW; assigned to libreoffice-bugs]
-
45191:
Add option for message "Protected Cells Cannot be Modified" also for Delete key (as for Backspace)
[NEW; assigned to libreoffice-bugs]
(*)
-
103920:
Writer slow and not responding when you delete columns from XLSX with 28101 lines
[NEW; assigned to libreoffice-bugs]
-
108637:
Memory usage increases considerably when deleting rows in a document with a 1000 empty sheets (see comment 3)
[NEW; assigned to libreoffice-bugs]
-
113981:
Adding a table row and/or resizing a table column height/width for a large table is noticeably slower compared to LibO 5.0
[NEW; assigned to libreoffice-bugs]
-
115849:
Allow table to split across pages and columns enabled when adding row in a table with table style
[NEW; assigned to libreoffice-bugs]
-
117882:
Deleting a row or adding a column decreases the height of the lines in spreadsheet.
[NEW; assigned to libreoffice-bugs]
-
125736:
Writer: adding a column to a table should enlarge and not squeeze table unless page width is reached
[NEW; assigned to libreoffice-bugs]
-
126008:
TABLES STYLES: Inserting or removing a row/column changes entire table's formatting (see comment 5)
[NEW; assigned to libreoffice-bugs]
-
128279:
TABLE: Deleting a column from an equi-distributed table should redistribute widths
[NEW; assigned to libreoffice-bugs]
-
134271:
Undoing the deletion of a row exceptionally slow compared to rejecting deletion of a row
[NEW; assigned to libreoffice-bugs]
-
136670:
EDITING: removing rows/columns via keyboard ctrl + minus works only once
[NEW; assigned to libreoffice-bugs]
-
136714:
Undo adding a row in a very large table slow
[NEW; assigned to libreoffice-bugs]
-
139365:
Table>insert Rows should move the cursor to the new row
[NEW; assigned to libreoffice-bugs]
-
140699:
Inserting a new line above or beyond a line with merged cells don't copy the merged cells
[NEW; assigned to libreoffice-bugs]
-
144265:
Relative referencing anomaly
[NEW; assigned to libreoffice-bugs]
-
155520:
Table: Unexpected paragraph style when insert "Insert bellow" loses styles
[NEW; assigned to libreoffice-bugs]
-
157023:
The size of sections (with tables in it) suddenly increases to bottom page after inserting a row, creating large empty area
[NEW; assigned to libreoffice-bugs]
-
60382:
EDITING and TABLE: No changes tracked when deleting table rows and tables
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
79480:
VIEWING: Deleting rows from this sheet will result in Page breaks to be displayed
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
101957:
Crash when inserting an row in Writer using the context menu (likely GTK2-related)
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
106646:
EDITING: Deleting a column in a large spreadsheet quite slow
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
114131:
Inserting new rows/columns not disabled in read-only spreadsheet when right-clicking on rows or columns
[RESOLVED FIXED; assigned to xiscofauli]
-
115573:
EDITING: Table loses formatting when inserting a new row in a table
[CLOSED FIXED; assigned to libreoffice-bugs]
-
115929:
TABLE: Formatting lost when adding or deleting a row
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
115958:
View jump to cursor position, when adding a new row if the screen position differs from the cursor position
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
120634:
Unexpected change of table content paragraph style when deleting a row
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
122500:
Table: add row by using tab key does not do borders correctly
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
129989:
Inserting a row in a table resets list numbers
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
131551:
In Writer: Table formatting is lost when a row is deleted
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
134301:
3 seconds delay of inserting a row and 6 seconds delay deleting a row in a larger spreadsheet
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
136730:
table content changed after inserting column and saving document
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
140712:
Deleting a column in very large table slow 3x slower compared to 5.0 branch
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
150504:
in writer-table small caps behave strangely
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
152522:
Assign <Alt>+<Del> to .uno:DeleteColumns in calc for shortcut parity as with Tables in Writer
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
153171:
suggestion: add option to add x number of rows/columns in the menu
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
45191:
Add option for message "Protected Cells Cannot be Modified" also for Delete key (as for Backspace)
[NEW; assigned to libreoffice-bugs]
-
116303:
Merge cells toolbar button in Writer is inactive when cell selection doesn't move cursor
[NEW; assigned to libreoffice-bugs]
-
116948:
UNO command to switch left/right columns resp. upper/lower rows
[NEW; assigned to libreoffice-bugs]
-
117368:
EDITING Hidden columns are shown after Select all - Delete
[NEW; assigned to libreoffice-bugs]
-
118724:
The column width dialog behaves differently compared to Table Properties Columns dialog
[NEW; assigned to libreoffice-bugs]
-
120726:
UI - Table protected cells: Add possibility to disable warning message
[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]
(*)
-
122044:
Doesn't save merging of cells after copy/paste table from Calc to table in Writer
[NEW; assigned to libreoffice-bugs]
-
122987:
Cell movement by ALT + drag on multiple selected sheets
[NEW; assigned to libreoffice-bugs]
-
123210:
Calc: Insert Rows Below if above hidden row should make visible/not hidden row
[NEW; assigned to libreoffice-bugs]
-
123986:
Split Table disabled when in table cell crossing page boundary
[NEW; assigned to libreoffice-bugs]
-
125732:
CALC - insert a new column before the first column after the PivotTable
[NEW; assigned to libreoffice-bugs]
-
125972:
Enhancement: Tables, Pagebreak: "keep with next row" feature
[NEW; assigned to libreoffice-bugs]
-
126083:
Borders of merged table cells disappear if you enable page header (also in PDF export) (steps in comment 7)
[NEW; assigned to libreoffice-bugs]
-
128090:
WRITER TABLES: Sort warning needed or some form of protection
[NEW; assigned to libreoffice-bugs]
-
129203:
Split Cell Recommendations
[NEW; assigned to libreoffice-bugs]
-
129639:
Could Not Set Column Width in One Column Table
[NEW; assigned to libreoffice-bugs]
-
131186:
Faulty behavior on Inserting rows/colums in a table by dragging
[NEW; assigned to libreoffice-bugs]
(*)
-
131470:
Swapping columns across multiple sheets works correctly only on the active sheet
[NEW; assigned to libreoffice-bugs]
-
132456:
Lots of time spend in SfxBroadcaster::RemoveListener Undoing deleting a row (3/4 minutes)
[NEW; assigned to libreoffice-bugs]
-
132915:
Missing cell border line after deleting a row above of a row with merged cells
[NEW; assigned to libreoffice-bugs]
(*)
-
133721:
VIEWING: Arrows for cell resizing in table not showing if picture or shape is in background
[NEW; assigned to libreoffice-bugs]
-
133776:
No border when dragging columns (MacOS)
[NEW; assigned to libreoffice-bugs]
-
135063:
Calc column width auto fit not working when selection active outside column
[NEW; assigned to libreoffice-bugs]
-
135671:
Table expanded cells expand when dragging fontwork through a table cells, but don't shrink until click in to cells one by one or file reload
[NEW; assigned to libreoffice-bugs]
-
135760:
Merge cells not functioning in exported DOCX
[NEW; assigned to libreoffice-bugs]
-
142477:
Improve resizing column behavior: currently lacking preview and minimal width
[NEW; assigned to libreoffice-bugs]
-
142969:
Line-border from frozen column shouldn't cross a group (+) icon
[NEW; assigned to libreoffice-bugs]
-
143235:
Calc drag and drop of rows or columns should be more user friendly
[NEW; assigned to libreoffice-bugs]
-
143917:
Row's "optimal height" does not adapt when entering text with fonts needing extra vertical space (Thai, Javanese, Arabic, Japanese...) (steps in comment 6)
[NEW; assigned to libreoffice-bugs]
-
144199:
FORMATTING Cell data shrunk to size that is not readable to the human eye when using Resize to fit cell
[NEW; assigned to libreoffice-bugs]
-
146868:
EDITING, FORMATTING: Setting row height of all cells to >=59pt prevents creation of new shapes
[NEW; assigned to libreoffice-bugs]
-
147015:
CALC FORMATTING Optimal Column Width anomaly relating to Typographic character kerning & Pair Kerning
[NEW; assigned to libreoffice-bugs]
-
148018:
Undo of deleting a row in large sheet takes 15 seconds (deleting 7 seconds). With track changes it takes 3,5 second for both actions
[NEW; assigned to libreoffice-bugs]
-
148239:
Column width value in hover text depends on position of the cursor
[NEW; assigned to libreoffice-bugs]
-
148619:
Cell reference in formula don't update on all sheets when moving cells on multiple sheets in specific ODS
[NEW; assigned to libreoffice-bugs]
-
150244:
TABLES: Command "Distribute columns evenly" affects all rows, not just the selected rows
[NEW; assigned to libreoffice-bugs]
-
151133:
Introduce function to remove empty rows/columns
[NEW; assigned to libreoffice-bugs]
-
151330:
Add option for Optimal row height to ignore hidden columns
[NEW; assigned to libreoffice-bugs]
-
151829:
Writer TABLE: Optimal column width does not adjust columns that are too wide
[NEW; assigned to libreoffice-bugs]
-
155241:
Calc: Column Width Accepts Invalid Input Resulting in Sheet Corruption
[REOPENED; assigned to libreoffice-bugs]
-
155287:
Deleting a column causes a full calculation of the row height
[NEW; assigned to libreoffice-bugs]
-
156380:
FORMATTING: images in cells should autoshrink to cell size, same as Excel behavior
[NEW; assigned to libreoffice-bugs]
-
156402:
Deleting rows that contain images doesn't delete all the image shapes
[NEW; assigned to libreoffice-bugs]
-
156689:
Deleting empty column(s) removes styling / formatting of adjacent column
[NEW; assigned to libreoffice-bugs]
(*)
-
157659:
Cut / Copy / Paste / Delete of Rows in Calc 7.5+ is slow
[NEW; assigned to libreoffice-bugs]
-
157945:
UI: Resizing of a selection of columns/rows should correspond to the mouse position
[NEW; assigned to libreoffice-bugs]
-
158167:
Calc: Move selected row and scroll sheet extremely slow with CPU in local debug build
[NEW; assigned to libreoffice-bugs]
-
158399:
Insert multiple columns/rows at once with non-contiguous selection
[NEW; assigned to libreoffice-bugs]
-
158689:
Calc's double-click on column header boundary always uses the default +2 mm for optimal width, instead of what is defined in Format>Columns>Optimal Width
[UNCONFIRMED; assigned to libreoffice-bugs]
-
158696:
UI. A checkbox for default column width rather odd UI choice width downsides
[NEW; assigned to libreoffice-bugs]
-
159114:
CRASH: inserting column and undoing
[NEW; assigned to libreoffice-bugs]
-
159237:
Optimal Column Width does not work with Right Indent Cells
[NEW; assigned to libreoffice-bugs]
-
160011:
Hidden columns should not prevent text from preceding columns from overflowing over their cells
[NEW; assigned to libreoffice-bugs]
-
160324:
Column resize handle touch-target too small
[ASSIGNED; assigned to heiko.tietze]
-
160921:
Changing Add in Columns->Optimal width causes some columns to be too narrow
[NEW; assigned to libreoffice-bugs]
-
160944:
LO Calc Crashes after inserting a row in spreadsheet (or after saving directly after)
[NEW; assigned to libreoffice-bugs]
-
42375:
UI: Context menu should show "Insert row" instead of "Insert rows" if only one row is selected
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
44773:
Unable to resize table row height with mouse if cursor outside of table
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
59751:
EDITING: Make Alt-ArrowKey swap paragraphs, rows and columns
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
60242:
TABLE: Split cell default choice
[RESOLVED FIXED; assigned to martin.vanzijl]
-
77001:
Calc slows down when selecting discontinuous rows
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
88582:
Features for rows, add menu Line Shift Up | Down
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
97073:
FORMATTING: Adjusting table row height when cursor outside of table is ignored
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
97791:
Calc:: Copying formulas DIVIDES prior combined Cells
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
(*)
-
98243:
cell scroll highlighting breaks cell border display when navigating up / down at document magnification of at least 150%
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
99416:
Copy/paste and adding/removing columns or lines is slow
[RESOLVED WORKSFORME; 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]
-
108016:
Calc: Insert Row Above should use format of selected row instead of previous row
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
(*)
-
113012:
UI: Unifying Calc cell context menu entry for cell & clear formatting and paste commands
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
113980:
Insert Row and Insert Column in Standard Toolbar not available after (Auto-) Filter has been applied
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
117232:
Ability to resize tables with mouse
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
119293:
UI Consistency for inserting rows in Writer table
[VERIFIED FIXED; assigned to heiko.tietze]
-
119335:
When handling a document with multiple tables Libre-Office Writer freezes and crashes
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
119453:
dynamic row height in text table inside frame does not update after adding paragraph
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
123282:
Any action in spreadsheet increases row height
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
123739:
Regression - scientific notation now where numbers were shown before - cell padding now requires 1 digit of free space before and after a number, or the cell goes in scientific notation
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
125868:
RTL Insert Cell shifts cells dialog text needs to indicate opposite direction
[RESOLVED FIXED; assigned to heiko.tietze]
-
126029:
FORMATTING: Table colour background corrupted on table properties dialogue opening.
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
127759:
EDITING extend enhanced table selection with cut/insert mode: cut selected table rows and columns completely in Writer tables and insert them before the actual row or colum
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
127774:
TABLE COLUMN: Formated table after opening not correct in writer.
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
128284:
TABLE: An easy way to change the order of the table rows
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
129908:
Crash at Data > Group and outlone > AutoOutline
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
130292:
FILESAVE Changed column width not saved in document
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
131122:
Tables in Libreoffice Writer do not save column width settings
[RESOLVED DUPLICATE; assigned to smolin.vofka]
-
131759:
"Split table" dialog doesn't remember the previously selected option
[VERIFIED FIXED; assigned to andreas.heinisch]
-
132457:
#DIV/0! error after undoing a deleting a row
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
134778:
PAGE HEADER: Size of table doesn't respect size of page header
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
144317:
minimize column width dont work on tables exceeding page limits in normal view
[VERIFIED FIXED; assigned to jluth]
-
145325:
Weird behaviour when using custom cell height
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
147301:
Disable Hidden Row/Col indicator by default
[RESOLVED FIXED; assigned to heiko.tietze]
-
148316:
Improve the method for calculating Optimal Row Height for vertical text/Japanese
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
149625:
FORMATTING: Pasting a table cell, pastes the source cell in the upper/actual cell as an inner table cell
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
154788:
The default width of Calc columns should be a bit narrower
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
156248:
Option key does not move cells, and source are not emptied
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
156268:
CRASH: inserting row and undoing
[RESOLVED FIXED; assigned to caolan.mcnamara]
-
156424:
Copy/paste of a row with images results in a copy with copied images positioned incorrectly
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
156458:
L10n German: "Spalten" instead of "Spalten löschen"
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
158997:
Calc Format>Columns>Optimal Width (with no extra width) causes some columns to be too narrow
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
160329:
Image anchored to cell ends up in wrong cell after using autofilter sort, depending on hidden rows
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
160456:
Calc no longer freezes the top row
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
160632:
TABLE: Crash when using column width dialog
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
160836:
unable to resize table row height with mouse, if contains an image which cropped by the fixed row height
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
160842:
unable to select cell content, if cropped part of an image of a different cell "covers" the same area
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
39936:
UI: Right Click on Row/Column -> Insert Copied Cells... (paste + shift cells in one click)
[ASSIGNED; assigned to balazs.varga991]
-
108662:
[META] Cells with multiple or partly direct formatted texts
[NEW; assigned to libreoffice-bugs]
-
38982:
Calc find & replace removes mixed cell formatting; undo does not restore it
[NEW; assigned to libreoffice-bugs]
-
39969:
Applying formatting doesn't work correctly if cell contains multiple direct formatting sequences
[NEW; assigned to libreoffice-bugs]
(*)
-
41281:
FILESAVE: Unable to save partial formatting of text to HTML
[NEW; assigned to libreoffice-bugs]
-
67884:
HTML Pasting into Calc ignores text formatting on partial strings
[NEW; assigned to libreoffice-bugs]
-
89951:
EDITING: format removed when merging formatted with non-formatted cells
[ASSIGNED; assigned to tibor.nagy.extern]
(*)
-
97935:
FILESAVE, FORMATTING. Format of cells containing text with several formats is corrupted when saving as xls, xlsx
[NEW; assigned to libreoffice-bugs]
-
99920:
Change font color in entire sheet and overwrite direct formatting parts
[NEW; assigned to libreoffice-bugs]
-
105977:
FORMATTING Cycle Case only works for whole cells, but not selection within a cell
[NEW; assigned to libreoffice-bugs]
-
107857:
Incorrect formatting logic when replacing formatted selected text (should be true replace instead of delete+insert)
[NEW; assigned to libreoffice-bugs]
-
108391:
Editing: The text color of multiple cells can't be changed under specific conditions
[NEW; assigned to libreoffice-bugs]
-
116261:
CALC FORMATTING editing in-cell attributed content (rich text) in the Input Line removes attribution from cell content
[NEW; assigned to libreoffice-bugs]
-
124294:
FORMATTING Strikethrough not cleared, when formatting cycle starts from partial application (edit mode works)
[NEW; assigned to libreoffice-bugs]
-
153392:
Font Name, Font Size and Font "Style" (Bold, Italic, Underline) changes applied to a column do not change all the content of selected cells. Ukrainian language/Cyrillic font
[NEW; assigned to libreoffice-bugs]
-
155453:
Cell content's formatting lost when edited in formula bar
[ASSIGNED; assigned to caolan.mcnamara]
(*)
-
155960:
Wrong format (HTML) copied to clipboard when a cell's contents have multiple formats
[NEW; assigned to libreoffice-bugs]
-
64905:
Changing text attributes for more cells, does not change the attributes of individual text elements
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
90781:
Changing font size for all cells does not change the size for extra formatted strings within cells
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
92961:
FILESAVE: XLSX - New line doesnt import correctly into Excel when text has multiple direct formatting parts
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
107965:
Apply a font color to multiple cells doesn't colorize all text (steps in Comment 16)
[RESOLVED FIXED; assigned to libreoffice-bugs]
(*)
-
108333:
Undo results in formatting which had never existed in the document - duplicate of existing bug
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
108394:
EDITING: (BOLD)formatting for multiple cell's isn't working under specific conditions
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
108404:
Calc changes the font attributes of selected text in unpredictable ways
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
108559:
Pasting direct formatted text in cell edit mode doesn't always retain the original direct formatting
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
113429:
Paste special - Text only, still pastes direct text formatting
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
38982:
Calc find & replace removes mixed cell formatting; undo does not restore it
[NEW; assigned to libreoffice-bugs]
-
108681:
[META] Cell formatting/style dialog bugs and enhancements
[NEW; assigned to libreoffice-bugs]
(*)
-
108730:
Calc cuts very high cells when printing or creating a PDF
[NEW; assigned to libreoffice-bugs]
-
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]
-
92416:
SIDEBAR: Functions pane improvements
[NEW; assigned to libreoffice-bugs]
-
60230:
Wrong function displayed when using Function list.
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
85897:
SIDEBAR: Make 'Function List' only accessible in sidebar
[RESOLVED FIXED; assigned to samuel.mehrbrodt]
-
92219:
Formula bar function wizard button should open the functions pane of sidebar
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
122718:
Sidebar Functions panel misses search like Function Wizard
[VERIFIED FIXED; assigned to rafael.palma.lima]
-
126666:
Make bottom description area in Sidebar's Function section more high
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
145741:
Calc Sidebar Function List Window does not permit size adjustment
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
154994:
Functions sidebar should be searchable as soon as it is focused
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
156378:
Pressing F1 with a function selected in the Functions sidebar should open corresponding help page
[RESOLVED FIXED; assigned to rafael.palma.lima]
-
92416:
SIDEBAR: Functions pane improvements
[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]
-
33387:
Last Used category in Function Wizard can not contain functions from Add-In
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
34356:
reference to external data via function wizard is not possible
[CLOSED FIXED; assigned to kohei]
-
49675:
shift+f4 doesn't work in the function wizard dialog (change to absolute reference)
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
67473:
UI: wrong help text displayed in function wizard list
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
67974:
UI: Add a search box in function wizard in Spreadsheet
[RESOLVED FIXED; assigned to abhilash300singh]
-
76343:
EDITING: Single quotes instead of double quotes for raw text in function wizard
[CLOSED NOTABUG; assigned to libreoffice-bugs]
-
85134:
Function wizard selecting the range of field does not allow dragging the limit
[CLOSED DUPLICATE; assigned to libreoffice-bugs]
-
92219:
Formula bar function wizard button should open the functions pane of sidebar
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
(*)
-
94125:
Assertion failed in function wizard
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
98315:
Function Wizard showing Breeze icons when in Sifr theme
[RESOLVED FIXED; assigned to cassie_lx]
-
101465:
If statement Function Wizard Result not the same as cell
[CLOSED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
101473:
[EDITING] Function wizard crashes LibO when evaluating addin that implement XVolatileResult
[RESOLVED FIXED; assigned to erack]
-
101876:
UI: resizing function wizard only resize the formula field, not the structure and parameter fields width
[VERIFIED FIXED; assigned to heiko.tietze]
-
104487:
Function Wizard should remember Category selection per session
[RESOLVED FIXED; assigned to andreas.heinisch]
-
105583:
Height of function wizard dialog too large
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
116511:
Calc crashes when opening Function Wizard through Cmd-F2 shortcut
[VERIFIED FIXED; assigned to tml]
-
123479:
Crash in: ScFormulaResult::GetMatrixFormulaCellToken()
[VERIFIED FIXED; assigned to l.lunak]
-
124279:
Function wizard structure tab shows inconsistent intermediate results
[RESOLVED FIXED; assigned to Katarina.Behrens]
-
131169:
Function wizard not correctly using the Add-In category
[RESOLVED FIXED; assigned to serval2412]
-
131423:
Function Wizard in Calc allows too many parameters
[VERIFIED FIXED; assigned to erack]
-
132173:
Function Wizard does not enter array formulas with inline arrays correctly
[VERIFIED FIXED; assigned to erack]
-
140554:
FIXED Function Wizard needs an update
[RESOLVED FIXED; assigned to erack]
-
146781:
Function wizard - allow search description of functions.
[VERIFIED FIXED; assigned to andreas.heinisch]
-
150465:
RANDBETWEEN() description in Function wizard should include whether the upper and lower bounds are included
[VERIFIED FIXED; assigned to rafael.palma.lima]
-
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]
-
72440:
Function Wizard Range Selection Resulted in #REF Error
[VERIFIED FIXED; assigned to jumbo4444]
-
79892:
Performance regression between 3.6 and later version, triple time to do the calculations (win only)
[VERIFIED FIXED; assigned to aron.budea]
-
83746:
FILEOPEN: When opening an .xls with a 1-1M VLOOKUP range, the range is truncated to 1-983040
[RESOLVED FIXED; assigned to erack]
-
87973:
XLSX:vlookup formula changed in path to external csv file after saved and re-opened
[RESOLVED FIXED; assigned to attila.szucs]
-
92456:
Vertical lookup freeze with large row
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
106575:
Correct VLOOKUP Formula - Incorrect Value shown. Shows correct value if formula reapplied / changes made in other sheets
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
107160:
VLOOKUP gets incorrect Value | Ctrl-Shift-F9 doesn't help
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
107371:
Enhancement to Calc functions MATCH, HLOOKUP and VLOOKUP
[RESOLVED INVALID; assigned to libreoffice-bugs]
-
107815:
Semicolon changing to comma in VLOOKUP
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
108268:
EDITING: Vlookup doesn't work
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
115490:
VLOOKUP unsorted is (too) slow in larger row sets, filling all cells in the column with the formula
[RESOLVED FIXED; assigned to dennisfrancis.in]
-
118990:
VLOOKUP in XLSX with external reference to Windows share saved incorrectly
[RESOLVED FIXED; assigned to mikekaganski]
-
119083:
Recalculation is slow with 90000 VLOOKUP
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
119659:
LOOKUP function >> application crashes, if "Result vector" argument is array of constant with more than one value in search direction, and search value is out of vector
[RESOLVED FIXED; assigned to erack]
-
121277:
External reference selection for function PROCV (vlookup)
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
124513:
Calc: Unable to reference cells in another workbook using mouse from Function Wizard
[RESOLVED WORKSFORME; assigned to caolan.mcnamara]
-
126651:
vlookup function can't draft mouse in different calc
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
139444:
VLOOKUP function very slow on Large Tables in Calc
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
144931:
300k x 100k vlookup lead to crash
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
153737:
After upgrading from LO 7.3.7.2 to 7.4.5.1 vLookup with DDE file descriptor does not work right
[RESOLVED DUPLICATE; 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]
-
93171:
Subtotal function with function indexes 101-111 don't update when rows are hidden (hard recalculation is needed)
[RESOLVED FIXED; assigned to erack]
-
95067:
UI: Subtotal tool option to use subtotal functions that exclude hidden cells
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
114241:
Subtotal syntax should allow function name
[CLOSED WONTFIX; assigned to libreoffice-bugs]
-
115022:
subtotal in .xlxs wrong on fileopen with Recalculation on File Load
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
119913:
FILEOPEN: XLSX: Wrong subtotal using autofilter after hard recalculating
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
126505:
Wrong Subtotal of auto-filtered rows on opening XLSX (comment 6)
[CLOSED DUPLICATE; assigned to libreoffice-bugs]
-
131541:
Calc seems to miscalculate when using subtotals but not with sum
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
133506:
Subtotal function to obtain the number of particular non numeric values
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
133886:
Libreoffice Calc Subtotals check all columns at once
[RESOLVED FIXED; assigned to yagit]
-
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]
-
149041:
Calc SUM button confusing with selected cells
[NEW; assigned to libreoffice-bugs]
-
71339:
EDITING sigma icon (sum function) operating on selected range
[VERIFIED FIXED; assigned to erack]
-
82481:
SUM() copies cell formats
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
86576:
Division of two =SUM() functions holding currency formatted data is incorrectly assigned currency cell formatting
[CLOSED FIXED; assigned to erack]
-
106987:
SUM not using round up for Total
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
109075:
Function Sum calculated cell is not correct
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
116104:
trivial sum() bad value
[RESOLVED NOTOURBUG; assigned to libreoffice-bugs]
-
116215:
Sum button: Calc adds wrong sum formulas if you select more than one row or column
[VERIFIED FIXED; assigned to erack]
-
116421:
autosum is not working
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
122025:
Cell format change back cause sum function problem.
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
124669:
Error in the function SUM (LibreOffice Calc)
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
124712:
LibreCalc sum function returns a 0 when used to sum data from an imported csv file.
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
130356:
Wrong calculations in CALC (SUM function)
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
132741:
Sum() function with range declared with $ returning #VALUE!
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
135391:
Sum function not working correctly with dollar format
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
142307:
Upgrade SSE2 sum to AVX512 sum with Neumaier (precise fp-sum)
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
146367:
SUM() does not use approx summation anymore since Kahan summation is used
[RESOLVED FIXED; assigned to erack]
(*)
-
149071:
SUMIFS generates wrong result
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
149041:
Calc SUM button confusing with selected cells
[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]
-
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]
-
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]
-
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]
-
160753:
XMATCH function in search for empty cell is different to Excel
[ASSIGNED; assigned to balazs.varga991]
-
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]
-
50882:
add function XOR to calc as defined in ODFF1.2
[RESOLVED FIXED; assigned to osc]
-
50950:
modify calc functions WEEKNUM, WEEKNUM_ADD to comply with ODFF1.2
[RESOLVED FIXED; assigned to winfrieddonkers]
-
51017:
ODFF: implement missing imaginary functions
[RESOLVED FIXED; assigned to erack]
-
56124:
add calc functions IFERROR and IFNA as in ODFF1.2
[RESOLVED FIXED; assigned to erack]
-
57180:
add calc function NUMBERVALUE() as in ODFF1.2
[RESOLVED FIXED; assigned to osc]
-
60322:
add calc function SKEWP as in ODFF v1.2
[RESOLVED FIXED; assigned to osc]
-
100749:
ODDFYIELD and ODDFPRICE function not working
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
107135:
Add missing functions FINDB, REPLACEB, SEARCHB
[RESOLVED FIXED; assigned to winfrieddonkers]
-
50882:
add function XOR to calc as defined in ODFF1.2
[RESOLVED FIXED; assigned to osc]
-
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]
-
40975:
Add "differentiation" function to Calc
[NEW; assigned to libreoffice-bugs]
-
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]
-
45802:
LibreOffice fails to update cell reference field after changing between A1/R1C1
[NEW; assigned to libreoffice-bugs]
-
109178:
[META] Named Cell Ranges and Formula Expressions bugs and enhancements
[NEW; assigned to libreoffice-bugs]
(*)
-
109182:
[META] Cell freezing/fixing/locking bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
33398:
Add "grab and drag" to freeze columns and rows
[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]
(*)
-
90630:
Weird visual behaviour when activating/deactivating freeze pane
[NEW; assigned to libreoffice-bugs]
-
90998:
Freeze multiple rows/cols
[NEW; assigned to libreoffice-bugs]
-
99570:
Freeze cells should expand when adding rows above or columns left of freeze
[NEW; assigned to libreoffice-bugs]
-
102939:
freeze cells not operating properly with multiple sheets selected
[NEW; assigned to libreoffice-bugs]
-
107994:
UI: Make Ctrl+Home move the cursor to the first non-frozen cell in the sheet
[NEW; assigned to libreoffice-bugs]
-
109517:
Not moving freeze pane inserting a new sheet in a Excel 97 file in hidden mode
[NEW; assigned to libreoffice-bugs]
-
112641:
freeze rows/columns functions incorrect or unexpected when frozen rows/columns don't fit in Window
[NEW; assigned to libreoffice-bugs]
-
117117:
Copy sheet to new file loses "Freeze Rows and Columns"
[NEW; assigned to libreoffice-bugs]
-
121219:
UI: Split view separator lines responsive on double click only after move by mouse
[NEW; assigned to libreoffice-bugs]
-
123634:
Calc does not adjust columns correctly when they are frozen
[NEW; assigned to libreoffice-bugs]
-
124653:
Frozen pane disapear on window resize
[NEW; assigned to libreoffice-bugs]
-
126221:
Frozen rows/columns + validity error + mouse click ends in range selection mode
[NEW; assigned to libreoffice-bugs]
-
130319:
Zooming right in causes Freeze Cells point to be forgotten after inevitable zoom out again
[NEW; assigned to libreoffice-bugs]
-
131450:
Frozen rows and columns are ignored when scrolling
[NEW; assigned to libreoffice-bugs]
-
133796:
[EDITING] Scroll Lock mode fails for horizontal cursor keys, when there are frozen rows and columns
[NEW; assigned to libreoffice-bugs]
-
134343:
Selecting cell in left split window causes right window cells to jump
[NEW; assigned to libreoffice-bugs]
-
142250:
[EDITING] Frozen Rows/Columns reset when unfolding an outline-group causes the border outside of window
[NEW; assigned to libreoffice-bugs]
-
145229:
Calc modifies split screen dimensions across SAVE/OPEN
[NEW; assigned to libreoffice-bugs]
-
146469:
Protected cell information popup can't be closed in X11 (steps in comment 4)
[NEW; assigned to libreoffice-bugs]
-
150871:
Calc sheet UI doesn't redraw after dragging split view bar
[NEW; assigned to libreoffice-bugs]
-
154913:
Poor performance for ODS with frozen rows and columns
[NEW; assigned to libreoffice-bugs]
-
155803:
Can't do "undo" or "redo" for freezing actions
[NEW; assigned to libreoffice-bugs]
-
156434:
[EDITING] Freeze Rows and Columns are lost when sheet is moved/copied to another document
[NEW; assigned to libreoffice-bugs]
-
160654:
drawing of cell borders severely broken (appearing/disappering) as one scrolls through columns
[NEW; 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]
(*)
-
59375:
EDITING: When user choose "freeze" in window menu and then will add or delete rows/colums over lock point - lock scape is not changed
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
60494:
UI: Expect minimum split pane height to depend on row 1 text line height and zoom level (now min 2 rows at 66%)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
90961:
Column/Row context menu should have a "freeze" entry for titles/headers
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
97105:
Freeze rows and columns part should be updated.
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
99477:
EDITING: "View> Freeze Cells> Freeze First..." does not work if the sheet is already frozen
[CLOSED FIXED; assigned to libreoffice-bugs]
-
100666:
Freeze First Row/Column commands only works if the first row/column is visible on the screen
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
104474:
Cell graphics rendering glitches with Freezing Rows/Columns or Split Windows
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
104490:
Freeze column button in drop down menu or on tool bar do absolutely nothing. no response and cells do not freeze
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
104643:
FILESAVE: Frozen row is not saved in XLS or XLSX (wayland)
[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]
(*)
-
112998:
Calc Hangs When Auto-filter Is Set and Row/Column Freeze Enabled and Fcitx Input Method Enabled
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
113800:
EDITING: Formula Bar Is Not Getting Focus When Column/Row Freeze Enabled
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
115303:
FILESAVE CALC Freeze Cells fails when window frame abuts frozen pane
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
120117:
Resizing the window destroys Column/Row Freeze State
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
127462:
UI: Add default option in split button for 'Freeze Rows and Columns'
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
143167:
Calc "Freeze Rows and Columns" randomly forgets row and column settings even though feature still checked on
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
147683:
Cell focus
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
150757:
Freeze setting for rows and columns not saved
[RESOLVED WORKSFORME; 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]
(*)
-
156075:
Freeze rows and columns, or Split window properties, are lost when the area cannot be shown by small window size
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
33398:
Add "grab and drag" to freeze columns and rows
[NEW; assigned to libreoffice-bugs]
-
112128:
[META] Cell edit mode bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
42471:
Undo of cell style background formatting does not work when cell is in edit mode / undo stack of cell editing is sort of separated..
[NEW; assigned to libreoffice-bugs]
-
65563:
RTL: Arabic/Hebrew text appears left aligned during cell edit when horizontal text alignment is set to Default
[NEW; assigned to libreoffice-bugs]
-
74375:
EDITING: Option to enable editing keys (cursor, Home, etc.) on first entry of text into cell (without the need to start editing mode with F2)
[NEW; assigned to libreoffice-bugs]
-
87420:
In-cell editing field is always top-aligned
[NEW; assigned to libreoffice-bugs]
-
93834:
CALC: Moving with arrows doesn't work when cells activated by double mouse click and '=' clicked
[NEW; assigned to libreoffice-bugs]
-
103583:
Size of input field in cell can increase but not decrease
[NEW; assigned to libreoffice-bugs]
-
106113:
EDITING: Text in cells has different vertical alignment when being edited
[NEW; assigned to libreoffice-bugs]
-
129369:
Function suggestion while editing end of text content in cell
[NEW; assigned to libreoffice-bugs]
-
138553:
When I write formula, I can't see the selected cells
[NEW; assigned to libreoffice-bugs]
-
144194:
CALC cell EDIT failure when right Justified formatting forces the exposed formula across the preceding cell
[NEW; assigned to libreoffice-bugs]
-
144296:
Under-engineered and inconsistent overflow/extension direction choice incl. with cell edit mode
[NEW; assigned to libreoffice-bugs]
(*)
-
147222:
Incorrect rendering when deleting lines in a cell with multiline text
[NEW; assigned to libreoffice-bugs]
-
148242:
Suppress formula handles where the function range exceeds the visible area
[NEW; assigned to libreoffice-bugs]
-
155891:
Option to REQUIRE pressing F2 or Enter to switch to cell edit mode and ignore any data entry attempts otherwise
[NEW; assigned to libreoffice-bugs]
-
63374:
calc gives no visual clue about enter/edit cell mode
[RESOLVED FIXED; assigned to sahil]
-
87459:
CONTEXT MENU: Addition of 'Edit Hyperlink' entry in cell edit mode
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
(*)
-
92605:
Format for editing Time does not match the format assigned to a cell.
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
100925:
When overwriting a cell, new content is displayed on top of the old content until finishing the edit
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
106426:
Calc UI visual glitch- edited cell font jumps above baseline
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
108560:
Pasting or editing large amount of multi-line text into a cell result in unusable Calc with GTK3 (steps to reproduce in comment 29)
[RESOLVED FIXED; assigned to caolan.mcnamara]
-
114675:
EDITING: pasting text (in Calc in a cell in edit mode, in Draw in a text shape), leaves the cursor in front of the pasted text
[RESOLVED FIXED; assigned to erack]
-
115792:
Cursor is in the wrong position after pasting text
[CLOSED DUPLICATE; assigned to libreoffice-bugs]
-
117413:
double display slightly offset when editing a cell
[RESOLVED FIXED; assigned to caolan.mcnamara]
-
125932:
Print/Export should close cells first
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
128527:
[EDITING] Create sheet during active cell editing puts content on newly created sheet
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
135761:
EDITING: Ctrl+Backspace between two spaces erases the space to the right
[RESOLVED FIXED; assigned to andreas.heinisch]
-
151562:
Text jumps down by a pixel after entering
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
155495:
Editing centered or right-aligned cell contents incorrectly
[VERIFIED FIXED; assigned to czeber.laszloadam]
-
160312:
Highlighting Calc cell when entering characters (not) in «Edit» mode
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
160908:
"Edit cell background highlight"
[RESOLVED FIXED; assigned to printfdebugging]
-
42471:
Undo of cell style background formatting does not work when cell is in edit mode / undo stack of cell editing is sort of separated..
[NEW; assigned to libreoffice-bugs]
-
112246:
Global changes of text attributes not work correctly
[NEW; assigned to libreoffice-bugs]
-
112451:
[META] Value highlighting bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
44669:
Setting "Display Zero Values" and "Value highlighting" without effect for CALC OLE objects VIEWING
[NEW; assigned to libreoffice-bugs]
-
53825:
UI: Value Highlighting with Format Templates
[NEW; assigned to libreoffice-bugs]
-
53826:
Value Highlighting separately activated
[NEW; assigned to libreoffice-bugs]
-
54975:
RFE: Value Highlighting: do not highlight constant expressions as formulas
[NEW; assigned to libreoffice-bugs]
-
47628:
VIEWING no background color on protected sheet with enabled 'Value Highlighting'
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
60875:
LOCALHELP incomplete for Menu 'View - Value Highlighting' of protected cells
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
116241:
Customizing value highlighting colors for colorblind users
[VERIFIED FIXED; assigned to szymon.klos]
-
44669:
Setting "Display Zero Values" and "Value highlighting" without effect for CALC OLE objects VIEWING
[NEW; assigned to libreoffice-bugs]
-
112560:
[META] Cell line spacing bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
63368:
FORMATTING: Images attached to cell get mispositioned when cell above is edited
[NEW; assigned to libreoffice-bugs]
-
108555:
Add line spacing feature to cell properties
[NEW; assigned to libreoffice-bugs]
(*)
-
112558:
Single line spacing of Calibri and Times New Roman no longer calculated correctly in Calc compared to Writer
[NEW; assigned to libreoffice-bugs]
-
112561:
XLS/XLSX/ODS - Excel uses a 1.12 line spacing for multiline text
[NEW; assigned to libreoffice-bugs]
-
112839:
[META] Regressions from the cross-platform consistent line spacing in 5.3+
[NEW; assigned to libreoffice-bugs]
-
112558:
Single line spacing of Calibri and Times New Roman no longer calculated correctly in Calc compared to Writer
[NEW; assigned to libreoffice-bugs]
(*)
-
117881:
FILEOPEN DOCX: Spacing in Linux is slightly different from Windows for bullet lists with Microsoft fonts
[NEW; assigned to libreoffice-bugs]
-
159488:
FILEOPEN DOCX Specific document is rendered more tightly as in Word
[UNCONFIRMED; assigned to libreoffice-bugs]
-
104932:
FILEOPEN: last page is missing due to line spacing
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
105860:
VIEWING: line spacing is too small compared to older versions and other programs
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
106111:
Display, PDF, print and print preview broken for all spreadsheets with line breaks (5.3 regression) (steps in comment 40)
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
107249:
Rendering of system font vertically cramped or cropped in dialog labels and controls in 5.3+
[RESOLVED FIXED; assigned to caolan.mcnamara]
-
107605:
Formatting fonts with bad metrics causes line height problems, e.g. Cardo
[VERIFIED FIXED; assigned to khaled]
-
108710:
Line spacing is too small in web view
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
116498:
Wrong font metrics with Font "DIN Light"
[VERIFIED FIXED; assigned to samuel.mehrbrodt]
-
155297:
FILEOPEN DOCX loading loses paragraph line spacing
[RESOLVED FIXED; assigned to khaled]
-
112558:
Single line spacing of Calibri and Times New Roman no longer calculated correctly in Calc compared to Writer
[NEW; assigned to libreoffice-bugs]
-
105860:
VIEWING: line spacing is too small compared to older versions and other programs
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
(*)
-
108891:
Increase inter-line spacing for multiline text
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
112257:
Calc (5.3.3.2) FORMATTING: "Optimal row hight" height too small for multiline cells when printig or pdf-Export
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
112497:
Inter-line spacing for multiline text needs more love
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
112824:
Line spacing problem of Futura-Book
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
63368:
FORMATTING: Images attached to cell get mispositioned when cell above is edited
[NEW; assigned to libreoffice-bugs]
-
113499:
[META] AutoFill bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
45061:
EDITING: drag-fill works only linearly (cannot fill both directions at once)
[NEW; assigned to libreoffice-bugs]
-
47778:
EDITING: Filling down or across through merged cells undoes the merge
[NEW; assigned to libreoffice-bugs]
(*)
-
65198:
EDITING: No autofill to add sequential Latin alphabet letters in cells
[NEW; assigned to libreoffice-bugs]
-
68047:
EDITING: fill with series isn't working without selecting of cell group
[NEW; assigned to libreoffice-bugs]
-
74393:
EDITING: Autofill tooltip should be based on numeric cell if one is present
[NEW; assigned to libreoffice-bugs]
-
93298:
Enable autofill handle while in cell edit mode
[NEW; assigned to libreoffice-bugs]
-
94669:
Calc editing - autofill step-size: suggest no increment if the sequence initially contains only one cell.
[NEW; assigned to libreoffice-bugs]
-
98263:
Autofill does not respect data validation rule
[NEW; assigned to libreoffice-bugs]
-
106060:
Calc - Formula drag & Autofill - The values of the filled formula cells include only first sheet values
[NEW; assigned to libreoffice-bugs]
-
109003:
Feature request: Auto filling cells by example / context of neighbouring cells, aka "Flash Fill"
[NEW; assigned to libreoffice-bugs]
-
109332:
[FEATURE] Pulling months should keep the case
[NEW; assigned to libreoffice-bugs]
-
118658:
Fill handle should be visible at the beginning of the row, when whole rows are selected
[NEW; assigned to libreoffice-bugs]
-
126189:
Enhance autofill to better sense data blocks with empty cells or columns
[NEW; assigned to libreoffice-bugs]
-
130570:
Make auto-increment on copied numbers configurable
[NEW; assigned to libreoffice-bugs]
-
131029:
When the time is autofilled, the integer part is incremented
[NEW; assigned to libreoffice-bugs]
-
134293:
Inconsistent double-click AutoFill behavior when rows are hidden or grouped
[NEW; assigned to libreoffice-bugs]
-
136004:
calc: UI: fill: 'Fill series' with values of type 'date' doesn't apply appropriate cell format
[NEW; assigned to libreoffice-bugs]
-
139681:
CALC AUTOFILL EDIT When the source cell range contents contain formulae, the existing pattern is applied inconsistently
[NEW; assigned to libreoffice-bugs]
-
140703:
Calc: UI: fill: funny little fail with 'downfill', cells formatted as text filled in wrong direction - regression
[NEW; assigned to libreoffice-bugs]
-
140984:
EDITING Autofill with user list does not change small/large caps
[UNCONFIRMED; assigned to libreoffice-bugs]
-
149356:
Choose which adjacent column of a "double clicked" formula dictates the extent of the fill
[NEW; assigned to libreoffice-bugs]
-
150739:
Add an option to warn when autofill overwrites existing data (turned off by default)
[NEW; assigned to libreoffice-bugs]
-
157629:
Sheet fill series also copies formats
[NEW; assigned to libreoffice-bugs]
-
157731:
Re-initialize autofill rather than overwriting content
[NEW; assigned to libreoffice-bugs]
-
33708:
Calc autofill should also fill right of selection (not just down)
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
45502:
FORMATTING: Using the Fill handle on cells with dashes counts down, not up, and removes dash
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
49638:
FORMATTING: Edit Fill Down mishandles merged cells
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
(*)
-
53431:
FILTER: fill down a cell with Autofilter arrow box cause duplication of arrow box
[VERIFIED FIXED; assigned to attila.szucs]
-
54308:
Calc EDITING: drag&fill not working when select some cell and hold Ctrl
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
58745:
EDITING Extending date lists with dates of 29th or greater by dragging misses month ends
[RESOLVED FIXED; assigned to andreas.heinisch]
-
66890:
EDITING: Double-clicking fill handle should also overwrite down the entire range (until empty cells)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
77929:
Fill series should detect the last cell to be filled, rather than fill to row #1648576
[CLOSED DUPLICATE; assigned to libreoffice-bugs]
-
85170:
FillAuto doesn't fill formulas in hidden columns
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
88109:
PERF: Calc autofill is very slow
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
88782:
EDITING spreadsheet: autofill using fill handle inserts incorrect data when used with merged cells
[VERIFIED FIXED; assigned to attila.szucs]
(*)
-
89754:
using autofill on dates is wrong when increment should be 0
[RESOLVED FIXED; assigned to andreas.heinisch]
-
105268:
Auto Fill: The Next Value for "001-001-001" is "001-001-002" Rather than "001-001000"
[VERIFIED FIXED; assigned to danielfaleirosilva]
-
108209:
Autofill overwrites data with mixed empty and filled cells
[VERIFIED FIXED; assigned to erack]
-
113500:
AutoFill with combined cell content incorrectly increments value when starting from the same content
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
113785:
On filtered list an autofill upwards erases data (steps in Comment 3)
[RESOLVED FIXED; assigned to jluth]
-
114970:
Autofill also copies formatting - no option to preserve formatting of cells that are filled
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
115173:
EDITING: Drag to fill (Replicate) not always accurately replicating/updating cell references
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
115923:
Clicking the fill handle triggers automatic horizontal scrolling
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
126767:
Autofill doesn't overwrite data in continuously filled cells
[VERIFIED FIXED; assigned to erack]
-
137205:
EDITING Autofill of merged cells with date content incorrect, series detection does not work
[VERIFIED FIXED; assigned to attila.szucs]
-
137621:
EDITING Autofill of merged cells with Boolean content incorrect, series detection does not work
[VERIFIED FIXED; assigned to attila.szucs]
-
137624:
EDITING Autofill of merged cells with mixed content incorrect, series detection does not work
[VERIFIED FIXED; assigned to attila.szucs]
-
137625:
EDITING Autofill of merged cells with user list content incorrect, series detection does not work
[VERIFIED FIXED; assigned to attila.szucs]
-
137653:
EDITING Autofill user list items with more than 1 item difference does not work
[VERIFIED FIXED; assigned to attila.szucs]
-
137654:
EDITING Autofill with userlist items in reversed order does not work
[VERIFIED FIXED; assigned to attila.szucs]
-
137774:
Filling hidden cells fails
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
153517:
CALC - wrong time value when using the autofill function and minutes are entered (not for 00 min)
[VERIFIED FIXED; assigned to erack]
-
154578:
Fill square is reduced when pulling selection with CTRL pressed
[VERIFIED FIXED; assigned to balazs.varga991]
-
45061:
EDITING: drag-fill works only linearly (cannot fill both directions at once)
[NEW; assigned to libreoffice-bugs]
-
113540:
Setting the alignment of a cell to "Filled" does not show an arrow on overflowing content
[NEW; assigned to libreoffice-bugs]
-
113687:
Wrong cell attributes assumed
[NEW; assigned to libreoffice-bugs]
-
113726:
Trailing space in cell text not encoded as <text:s/>
[NEW; assigned to libreoffice-bugs]
-
114398:
Calc, on reopen, messes up soft newlines pasted from RichText format (comment 5)
[NEW; assigned to libreoffice-bugs]
-
114452:
The "increase indent" icon has no effect after reaching cell border in CALC
[NEW; assigned to libreoffice-bugs]
-
115775:
[META] Database Range and Consolidate bugs and enhancements
[NEW; assigned to libreoffice-bugs]
-
42196:
Automatically extend the chart data source range when adding rows at the end
[NEW; assigned to libreoffice-bugs]
-
45862:
[EDITING] Menu/Data/Consolidate, Only the last range to consolidate is saved in the file.
[NEW; assigned to libreoffice-bugs]
-
60167:
Database ranges don't get saved when saving to Excel 97/XP/2003
[NEW; assigned to libreoffice-bugs]
-
92981:
Wrong error in bracketing from xls file
[NEW; assigned to libreoffice-bugs]
-
94048:
Calc is too restrictive with naming cell ranges
[NEW; assigned to libreoffice-bugs]
-
117346:
color of Auto-FILTER-▼-Button does not switch back from blue to black after Filter RESET, still shows old filter settings
[NEW; assigned to libreoffice-bugs]
-
122318:
Not possible to create a dynamic Named Range with a calculated reference (like with OFFSET) and use it as a Print Range, like Excel can.
[NEW; assigned to libreoffice-bugs]
-
127419:
EDITING: Database range is extended automatically against my wishes when filtering
[NEW; assigned to libreoffice-bugs]
-
132191:
Refreshing a range applies the first data row's background color to all the other data rows
[NEW; assigned to libreoffice-bugs]
-
133529:
Calc: ui: filesave: conflict between sort and filter, unclear use of tag 'table:orientation'
[NEW; assigned to libreoffice-bugs]
-
136363:
calc: database-range definition broken on save-load cycle, (tag / attribute table:orientation="column" inserted)
[NEW; assigned to libreoffice-bugs]
-
137805:
[META] XLSX (OOXML) Data range / Format as Table issues
[NEW; assigned to libreoffice-bugs]
-
66377:
Support Table Styles / formatting coming from Excel's "Format As Table"
[NEW; assigned to libreoffice-bugs]
-
116331:
XLSX FILEOPEN Reference to an external *.xlsx file’s data table results an Error:508
[NEW; assigned to libreoffice-bugs]
-
122897:
FILESAVE XLSX Spreadsheet with Database Range is incorrect when the document is opened in Excel
[NEW; assigned to libreoffice-bugs]
-
130577:
FILEOPEN: XLSX import looses defined range definitions
[NEW; assigned to libreoffice-bugs]
-
132780:
Feature Request: Add Calc Tables with functionality similar to Excel's "Format as tables"
[NEW; assigned to libreoffice-bugs]
-
136541:
Fileopen XLSX and XLS: Some filter cells have no color
[NEW; assigned to libreoffice-bugs]
-
137846:
FILEOPEN XLSX Defined name pointing to data table does not resolve source file name
[NEW; assigned to libreoffice-bugs]
-
137847:
FILESAVE XLSX Named range pointing to data range in external file breaks
[NEW; assigned to libreoffice-bugs]
-
138704:
FILEOPEN XLSX AutoFilter in Table imported incorrectly, interacts weirdly with normal autofilter
[NEW; assigned to libreoffice-bugs]
-
139499:
FILESAVE XLSX Mangled structured references in Data Validity cell range criterion (column name saved in lowercase)
[NEW; assigned to libreoffice-bugs]
-
143058:
FILEOPEN XSLX following SAVE from ODS when Range Names are "large:
[NEW; assigned to libreoffice-bugs]
-
159341:
FILEOPEN XLSX Item references to table are not imported correctly
[NEW; assigned to libreoffice-bugs]
-
159343:
Function wizard breaks formula reference to database range
[NEW; assigned to libreoffice-bugs]
-
126926:
Extra filter icon appears on deleting sheet columns
[VERIFIED FIXED; assigned to tundeth]
-
131424:
FILEOPEN XLSX Table reference broken if named table header contains comma
[RESOLVED FIXED; assigned to erack]
-
132519:
CELL("ADDRESS";...) to other sheet from Workbook imported from Excel may let INDIRECT() fail with #REF! if string reference setting forces different syntax than current formula syntax (comment 9).
[RESOLVED FIXED; assigned to erack]
-
137091:
XLSX: Error 507 when opened with Turkish locale
[VERIFIED FIXED; assigned to erack]
-
144786:
FILEOPEN XLSX Hidden status of Table/Data range filter button not imported
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
147096:
XLSX - Calc validity dropdown selection doesn't work, a range name is missing
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
66377:
Support Table Styles / formatting coming from Excel's "Format As Table"
[NEW; assigned to libreoffice-bugs]
-
144048:
Calc: Define Range doesn't set selected range
[NEW; assigned to libreoffice-bugs]
-
147082:
Copying Sheet should also copy Range
[NEW; assigned to libreoffice-bugs]
-
148679:
Database range (and its column labels / totals settings) is not considered when expanding the range for sorting
[NEW; assigned to libreoffice-bugs]
-
152095:
Enhancement request : adding 'Data - Refresh all ranges' command
[NEW; assigned to libreoffice-bugs]
-
153221:
FILESAVE ODS Cell Validation source as structured reference is saved as absolute cell reference
[NEW; assigned to libreoffice-bugs]
-
155881:
Saving causes consolidate dialog to fill up with garbage ranges
[NEW; assigned to libreoffice-bugs]
-
157211:
EDITING: cell range selection modified when opening Calc's "Define Database Range" dialog
[NEW; assigned to libreoffice-bugs]
-
160018:
Defined Ranges in a single column with delimiting row corrupted by 7.6.5 (STR comment 5)
[NEW; assigned to libreoffice-bugs]
-
59312:
AUTOFILTER: in non functional after 'Copy Sheet' in new sheet
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
97907:
Sort extends database range (user is asked if the selection has to be extended with ...)
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
113585:
Auto Filter Columns are Treated Separately in the Attached ODS File
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
115520:
Define Database Range shouldn't close after having a false name
[VERIFIED FIXED; assigned to tundeth]
-
123598:
Autofilter removed from output range after save & reload
[VERIFIED FIXED; assigned to tundeth]
-
152577:
Database range disappears when deleting a sheet it doesn't belong to
[VERIFIED FIXED; assigned to tundeth]
-
155369:
Formula Calculation: Indirect() returns #REF!
[VERIFIED FIXED; assigned to dennisfrancis.in]
(*)
-
42196:
Automatically extend the chart data source range when adding rows at the end
[NEW; assigned to libreoffice-bugs]
-
119423:
CTRL+D leads to invalid merged cells that are not selectable and are not saved
[NEW; assigned to libreoffice-bugs]
-
119928:
Newline in cell formula are ignored when copy-pasting more than one cell in Calc 6.x
[NEW; assigned to libreoffice-bugs]
-
122373:
Date format convert to date and increment in copy enhancement
[NEW; assigned to libreoffice-bugs]
-
125077:
[META] regressions introduced by row height recalculation on document load
[NEW; assigned to libreoffice-bugs]
-
128204:
ODS file opens slow but after on/off Wrap text automatically it opens very fast (because of adapting row height)
[NEW; assigned to libreoffice-bugs]
-
140127:
Impossible to reach content because oversized cell caused by Wrap
[NEW; assigned to libreoffice-bugs]
-
146529:
FILEOPEN External document loading lookup fails if optimal height calculation is enabled on cell with reference (Windows-only)
[NEW; assigned to libreoffice-bugs]
-
159082:
Calc INDIRECT() links faulty in folders other than ~/documents on FILEOPEN
[NEW; assigned to libreoffice-bugs]
(*)
-
43804:
Slow FILEOPEN and EDITING of ODS spreadsheet because of adapt row height processing
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
123034:
Layout change after save & reload (caused by Text wrap)
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
124098:
FILEOPEN: Calc sheet showing multiple "adapt Row Height" responses, slow loading
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
124565:
FILESAVE: Pasted row height is reset by after saving and reopen
[VERIFIED FIXED; assigned to vasily.melenchuk]
-
127442:
Auto row height not set / not remembered in Calc
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
130383:
Filesave ODS: Row height after Optimal Height still opens as 1 line instead of 2 in cell F5 (not with XLS/X)
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
130795:
FILEOPEN: Spreadsheet takes long to open
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
132354:
Automatic Row height wrong after FileOpen (workaround: set height manually)
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
146668:
Height of cells with wrapped text is lost after saving, depending on the column width
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
128204:
ODS file opens slow but after on/off Wrap text automatically it opens very fast (because of adapting row height)
[NEW; assigned to libreoffice-bugs]
-
126829:
Able to apply an indent for right justified values in cell, even though indent not selectable
[NEW; assigned to libreoffice-bugs]
-
127188:
FORMATTING adding decimal places changes format
[NEW; assigned to libreoffice-bugs]
(*)
-
127241:
Date format not saved and read properly
[REOPENED; assigned to libreoffice-bugs]
-
127530:
Calc does not reapply DD-MMM-YY date formatting when modifying date values (en-US locale affected?)
[NEW; assigned to libreoffice-bugs]
-
131020:
Set Default Year for data entry with options
[REOPENED; assigned to libreoffice-bugs]
-
131166:
if Excel .xlsx spreadsheet FILESAVE to .ods file some FORMATTING is changed rendering spreadsheet unusable
[NEW; assigned to libreoffice-bugs]
-
133764:
[META] Very large spreadsheets problem
[NEW; assigned to libreoffice-bugs]
-
91424:
handling of relative references in OOXML range names
[NEW; assigned to libreoffice-bugs]
(*)
-
133619:
[META] Regressions from increasing column limit in Calc (mainly bug 50916)
[NEW; assigned to libreoffice-bugs]
-
153399:
[UI] Vertical scrolling becomes unresponsive when hide columns option is used such that the background is visible
[NEW; assigned to libreoffice-bugs]
-
153644:
Calc: Undo doesn't remove cell's borders
[NEW; assigned to libreoffice-bugs]
-
108284:
FILEOPEN ODS: Opening is slower as it used to be in earlier releases
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
124778:
View - Comments causes crash
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
124815:
CRASH: inserting a column
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
124816:
CRASH: inserting a new row
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
124818:
CRASH: selecting all and switching spreadsheet
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
124822:
CRASH: cutting and undoing
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
124896:
CRASH: deleting sheet
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
124997:
Columns don't have vertical gridlines after column 64
[VERIFIED FIXED; assigned to mikekaganski]
-
125051:
EDITING: CRASH when start SpellCheck
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
126418:
Crash in: ScColumn::MergeBlockFrame(SvxBoxItem *,SvxBoxInfoItem *,ScLineFlags &,long,long,bool,short)
[VERIFIED FIXED; assigned to mikekaganski]
-
126685:
CRASH: selecting all in sheet
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
126904:
In LO Calc: Right arrow causes a large unexpected column jump in protected sheet.
[RESOLVED INVALID; assigned to libreoffice-bugs]
-
126905:
Unexpected change in right-click menu and associated command availability.
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
128562:
Pressing F5 (Navigation) in Calc crashes document, corrupts user profile, and makes Calc impossible to use
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
128753:
CRASH: Closing LibreOffice after cutting content from document
[CLOSED FIXED; assigned to serval2412]
-
128895:
Hidden Columns but keep reappearing! Unlike Rows which will stay hidden (steps: comment 19)
[RESOLVED FIXED; assigned to jluth]
-
128951:
API: inserting a sheet fails with IllegalArgumentException
[RESOLVED FIXED; assigned to mikekaganski]
-
129533:
Calc crashes on Navigator click or move
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
129908:
Crash at Data > Group and outlone > AutoOutline
[VERIFIED FIXED; assigned to libreoffice-bugs]
(*)
-
130959:
LibreOffice crashes when opening files with non-existing hyperlinks
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
131455:
Right arrow causes a large unexpected column jump. ( steps in comment 4 )
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
131907:
Crash: reject/clear formatting
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
132057:
Calc jumping to "protected cells" during data entry in spreadsheets
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
132278:
crash after opening an old file
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
133326:
Crash after redo (steps in comment 5)
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
133629:
FORMATTING: Calc crashes on setting borders to all cells on more than one sheet simultaneously
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
134461:
FILEOPEN XLSX Crash when header is set & Jumbo tables enabled
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
134552:
EDITING Calc custom row height not applied with very large spreadsheets
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
134553:
New or XLSX-imported chart and images disappears with Jumbo sheets enabled
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
135332:
Crash: Scroll sidebar on Data Provider, which was opened by TAB UI
[RESOLVED FIXED; assigned to tusharrai282]
-
139782:
Calc crashes opening file containing "MATCH" formula referencing not yet allocated column
[VERIFIED FIXED; assigned to m.weghorn]
-
140014:
Calc crashes when using COUNTIF, SUMIF, etc. on columns "far away" without data
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
140607:
LibreOffice with enabled Jumbo table feature crashes when I try open XLS file from bug 122092
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
144537:
Small Calc ODS with simple chart: crash on row delete if jumbo option on
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
146162:
JUMBO SHEETS: cannot hide all columns
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
146861:
Crash when Undo Clone formatting with Jumbo sheets active
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
147830:
CRASH when apply particular advanced filter in particular document
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
149152:
I cannot insert and display a pdf into a Calc spreadsheet.
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
149968:
Calc crashes when I delete a empty row in a 16M row fairly "empty" spreadsheet with a simple chart in it. Crash in: ScDocument::DelBroadcastAreasInRange(ScRange const&)
[VERIFIED DUPLICATE; assigned to libreoffice-bugs]
-
151946:
Opening spreadsheet very slow
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
153399:
[UI] Vertical scrolling becomes unresponsive when hide columns option is used such that the background is visible
[NEW; assigned to libreoffice-bugs]
-
138426:
Right arrow causes a large unexpected column jump ( part 2 )
[NEW; assigned to libreoffice-bugs]
-
148038:
[META] Calc spreadsheets with more than 1048576 rows
[NEW; assigned to libreoffice-bugs]
-
113611:
The data could not be loaded completely because the maximum number of rows per sheet was exceeded
[NEW; assigned to libreoffice-bugs]
-
135913:
Parts of sheet not visible with 16m rows
[NEW; assigned to libreoffice-bugs]
-
147920:
FILEOPEN XLSX Chart disappears with jumbo tables on
[NEW; assigned to libreoffice-bugs]
-
148552:
Chart moves of Calc grid when shrinking the chart (Jumbo sheet)
[NEW; assigned to libreoffice-bugs]
-
148492:
EDITING: Ctrl+Cursor jumping slow in jumbo sheet with freezed columns
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
113611:
The data could not be loaded completely because the maximum number of rows per sheet was exceeded
[NEW; assigned to libreoffice-bugs]
-
150505:
Whole-row protections are inconsistent between LO 7.3 and 7.4
[NEW; assigned to libreoffice-bugs]
(*)
-
151049:
16K columns: Show an infobar when there are pre-defined now-invalid range names
[NEW; assigned to libreoffice-bugs]
-
50916:
Allow more than 1024 columns in calc
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
105036:
xlsx file with huge drawing.xml will not open
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
109061:
xlsx import : large ranges in formula shows error on recalc
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
133033:
CRASH: With Ctrl+Down or Ctrl+A when 'Enable very large spreadsheets' is active
[VERIFIED FIXED; assigned to libreoffice-bugs]
(*)
-
133649:
paste special command when experimental very large spreadsheet option is active will crash
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
133730:
Fatal Error: multi_type_vector::position with "enable support for large sheets"
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
133748:
Slow when switching sheets with "support for large sheets enabled"
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
133749:
Slow saving with "support for large sheets enabled" compared to normal
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
133751:
Crash selecting multiple columns with Support for large sheets enabled
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
133830:
Crash mergedlo!SfxSetItem::GetItemSet+0 with "support for large sheets enabled"
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
133853:
Number of columns in large sheets 16385 (XFE) instead of XFD (16384)
[VERIFIED FIXED; assigned to aron.budea]
-
133880:
2^20 Table Rows, in this age of (supposedly) 64 bit Software? I need well over two (2) Million!
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
134362:
Very large spreadsheets crash with more than 1048576 rows
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
134392:
CRASH: importing file with Enable very large spreadsheets enabled
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
134550:
FILEOPEN: Large Spreadsheet Experimental XLSX Crash in: ScBroadcastAreaSlotMachine::StartListeningArea(ScRange const &,bool,SvtListener *)
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
135420:
FILESAVE (Calc-large-spreadsheets): Can't save large spreadsheet correctly
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
135507:
UI: Navigator (F5) doesn't go to column > AMJ in very large spreadsheets
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
136156:
Calc scales a sheet with delay if enabled very large spreadsheets (macOS only?)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
136546:
Crash when loading xlsx spreadsheet with many columns
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
136735:
Calc with large spreadsheets enabled crashes when highlighting column
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
136818:
Calc crashes when I try open a file (Very large table option is enabled)
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
137228:
The data could not be loaded completely because the maximum number of columns per sheet was exceeded.
[CLOSED DUPLICATE; assigned to libreoffice-bugs]
-
141647:
XLSX: CHARTS: Calc lost diagrams on different sheets
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
143214:
Large spreadsheets: Calc crashes (sometimes) when I change a value after a certain column ( steps in comment 10 )
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
144363:
Experimental 4k+ columns bugs - 1) Merged / Big cells are confused in view, 2) cannot delete rows
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
144380:
Experimental Features - Forever loop for Deleting all columns
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
145839:
Calc crashes when applying filter to a column in an xlsx file
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
146162:
JUMBO SHEETS: cannot hide all columns
[RESOLVED FIXED; assigned to libreoffice-bugs]
(*)
-
146815:
Crash in: SfxSetItem::GetItemSet() with Paste transposed - steps Comment 13
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
147451:
Crash when click hyperlink to file
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
147458:
Pasting chart out of visible range (of the cell grid) with Jumbo sheet turned ON
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
147509:
You can't insert a column after selected if the Jumbo feature is enabled
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
147830:
CRASH when apply particular advanced filter in particular document
[RESOLVED FIXED; assigned to libreoffice-bugs]
(*)
-
147894:
Calc is crashed when I tried fill a range to right from A1 to XFD1
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
148143:
CRASH: after pasting twice the whole sheet
[RESOLVED FIXED; assigned to kohei]
-
148147:
Calc freezes on "Sheet" menu after selecting multiple row ranges
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
149112:
Showing subtotals dialog takes long time with 16K columns
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
149764:
user-defined rows by columns (RxC, 2RxC/2, 4RxC/4, 8RxC/8, 16CxC/16)
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
150430:
FILEOPEN / EDITING: Rows and row headers are not aligned to each other to the point of incorrect cell selection
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
150648:
EAN13 function works in spreadsheet with LibreOffice 7.3 not 7.4
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
(*)
-
151046:
INDIRECT() with a loaded range name argument matching a (now 16k column) cell address uses cell reference instead.
[RESOLVED FIXED; assigned to erack]
-
160399:
Print Preview freezes with whole row merged in large spreadsheet
[RESOLVED FIXED; assigned to libreoffice-bugs]
(*)
-
91424:
handling of relative references in OOXML range names
[NEW; assigned to libreoffice-bugs]
-
134249:
Option Text Overflow should block overflow
[NEW; assigned to libreoffice-bugs]
-
134707:
FILEOPEN XLSX : Set the alignment of the text and the text is compressed
[NEW; assigned to libreoffice-bugs]
-
137222:
Wrong format of text in cell A81
[NEW; assigned to libreoffice-bugs]
-
138872:
FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)
[UNCONFIRMED; assigned to libreoffice-bugs]
-
141891:
UI: adjacent cells formatted slanted and horizontal don't colour correctly
[NEW; assigned to libreoffice-bugs]
-
145911:
Optimal Width incorrectly assesses cells where wrapping is active (see comment 2)
[NEW; assigned to libreoffice-bugs]
-
146142:
Automatic number formatting not undone after search and replace
[NEW; assigned to libreoffice-bugs]
-
148689:
[FILEOPEN] "Symbolic Link" SLK / SYLK trigrams
[NEW; assigned to libreoffice-bugs]
-
148827:
[FILEOPEN] "Symbolic Link" SLK / SYLK incorrect date
[NEW; assigned to libreoffice-bugs]
-
151196:
FORMATTING "MM/DD/YYYY HH:MM" won't wrap (wrapping uses pre-formatted data?)
[NEW; assigned to libreoffice-bugs]
-
151839:
CharBackColor text property in Calc cells is available in API, but not exported to file formats, nor accessible from UI
[NEW; assigned to libreoffice-bugs]
-
152588:
FILEOPEN, FORMATTING Invalid row height when opening Excel file saved with aspose-cells
[NEW; assigned to libreoffice-bugs]
-
153316:
Tabs replaced with SOH character in multi-line text
[NEW; assigned to libreoffice-bugs]
-
153624:
Cell focus highlight frame is thicker after ROW 99865 or higher (after millionth row) (without Skia)
[NEW; assigned to libreoffice-bugs]
-
154131:
Add option to not detect numbers in scientific notations (like 1E1 or 5E2) at text paste / import
[ASSIGNED; assigned to jumbo4444]
(*)
-
154145:
UI: Vertical or Horizontal Alignment in Calc being set to default, but it's not clear what it does
[NEW; assigned to libreoffice-bugs]
-
154189:
Opening an xlsx in 7.5.1 removes color and border formatting which used to show in 7.3.5 and shows in Excel
[NEW; assigned to libreoffice-bugs]
-
154792:
Calc Round Down is Rounding Up for some values
[REOPENED; assigned to libreoffice-bugs]
-
154812:
Unable to click on the left side of a formula when it is centered in a cell
[NEW; assigned to libreoffice-bugs]
-
154820:
Pasting a cell from Excel changes the default cell style
[NEW; assigned to libreoffice-bugs]
-
155146:
Add vertical overflow indicator to Calc cells (decription in comment 3)
[NEW; assigned to libreoffice-bugs]
-
155886:
Hash marks that indicate "cell too narrow" should fill up the cell width
[NEW; assigned to libreoffice-bugs]
-
156564:
Extra pages printed with Shrink to fit cell size
[NEW; assigned to libreoffice-bugs]
-
156667:
Calc: setting number of decimal places to 0 directly has no effect, unless you set it to 1 first
[NEW; assigned to libreoffice-bugs]
-
156735:
Background color of loaded XLSX not shown
[NEW; assigned to libreoffice-bugs]
-
157082:
Calc Round Up is Rounding Down for some values
[REOPENED; assigned to libreoffice-bugs]
-
157618:
FILESAVE: Calc ignores directly formatted text color in .ods files
[NEW; assigned to libreoffice-bugs]
-
158403:
Generated document not showing correctly values in LibreOffice Calc
[REOPENED; assigned to libreoffice-bugs]
-
158502:
Can't have added text before format codes with NatNum modifier
[NEW; assigned to libreoffice-bugs]
-
158555:
[NatNum12] does not allow literal text to the left of 0
[NEW; assigned to libreoffice-bugs]
-
158626:
Cell background colour (from "Office" document theme) is changed on xlsx-ods-xlsx conversion
[NEW; assigned to libreoffice-bugs]
-
159690:
Manual line break forces automatic Wrap Text - comment 17
[NEW; assigned to libreoffice-bugs]
-
159916:
Spreadsheet default alignment is not honored for xlsx format
[NEW; assigned to libreoffice-bugs]
-
160002:
Indentation issue in currency formatted (with left-aligned currency symbol) cells in Calc
[NEW; assigned to libreoffice-bugs]
-
160666:
ODS multiline field wrapping NOK
[NEW; assigned to libreoffice-bugs]
-
34717:
FILEOPEN: automatic row height is too small in generated .xls (not if resaved in MSO)
[RESOLVED NOTOURBUG; assigned to libreoffice-bugs]
-
36466:
Add option to Select Visible Cells Only (to be copied from or copied to)
[VERIFIED FIXED; assigned to tundeth]
-
36968:
FORMATTING cells: background color not displayed on VDU on protected sheet
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
44750:
Allow changing the document's locale directly, not globally
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
46884:
Calc: Font rendering problem, text becomes wrapped in cell when printed
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
50760:
If different format in cells, Standard format not applied to all of them in 1 action
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
51208:
FORMATTING: Date formatting tool not working on Mac Snow Leopard
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
55433:
EDITING, FORMATTING: Row Height fails to expand automatically after editing cell content in particular .ods
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
57474:
Copy-paste of multiline cells to external text editor inconsistent
[RESOLVED NOTABUG; assigned to libreoffice-bugs]
-
57519:
Cell wrap does not function automatically once column width is reduced
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
62268:
FILEOPEN: Optimum row height should be recalculated with "style:use-optimal-row-height='true'"
[RESOLVED FIXED; assigned to vasily.melenchuk]
-
62361:
FILEOPEN without optimum row height calculation
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
66574:
FORMATTING: Formatting transformation when copy-paste
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
69745:
FORMATTING: optimal-row-height is ignored if there are some leading covered cells
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
75702:
FILEOPEN: line-break ignored (The cell should display one line above the other - comment 18)
[VERIFIED FIXED; assigned to jluth]
-
75838:
FORMATTING: Red underline by spell checker is broken if you change the (cell) language
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
76750:
UI: Feature Request to Select the Language of the Cells and Sheet
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
79063:
cell height of spreadsheet printed different after cut/paste to Writer as object when row height set using dialog
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
81328:
Feature request: Show font-size preview while change font size
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
84099:
Calc can't handle very high rows
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
94155:
EDITING Cell highlightning depends on cell name
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
98590:
Confusing behavior when cell with number is changed to format Text: no indication if cell value type is number or text
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
(*)
-
98815:
{tab} character in cells is not saved
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
99304:
Multi-line text in cell causes row to collapse slightly, cutting off text
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
99896:
Implement "Live Preview" for font size in Calc
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
(*)
-
100925:
When overwriting a cell, new content is displayed on top of the old content until finishing the edit
[RESOLVED FIXED; assigned to libreoffice-bugs]
(*)
-
103829:
FILESAVE: Tab characters lost in cell
[RESOLVED FIXED; assigned to jluth]
-
105959:
FORMATTING in Calc --change case does not happen across cells
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
108275:
Cell designated as Text behaves as if it's designated to contain a formula
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
108394:
EDITING: (BOLD)formatting for multiple cell's isn't working under specific conditions
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
(*)
-
108404:
Calc changes the font attributes of selected text in unpredictable ways
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
(*)
-
108762:
in a spreadsheet, some of the cells are not seeable any more, some are, comments are note readable and cannot seem to be reformattable
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
115317:
EDITING: Unable to paste URL when editing a cell
[VERIFIED FIXED; assigned to paul.trojahn]
(*)
-
117413:
double display slightly offset when editing a cell
[RESOLVED FIXED; assigned to caolan.mcnamara]
(*)
-
120319:
FILEOPEN XLSX Consecutive spaces in cells with Wrap text affect horizontal text alignment
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
122676:
FORMATTING Currency Negative Values does not Correctly Apply (*) with a Space
[VERIFIED FIXED; assigned to czeber.laszloadam]
-
123026:
LibreOffice ignore xlsxwriter 'text_wrap' formatting option, seems optimal height for row is not being set to hold cells with wrapped text
[RESOLVED FIXED; assigned to jluth]
-
123156:
Calc: When wrong or large number is converted to date, it should give #ERROR and not wrong date
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
126308:
Escape character "'" (single quote) shows in final cell output
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
132216:
Number indent inconsistent in Calc with right-aligned cells
[RESOLVED WORKSFORME; assigned to libreoffice-bugs]
-
136119:
Spreadsheets should not have "infinite" number of cells
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
150052:
FORMATTING - Formatting not restored calc undo
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
153425:
Calc shows different representations (TRUE/FALSE/1/0) of boolean data types stored in .xlsx starting near row 50
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
153437:
Cancelling insertion of a line insert a shift after column I
[VERIFIED FIXED; assigned to czeber.laszloadam]
-
153527:
LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet
[VERIFIED FIXED; assigned to mikekaganski]
-
154044:
Undoing the first applied cell formatting only works for column A
[VERIFIED FIXED; assigned to mikekaganski]
-
154114:
Formatting active cell applies formatting to entire cell range with data (as if prior Ctrl +A selection remains active)
[RESOLVED FIXED; assigned to libreoffice-bugs]
-
154183:
deleting a row breaks highlighting background
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
155368:
Can't toggle Wrap Text on all cells if a cell already has it
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
155510:
The cell loses background-color on table page break
[RESOLVED FIXED; assigned to vmiklos]
-
155800:
[FR] Wrap text by clipping
[RESOLVED WONTFIX; assigned to libreoffice-bugs]
-
156209:
Font size increases when copying from cell in edit mode and pasting into another in non-edit mode
[VERIFIED FIXED; assigned to libreoffice-bugs]
-
156520:
Date acceptance pattern keeps overriding my cells
[RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
-
157514:
Delete Decimal Places should consider the number of visible decimal places
[RESOLVED DUPLICATE; assigned to libreoffice-bugs]
-
159938:
Moving through cells with overflowing content changes the cells' height and wrapping
[RESOLVED FIXED; assigned to mikekaganski]
-
31205:
Apply fill patterns to cell backgrounds
[NEW; assigned to libreoffice-bugs]
Bug 108252 blocks one bug:
view as bug list-
108252:
[META] Cell-related bugs and enhancements (including formatting)
[NEW; assigned to libreoffice-bugs]
| Max Depth: |