I have a small .xlsx that was sent to me by another person. It opens perfectly in Excel. However, when opened in calc, column A is missing. I am currently using v7, but this error happened in v6 as well. I am attaching the problem file.
Thanks,
Hello,
To attach a file, edit your question (selection in lower right of your question) then use paper clip icon in toolbar. See → How do I attach a file to my question/answer?
There are three sheets. 3rd qtr is empty. 2nd qtr & 4th qtr all columns visible including Col A which is Seq No on both sheets.
Done using LO v7.0.1.2 from TDF on Ubuntu 20.04.1
left-click upper left corner of sheet (left to ‘B’, above ‘1’) - select all -, right-click any column header - e.g. ‘B’, from dialog select ‘show columns’, looks like ‘no effect’, but afterwards you can shift to the left and see an nearly empty column ‘A’,
P.S. ‘solved marks’ (click the grey circeled hook - ✓ - top left to the answer to turn it green) and ‘likes’ (click the upvote link - ^ - above it if you consider the answer ‘good’, - v - for the opposite) are welcome, please use the ‘answer’ button only! if you have an answer to the question, to add info edit the question or use comments,
Thanks. The solution does expose col A. However, there is still a problem. If you open the file in Excel, column A has value in rows 2-13. The values are sequential numbers starting with 1. When opened in calc, and expose column A with the above solution, rows 2-13 are blank.
Hello,
I must be missing something here.
Using LO v7.0.1.2 from TDF on Ubuntu 20.04.1, I open the .xlxs file and this is what I see:
Tab 1:
Tab 2:
Tab 3:
No special attention needed. Just opened the file.
Possible bug in version you are using but for a different OS - Windows, MacOS?
possible bug? … or something new in ex$el, tried with LO 6.1.6.3, 7.1.0.0.a0+, ex$el 2010, all winx64, all open with hidden col. A in sheet3, it’s even defined as ‘hidden’ in the worksheet file
<col min="1" max="1" width="0" hidden="1" customWidth="1"/>
all needed ‘select all’ and ‘show columns’ to unhide col A, all have ‘Seq No’ in A1, all have A2:A13 empty … it’s narrowed down, let’s give it to the experts …
