https://bugs.documentfoundation.org/show_bug.cgi?id=152658
--- Comment #5 from Colin <[email protected]> --- (In reply to m.a.riosv from comment #4) > Sorry, but I don't know what assures the new value meets the criteria for to > be selected in the list. > So for me not a bug. Did you observe the effect on the file when you change the value from 74 to 75? It must just be the same as adding a new row with the value of 75. Does LO exclude the new row just because 75 doesn't already exist in the index? Try another angle; Set the filter status to everything Add the value 12 to the bottom of the list Inspect the filter values and 12 is selected Now set the filter to exclude blanks Add the value 13 to the bottom of the list Inspect the filter values and 13 is deselected Did you change the filter from ignore blanks to ignore blanks AND any numbers between 12.1 and 14? What would you expect to happen if you cut and pasted 500 new entries to the bottom of the list? Again, for the record, Excel includes them and if the overarching desire is to be Excel compatible then I'm sorry to say it's failing -- You are receiving this mail because: You are the assignee for the bug.
