Before : a b c d e >> Output : abcde
(no empty cells after output in the same row )
Thanks : )
Before : a b c d e >> Output : abcde
Code: Select all
def shrink_row_selection(*_):
doc = XSCRIPTCONTEXT.getDocument()
row_range = doc.CurrentSelection
sheet = row_range.Spreadsheet
cursor = sheet.createCursorByRange(row_range)
data = cursor.DataArray
cursor.clearContents(63)
out = [[entry for entry in data[0] if entry]]
cursor.collapseToSize(len(out[0]),1)
cursor.DataArray = out
Code: Select all
def shrink_source_row_paste2target(*_):
doc = XSCRIPTCONTEXT.getDocument()
row_range , target = doc.CurrentSelection
sheet = target.Spreadsheet
cursor = sheet.createCursorByRange(target)
data = row_range.DataArray
out = tuple( filter( lambda x: f"{x}", data[0]) ) # dont skip zero!!
cursor.collapseToSize( len(out), 1)
cursor.DataArray = (out,)