Re: [libreoffice-users] 7.1 Writer no longer appears to remember last cursor position
Hi Mark, is there any entry in Tools → Options → LibreOffcie → User Data → First Name / Last Name? The cursor will set to the position the user endet to work with thge document. If there is no user defined it will always be set at the start of the document. 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] Using Base to front-end a spreadsheet. Can you insert a new record/line?
Hi Richard, > Is there a way to use LO Base connected to a spreadsheet to insert a > new row in the spreadsheet via Base? No chance to do this directly. Base will load the Calc table when starting Base. All tables are write protected for Base. You could only change the content in Calc directly. Then you have to refesh the tables (View → Refresh Tables) to see the changed content. 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
[libreoffice-users] Using Base to front-end a spreadsheet. Can you insert a new record/line?
Is there a way to use LO Base connected to a spreadsheet to insert a new row in the spreadsheet via Base? Any tips, directions, howtos, or confirmation that it can or can't be done would be appreciated. -- ~~R -- 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] Basic macro to insert a custom shape into a page ?
Hi Mauricio, I have translated the steps to C++ with createInstance => new and keeping setPropertyValue or using method MergeDefaultAttributes. The custom shape is generated, but the faulty method (for which I have the patch) is not touched. It seems, it is needed, that the custom shape is generated with the mouse. At least I now know, how to generate a custom shape in a Basic macro. :) Kind regards Regina Mauricio Baeza schrieb am 11.02.2021 um 19:26: On Thu, 2021-02-11 at 19:08 +0100, Regina Henschel wrote: Hi all, does someone has a basic macro snippet for to insert a custom shape (e.g. a smiley) into a page? Background: For a unit test I need to insert a custom shape via code similar to as it is done via mouse. But I have no idea how to code it. A macro might give me an initial stage for a solution. Kind regards Regina For Calc, for example: Sub Main Dim size As New com.sun.star.awt.Size Dim args(0) As New com.sun.star.beans.PropertyValue doc = ThisComponent sheet = doc.getCurrentController.getActiveSheet() dp = sheet.getDrawPage() shape = doc.createInstance("com.sun.star.drawing.CustomShape") dp.add(shape) size.Width = 5000 size.Height = 5000 shape.setSize(size) args(0).Name = "Type" args(0).Value = "smiley" shape.setPropertyValue("CustomShapeGeometry", args) End Sub -- 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] Basic macro to insert a custom shape into a page ?
So my guess that you were using the gallery was wrong. On the bright side, I did figure out how to access the gallery :-) It looks like you were provided a solution with using a custom shape, another thing I have not done before! Good Luck! Andrew Pitonyak On Thursday, February 11, 2021 15:53 EST, Regina Henschel wrote: Andrew Pitonyak schrieb am 11.02.2021 um 20:06: > > This might seem obvious, but: > > 1. What document type? Calc > > 2. What is a "custom" shape? Do you mean com.sun.star.drawing.CustomShape Yes > > Not that I have never used Cutom Shapes in any way in LibreOffice, but i have > written a Macro at least once. :-) > > I have written code that adds things such as lines (and other shapes) into > documents. > > I might have looked at something in LO that allows me to have a bunch of > shapes. On my computer, I use > > View > Gallery > > Too open it. From there it looks like I can drag objects out of the "gallery" > and onto a document. That makes a kind of copy I need an object newly created with the mouse. When you click on a shape icon in the toolbar and then click and drag with the mouse to create the shape, then the created custom shape is on a wrong layer. You notice in the "Drawing object properties"-toolbar, that both "To Foreground" and "To Background" are enabled. "To Foreground" should not be enabled, because when you create a custom shape with the mouse, you are working already in the "Foreground". I have a patch for it, but struggle with the unit test. Kind regards Regina -- 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] Basic macro to insert a custom shape into a page ?
Hi Mauricio, Mauricio Baeza schrieb am 11.02.2021 um 19:26: On Thu, 2021-02-11 at 19:08 +0100, Regina Henschel wrote: Hi all, does someone has a basic macro snippet for to insert a custom shape (e.g. a smiley) into a page? Background: For a unit test I need to insert a custom shape via code similar to as it is done via mouse. But I have no idea how to code it. A macro might give me an initial stage for a solution. Kind regards Regina For Calc, for example: Sub Main Dim size As New com.sun.star.awt.Size Dim args(0) As New com.sun.star.beans.PropertyValue doc = ThisComponent sheet = doc.getCurrentController.getActiveSheet() dp = sheet.getDrawPage() shape = doc.createInstance("com.sun.star.drawing.CustomShape") dp.add(shape) size.Width = 5000 size.Height = 5000 shape.setSize(size) args(0).Name = "Type" args(0).Value = "smiley" shape.setPropertyValue("CustomShapeGeometry", args) End Sub Aha! That means, that Size and Type are set after the object is added to the draw page. Unfortunately using this macro, does not show the error, which I'm going to fix. Nevertheless I will test in code, whether creating with a ctor with new ... (which corresponds to createInstance) and then applying the properties will work. But I will need some time for that. Kind regards Regina -- 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] Basic macro to insert a custom shape into a page ?
Andrew Pitonyak schrieb am 11.02.2021 um 20:06: This might seem obvious, but: 1. What document type? Calc 2. What is a "custom" shape? Do you mean com.sun.star.drawing.CustomShape Yes Not that I have never used Cutom Shapes in any way in LibreOffice, but i have written a Macro at least once. :-) I have written code that adds things such as lines (and other shapes) into documents. I might have looked at something in LO that allows me to have a bunch of shapes. On my computer, I use View > Gallery Too open it. From there it looks like I can drag objects out of the "gallery" and onto a document. That makes a kind of copy I need an object newly created with the mouse. When you click on a shape icon in the toolbar and then click and drag with the mouse to create the shape, then the created custom shape is on a wrong layer. You notice in the "Drawing object properties"-toolbar, that both "To Foreground" and "To Background" are enabled. "To Foreground" should not be enabled, because when you create a custom shape with the mouse, you are working already in the "Foreground". I have a patch for it, but struggle with the unit test. Kind regards Regina -- 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] 7.1 Writer no longer appears to remember last cursor position
I upgraded to 7.1 (on Xubuntu 20.04) recently and noticed that it no longer appears to remember the last position I was editing the next time I open the file. I have a list of items I add to daily. With 7.1, when I open it for editing, instead of coming up at the end of the file, as it did up through 7.0, it now goes to a fixed position somewhere in the middle of the file. I changed nothing about the file and I didn't see any options to control this. I have the authorship properties of the file set and they remain unchanged as well. What's up? Thanks. Mark -- 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] Polish diacritical marks
I'm on LO 7.0.4.2 and don't see the issue. Do you have the problem on 7.0 or 7.1? If you see the problem on 7.1, then I'd suggest: reporting the bug as Mike mentioned and possibly try downgrading to 7.0 for the time being to see if that fixes it. If you see the problem on 7.0, then I'd suggest upgrading to 7.1. It's my understanding that 7.0 is end-of-life so I doubt there's much value in reporting a bug for that version. On Thu, Feb 11, 2021 at 5:06 AM wrote: > For example ł is l. > > Under ver. 6 all is correct. > > > *Sent:* Tuesday, February 09, 2021 1:09 AM > *Subject:* Re: [libreoffice-users] Polish diacritical marks > > > > [Sorry I'm new to the list and probably should have included the list on > my reply. I just joined so I don't have access to reply directly to your > email to the list. I just saw it in the mail archive.] > > > > > > What happens when you type those special Polish characters? Which LO > application are you having the problem with? > > > > I can type the following in LO Writer and they appear correctly: > > > > ęóąśłżźćń > > -- 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] Basic macro to insert a custom shape into a page ?
This might seem obvious, but: 1. What document type? 2. What is a "custom" shape? Do you mean com.sun.star.drawing.CustomShape, or do you mean a Custom Shape that you have added to a Library? Not that I have never used Cutom Shapes in any way in LibreOffice, but i have written a Macro at least once. :-) I have written code that adds things such as lines (and other shapes) into documents. I might have looked at something in LO that allows me to have a bunch of shapes. On my computer, I use View > Gallery Too open it. From there it looks like I can drag objects out of the "gallery" and onto a document. I had forgotten you can do that in LO. Is this the type of graphic that you want to insert? Not that I know how, but I am trying to clarify in case it is something that I do know how to do. On Thursday, February 11, 2021 13:08 EST, Regina Henschel wrote: Hi all, does someone has a basic macro snippet for to insert a custom shape (e.g. a smiley) into a page? Background: For a unit test I need to insert a custom shape via code similar to as it is done via mouse. But I have no idea how to code it. A macro might give me an initial stage for a solution. Kind regards Regina -- 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] Basic macro to insert a custom shape into a page ?
On Thu, 2021-02-11 at 19:08 +0100, Regina Henschel wrote: > Hi all, > > does someone has a basic macro snippet for to insert a custom shape > (e.g. a smiley) into a page? > > Background: For a unit test I need to insert a custom shape via code > similar to as it is done via mouse. But I have no idea how to code > it. A > macro might give me an initial stage for a solution. > > Kind regards > Regina > For Calc, for example: Sub Main Dim size As New com.sun.star.awt.Size Dim args(0) As New com.sun.star.beans.PropertyValue doc = ThisComponent sheet = doc.getCurrentController.getActiveSheet() dp = sheet.getDrawPage() shape = doc.createInstance("com.sun.star.drawing.CustomShape") dp.add(shape) size.Width = 5000 size.Height = 5000 shape.setSize(size) args(0).Name = "Type" args(0).Value = "smiley" shape.setPropertyValue("CustomShapeGeometry", args) End Sub -- 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] Basic macro to insert a custom shape into a page ?
Hi all, does someone has a basic macro snippet for to insert a custom shape (e.g. a smiley) into a page? Background: For a unit test I need to insert a custom shape via code similar to as it is done via mouse. But I have no idea how to code it. A macro might give me an initial stage for a solution. Kind regards Regina -- 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