Max Depth:

Bug 108252 depends on 1022 open bugs:

view as bug list

•    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]
    •    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]
  •    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]
      •    123789: Extend SfxStyleFamily by Shapes [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]
      •    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]
            •    108151: System input language is always ignored on Linux [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]
        •    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]
      •    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]
    •    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]
      •    49437: Writer/Calc: Use XML for serializing table autoformats instead of the current brittle binary format [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]
  •    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]
      •    106952: Update cell style can bypass cell protection [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]
      •    160535: Support sheet protection option: Use AutoFilter [NEW; assigned to libreoffice-bugs]
      •    160536: Support sheet protection option: Use PivotTable&PivotChart [NEW; assigned to libreoffice-bugs]
        •    160404: FILEOPEN XLSX Pivot table is not imported if sheet protection has Pivot table editing enabled [NEW; assigned to libreoffice-bugs]
      •    160537: Support sheet protection option: Edit objects [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]
  •    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]
    •    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]
    •    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]
      •    127170: Clarify clock time (HH:MM, MM:SS, ...) and duration time ([HH]:MM, [MM]:SS, ...) formatting in help; (ignore the MM month vs minute discussion) [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]
  •    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]
        •    60170: Extend ODF to allow import and export of external range names. [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]
      •    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]
    •    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]
  •    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]
    •    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]
    •    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]
    •    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]
  •    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]
      •    155453: Cell content's formatting lost when edited in formula bar [ASSIGNED; assigned to caolan.mcnamara]
    •    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]
  •    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]
    •    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]
    •    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]
    •    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]
    •    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]
    •    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]
    •    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]
        •    159872: [LOCALHELP] Help pages for Calc functions FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY [NEW; assigned to libreoffice-bugs]
      •    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]
    •    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]
    •    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]
  •    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]
  •    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]
  •    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]
      •    144296: Under-engineered and inconsistent overflow/extension direction choice incl. with cell edit mode [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]
  •    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]
  •    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]
  •    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]
  •    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]
    •    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]
  •    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] (*)
  •    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]
    •    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]
    •    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]
  •    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]

Bug 108252 blocks one open bug:

view as bug list

•    108252: [META] Cell-related bugs and enhancements (including formatting) [NEW; assigned to libreoffice-bugs]
  •    127204: [META] Formatting bugs and Improvements [NEW; assigned to libreoffice-bugs]

Max Depth: