Hi Michael, even you don't like how it works, it is not a bug as Eike have explained, and he knows, as expert developer, about what he is talking.
Changing the cell format never change their content, unintuitive or not, this is a basic assumption in a spreadsheet, and I hope this will be always so. If there are not formulas, you can copy the range and select the unformatted text option in the right arrow of the paste button. Or if it is only a column with data using Menu/Data/Text to columns. If you are not agree, please open a new bug as a request for enhancement, detailing as much as possible what you want. Next comment I attach a file sample how to extract the data from your web page, throuhg Menu/Insert/Link to external data. You can see and edit the link in Menu/Edit/Links. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1305877 Title: [Upstream] ' prepended when applying Number Category to Text Category cell with a number in it To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1305877/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
