[libreoffice-users] Open form from button
Hi all Is it possible to open to put a button in a form to open a different form from a linked field? I have a form that gives general information about the use of a plant in landscaping, and a quite different form that gives information about propagating that plant. I'd like to have a button to open the second form from the first. -- Regards, Edwin Humphries Mobile: 0435 672 457 I acknowledge the traditional Wodi Wodi custodians, their elders and customs, of the Dharawal lands on which I live. "At every moment he beholdeth a wondrous world, a new creation, and goeth from astonishment to astonishment, and is lost in awe at the works of the Lord of Oneness." Bahá'u'lláh "... humans are interesting. With all the wonders there are in the Universe, they invented boredom." Terry Pratchett, Hogfather "The most beautiful thing we can experience is the mysterious. It is the source of all true art and all science. He to whom this emotion is a stranger, who can no longer pause to wonder and stand rapt in awe, is as good as dead: his eyes are closed." Albert Einstein "Stuff your eyes with wonder ... live as if you'd drop dead in ten seconds. See the world. It's more fantastic than any dream made or paid for in factories." Ray Bradbury -- 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] Extract text from base field, place into new field
Hi all I need to copy the first word from an existing field and place it into a new field. Is there a way to do that autoagically? -- Regards, Edwin Humphries I acknowledge the traditional Wodi Wodi custodians, their elders and customs, of the Dharawal lands on which I live. "At every moment he beholdeth a wondrous world, a new creation, and goeth from astonishment to astonishment, and is lost in awe at the works of the Lord of Oneness." Bahá'u'lláh "... humans are interesting. With all the wonders there are in the Universe, they invented boredom." Terry Pratchett, Hogfather "The most beautiful thing we can experience is the mysterious. It is the source of all true art and all science. He to whom this emotion is a stranger, who can no longer pause to wonder and stand rapt in awe, is as good as dead: his eyes are closed." Albert Einstein "Stuff your eyes with wonder ... live as if you'd drop dead in ten seconds. See the world. It's more fantastic than any dream made or paid for in factories." Ray Bradbury -- 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] Image wrap and footnotes
Hi all. I'm writing a family history, with lots of photos, most of which are right aligned and wrapped left. One image is configured to sit at the bottom of the page text area, but it seems that LO doesn't know how to wrap footnote text, because the image sits over the top of it. I can manually move the image up the page, but every time I think of some change to the document before that image appears, I'll have to go to it and manually redo it. Is there a way to configure the image so that it sits above the footnote text, or to configure the footnote text so that it obeys the image’s wrap settings? -- Regards, Edwin Humphries Mobile: 0435 672 457 I acknowledge the traditional Wodi Wodi custodians, their elders and customs, of the Dharawal lands on which I live. "At every moment he beholdeth a wondrous world, a new creation, and goeth from astonishment to astonishment, and is lost in awe at the works of the Lord of Oneness." Bahá'u'lláh "... humans are interesting. With all the wonders there are in the Universe, they invented boredom." Terry Pratchett, Hogfather "The most beautiful thing we can experience is the mysterious. It is the source of all true art and all science. He to whom this emotion is a stranger, who can no longer pause to wonder and stand rapt in awe, is as good as dead: his eyes are closed." Albert Einstein "Stuff your eyes with wonder ... live as if you'd drop dead in ten seconds. See the world. It's more fantastic than any dream made or paid for in factories." Ray Bradbury -- 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 macros
OK, so I tried to follow the instructions as best as I could, but no success. I've attached a demo version of what I've tried, with essential image files, in exactly the same relation they are in the full version. I've added the macro and an action button. Can someone tell me what I'm doing wrong? On 26/03/2024 5:50 pm, Robert Großkopf wrote: Hi Edwin, Thank you. I should have clarified: the image that comes up on the form is a size limited version of the actual file on the hard disk. This will be the problem: Where could you get the path to the original sized images? Macro will work with a path to external images. 2. In each image button, under the additional information field, write the name of the image control. Don't know why an image button. Could be any button, which contains in additional information the name of the field with URL-information to the original image. Regards Robert -- Regards, Edwin Humphries Mobile: 0435 672 457 I acknowledge the traditional Wodi Wodi custodians, their elders and customs, of the Dharawal lands on which I live. "At every moment he beholdeth a wondrous world, a new creation, and goeth from astonishment to astonishment, and is lost in awe at the works of the Lord of Oneness." Bahá'u'lláh "... humans are interesting. With all the wonders there are in the Universe, they invented boredom." Terry Pratchett, Hogfather "The most beautiful thing we can experience is the mysterious. It is the source of all true art and all science. He to whom this emotion is a stranger, who can no longer pause to wonder and stand rapt in awe, is as good as dead: his eyes are closed." Albert Einstein "Stuff your eyes with wonder ... live as if you'd drop dead in ten seconds. See the world. It's more fantastic than any dream made or paid for in factories." Ray Bradbury -- 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 macros
Robert
Thank you. I should have clarified: the image that comes up on the form
is a size limited version of the actual file on the hard disk. I called
it a "thumbnail" as shorthand for that level of detail; Sorry.
So, seeing how I am an ingénue in the macro game, can I confirm the process?
1. Add as an embedded macro the following:
SUB ShowLinkedContent(oEvent AS OBJECT)
oDoc = ThisComponent
DIM oButton AS OBJECT, oForm AS OBJECT, oField AS OBJECT,
oShell AS OBJECT
DIM stField AS STRING, stUrl AS STRING, stContent AS STRING
DIM arUrl_Start()
oButton = oEvent.Source.Model
stField = oButton.Tag
oForm = oButton.Parent
oField = oForm.getByName(stField)
stUrl = oField.BoundField.getString
arUrl_Start = split(oDoc.Parent.Url,oDoc.Parent.Title)
oShell = createUnoService("com.sun.star.system.SystemShellExecute")
stContent = convertToUrl(arUrl_Start(0) + stUrl)
oShell.execute(stContent,,0)
END SUB
2. In each image button, under the additional information field, write
the name of the image control.
Is that right?
On 25/03/2024 6:01 pm, Robert Großkopf wrote:
Hi Edwin,
How should an external viewer open another picture, which isn't linked
in the form? A macro will open the thumbnails.
Link the original fotos to the form. Then take this procedure:
SUB ShowLinkedContent(oEvent AS OBJECT)
DIM oButton AS OBJECT, oForm AS OBJECT, oField AS OBJECT, oShell
AS OBJECT
DIM stField AS STRING, stUrl AS STRING, stContent AS STRING
DIM arUrl_Start()
oButton = oEvent.Source.Model
stField = oButton.Tag
oForm = oButton.Parent
oField = oForm.getByName(stField)
stUrl = oField.BoundField.getString
arUrl_Start = split(oDoc.Parent.Url,oDoc.Parent.Title)
oShell = createUnoService("com.sun.star.system.SystemShellExecute")
stContent = convertToUrl(arUrl_Start(0) + stUrl)
oShell.execute(stContent,,0)
END SUB
Write the name of the image control to the additional information of
the button, which should start this procedure.
Regards
Robert
--
Regards,
Edwin Humphries
Mobile: 0435 672 457
I acknowledge the traditional Wodi Wodi custodians, their elders and
customs, of the Dharawal lands on which I live.
"At every moment he beholdeth a wondrous world, a new creation, and
goeth from astonishment to astonishment, and is lost in awe at the works
of the Lord of Oneness." Bahá'u'lláh
"... humans are interesting. With all the wonders there are in the
Universe, they invented boredom." Terry Pratchett, Hogfather
"The most beautiful thing we can experience is the mysterious. It is the
source of all true art and all science. He to whom this emotion is a
stranger, who can no longer pause to wonder and stand rapt in awe, is as
good as dead: his eyes are closed." Albert Einstein
"Stuff your eyes with wonder ... live as if you'd drop dead in ten
seconds. See the world. It's more fantastic than any dream made or paid
for in factories." Ray Bradbury
--
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 macros
Hi all, I have a database consisting of several flat-file tables with associated forms. They contain information about plants, including several photos (up to 6) per form. They are currently 150*150 "thumbnails", but the photos themselves are larger, sometimes much larger. I would like to add a feature that allows a viewer to open the photo up in a separate window to screen maximum. I have seen several macros online that purport to do that, but with limited documentation, and apparently suited only for one photo per form. Moreover, I have little experience with scripted macros, in Base (or any other program, for that matter). Can anyone help with this? -- Regards, Edwin Humphries Mobile: 0435 672 457 I acknowledge the traditional Wodi Wodi custodians, their elders and customs, of the Dharawal lands on which I live. "At every moment he beholdeth a wondrous world, a new creation, and goeth from astonishment to astonishment, and is lost in awe at the works of the Lord of Oneness." Bahá'u'lláh "... humans are interesting. With all the wonders there are in the Universe, they invented boredom." Terry Pratchett, Hogfather "The most beautiful thing we can experience is the mysterious. It is the source of all true art and all science. He to whom this emotion is a stranger, who can no longer pause to wonder and stand rapt in awe, is as good as dead: his eyes are closed." Albert Einstein "Stuff your eyes with wonder ... live as if you'd drop dead in ten seconds. See the world. It's more fantastic than any dream made or paid for in factories." Ray Bradbury -- 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] Default Images Path
Hi all. I have a large number of images to link to an LO database, so am trying to reduce the number of keystrokes and mouse taps to speed it up. One of the ways I can do this is to have the directory that opens when I click on the image field be the directory in which the images reside. I have set the paths (Tools > Options > Paths) for Images to be that directory, but it still opens to the gallery directory. I have also set the Gallery location to the correct directory, but it still opens to the default gallery location. What can I do to correct this? Thanks, Edwin -- 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
