Re: [libreoffice-users] Base macros
I have not dealt with Base for years now (say 15), but, I did create a database to track stuff that I own. The DB contained full scale images of the receipts. I did not do as our indicated, but, it does display properly scaled images in the image control. I took a look at the macros I wrote and I did nothing special in the macros (it seems) to properly scale. My biggest error was to embed the entire full size image into the DB. I do have buttons that Add an Image (so select, load and store in DB), Delete an image (delete from DB), replace an image (so select from file system, then replace existing), and extract from the DB I can directly email you a copy of an empy DB if it interests you, but I am not sure if it is useful or not. It sounds like you did it write, show a thumbnail stored in your DB and reference the actual file on disk. I am writing a database front end application in C++ and QT for specific collectibles and it will find the image using a naming scheme based on a catelog number (at least for the standard image). Probably a better solution. Andrew Pitonyak On Monday, March 25, 2024 01:01 EDT, Edwin Humphries wrote: 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 -- 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] Labels created in Writer shifts downward while printed
Ian Bertram wrote: I've had similar issues with user defined labels. Make sure to check the spacing between labels is correctly set. If it is fractionally out, you will get this sort of cumulative increase in misalignment. On Mon, 25 Mar 2024, 22:27 Paul D. Mirowsky, wrote: A shat in the dark... * A blank or unseen line at last table row cell(s) * Incorrect metric vs decimal inch calculation forcing a mismatch between software and printer * header or footer is not zero in length * Select all and right click "clear direct formatting" Hope this helps. On 3/22/24 20:13, Hartman Tam wrote: Hello all, I'm creating some labels in Writer. After it being printed, each label shifted downward gradually. This happens with and without any formatting. I have checked I have my label setup correctly. I also tried disabled my printer's scaling but doesn't help. My printer is Brother MFC-L2710DW. Did I miss anything? How can I solve this? LibreOffice version: * Version: 7.3.7.2 / LibreOffice Community * Build ID: 30(Build:2) * CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 * Locale: en-GB (en_GB.UTF-8); UI: en-GB * Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.4 * Calc: threaded Jumbo The label I'm using: https://www.amazon.co.uk/gp/product/B093TM72T7 Thanks, Hartman -- 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 Is it possible that there is a page size to paper size mismatch? Regards Fred James -- 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
Re: [libreoffice-users] Labels created in Writer shifts downward while printed
I've had similar issues with user defined labels. Make sure to check the spacing between labels is correctly set. If it is fractionally out, you will get this sort of cumulative increase in misalignment. On Mon, 25 Mar 2024, 22:27 Paul D. Mirowsky, wrote: > A shat in the dark... > > * A blank or unseen line at last table row cell(s) > * Incorrect metric vs decimal inch calculation forcing a mismatch > between software and printer > * header or footer is not zero in length > * Select all and right click "clear direct formatting" > > Hope this helps. > > > On 3/22/24 20:13, Hartman Tam wrote: > > Hello all, > > > > I'm creating some labels in Writer. After it being printed, each label > > shifted downward gradually. This happens with and without any > > formatting. I have checked I have my label setup correctly. I also > > tried disabled my printer's scaling but doesn't help. My printer is > > Brother MFC-L2710DW. Did I miss anything? How can I solve this? > > > > LibreOffice version: > > > > * Version: 7.3.7.2 / LibreOffice Community > > * Build ID: 30(Build:2) > > * CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 > > * Locale: en-GB (en_GB.UTF-8); UI: en-GB > > * Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.4 > > * Calc: threaded Jumbo > > > > The label I'm using: https://www.amazon.co.uk/gp/product/B093TM72T7 > > > > Thanks, > > Hartman > > > -- > 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] Labels created in Writer shifts downward while printed
A shat in the dark... * A blank or unseen line at last table row cell(s) * Incorrect metric vs decimal inch calculation forcing a mismatch between software and printer * header or footer is not zero in length * Select all and right click "clear direct formatting" Hope this helps. On 3/22/24 20:13, Hartman Tam wrote: Hello all, I'm creating some labels in Writer. After it being printed, each label shifted downward gradually. This happens with and without any formatting. I have checked I have my label setup correctly. I also tried disabled my printer's scaling but doesn't help. My printer is Brother MFC-L2710DW. Did I miss anything? How can I solve this? LibreOffice version: * Version: 7.3.7.2 / LibreOffice Community * Build ID: 30(Build:2) * CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 * Locale: en-GB (en_GB.UTF-8); UI: en-GB * Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.4 * Calc: threaded Jumbo The label I'm using: https://www.amazon.co.uk/gp/product/B093TM72T7 Thanks, Hartman -- 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] Reference manager adding into LibreOffice writer
Şerife - I don't know about Mendeley, but Zotero works well with LO Writer. Just follow the instructions at https://www.zotero.org/support/installation. As explained at https://www.zotero.org/support/word_processor_integration, 'the word processor plugins are bundled with Zotero and should be installed automatically for each supported word processor on your computer when you first start Zotero.' - Robert From: Şerife ÇAKIR Sent: March 25, 2024 03:46 To: Users@global.libreoffice.org Subject: [libreoffice-users] Reference manager adding into LibreOffice writer Hi, I have a trouble. I am writing my thesis and using LibreOffice writer instead of Office Word. But I am not adding Mendeley or the other reference adding extensions, like Zotero, endnote into LibreOffice. I need it immediately. Can you help me about it? I don't want to enter for each reference by manual. I want to add automatically with an extension, like Mendeley. Thanks in advance. Regards -- *MSc. Şerife ÇAKIR* -- 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] Spell Check
Hello, I am sorting out a new mac laptop and would like to run Libre for my word processing. I did download it and using the address of chris.u...@gmail.com I'm writing from a different address due to a couple of hiccups. Whilst testing the libreoffice word processor on my first document its spell check functions were all over the placesome corrected and some deliberate simple ones it refused to identify. Is this a bug with the latest offering or can I cure this somehow? Thanks, Chris *Chris UndyLibrary and * *Research* *Library* Museum of Old and New Art Mobile: 0425 701 473 mona.net.au The Museum of Old and New Art -- 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] Reference manager adding into LibreOffice writer
Hi, I have a trouble. I am writing my thesis and using LibreOffice writer instead of Office Word. But I am not adding Mendeley or the other reference adding extensions, like Zotero, endnote into LibreOffice. I need it immediately. Can you help me about it? I don't want to enter for each reference by manual. I want to add automatically with an extension, like Mendeley. Thanks in advance. Regards -- *MSc. Şerife ÇAKIR* -- 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
Ho Edwin, started the macro and recognized I havent declared oDoc. Write after all the variables at first line: oDoc = ThisComponent Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- 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
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
--
Homepage: https://www.familiegrosskopf.de/robert
--
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
