OpenOffice.org's spreadsheet application. Tag questions about macro programming or formulas with macros or worksheet-function respectively
0
votes
1answer
389 views
Count the number of contiguous empty cells at the end of a row
I have rows of data, some cells are empty and some contain a number. I need to identify how many contiguous empty cells exist at the end of each row.
I've tried using a string of nested IF ...
0
votes
0answers
486 views
openoffice-calc, drop-down-list, avoid duplicates
In openoffice-calc, one can create an drop-down list via Data > Validity, and selecting a Cell-range. If my Cell-range contains duplicates, I have also duplicates in my list. Is there a way to avoid ...
0
votes
3answers
264 views
Opening OpenOffice.org documents is slow on Windows 2003 server
While trying to open/access OpenOffice documents on Windows 2003 server it gives a very slow response, while accessing the same document using Microsoft Office 2007 it opens up instantly.
The version ...
0
votes
1answer
271 views
How can I create a toolbar button that applies a thousands-separated number style in OpenOffice.org Calc?
In OpenOffice.org Calc I very often want to format numbers with a thousands separator.
How can I create a toolbar button to do this?
Via the menus, the appropriate format can be applied with Format ...
-1
votes
1answer
443 views
How to make LibreOffice Calc to connect points in a holed series chart with lines?
I've got a time series data table with one function (row) value available for every month and the second for every 3rd month (every quarter), having holes (empty cell values) for every 2nd and 1st ...
