Tagged Questions
2
votes
2answers
65 views
OpenOffice Calc regex returns wrong value - what's wrong with my regex?
I have a column of text with values concatenated by my bank, as in a typical monthly statement.
Here is an example (column A240):
OCT 26 BALANCEPROTECTOR PREMIUM $10.05
I'm trying to set the ...
0
votes
1answer
69 views
OpenOffice partial cell in-between value copy function?
I have a very long worksheet list with contact information of various companies and I need to create usernames for them, so I would use the middle part of their website URL for those. For example, in ...
-1
votes
1answer
1k views
Calculate age in days/months/years in OpenOffice
In need to find the age in days - months - years in OpenOffice.
There is DATEDIF() in Microsoft Excel. You can use it to find the difference in days/months/years between two dates.
Age Calculation
...
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 ...
2
votes
3answers
951 views
Excel / open/libre office formulae: number of full months left until date
I need a formula which equates to an integer value for the number months left until a set date (2011-10-16) based on the current date.
e.g.
on 2011-03-13 the answer would equate to 8
on 2011-03-17 ...
