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 Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1305877 Title: [Upstream] ' prepended when applying Number Category to Text Category cell with a number in it Status in LibreOffice Productivity Suite: Confirmed Status in “libreoffice” package in Ubuntu: Triaged Bug description: 1) lsb_release -rd Description: Ubuntu Trusty Tahr (development branch) Release: 14.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:4.2.3~rc3-0ubuntu2 Candidate: 1:4.2.3~rc3-0ubuntu2 Version table: *** 1:4.2.3~rc3-0ubuntu2 0 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages 100 /var/lib/dpkg/status 3) What is expected to happen in Calc is secondary click an an empty cell -> Format Cells... -> under Category choose Text -> click button OK -> in that cell type 1 -> secondary click the cell -> Format Cells... -> under Category choose Number -> click button OK and when one clicks the cell the input line just shows 1, as it does in Microsoft Excel 2003 (11.5612.8172). 4) What happens instead is it shows: '1 WORKAROUND: Set the cell Category to Number prior to inserting numbers. ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: libreoffice-calc 1:3.5.7-0ubuntu5 ProcVersionSignature: Ubuntu 3.2.0-60.91-generic 3.2.55 Uname: Linux 3.2.0-60-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.0.1-0ubuntu17.6 Architecture: amd64 Date: Thu Apr 10 14:10:51 2014 InstallationMedia: Ubuntu 12.04.1 LTS "Precise Pangolin" - Release amd64+mac (20120823.1) MarkForUpload: True SourcePackage: libreoffice UpgradeStatus: No upgrade log present (probably fresh install) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1305877/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
