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)
