Re: [libreoffice-users] Libre affected by gmail
Have a look at: https://www.labnol.org/internet/gmail-size-search/26669/ Mike On Mon, 15 Apr 2019 at 04:42, charles meyer wrote: > Hi Folks, > > I've Googled this but found little help in reducing my gmail account use. > > For any of the fellow Gmail users on this list... > > I've save my messages which I then read/edit often in Libre Writer. > > I've searched in my Gmail Inbox for messages from a certain sender and then > chosen to delete all messages from the at sender for 1 year. > > It deletes them all but no matter how many senders I do that with I'm still > stuck using 47% of my gmail account. > > Is there any easy way to search for my largest messages (by size) in my > Inbox and/or Sent box so I can delete them to lower my percentage of use in > my Gmail boxes? > > Thanks so much. > > -- > 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] Re: Basic Macro – Copy array of custom type
Den sön 14 apr. 2019 kl 21:53 skrev Johnny Rosenberg : > Hi! > As we know by now, in LibreOffice Basic we can not copy an array directly, > we will only get a new name for the same array. It's like assigning two > array pointers to the same array. The obvious way to copy an array is to do > it element by element in a loop, but there is a workaround. Here's an > example that works: > > > > > > > > > > > > > > > > > > > > > *Option ExplicitSub Test1Dim A(9) As LongDim i As Integer' > Initialise a:For i=0 To 9A(i)=iNext i' Copy A to B: > Dim B(9) As Long: B=AReDim Preserve B(9)' Do some changes to B > without affecting A:B(7)=A(3)B(3)=A(7)* > *' Display the results:* > > > > > > > > *Dim Message As String, Tab As String, NL As String, Spc As String > Tab=Chr(9): NL=Chr(13): Spc=" "Message="i" & Tab & "A(i)" & Tab & > "B(i)" & NLFor i=0 To 9Message=Message & i & Tab & Spc & A(i) & > Tab & Spc & B(i) & NLNext iMsgBox MessageEnd Sub* > > So, the trick in this case is to first assign B to A, then running the > ReDim statement. After that we have two separate arrays. > > However, I want to do this with a custom type, like so: > > > > *Private Type NumberTypeValueAs LongStatus As BooleanEnd > Type* > > > > > > > > > > > > > > > > *Sub Test2Dim A(9) As NumberTypeDim i As Integer'Initialise > a.For i=0 To 9A(i).Value=iA(i).Status=TrueNext > i'Copy A to BDim B(9) As NumberType: B=A ' ”Basic runtime error: > Object required.”ReDim Preserve B(9)End Sub* > > This will throw a runtime error at *B=A* at third line from the end: > ”Basic runtime error: Object required”. What am I missing? How to do this > properly? > > > Kind regards > > Johnny Rosenberg > > OK, to get rid of the error the keyword ”Let” was required. So finally I know what that's for… This code doesn't give me any errors, but the results are not right: *Option Explicit* *Private Type NumberTypeValueAs LongStatus As BooleanEnd Type* *Private Sub Test2RandomizeDim A(9) As NumberTypeDim i As Integer' Initialise a.For i=0 To 9A(i).Value=i A(i).Status=TrueNext i' Copy A to BDim B(9) As New NumberType: Let B=AReDim Preserve B(9)' Do some changes to B without affecting A:B(7).Value=A(3).ValueB(3).Value=A(7).Value B(3).Status=FalseB(7).Status=FalseDim Message As String, Tab As String, NL As String: Tab=Chr(9): NL=Chr(13)Dim Spc1 As String, Spc2 As String: Spc1=" ": Spc2=" "Message="i" & Tab & "A(i)" & Tab & Tab & Tab & "B(i)" & NLFor i=0 To 9Message=Message & i & Tab & Spc2 & _A(i).Value & Spc1 & _A(i).Status & Tab & Tab & Spc2 & _B(i).Value & Spc1 & _ B(i).Status & NLNext iMsgBox MessageEnd Sub* It seems like ReDim Preserve has no effect in this case. A and B are still pointers to the same array, as it seems. Suggestions? Except assigning all the values in loops, because I already know that… 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
[libreoffice-users] Basic Macro – Copy array of custom type
Hi! As we know by now, in LibreOffice Basic we can not copy an array directly, we will only get a new name for the same array. It's like assigning two array pointers to the same array. The obvious way to copy an array is to do it element by element in a loop, but there is a workaround. Here's an example that works: *Option ExplicitSub Test1Dim A(9) As LongDim i As Integer' Initialise a:For i=0 To 9A(i)=iNext i' Copy A to B: Dim B(9) As Long: B=AReDim Preserve B(9)' Do some changes to B without affecting A:B(7)=A(3)B(3)=A(7)* *' Display the results:* *Dim Message As String, Tab As String, NL As String, Spc As String Tab=Chr(9): NL=Chr(13): Spc=" "Message="i" & Tab & "A(i)" & Tab & "B(i)" & NLFor i=0 To 9Message=Message & i & Tab & Spc & A(i) & Tab & Spc & B(i) & NLNext iMsgBox MessageEnd Sub* So, the trick in this case is to first assign B to A, then running the ReDim statement. After that we have two separate arrays. However, I want to do this with a custom type, like so: *Private Type NumberTypeValueAs LongStatus As BooleanEnd Type* *Sub Test2Dim A(9) As NumberTypeDim i As Integer'Initialise a.For i=0 To 9A(i).Value=iA(i).Status=TrueNext i'Copy A to BDim B(9) As NumberType: B=A ' ”Basic runtime error: Object required.”ReDim Preserve B(9)End Sub* This will throw a runtime error at *B=A* at third line from the end: ”Basic runtime error: Object required”. What am I missing? How to do this properly? 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] Libre affected by gmail
Charles, LO did not affect your email. Messages from 1 sender - unless they send you lots of attachments, isnt going to help you. You need to search for messages over a certain size - if that is the route you want to take. That question is for another group overall as it has nothing to do with LO/OO. Just search on whatever search engine - gmail: messages over a certain size. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Sun, Apr 14, 2019 at 1:43 PM charles meyer wrote: > > Hi Folks, > > I've Googled this but found little help in reducing my gmail account use. > > For any of the fellow Gmail users on this list... > > I've save my messages which I then read/edit often in Libre Writer. > > I've searched in my Gmail Inbox for messages from a certain sender and then > chosen to delete all messages from the at sender for 1 year. > > It deletes them all but no matter how many senders I do that with I'm still > stuck using 47% of my gmail account. > > Is there any easy way to search for my largest messages (by size) in my > Inbox and/or Sent box so I can delete them to lower my percentage of use in > my Gmail boxes? > > Thanks so much. > > -- > 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] Libre affected by gmail
Hi Folks, I've Googled this but found little help in reducing my gmail account use. For any of the fellow Gmail users on this list... I've save my messages which I then read/edit often in Libre Writer. I've searched in my Gmail Inbox for messages from a certain sender and then chosen to delete all messages from the at sender for 1 year. It deletes them all but no matter how many senders I do that with I'm still stuck using 47% of my gmail account. Is there any easy way to search for my largest messages (by size) in my Inbox and/or Sent box so I can delete them to lower my percentage of use in my Gmail boxes? Thanks so much. -- 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