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

  • Linux Ubuntu Cannot Print Large Images
  • Cannot Print PDF Solution and Howto Resize
  • Linux Console Login Screen TTY Change Message
  • Apache Cannot Start Listening Already on 0.0.0.0
  • MySQL Bash Query to pipe input directly without using heredoc trick
  • CentOS 6 and 7 / RHEL Persistent DHCP Solution
  • Debian Ubuntu Mint rc-local service startup error solution rc-local.service: Failed at step EXEC spawning /etc/rc.local: Exec format error
  • MySQL Cheatsheet Guide and Tutorial
  • bash script kill whois or other command that is running for too long
  • Linux tftp listens on all interfaces and IPs by DEFAULT Security Risk Hole Solution
  • python import docx error
  • Cisco Unified Communications Manager Express Cheatsheet CUCME CME
  • Linux Ubuntu Debian Missing privilege separation directory: /var/run/sshd
  • bash how to count the number of columns or words in a line
  • bash if statement how to test program output without assigning to variable
  • RTNETLINK answers: Network is unreachable
  • Centos 7 how to save iptables rules like Centos 6
  • nfs tuning maximum amount of connections
  • qemu-kvm error "Could not initialize SDL(No available video device) - exiting"
  • Centos 7 tftpd will not work with selinux enabled