New answers tagged libreoffice-calc
1
vote
How to actually select only odd or even rows from a selection in LibreOffice Calc?
Though, AFAIK, one cannot change the rows selected by either mouse or keyboard, one can specify operations performed on the basis of row number (or column number). One could include only certain rows' ...
2
votes
How to filter out certain characters in a range of cells
I actually did it with following formulas:
=MID(A1,FIND("-",A1)-4,5) "End result is 2008- for first row"
=MID(B2,FIND("-",B2)+4,4) "End result is 2011 for first row&...
Top 50 recent answers are included
Related Tags
libreoffice-calc × 702libreoffice × 185
microsoft-excel × 130
worksheet-function × 116
openoffice-calc × 99
spreadsheet × 72
openoffice × 33
charts × 32
csv × 30
conditional-formatting × 22
macros × 11
google-spreadsheets × 11
libreoffice-writer × 11
linux × 10
ubuntu × 10
date × 10
vlookup × 9
formatting × 7
copy-paste × 7
pivot-table × 7
find-and-replace × 7
cell-format × 7
keyboard-shortcuts × 6
pdf × 6
microsoft-office × 6