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

  • QEMU-KVM soundhw deprecated how to enable sound in QEMU 4.x series
  • Virtualbox Error Cannot register the hard disk because a hard disk with UUID already exists solution
  • kernel: [549267.368859] mate-terminal[7871]: segfault at 2000000101 ip 00007f5d0a9548f0 sp 00007fff7012c610 error 4 in libgobject-2.0.so.0.4800.2[7f5d0a920000+52000]
  • apcupsd how to setup and monitor APC UPS units
  • How To Password Reset, Recover, Bypass, Remove and Unlock on Windows 10,8,7,Vista,XP,NT,2000,2003,2008,2012,2016,2019 Administrative Login Programs
  • Nvidia Ubuntu Linux Screentearing Video with solution driver
  • ?? Question Marks for time, permissions and size of a file?
  • mdadm how to stop a check
  • access denied by acl file qemu-kvm: bridge helper failed
  • Linux NIC connecting at 100M instead of 1000M gigabit speeds? It could be overheating
  • "This kernel requires the following features not present on the CPU: cmov Unable to boot - please use a kernel appropriate for your CPU.
  • http://vault.centos.org/5.9/os/i386/repodata/filelists.xml.gz: [Errno -1] Metadata file does not match checksum solution
  • Linux Ubuntu Wifi Disabled Only Works When Laptop Plugged Into Wall AC Power
  • CentOS 6 impossible to compile a newer libguestfs
  • chroot
  • How To Get Started on Ubuntu with gpt-2 OpenAI Text Prediction
  • Remove cloud-init in your VM
  • QEMU-KVM KVM Command Line Practical Guide
  • Linux How To Change NIC Name to eth0 instead of enps33 or enp0s25
  • virt-resize: error: libguestfs error: could not create appliance through libvirt.