Re: [libreoffice-users] Newbie help needed please.

[Steve Edmonds]

Hi.
It seems the text has been converted to a shape.
If you open Libreoffice Draw, and then from there open the PDF you can 
edit it.


If you know the font used or can find one that looks the same, you can 
delete the characters you want to change (or the whole date) and add 
text (insert text box in the top row of icons, or F2) for the date you 
require.


If you right click on the existing text shapes, you can inspect Line and 
Area (Fill), note the settings and fill colour so you can make the new 
text the same.


You can drag guide lines from the rulers to mark the position of the old 
text to be deleted, so you can place the new text in the same place and 
same size.


Steve

On 23/07/18 14:22, Diamondblack wrote:

I am a complete novice and I do not want to come on the forum and upset
anyone with such a simple task.

I have Downloaded and installed LibreOffice 5.4.7.

I have two PDF Files and all I need to do is change the text and I can not
ever work out how to do a simple edit.

All I have to do is change 2017 to 2009 on the first PDF file and change
1967 to 1959 on the other PDF file.


AutoBild_logo_2017.pdf


AutoBild_Turm_Druck2017.pdf



I can manage to highlight the text and delete it and thats all, is it
possible the it is not even text?



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Newbie help needed please.

[jonaton]

On 23/07/18 02:22 AM, Diamondblack wrote:

> I have two PDF Files and all I need to do is change the text and I can not
> ever work out how to do a simple edit.
> 
> All I have to do is change 2017 to 2009 on the first PDF file and change
> 1967 to 1959 on the other PDF file.

PDF was designed to be a _read only_ format.
This means that to edit the file is to violate the primary intent and
function of the file format.

jonathon


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Underlined unformatted text

[Steve Edmonds]

Hi.
When you paste unformatted text, the text takes on the formatting 
currently active at the cursor. So if underlining is active at the 
cursor, all the inserted text will be underlined.

Does this occur when you paste unformatted into a blank document.

Steve

On 23/07/18 10:21, Peggy wrote:

Why is it that when I do an unformatted paste of what I copied is it all
underlined!

I posted another problem less than an hour ago. Do you think I need to
uninstall and reinstall?




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Newbie help needed please.

[Diamondblack]

I am a complete novice and I do not want to come on the forum and upset
anyone with such a simple task.

I have Downloaded and installed LibreOffice 5.4.7.

I have two PDF Files and all I need to do is change the text and I can not
ever work out how to do a simple edit.

All I have to do is change 2017 to 2009 on the first PDF file and change
1967 to 1959 on the other PDF file.


AutoBild_logo_2017.pdf

  

AutoBild_Turm_Druck2017.pdf

  


I can manage to highlight the text and delete it and thats all, is it
possible the it is not even text?



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Underlined unformatted text

[Brian Barker]

At 18:21 22/07/2018 -0400, Peggy Marliz wrote:
Why is it that when I do an unformatted paste of what I copied is it 
all underlined!


Possibly because you have the recording of changes toggled on. Go to 
Edit | Changes > | Record to toggle it off if that is what you 
prefer. To remove the effect for existing marked text, right-click 
and select Accept Change, or use Edit | Changes > | Accept or Reject...



Do you think I need to uninstall and reinstall?


No.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Underlined unformatted text

[Peggy]

Why is it that when I do an unformatted paste of what I copied is it all
underlined!

I posted another problem less than an hour ago. Do you think I need to
uninstall and reinstall?

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Strange Macro folder behavior

[Drew Jensen]

One more reference for you, particularly if you are trying to use Record
Macro, with much better detail on what could be culprit here.
https://forum.openoffice.org/en/forum/viewtopic.php?f=9=80579#p371390

How it helps,

Drew

On Sun, Jul 22, 2018 at 5:49 PM Peggy <33mar...@gmail.com> wrote:

> I selected some all capitalized text in a title, wanting to make a macro to
> change it to initial caps. Ran the macro, stopped it and it worked. Went to
> the macros under "My macros" in the library to assign a shortcut key.
>
> I couldn't find the macro but found a whole new Folder named with the Title
> I'd selected. Worse yet was a folder with the title of another document I'd
> started. I couldn't find any way to delete either of them.
>
> And even worse, when I looked at "My Macros" they were all gone.
>
> Searched online and there were a couple of questions from people who had
> lost all their macros, but they weren't answered. One was closed by a
> moderator because (something like) it was untimely. Don't quote me on that.
> Whatever it didn't seem the reason for closing it was valid.
>
> I will uninstall and reinstall Libre Office, just losing one template I
> made since my macros are gone. But can anyone tell me what I did to cause
> those new folders? My macors were simple but convenient, and I can create
> them again.
>
> Peggy
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Pasted Text inside a "box"

[Steve Edmonds]

Hi.
Is it in a frame.
If you Paste Special>Unformatted text (right click or edit menu) you 
should be able to paste without any carry over from the copy.

Steve

On 19/07/18 02:24, Peggy wrote:

It happens quite often when I paste something I want to save. The box can
be holding a lot of text and you have to stay in it to add your own text.
It's not a table because a right click doesn't bring up table options. I
tried paragraph formate from the right cliick and checked no borders. No
luck.

Thanks so much to anyone who can tell me how I can fix this. It's
irritating.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Strange Macro folder behavior

[Drew Jensen]

Howdy,

So, I see that on ask libreoffice this has come up twice and both times
closed out (without an answer) or left unanswered.

There is an old forum post on this that might help in your case. You can
find it here:
https://forum.openoffice.org/en/forum/viewtopic.php?f=5=42324 but that is
back form 2012.

By any chance had you been using the Record Macro feature also?

Best wishes,

Drew

On Sun, Jul 22, 2018 at 5:49 PM Peggy <33mar...@gmail.com> wrote:

> I selected some all capitalized text in a title, wanting to make a macro to
> change it to initial caps. Ran the macro, stopped it and it worked. Went to
> the macros under "My macros" in the library to assign a shortcut key.
>
> I couldn't find the macro but found a whole new Folder named with the Title
> I'd selected. Worse yet was a folder with the title of another document I'd
> started. I couldn't find any way to delete either of them.
>
> And even worse, when I looked at "My Macros" they were all gone.
>
> Searched online and there were a couple of questions from people who had
> lost all their macros, but they weren't answered. One was closed by a
> moderator because (something like) it was untimely. Don't quote me on that.
> Whatever it didn't seem the reason for closing it was valid.
>
> I will uninstall and reinstall Libre Office, just losing one template I
> made since my macros are gone. But can anyone tell me what I did to cause
> those new folders? My macors were simple but convenient, and I can create
> them again.
>
> Peggy
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base : How to control insert into a form in order to generat my own keys by macro ?

[Drew Jensen]

On Sun, Jul 22, 2018 at 2:58 AM Patrick Gelin  wrote:

> Hi,
>
> I would like to control key generation by macro when inserting a new row
> into a form with Base. But the risk is to execute twice insert action :
> the first with my handling insert event (I want to manage the mapping
> and use my own generated keys) and the second by the form base code
> automatically 


There are two paths to this:
One: setup a inert trigger in the database engine to do this.
Details on creating triggers vary depending on the engine you are using.
This works if the data you use to assemble your key is already in the
database (fields in other tables for instance).
OR
Two: handle it with the client application (Base) which seems to be the
advice you are getting so far.

The decision as to which way to go depends on how you want to use it, doing
it with a triggere means that any form, or table grid, attached to the
table will pick up the function but you if you want to read values from
form controls to construct your key the client side work work best.

Best wishes,

Drew

>


> So, if I set the property {AllowInserts = false}, do the Form stop to
> handling the insert but continue to fired /"Before Record Action"/ and
> /"After Record Action"/ events ? I think no, because the form could will

not display the new line to insert ...
>

Ok, that question gets into


>
> So I need to stop the handlind to the Form after my own into events. But
> I understand /"After Record action"/ event handling use a /"Sub"/ action
> not a /"function"/, so I can't return false after my handling ...
>
> So how to do ?
>
> Thank you for your help...
> Patrick
> /
> /
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Predefinied constants (Macro, Basic)

[Drew Jensen]

Howdy,

To the best of my knowledge those are it.

You would need to recreate those once and then include them in later
projects. It's a common thing for folks to do, make their own include
library with such.
In fact you might want to look at the Access2Base library in the
libreoffice distribution, I believe the author may have defined a number of
constants (the whole library recreated VBA functions for use in
LibreOffice), it may be that what you are looking for is already there you
would simply need to load it at runtime. Not to mention you might find some
others things there, coming from a VBA background, useful.

Best wishes,

Drew

On Sun, Jul 22, 2018 at 4:26 PM Johnny Rosenberg 
wrote:

> Hi!
>
> I have done some searching and finally I found this at
> https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Constants:
>
> ”OpenOffice.org Basic predefines several constants. Among the most useful
> are:
>
>- True and False, for Boolean assignment statements
>- PI as a type Double numeric value”
>
> I assume this is true for LibreOffice as well, but I can't find the rest of
> the ”several constants”.
>
> At work a use Excel (I don't really want to and it's full of bugs, but at
> least I get paid…) and I wrote some macros in VBA. VBA has a lot of
> predefined constants, for instance vbNewLine and a lot more, and I'm now
> trying to find out what constants are available in LibreOffice Basic, since
> LibreOffice is what I use exclusively at home, so I don't have to reinvent
> the wheel.
>
> So a link to a list of ALL predefined Basic constants would be very
> appreciated.
>
> Kind regards
>
> Johnny Rosenberg
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Predefinied constants (Macro, Basic)

[Johnny Rosenberg]

Hi!

I have done some searching and finally I found this at
https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Constants:

”OpenOffice.org Basic predefines several constants. Among the most useful
are:

   - True and False, for Boolean assignment statements
   - PI as a type Double numeric value”

I assume this is true for LibreOffice as well, but I can't find the rest of
the ”several constants”.

At work a use Excel (I don't really want to and it's full of bugs, but at
least I get paid…) and I wrote some macros in VBA. VBA has a lot of
predefined constants, for instance vbNewLine and a lot more, and I'm now
trying to find out what constants are available in LibreOffice Basic, since
LibreOffice is what I use exclusively at home, so I don't have to reinvent
the wheel.

So a link to a list of ALL predefined Basic constants would be very
appreciated.

Kind regards

Johnny Rosenberg

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base : How to control insert into a form in order to generat my own keys by macro ?

[Robert Großkopf]

Hi Patrick,
> 
> But it looks strange to call "UndoRecordChanges" form operation after my
> own "YourInsertFunction", it look like this call undo my own insert ...
> then, undo the operation of the form is not really no operation of the
> form ...

This should stop the prozess. I have had a look here
https://api.libreoffice.org/docs/idl/ref/FormFeature_8idl.html
and found nothing else to stop the process.

Could be
oFormOperations.execute(oFormFeature.ReloadForm)
oFormOperations.execute(oFormFeature.MoveToLast)

will switch to the new input you have inserted by yourself.
> 
> Could you please tell me more about the form operations ? In the book
> Robert Benitez - Database Programming OpenOffice.org Base & Basic -
> Cecilia Benitez, 2008 I find out nothing about all this ...

Most of the code I am using I have learned of the German book about
BASIC from Thomas Krumbein and also in message boards.

I have written down all this in the German Base-Handbuch, but it isn't
translated yet in English. The German version you could find here:
https://de.libreoffice.org/get-help/documentation/

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base : How to control insert into a form in order to generat my own keys by macro ?

[Patrick Gelin]

Thank you very much Robert :-)

But it looks strange to call "UndoRecordChanges" form operation after my 
own "YourInsertFunction", it look like this call undo my own insert ...
then, undo the operation of the form is not really no operation of the 
form ...


Could you please tell me more about the form operations ? In the book 
Robert Benitez - Database Programming OpenOffice.org Base & Basic - 
Cecilia Benitez, 2008 I find out nothing about all this ...


Do you think an other solution would be to lock the form controller or 
cancel the event, into "Before Record Action" handling ? I could find 
/"myDocument.lockControllers"/ function but it will stop only the 
interface refresh ...


Patrick

Le 22/07/2018 à 15:40, Robert Großkopf a écrit :

Hi Patrick,

So, if I set the property {AllowInserts = false}, do the Form stop to
handling the insert but continue to fired /"Before Record Action"/ and
/"After Record Action"/ events ? I think no, because the form could will
not display the new line to insert ...

You will need "Before Record Action". After the action the data will be
inserted.
You will also need AllowInserts = true. Without this you couldn't get
the cursor in a new row.
The macro should do something like this:

SUB InsertStop(oEvent AS OBJECT)
DIM oFormFeature AS OBJECT
DIM oFormOperations AS OBJECT
oFormFeature = com.sun.star.form.runtime.FormFeature
IF oEvent.Source.ImplementationName =
"org.openoffice.comp.svx.FormController" THEN
oFormOperations = oEvent.Source.FormOperations
YourInsertFunction()
oFormOperations.execute(oFormFeature.UndoRecordChanges)
REM oFormOperations.execute(oFormFeature.MoveToLast)
END SUB

The YourInsertFunction() does exist, or do I understand your mail the
wrong way?

Regards

Robert



--
/M Patrick GELIN
181 route d'Arzay
Lieu dit "Saint Martin"
38440 Lieudieu
06 80 32 87 18/

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base : How to control insert into a form in order to generat my own keys by macro ?

[Robert Großkopf]

Hi Patrick,
> 
> So, if I set the property {AllowInserts = false}, do the Form stop to
> handling the insert but continue to fired /"Before Record Action"/ and
> /"After Record Action"/ events ? I think no, because the form could will
> not display the new line to insert ...

You will need "Before Record Action". After the action the data will be
inserted.
You will also need AllowInserts = true. Without this you couldn't get
the cursor in a new row.
The macro should do something like this:

SUB InsertStop(oEvent AS OBJECT)
DIM oFormFeature AS OBJECT
DIM oFormOperations AS OBJECT
oFormFeature = com.sun.star.form.runtime.FormFeature
IF oEvent.Source.ImplementationName =
"org.openoffice.comp.svx.FormController" THEN
oFormOperations = oEvent.Source.FormOperations
YourInsertFunction()
oFormOperations.execute(oFormFeature.UndoRecordChanges)
REM oFormOperations.execute(oFormFeature.MoveToLast)
END SUB

The YourInsertFunction() does exist, or do I understand your mail the
wrong way?

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Base : How to control insert into a form in order to generat my own keys by macro ?

[Patrick Gelin]

Hi,

I would like to control key generation by macro when inserting a new row 
into a form with Base. But the risk is to execute twice insert action : 
the first with my handling insert event (I want to manage the mapping 
and use my own generated keys) and the second by the form base code 
automatically 


So, if I set the property {AllowInserts = false}, do the Form stop to 
handling the insert but continue to fired /"Before Record Action"/ and 
/"After Record Action"/ events ? I think no, because the form could will 
not display the new line to insert ...


So I need to stop the handlind to the Form after my own into events. But 
I understand /"After Record action"/ event handling use a /"Sub"/ action 
not a /"function"/, so I can't return false after my handling ...


So how to do ?

Thank you for your help...
Patrick
/
/

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy