Max Depth:

Bug 108988 depends on 83 bugs:

view as bug list

•    108988: [META] Validity-related bugs and enhancements [NEW; assigned to libreoffice-bugs]
  •    78472: EDITING: Can not get visible selection button in freeze column with data validation while horizontal sheet scrolling [NEW; assigned to libreoffice-bugs]
  •    87476: EDITING: "Validity..." functional to unprotected cells when sheet is protected [NEW; assigned to libreoffice-bugs]
  •    94510: Validity list of dates converted to numbers inside list [NEW; assigned to libreoffice-bugs]
  •    94513: editing: Improvement: text completion should include validity values [NEW; assigned to libreoffice-bugs]
  •    96707: EDITING: Data - Form does not respect Data - Validity [NEW; assigned to libreoffice-bugs]
  •    96709: EDITING: Calc copy Valitidy is not easy/clear, explicit option in Paste special is missing [NEW; assigned to libreoffice-bugs]
  •    96718: EDITING: Data - Validity: make available cell ranges by mouse-selection in ALL conditions of Validity [NEW; assigned to libreoffice-bugs]
  •    96741: EDITING: Data - Validity: mouse-selection(s) should work in a custom mix with typing [NEW; assigned to libreoffice-bugs]
  •    96743: UI: Data - Validity: Make available "Insert => Names => Insert", or add completion of available names while typing [NEW; assigned to libreoffice-bugs]
  •    98144: list validation menus sometimes too small [NEW; assigned to libreoffice-bugs]
  •    98263: Autofill does not respect data validation rule [NEW; assigned to libreoffice-bugs]
  •    101808: no option to set length in settings of cells as TEXT [NEW; assigned to libreoffice-bugs]
  •    103883: The concatenation of ranges for use in the Validity... [NEW; assigned to libreoffice-bugs]
  •    115081: Data validity restriction can be violated by copying value into a cell [NEW; assigned to libreoffice-bugs]
  •    118276: FILEOPEN XLSX Basic code with Validity and Sheets does not work in Calc [NEW; assigned to libreoffice-bugs]
  •    125914: Validation with cells referencing themselves always gives error [NEW; assigned to libreoffice-bugs]
  •    129018: Count number of cells failing validation [NEW; assigned to libreoffice-bugs]
  •    131309: Validity>Custom>Formula does not have the expected effect without additional measures - evaluation of entered formula only happens after additional trigger [NEW; assigned to libreoffice-bugs]
  •    135482: EDITING: Data validity fails after copying sheet and deleting original sheet [NEW; assigned to libreoffice-bugs]
  •    137113: LO Calc Data - Validity - Cell Range / LIST - Selection List - Typing Selection is NOT working [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]
  •    140986: LO hangs when you select a cell with validity's drop-down [NEW; assigned to libreoffice-bugs]
  •    141041: Validity drop-down list should always have the same width as its cell and the same font size as the cell has and should be independent of scale factor [NEW; assigned to libreoffice-bugs]
  •    146887: A validity list ignores hyphens in the search [NEW; assigned to libreoffice-bugs]
  •    150004: Validation dropdown stays visible when changing rows/columns [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]
  •    153950: cells arent working [NEW; assigned to libreoffice-bugs]
  •    156233: Validation #REF! error when deleting original worksheet after duplicating it [NEW; assigned to libreoffice-bugs]
  •    156263: Calc windows cannot be closed after focus change from Validity dialog [NEW; assigned to libreoffice-bugs]
  •    156398: Fileopen XLSX: Data Validation Input Message not see with Dark Mode [NEW; assigned to libreoffice-bugs]
  •    156432: Calc data validation: "Allow empty cells" does not work [NEW; assigned to libreoffice-bugs]
  •    159695: Validity settings are editable on a protected sheet from context menu [NEW; assigned to libreoffice-bugs]
  •    160096: Validity list set to not show error message does not allow unlisted values to be entered [NEW; assigned to libreoffice-bugs]
  •    41425: FILESAVE: Formatting and/or data validation, positioned after last non-empty cell, is lost when saving to XLS or XLSX [RESOLVED FIXED; assigned to libreoffice-bugs]
  •    41845: Deleting validated rows does not delete validation circles. [VERIFIED FIXED; assigned to tibor.nagy.extern]
  •    45189: VIEWING: Cell Validity: Error Alert - associate an icon with the type of error (stop, warning, information) [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
  •    61623: UI Data Validity List and icon drawing bugs [RESOLVED FIXED; assigned to balazs.varga991]
  •    69734: UI: UI DropDown Menu appears in other tables [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    84874: FILESAVE to .xlsx. MS Excel doesn't load spreadsheets with promptTitle longer than 256 characters. [VERIFIED FIXED; assigned to tibor.nagy.extern]
  •    88646: FILEOPEN: imported dropdown menu from excel does not work [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
  •    90104: Data validity error when saving decimal number to .xlsx format [VERIFIED FIXED; assigned to tibor.nagy.extern]
  •    90324: xlsx import : Text formatted custom validated cell does not allow entry of valid numbers;support of formula in validation [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    91682: FILEOPEN: Empty Selection List (Tools>Validation). Lost on OOXML round trip [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    96698: Data => Validity => Custom (like Excel) is missing [RESOLVED FIXED; assigned to libreoffice-bugs]
  •    98953: [UI] Cell validation: filter possible values while typing [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    108989: Add contextual UNO commands for name ranges and data validity to context menu [VERIFIED FIXED; assigned to gulsah.1004]
  •    111665: "Data" -> "Validity": represent boolean values with a checkbox [RESOLVED WONTFIX; assigned to libreoffice-bugs]
  •    112566: FILESAVE XLSX Spreadsheets with data validation from external file XLSX export issue when the external file is not present [VERIFIED FIXED; assigned to libreoffice-bugs]
  •    113535: Referenced validity lists do not contain all entries [RESOLVED NOTABUG; assigned to libreoffice-bugs]
  •    114393: Filter entries in Validity drop-down list by typed input [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    120012: FILESAVE: Formatting and/or data validation, positioned after last non-empty cell, is lost when saving to XLS or XLSX [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    41425: FILESAVE: Formatting and/or data validation, positioned after last non-empty cell, is lost when saving to XLS or XLSX [RESOLVED FIXED; assigned to libreoffice-bugs] (*)
  •    125414: FILESAVE XLSX Ellipses of the “Mark invalid data” function shouldn't be exported when saving XLSX [RESOLVED FIXED; assigned to szabolcs450]
  •    125462: CALC EDIT The red ellipses of the “Mark invalid data” detective function stay visible even after a correct data is entered in the cell [VERIFIED FIXED; assigned to tibor.nagy.extern]
  •    125595: FORMATTING: Validity cell range with invisible characters (e.g. newline) stripped [RESOLVED FIXED; assigned to libreoffice-bugs]
  •    125917: calc freezes when using data validity [VERIFIED FIXED; assigned to caolan.mcnamara]
  •    126305: Data validaty on Error Alert action value lost on save xlsx (Always Stop), but on xls is ok [VERIFIED FIXED; assigned to tibor.nagy.extern]
  •    128797: FILEOPEN XLSX Detective marks cells invalid if number is stored in text cell [RESOLVED FIXED; assigned to tibor.nagy.extern]
  •    130850: Calc still shows a validity's drop-down icon after you selected another sheet [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    130854: Drop-down list in cell closes itself without press on Enter key [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    136857: Spaces in Validity Input Help multiply with each save [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    136878: Move Validity drop-down list control inside cell [RESOLVED WONTFIX; assigned to libreoffice-bugs]
  •    137167: Validity List truncated when saving in Excel format [RESOLVED NOTOURBUG; assigned to libreoffice-bugs]
  •    137215: Hang after switching windows with cell selector open in Validity dialog [VERIFIED FIXED; assigned to caolan.mcnamara]
  •    137246: Calc Data Validity. Error Message UI Error [RESOLVED NOTABUG; assigned to libreoffice-bugs]
  •    137614: EDITING Mark Invalid Data circles only the top left cell of merged cells [VERIFIED FIXED; assigned to tibor.nagy.extern]
  •    137945: Every time after spreadsheet saved and reopened, spaces are multiplied in content validation help messages [CLOSED FIXED; assigned to libreoffice-bugs]
  •    138134: EDITING Validation circle does not disappear when value is changed by formula calculation [VERIFIED FIXED; assigned to tibor.nagy.extern]
  •    138137: EDITING Merged cells don’t lose detective circles when correct value is entered [VERIFIED FIXED; assigned to tibor.nagy.extern]
  •    138483: EDITING Validation circles not updated when circled cells get merged [VERIFIED FIXED; assigned to tibor.nagy.extern]
  •    138827: Validity - not possible to accept all possible whole numbers by leaving value field blank [RESOLVED NOTABUG; assigned to libreoffice-bugs]
  •    139059: The Validity list arrow doesn't appear when we have frozen columns and the next column is not visible [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    143619: EDITING Validation circles move left/up on deleting a column/row [VERIFIED FIXED; assigned to rb.henschel]
  •    143699: Data -> Validity [Cell range] doesn't save "Sort entries" in xlsx format [RESOLVED NOTABUG; assigned to libreoffice-bugs]
  •    145646: While selecting from the dropdown of data validation using keyboard, different one gets entered on pressing return [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
  •    150098: Evaluate formula inputs in Validity... [VERIFIED FIXED; assigned to balazs.varga991]
  •    152037: Data validation error when entering correct text length in XLSX file [VERIFIED FIXED; assigned to czeber.laszloadam]
  •    152936: Feature Request: Consider adding autocomplete (with full-text search) to cell validation [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    154622: Correct shortcut for expanding cell validity selection list: Alt + Down instead of Ctrl + D (documentation, extended tips) [RESOLVED FIXED; assigned to stephane.guillou]
  •    155708: UI: Validity dialog closes when moving focus to another Calc window [VERIFIED FIXED; assigned to balazs.varga991]
  •    157551: LO Calc Data - Validity - Cell Range / LIST - Selection List - The dropdown is tiny and away from clicked arrow [VERIFIED FIXED; assigned to libreoffice-bugs]
  •    157657: Add option to make data validity case-sensitive [RESOLVED FIXED; assigned to balazs.varga991]
  •    159595: Data validation without error check allows to enter data other than defined [VERIFIED FIXED; assigned to serval2412]
  •    161395: "Whole numbers" is ambiguous [RESOLVED FIXED; assigned to heiko.tietze]

Bug 108988 does not block any bugs.

Max Depth:

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    [x]
  • | Forgot Password
    Login: [x]