OpenOffice Calc SUM function not working Solution - Result is always 0/apostrophe appears in front of all numbers.

I right clicked all applicable cells and chose "number" but that's enough.
I notice when I click the cell there is an invisible ' in front of the number:
'33.64

Calc imported my CSV and decided to add a ' in front of the numeric currency values!!!*Actually the problem occurs when you right click the cells and change the type from text to number, no matter what format you choose.

If I change it to be currency it still does the same thing!  What a stupid bug in Calc/Openoffice.

The only solution is search and replace ' to blank but it's ridiculous.  This is typical OpenSource software that keeps introducing bugs into the simplest of operations and tasks.
  You can't even do a standard search and replace since it's a weird bug that ony shows itself when you click an individual cell that is affected.

I don't have time for this, I've read belligerent comments in the OpenOffice forums from what seems like a dev who refuses to admit this is a bug.  There is supposedly some work around involving changing the default language or something, this bug has been around for years and the devs would rather flame the users than even acknowledge and fix it.

*Easy solution with regular expression searches within the whole Calc sheet


Just do a find and replace but don't choose "Current selection only"
, because the cells in the selection don't show it so it will say "Search key not found".

Make sure you use "Regular Expressions" (hit More):


Search for: ^.
Replae with: &

After that you'll find your numbers are really numbers and that there's no apostrophe ' in front of them.


Tags:

openoffice, calc, sum, apostrophe, clicked, applicable, quot, imported, csv, numeric, currency, occurs, text, format, opensource, software, introducing, simplest, operations, tasks, ony, individual, ve, belligerent, comments, forums, dev, refuses, involving, default, devs, users, acknowledge, searches, expressions, replae, ll,

Latest Articles

  • ImageMagick Convert PDF Not Authorized
  • ImageMagick Converted PDF to JPEG some files have a black background solution
  • Linux Mint Mate Customize the Lock screen messages and hide username and real name
  • Ubuntu/Gnome/Mint/Centos How To Take a partial screenshot
  • ssh how to verify your host key / avoid MIM attacks
  • Cisco IP Phone CP-8845 8800/8900 Series How To Reset To Factory Settings Instructions
  • ls how to list ONLY directories
  • How to encrypt your SSH private key file id_rsa
  • Linux Mint 18 Disable User Name List from showing on Login Screen
  • Firefox Cannot Hit Enter Key In Address Bar and Location History Not Working
  • Cisco Unified Communications Manager / CUCM IP 8.6,10,12 Install Error Solution
  • Ubuntu Debian Mint Linux SSHD OpenSSH Server Not Starting After Reboot Solution
  • nmap how to scan for all ports and not just the 1000 most common ports
  • Windows 7,8,10 and Server 2008, 2012, 2016, 2019 Read Only Attribute Won't Go Away
  • bind / named how to make a wildcard record and retain defined A records
  • Cisco Unified Communications Manager 12 Install Errors on Proxmox/KVM
  • Local Vs Universally Administered MAC Address NIC Refuses to come up
  • Cisco Unified Communications Manager 12 CUCM 12 - How To Enable Video Calling
  • Windows 7, 8, 10, Windows Server 2008, 2012, 2016, 2019 How To AC97 Audio Drivers and Other Unsigned Drivers
  • Cisco Unified Communications Manager / CUCM IP Telephony Definitions