4

My request is very simple.

I just opened a csv file with LibreOffice Calc, and I notice that the columns go from A to BL. I need to know how many columns there are, in this A-BL range.

How could I do that?

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
DavideChicco.it
  • 3,318
  • 13
  • 56
  • 84

1 Answers1

9

Just execute the following three steps:

  1. Navigate to Column BL (manually or using the navigator: Hit F5 to open the navigator, enter "BL" at the column text field and hit ENTER;
  2. Select all the cells from BL1 to A1: press and hold SHIFT, hit Pos1 (may be Home on your keyboard);
  3. Check the status bar. It shows the selection's size - 64 columns:

enter image description here

tohuwawohu
  • 13,268
  • 4
  • 42
  • 61
  • Thanks @tohuwawohu. (1) and (2) do not work; but (3) works well. – DavideChicco.it Jul 06 '16 at 16:59
  • 1
    @DavideChicco.it Those weren' meant as alternatives, but as three successive steps - step 1 and 2 create the selection, step 3 evaluates its size. – tohuwawohu Jul 06 '16 at 17:00
  • Oh thanks. Perhaps I just found an easier way: highlight a row from column A to column BL, and then read the status bar saying "Selected 1 row, 64 columns" – DavideChicco.it Jul 06 '16 at 17:32
  • Yes, there's no difference in the result when you build the selection from left to right or otherwise. But you'll have to put the selection manually, exactly as needed. This is ensured by the steps i've described (should work with many more columns, too, where selecting them manually may be painstaiking. Juping to the last column as described and creating the selection by "jumping back" should work in any case, independent of the columns's count. – tohuwawohu Jul 06 '16 at 18:48