Cell content does not match what it says in the formula bar

ocorlett · December 2, 2025, 6:19pm

I copied and pasted a big table from https://www.marketbeat.com/stocks/LON/ into a LO spreadsheet . I am attaching one row from the copied table. In cells c3, g3 and f3, the visible content of the cells does not match what it says in the formula bar when you click on that cell. For example, C3 shows “+0.2%” while in the formula bar it displays “GBX 8,360”. I have included in the attached .ods an image of the same row as it appears in the webpage.
I don’t understand what is going on here, nor how to fix it so that each data item has its own cell (for example, for c3 the data items GBX 8,360 and +0.2%).

LSE Top.ods (64.9 KB)

PKG · December 2, 2025, 6:31pm

2025-12-02 19 30 32

bantoniof · December 2, 2025, 8:57pm

There is a line break between GBX 8,360 and +0.2%

If you make the row where the cell is higher, you will see the full text.
If you click on the down arrow at the end of the formula bar, the box to enter the formulas expands downwards and you will see the full text.

Recomended readings : Getting Started Guide 25.2 - Chapter 2, Getting Started with Calc and Calc Guide 25.2

fpy · December 2, 2025, 9:26pm

as a side note, should have a “latest” alias to avoid overly specific GS252

bantoniof · December 2, 2025, 11:39pm

Those are the latest guides. the documentation is not as the help is.
but the user can clic in the LibreOffice Logo to go to the complete bookshelf

fpy · December 3, 2025, 7:02am

sure. as of today.

why not. but who knows that

and by the way, weird display :

sure. I guess the link from should reflect it
currently: https://www.libreoffice.org/donate/?pk_campaign=help

ocorlett · December 3, 2025, 11:46am

I tried search replace $ with regular expressions checked in the hope that it would get rid of the line break, but no such luck. Thanks for your help.