LibreOffice - another piece of rotting meat, II

Saga continues...

Was doing personal finances today and had to calculate a running total of my credit card statement. For that I copied and pasted a table from the CC company web site into Calc.

The table contained 3 columns: date (dd/mm/yyyy), vendor and amount ($#,###.##). I pasted the info into Calc, selected the cell under the amount, entered =sum(, selected the column and pressed Enter. The total was 0.

What the... said I, and looked at the numbers. They were left aligned, which meant Calc treated them as strings.

I search/replaced the $ symbols out of the numbers. Nothing changed - still 0 total, left-aligned values. Looked closer - all numbers had a blank space at the end. Search/replaced spaces with nothing. The total was still 0.

Even though the numbers in the cells were now perfectly formatted, stupid POS that Calc is considered them strings.

The developers of LibreOffice are either high on mind-altering substances, or terminally stupid, or they all work for Microsoft. Releasing untested piece of crap into the world and calling it an office suite is audacious.

Posted by: LinuxLies at 06:50 PM | No Comments | Add Comment
Post contains 198 words, total size 1 kb.