New answers tagged libreoffice
No longer works as of now :( ubuntu version 14.04 libre office version 4.2 install error from libre office: java.lang.reflect.InvocationTargetException
This is what you are looking for The formula for ease of copy-paste is added below =SUMIF($B$4:$C$12,D4,$C$4:$C$12) Note: If you are new to excel formulas and wondering about the $ signs in the formulas - read about relative and absolute cell addressing here
An alternative would be to use Find&Replace to Replace ( with nothing, ) with nothing, - with nothing (this part could be tricky if there are multiple different kinds of characters that look like dashes, but if they are all standard dashes it's easy), and space with nothing. Four characters typed into the "Find" field, the "Replace All" button pressed ...
The Query window (which can only be used for SELECT statements) by default has a Base parser which is optimized for the most common functions in an old version of HSQLDB (version 1.8 is what is bundled with OpenOffice, while the current version is 2.3). If you need to use a syntax in the query window that the parser objects to, you can turn off the parser ...
Top 50 recent answers are included