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]
-
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]
Bug 108988
does not block any bugs.