Andrew Pitonyak schreef op 13/03/2015 om 12:55:
Of course you can do it... Start by finding each bookmark to see how that is
done. I don't remember off hand if you can then insert the image at the anchor
point. You may need to use a dispatch to do it.
something like
| oMarks = ThisComponent.
Semen,
I use a hidden calc doc to produce charts
i hope this can help::
greetz
Fernand
Sub AreaChart(ChartDataArray(), LabelsArray(), CName as String, CSheet
as String, Optional YPos as Integer,bOrders as boolean)
Dim Length as Integer
Dim oCharts
Dim oRect as new com.sun.star.awt.Recta
Michaël ,
totaal overbodig Openoffice en Libreoffice zijn GRATIS
wellicht werkt het "garagesysteem" niet met opensource sofware, maar
uitsluitend met MS ??
Beste,
Ik werk momenteel bij een Autogarage en wij stappen over naar een ander
systeem. Nu zijn wij van plan over te stappen op Openoffic
Vladislav ,
it depends in what format your logo is in a LO doc
EPS = troubles
SVG or any pixel format (jpg etc..) is ok
greetz
fernand
Hello,
Is there chance to improve ON in that way that logo of my firm can export
in pdf file. This functionality is very important if we want to work
normall
Hagar , others
Many , many years ago i learned using the API and Basic from this forum
Please copy not only the snipets , this forum gives tons of code
examples and solutions not found in any other documentation , specialy
the libraries made by Danny Brewer must been saved from distroying
gre
Vladislav ,
In Belgium we have to deal with at least 2 languages Dutch and French
who have also a lot non asci characters, we use extenifly Basic and some
times hwe have to decode some text to UTF-8 who works and we decode the
stream
plese find below some code to encode a stream before insert
Dave,
Not realy, the newest worklows are RGB based, the convertion to CMYK is
done after the PDF is made, make your RGB PDF's with Openoffice and
let your print shop do the convertion to there own (machine depended)
CMYK standards.
Converting RGB to CMYK is not a straight forward, print sh
Hallo Peter ,
Hi Clarence,
Am 02.09.2013 08:47, schrieb Clarence GUO:
Hi~
I'm totally green at StarBasic and VBA. Now I have a question about
CreateObject. I installed SAP and have below macros.
Dim SapGuiAuto As Variant
Set SapGuiAuto = CreateObject("SAPGUI")
"SAPGUI" must be an ActiveXObje
Jörg ,
For LO 4.0 Windows this is not happening, the toolbars are coming and
going as expected
AOO 4.0 prerelease Windows same behaviour the toolbars are
coming and going as expected
greetz
Fernand
From: Jörg Schmidt [mailto:joe...@j-m-schmidt.de]
Sent: Friday, August 16, 2013 9:12 A
Dominic ,
the trick is to use the form "explorer" to add a extra subform to a form
open first the forms toolbar
hi
I need help with openoffice base. i created a form with a subform using the
wizard. i need more than one subform and dont know how to add additional
subforms. i tried re
Andrea
You worked on the export off the images, did also you modified the
current behavior where the cropping and color changes are not exported ?
When a image is cropped in a OO-doc then we must export not the original
image but the image as we sea in the document. When needed I can past
yo
Donald ,
make 2 page styles
- one with 4 columns and with "next" style no columns.
- one with no columns and "next" style 4 columns
swith from page style when wanted
hope it helps
Fernand
I recently started a document with 4 columns. I then tried to have no
columns on subsequent pages. As
Mechtilde
Hello,
We need base with its easy way to connect to databases like mysql or
postgresql especially under other OS's than Windows.
we ourselves developed an extension based on this funktion for Law
Offices in Germany
There is no other free Office Suite which had a databse modul which
Ariel ,
Well no doubt this may start a rather heated discussion.
One of my favorites quotes about Base is from Andreas Säger (villeroy on
the forums):
"The difference between MS Access and Base amounts to several millions of
Dollars and more than one decade of development time.
Once you got
On 4/03/2013 8:27, M. Fioretti wrote:
On Mon, Mar 04, 2013 08:16:25 AM +0100, Fernand Vanrie wrote:
99% percent , changes comes and will come from incompatiliteis in de API.
for now this is OK, small changes from version to version, but
nothing who not can been repaired or handled with the
Yessica?
Hello,
I have a macro in a form called Sales Payments.
What the macro should do is this: when you select a customer from a combo
box, take the current balance of the customer (which is in the the Customer
table, saldo_actual field) and put it into a form field Payments Sales
called bal
Ariel ?
On Tue, Feb 05, 2013 at 07:29:56PM -0500, Rob Weir wrote:
Current BZ version doesn't seem to allow display of vote totals in a
view column. But I found a way to make an off-line report. So if any
developer is looking for things that will make many users happy, here
is a list of all op
aid in my previous mail, I put in value If required, I deleted all records
from the cliente table and have even removed all relationships with other
tables, just do not let me, I can not just save the changes made and the
cursor is just saldo_actual field.
Regards,
Yessica
2013/2/3 Fernand Van
i opened your base document , opened to edit your cliente table, close
and run your macro
now your macro works :-)
Op 03/02/2013 13:38, Fernand Vanrie schreef:
Op 02/02/2013 11:20, Yessica Brinkmann schreef:
Hello,
Yes, I write: SELECT cliente.saldo_actual FROM cliente WHERE
id_cliente=0
its run in a query, than it must also in the macro ?
TRYE to run a other macro with only the statement with the id and the
value hardcoded
Regards,
Yessica
2013/2/2 Fernand Vanrie
Op 02/02/2013 07:04, Yessica Brinkmann schreef:
Hello,
I wanted to ask if I can please help with this issue. Is
Sorry, did not know that I should not
put attachments. Now I have no errors in the macro, and I used the SQL
UPDATE indicated. Just do not know why but UPDATE fails. So, when I check
the table, I do not see the value of the changed field. I refreshed the
table also but nothing. I printed the total
Ariel, Yessica,
with OObase database, table and field names are case sensitive, their is
no need to quote if: tables are lowercase and fieldnames uppercase.
if quotes are used, then leave the dots out of the quotes
sSQL= "SELECT ""mybase"".""cliente"".""saldo_saldo_actual""
WHERE...
veConnection
oStat=oCon.CreateStatement
sSQL="UPDATE cliente SET cliente.saldo_actual =
cliente.saldo_saldo_actual + "& oTotal.getCurrentValue()& " WHERE
cliente.id_cliente=" & CInt(sCliente)
oRes=oStat.ExecuteQuery(sSQL)
End Sub
Regards,
Yessic
d data:
Total= oFrm.getByName("fmttotal").VALUE
I can not find the client code for the name either, if that's what you
suggest because this name is not necessarily unique, only the customer id
is unique.
regards,
Yessica
2013/1/31 Fernand Vanrie
Yessica,
Hello,
Yes, my contr
Yessica,
Hello,
Yes, my controls now have the same name as the one I use to call the macro.
Initially that was my mistake but I spent those mistakes. Now my problem is
that I describe in my previous mail, on the subject of the combo box and
customer_id and name.
There is a key value associated wi
Yessica
nono , just check if the name of your controls are identical to what you
call with "getbyname" (check uppercase, lower)
greetz
Fernand
Hello,
I think I can do this with string functions Left and Split but I do not
know which is the separator for the ComboBox, for separating the
Yessica ,
hard to sea, but the error must open the basic ID and higlight the place
off the error,
"container.NoSuchElementException" >> probably a typo in the name of one
of the fieldnames ?
called by the "getbyname"
hope it helps
Fernand
Hello,
I have a database of business management.
Hallo Armin ,
Hi Fernand,
On 22.11.2012 18:38, Fernand Vanrie wrote:
Armin ,
Hi Fernand,
On 15.11.2012 09:34, Fernand Vanrie wrote:
Alexandro ,
---snip---
Draw is a perfect Desktop publisher, is so perfect is compatible
with other
We uses exclusifly Writer (+ lot of basic macro
Armin ,
Hi Fernand,
On 15.11.2012 09:34, Fernand Vanrie wrote:
Alexandro ,
---snip---
Draw is a perfect Desktop publisher, is so perfect is compatible
with other
We uses exclusifly Writer (+ lot of basic macro's) to make over 8.000
full color magazine pages par year. This pages ar
Dave ,
Hi Phil,
It is not completely impossible that an extension could be added to AOO to read
and write Publisher files. It just takes one or two Java programmers with the
time and interest. See [1] for where the effort could start.
On Nov 22, 2012, at 8:36 AM, Fernand Vanrie wrote
ess story about your experience
and work with writer. It sounds very interesting especially when you stay in
one world, means no heavy exchange of MS formats.
Thanks for sharing
Juergen
Am Donnerstag, 15. November 2012 um 09:34 schrieb Fernand Vanrie:
Alexandro ,
On Tue, Nov 13, 2012 at 11:24 PM,
Alexandro ,
On Tue, Nov 13, 2012 at 11:24 PM, Phillip Zadro
wrote:
hi Is there any likelihood that OpenOffice will one day include a desktop
publisher? There is only one thing that is stopping me from migrating
completely from Microsoft Office to either OpenOffice or LibreOffice and it
is t
Phillip ,
hi Is there any likelihood that OpenOffice will one day include a desktop
publisher?
OO and LO are are already a Desktop application, included a very good
PDF exporter. Sure its not like you MS Publisher , here you don't pay
but need a bit more skills to make it work as a publish
33 matches
Mail list logo