Instead of providing any practicable solution you deliver spam for a questionable developers tool. This is the Calc forum. We have to assume that Kay67 is not interested in writing any program. Hopefully someday we can see you thinking a bit, before writing such things. IMMHO the best thing you can...

I have seen in ML how a PPMC member is going to post in the blog, the Hagar's post about statistics. Where it can be seen the very good job of the forums. Thanks, but this is for me a clear intention of this particular PPMC member to appropriate of something that he did not collaborate at all (+0). ...

An array formula can do the job:
=MAX((NOT(ISBLANK($A$1:$A$100))*ROW($A$1:$A$100)))
use Ctrl+Shift+Intro to enter the formula.

Welcome to the forum jim7634,
can you upload the file, after eliminate any confidential information?

The best to avoid calculation errors, which is very easy in a payroll. It's to have every concept unit, prices and amounts/deductions in one cell and use separated cells for subtotal and total.
A basic sample.

Have you save the files at least once?

Both in OpenOffice and LIbreOffice it is posible to customize the toolbar to select the border style and the color border.
Also Ctrl+1 shows in one step the format cell box, with the last tab used selected.

Maybe using LIbreOffice.
Mark in Menu/Tools/Options/LibreOffice/General/Enable experimantal (unstable) features.

In conditional formatting, change "Field value is" to "Formula is", and use a formula like:
FIND("leave";A1;1) or
SEARCH("leave";A1;1)
the difference is SEARCH() support regular expressions, which lets make complex search expressions.

Welcome to the forum Jimster2012,
Have you looked in the Macros and UNO API in this forum?
http://user.services.openoffice.org/en/ ... m.php?f=20

I don't know but maybe it is a problem involved with Java.
OOo can't work with a Java 64 is needed a Java 32.
Be sure that in Menu/Tools/Options/OpenOffice/Java, there is select a Java 32 version, it's possible to have various versions of Java at same time in the computer.

Welcome to the forum gillianmoon,
maybe this thread can help.
http://user.services.openoffice.org/en/ ... nd#p193952

In Menu/Format/Page/Header|Footer - Edit, you can fin how to insert the filename, page number, date, time, etc.
To insert without loose the reference, hide the first row|column in the print range, and insert rows and/or column is always after.

Hi Hagar, many thanks. I hope you enjoy this days.

And a best world for the new year.

And you can come here, to get from us make your business for less than nothing, by your insults. Really a hard face.
Please open your mind.
There is a section in the forum: Board index ‹ Business ‹ Paid support.

I am agree rudolfo.

Thanks Drew, a beautiful footprint of the project history.
Best wishes for all.

Also the TEXT(number,"format") function lets to get the same formats as the cells.

This can make more understandable, how the forums are helping in maintain a close connection with the users community, in this meanwhile.

Hi Hogar, I am only talking about to set the rule.

Why not agree a rule for this situations?
Inform the ppmc, waiting a while for their comments, if there is no problem, fix an apply the rule.
This lets all admins and mods can know what to do.

I think is a problem in LibO 3.4 and above, also with access databases, seems that SDBC drivers weren't shipping in this versions of LibreOffice.
Look in this reported bug: https://bugs.freedesktop.org/show_bug.cgi?id=35673

Can't you set to VLOOKUP(P126;History.F5:F195;5;0) and hide the row 5, this avoid unwanted changes in the begin of the array.

i was replying to the suggestion of making a word for "VLOOKUP(M$1;(INDIRECT("'"&$A71&"'.$A$1:$G$63"));5;0) ". it was almost a good idea, but the "71" is relative. when i fill this formula across rows and columns; pretty sure a word will not work. ......

Rory have read my mind. Well I am not very happy with some things in the podling, maybe not the only one. I think in the ML too much bla.. bla.. bla.. little productive, and more arrogance than needed with a not very nice language. And a few doing the productive work. A Christmas card showing what i...

How we can get the statistics of the forums from 1/October/2011?
And Is there the number of New topics and the Solved topics?
Thanks in advance.

I think here you can find what are you looking for:
http://user.services.openoffice.org/en/ ... ty#p187082

You can use a Named Ranges with formulae, this lets reduce the formula size.
Menu/Insert/Name/Define Then substitute (INDIRECT("'"&$A71&"'.$A$1:$G$63")) with DataRange in the formula.

+1 Villeroy + Hagar,
Seems clear what is the real target and how is hidden as if was an open source support.

Try with:

Code: Select all Expand view
VLOOKUP(D14&"-1",OFFSET('Vehicle List'.A2,0,0,COUNTA('Vehicle List'.A1:A10)-1,COUNTA('Vehicle List'.A1:I1)),2,0)