Software Salariman

Nuts and bolts about programming applications, databases and spreadsheets. Note: Comments are moderated to filter comment spam. Mobile version

Showing posts with label OO-Calc. Show all posts

Showing posts with label OO-Calc. Show all posts

2014-02-04

Excel find first word without IFERROR() or IF(ISERROR())

In Excel, to find the first word in a cell, find the position of first space then return all characters up to but excluding the space: =LEFT...

2012-10-28

Australian Accounting Number Formats

Number format codes for Excel and Libre Calc used in Australian accounting (Excel does not have this number format code available as a defa...

2010-10-15

Automatically Update Last Row in Range Formulas

In OpenOffice Calc, worksheet formulas that apply a range of rows, such as SUM() , need to be updated when an extra row is added just above ...

2009-08-05

OpenOffice Calc AutoInput capitalization annoyance

When you enter text in a cell in OpenOffice Calc, you might find that your text is incorrectly capitalized and you cannot correct it! For ex...

View web version

About Me

Temporary

View my complete profile

Powered by Blogger.