https://bugs.documentfoundation.org/show_bug.cgi?id=151851
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |rg --- Comment #4 from m.a.riosv <[email protected]> --- Created attachment 183368 --> https://bugs.documentfoundation.org/attachment.cgi?id=183368&action=edit Formula to sort arrays of data. Seems to me that such formula in any case is not of too much confidence. Excel: Introducing something in the empty cells between data (a4, a8) produce a result sort list with replicated values at the end. If there are numbers, the second it's not on the sorted list. Calc: retains the '0' at the top, but if numbers in a4,a8 only a4 it's on the sorted list but duplicated. Attached a sample file that deals with numbers, text, blank cells (at the end), working with calc and excel. Based on 'ken johnson' answer https://forum.openoffice.org/en/forum/viewtopic.php?p=290729#p290729 -- You are receiving this mail because: You are the assignee for the bug.
