Hopefully this will make it back top the list, Good call responding to the
list
I believe that you cannot have a view cursor unless you have a display. Some
work was done to improve things like maybe it will work if you load the
document and then hide it But that is a long shot. Off hand I don't think
that you can understand much related to position such add page number without a
view. All of the other cursors so not provide this information.
After saying that... I expect that PDF export needs a way to understand page
numbers and it sounds like you can do that without a view... So perhaps I am
mistaken. My best guess is that it only matters of page numbers are displayed
in the document and that uses field which should have a display value stored
but not updated without the view.
Not sure is this helps...
greyspammer greyspam...@postino.ch wrote:
A user who could not post directly to the list because he was using his phone
with a non-matching e-mail address asked me why I was using
CurrentController. I think I better write the answer to the list so everyone
can participate.
The macro is rather complex. The documents are invoices containing text
table with a list of items and their prices. They are created by a
third-party program. I supply a template and the program fills in the data
from its database.
Now, it can happen that the table with the items is longer than one page
(even longer than two or three) pages. The macro will detect this and split
the table at those places, adding a subtotal to the foot of each page and a
carry over on the start of the next page. I plan to add this macro to the
template so that it automatically executes when a PDF is generated.
Example: The document I get looks like this (I hope the layout survives ;)):
- snip -
- snap -
After the macro is done, the document looks like this:
- snip -
- snap -
As you can see, it's pretty complex and due to the lack of documentation,
the only way to achieve this result was to replicate the steps I would
otherwise do manually. That means getting a view cursor (which is a part of
the current controller). Then I use my view cursor to do the stuff. I put it
in the last column of the first row. Then I go down cell by cell, summing up
values on way. Until the page changes. Then I go back up, insert subtotal
and carry over and finally split the table between them.
If there is another way to do it without CurrentController, I have not found
it.
If it helps, I can post the macro but it's a bit lengthy...
--
View this message in context:
http://nabble.documentfoundation.org/Macro-from-command-line-ThisComponent-CurrentController-not-found-tp4074374p4074502.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
