Incorrect display of xlxs file

This is more providing information than asking a question. I’m putting it here because I don’t know where else to put it. The first column of the following file should contain times of day only, but in some rows contains pound signs when the file is opened in LibreOffice. It displays correctly when opened by OpenOffice.

I also note that the first column is shown as Column B rather than A (also in OpenOffice). I don’t know whether or not that fact is relevant.

Backwards K Victoria Sunday final.xlsx

Could you please also attach a screenshot with those pound signs shown and emphasized, and also specify LibreOffice and OS versions.

I cannot see pound signs using Version: (x64)
Build ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3
CPU threads: 12; OS: Windows 10.0; UI render: GL;
Locale: ru-RU (ru_RU); Calc: CL

At any rate, as described in the “How to use this Ask site” linked from the main page, bug reports should go to bug tracker.

I could/would add a screenshot, but it’s probably not useful because as indicated in the answer below, the issue seems to be the width of the column. Interesting that the column is apparently too narrow to display properly in LibreOffice, but not in OpenOffice.

Great you found it! (/me also learned that “pound sign” is “#” - need to remember; I somehow was looking for “£”.) Still, knowing the LO version could help to check if that specific version possibly imported the width incorrectly.

Looking at Help/About, I think I’m using the same version you cited above. If it’s potentially useful, I’m certainly happy to provide the screenshot, but I now can’t figure out how to do that as part of this “question”.

Well - you edit your original question, and there you would find the controls to attach a picture.

If you are using the same version, then it should be something different in system - OS, ot installed fonts, or … don’t know actually :slight_smile:

By the way: if your question is answered by @erAck, then please mark it as the correct answer (using the checkbox at the left of the answer).

Doesn’t happen for me with this document. Anyway, if ### are displayed it means the column is too narrow, just widen it, either by dragging the column margin in the header, or on such cell press Shift+Alt+Right, or press Alt+Right anywhere in the column. The sheet starts at column B because column A is hidden. I this case select column B and the column left to it by clicking and holding on the column header and while holding imaginary select the column left to it, or use Shift+Ctrl+T to enter the name box and input A1:B1 and hit Enter. Then from the context menu on the B column header choose Show Columns.

Thank you. I’ve certainly learned something here. As mentioned above, it’s interesting that the column is apparently too narrow to display properly in LibreOffice, but not in OpenOffice.

Please, if the answer solves the question click :heavy_check_mark:.