[libreoffice-users] Locking a single cell in a Calc sheet using a macro
Hi, I am trying to write a macro that will, amongst other things, lock a single cell in a Calc sheet. I can easily test to see if the cell is locked, using CellProtection.IsLocked, but I don't see how to change the value. Any ideas? Graham -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Can words in LibreOffice be auto-italicized?
Hi, menu:FindReplace... Search: whatever button: [Select All] Now you have a multiple selection which can be formatted by a character style (character styles can be assigned to shortcuts) or by hard formatting. -- View this message in context: http://nabble.documentfoundation.org/Can-words-in-LibreOffice-be-auto-italicized-tp3601650p3996384.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Locking a single cell in a Calc sheet using a macro
On 19/07/12 11:19, Graham Luffrum wrote: Hi, I am trying to write a macro that will, amongst other things, lock a single cell in a Calc sheet. I can easily test to see if the cell is locked, using CellProtection.IsLocked, but I don't see how to change the value. Any ideas? Graham Way outside my own skills - but does http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=34393 give insight? (Googling for 'openoffice CellProtection.IsLocked' came up with several likely-looking hits. Although one said it couldn't be done :-{ ) -- Mike Scott Harlow, Essex, England -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Locking a single cell in a Calc sheet using a macro
2012/7/19 Graham Luffrum grhmlf...@gmail.com: Hi, I am trying to write a macro that will, amongst other things, lock a single cell in a Calc sheet. I can easily test to see if the cell is locked, using CellProtection.IsLocked, but I don't see how to change the value. Any ideas? Graham I tried to just set IsLocked to False and True, but I guess you tried that too, because nothing happened: ThisComponent.getSheets().getByIndex(0).getCellByPosition(0,0).cellProtection.IsLocked=False ' Nothing happens I found this thread in a forum, however: http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=34393 They also suggest to manipulate IsLocked, which obviously doesn't work, at least not with LibreOffice Calc 3.5.5. However, they also suggest using two different cell styles, one unlocked and one locked, and apply them with a macro. I didn't test that, but take a look yourself. Still, I wonder why IsLocked didn't work. On the other hand, if it worked, I suppose there would be a method for it, like CellProtection.Lock() or something like that. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] North American DVD 3.5.5 now online on LO's servers/mirrors
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/18/2012 08:04 PM, webmaster-Kracked_P_P wrote: The LibreOffice North American Community DVD Project's 3.5.5-1 DVD is now online at LO's download pages. [..] Most excellent news! I am going to Haïti for an IT project that includes some LibreOffice training. I will be burning a few DVDs and bring the ISO image with me :) Many thanks for your contributions! Cheers, Fabian Rodriguez http://libreoffice.magicfab.ca -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: PGP/Mime available upon request Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlAH+58ACgkQfUcTXFrypNX4LACg6GCZfbgK67jqqP7n2lKXyYMX 8wAAoM5l9ax4yrIwcD9bybY+Ei4VXtr1 =VRT9 -END PGP SIGNATURE- -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Macro code to highlight a field on a Form
Hi Tom, I'm back on deck again now. Thanks for this URL - I've bookmarked it for future reference. Noel -- Noel Lodge lodg...@gmail.com On 8 July 2012 06:06, Tom tomdavie...@yahoo.co.uk wrote: Hi :) There is an excellent guide on writing Macros https://wiki.documentfoundation.org/Documentation/Publications#Programmers but getting personalised advice from an experienced expert such as Andreas is even better. Still it can be useful to have a guide too. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Macro-code-to-highlight-a-field-on-a-Form-tp3993100p3994218.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Can words in LibreOffice be auto-italicized?
Lluís de Yzaguirre wrote Thanks, but could you teach a macro to do so? Of course. Go ahead and write your macro if you are a programmer. But what is it good for? Save 3 keystrokes per day or 30? Forget it. -- View this message in context: http://nabble.documentfoundation.org/Can-words-in-LibreOffice-be-auto-italicized-tp3601650p3996440.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Function in OSX with Calc 3.5.5
Just installed 3.5.5 and now my functions just show ### as results. The functions are basic like min, max and sum. Any ideas why ? -- View this message in context: http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Function in OSX with Calc 3.5.5
On 07/19/2012 11:55 AM, digisan wrote: Just installed 3.5.5 and now my functions just show ### as results. The functions are basic like min, max and sum. Any ideas why ? -- View this message in context: http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446.html Sent from the Users mailing list archive at Nabble.com. The cells are probably not wide enough to display the data as formatted. Try either widening the cells or changing the display format for the cells. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Function in OSX with Calc 3.5.5
That was my first thought. I tried widening the cells - drastically as well as different formatting options. I have it set for only 3 decimal places. -- View this message in context: http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996453.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base fread-only
On Wed, Jul 18, 2012, at 01:06 PM, Andreas Säger wrote: [Tutorial] Read-Only in Base: http://user.services.openoffice.org/en/forum/viewtopic.php?f=83t=26448 -- To quote the tutorial: 0. All input forms in Base indicate read-only in the title bar, but this does not matter at all And I wasn't even using an input form! -- Larry Blanchard lbla...@fastmail.fm -- http://www.fastmail.fm - IMAP accessible web-mail -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Base fread-only
On Wed, Jul 18, 2012, at 01:32 PM, Andrew Brager wrote: On 7/18/2012 1:05 PM, Jay Lozier wrote: It sounds like the file ownership got messed up. Depending on how comfortable you are with using the terminal I would use the following to change the ownership chown username path-to-file/file.ext For example the file is in your db sub folder of your Documents folder the path is /home/username/Documents/db. The username is your log on name for Ubuntu. May or may not be ownership. The above can't hurt, however if it's purely a permission problem then you probably want to do chmod 644 path-to-file/file.ext depending on your preferences. C'mon guys, I *said* I'd checked permissions. That should have given you a clue. But just to make it clear, I was a programmer for over 45 years. Much of that was at the system level on Unix. And if you'd read my query a little more carefully, you'd see that I'd referenced two different databases with the same permissions, one of which worked and one of which didn't. So far, I've gotten 3 responses, none of which were useful. Don't any of the LO gurus frequent this list? If not, I might as well unsubscribe. -- Larry Blanchard lbla...@fastmail.fm -- http://www.fastmail.fm - Does exactly what it says on the tin -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base fread-only
On Wed, Jul 18, 2012, at 01:06 PM, Andreas Säger wrote: [Tutorial] Read-Only in Base: http://user.services.openoffice.org/en/forum/viewtopic.php?f=83t=26448 Andreas, I owe you an apology. I was irritated by the replies on permissions and failed to read far enough in the tutorial. The pertinent line is, as I'm sure you knew: Primary keys provide unique pointers to each single row of a table (some ID number). A primary key makes tables editable for Base. Sure enough, no key. Mea culpa, mea culpa, ... -- Larry Blanchard lbla...@fastmail.fm -- http://www.fastmail.fm - IMAP accessible web-mail -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Function in OSX with Calc 3.5.5
digisan wrote: Just installed 3.5.5 and now my functions just show ### as results. The functions are basic like min, max and sum. Any ideas why ? -- View this message in context: http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446.html Sent from the Users mailing list archive at Nabble.com. Can you create a Calc document that has this problem without showing privileged information? If you can, please do so and upload it to Nabble so someone could download it to see what the problem is. --Dan -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Function in OSX with Calc 3.5.5
Here is a sample of what I'm dealing with. Thanks for the suggestion Dan. http://nabble.documentfoundation.org/file/n3996484/UploadTroubleShooting.ods UploadTroubleShooting.ods -- View this message in context: http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996484.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Function in OSX with Calc 3.5.5
On 2012-07-20 06:01, digisan wrote: Here is a sample of what I'm dealing with. Thanks for the suggestion Dan. http://nabble.documentfoundation.org/file/n3996484/UploadTroubleShooting.ods UploadTroubleShooting.ods -- View this message in context: http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996484.html Sent from the Users mailing list archive at Nabble.com. Hi. Opens and looks fine on 3.4 here, do you have a screen shot to show what you see (Grab on mac Osx). Steve -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Function in OSX with Calc 3.5.5
Steve, I was using 3.4 and installed 3.5.5. Here is a portion of the screen shot. Does anyone know where to download 3.4, it looks like it is no longer available on the website. http://nabble.documentfoundation.org/file/n3996499/Screen_Shot_2012-07-19_at_12.36.57_PM.png -- View this message in context: http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996499.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Function in OSX with Calc 3.5.5
Steve Edmonds wrote: On 2012-07-20 06:01, digisan wrote: Here is a sample of what I'm dealing with. Thanks for the suggestion Dan. http://nabble.documentfoundation.org/file/n3996484/UploadTroubleShooting.ods UploadTroubleShooting.ods -- View this message in context: http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996484.html Sent from the Users mailing list archive at Nabble.com. Hi. Opens and looks fine on 3.4 here, do you have a screen shot to show what you see (Grab on mac Osx). Steve I used 3.4.6 and 3.5.5 to open the calc document with no ### showing in any cells. The only way I could produce any ### in a cell was to reduce the width of column and then only in the second sheet and the columns containing functions. If you are getting ### on a Mac, it could be a bug in the Mac version, but I have no way to test this. --Dan -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] unsubscribe
please nsubscribe -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Function in OSX with Calc 3.5.5
Just got my mac from the car, in 3.5.4.2 it is showing fine. Is your font Arial (shows that here). Steve On 20/07/12 7:39 AM, digisan wrote: Steve, I was using 3.4 and installed 3.5.5. Here is a portion of the screen shot. Does anyone know where to download 3.4, it looks like it is no longer available on the website. http://nabble.documentfoundation.org/file/n3996499/Screen_Shot_2012-07-19_at_12.36.57_PM.png -- View this message in context: http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996499.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Function in OSX with Calc 3.5.5
digisan schrieb: Steve, I was using 3.4 and installed 3.5.5. Here is a portion of the screen shot. Does anyone know where to download 3.4, it looks like it is no longer available on the website. http://nabble.documentfoundation.org/file/n3996499/Screen_Shot_2012-07-19_at_12.36.57_PM.png You have turned on Value highlighting, isn't it? So I guess that the blue values are numbers and the are formulas. Please have a look at Tools Options Calc View Section 'Display'. If there is a check for 'Formulas', remove it. Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] unsubscribe
Hi :) This guide migth help you unsubscribe http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Good luck and regards from Tom :) --- On Thu, 19/7/12, Naipaul Ojar naipaul.o...@gmail.com wrote: From: Naipaul Ojar naipaul.o...@gmail.com Subject: [libreoffice-users] unsubscribe To: users@global.libreoffice.org Date: Thursday, 19 July, 2012, 21:31 please nsubscribe -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)
Just can't figure it out. I have a column of 2000 formulas and values. Right now, A1:A1620 contains values, and A1621:A2000 contains formulas. The formulas in A1621:A2000, at the moment, return empty strings, all of them, so it looks like only the 1620 first rows contains data. So the formulas looks something like =IF(this and that;;something else) (but a bit more complicated). The point is that if I input something on a ”new” row in one of the other columns, the A column shall, in some cases, display something. Okay, that's what the spreadsheet looks like, roughly. Now I use a couple of macros to do things for me a lot faster than I could ever do myself. One small part of a new macro I'm trying to write needs to search for the first ”empty” row, which means the first row where the A column contains a formula that returns an empty string. Here's what I tried: Function FindCurrentRow(Sheet As Object) As Integer Dim SearchDescriptor As Object SearchDescriptor=Sheet.createSearchDescriptor() With SearchDescriptor .SearchByRow=False ' I want to search by column, starting at A. .SearchRegularExpression=False .SearchString= .SearchType=1 ' 0=Search in formulae, 1=Search values. End With Dim Found As Object Found=Sheet.findFirst(SearchDescriptor) FindCurrentRow=Found.getCellAddress().Row End Function In this example I expect the function to return 1620 (which is the row address for the cell A1621). Instead 2000 is returned, so for some reason, when my cell formula returns , that doesn't seem to be the same as .SearchString=. I also tried different values of .SearchValue, still with the same result: 2000 instead of 1620. So it only finds the first cell in the A column that is REALLY empty – no formula, no value. To me this seems like a bug, but for someone else, hopefully, it might seem like I'm just stupid, so feel free to call me stupid and, more important, tell me what I'm doing wrong and how I should do instead… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Function in OSX with Calc 3.5.5
That's it. I had Formulas checked. In 3.5.5.3 on the Mac it is under preferences. Thanks so much to all for the help. -- View this message in context: http://nabble.documentfoundation.org/Function-in-OSX-with-Calc-3-5-5-tp3996446p3996518.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Date format macro.
I'd like to create a macro for a user-defined date format (H:MMa/p). As examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p. I can create the format manually, but I understand the LibreOffice format can't save user-defined formats. So my thought is to create a macro which creates the format each time the spreadsheet is opened. The user-defined Format Code is for a saved Style. The macro records without incident and the date format is correct. However, running the saved macro doesn't change the format. It seems this should work. Thoughts? The recorded macro is as follows: sub FormatTime rem -- rem define variables dim document as object dim dispatcher as object rem -- rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService(com.sun.star.frame.DispatchHelper) rem -- dim args1(0) as new com.sun.star.beans.PropertyValue args1(0).Name = ToPoint args1(0).Value = $D$13 dispatcher.executeDispatch(document, .uno:GoToCell, , 0, args1()) rem -- dim args2(0) as new com.sun.star.beans.PropertyValue args2(0).Name = DesignerDialog args2(0).Value = true dispatcher.executeDispatch(document, .uno:DesignerDialog, , 0, args2()) rem -- rem dispatcher.executeDispatch(document, .uno:EditStyle, , 0, Array()) rem -- dim args4(0) as new com.sun.star.beans.PropertyValue args4(0).Name = DesignerDialog args4(0).Value = false dispatcher.executeDispatch(document, .uno:DesignerDialog, , 0, args4()) end sub -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] [List Threading] was: Re: Correct Syntax to address a table or form field in Base's Basic
On 19/07/2012 at 07:02, NoOp gl...@sbcglobal.net wrote: IMO, reading/replying to a high volume mailing list via email IYO, what is wrong with reading/replying to a high volume mailing list via e-mail? I must have missed something in past year or so. -- Best regards Mirosław Zalewski -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: 3.4
I have the original, complete version still on my machine - if there's some way to get it to you, I'd be happy to so do. [just need to know how where to upload it] On Thu, Jul 19, 2012 at 2:39 PM, digisan digi...@sbcglobal.net wrote: Steve, I was using 3.4 and installed 3.5.5. Here is a portion of the screen shot. Does anyone know where to download 3.4, it looks like it is no longer available on the website. http://nabble.documentfoundation.org/file/n3996499/Screen_Shot_2012-07-19_at_12.36.57_PM.png -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: [List Threading] was: Re: Correct Syntax to address a table or form field in Base's Basic
On 07/19/2012 03:33 PM, Mirosław Zalewski wrote: On 19/07/2012 at 07:02, NoOp gl...@sbcglobal.net wrote: IMO, reading/replying to a high volume mailing list via email IYO, what is wrong with reading/replying to a high volume mailing list via e-mail? I must have missed something in past year or so. It's a waste of resources - network and diskspace. If the email client doesn't have an option to read only subject headers first, then the email(s) must be downloaded via the user's email client (or web client) before the subscriber can view the message. With nttp services like gmane.org, the subscriber can view all of the archived threads (well, most all - I see back to Harold Fuchs 10/09/2010 msg: OT:Get Gmane User Going. All of the messages are shown threaded (my option). You only view a message when you click on the message subject, same for responding. Once I've viewed/responded to a message (to view or or respond), I can elect to have those messages saved on my hard drive for offline viewing. To each their own. But to me, as I subscribe to over 50 mail lists across 6 different nntp (and usenet servers), and am active 8-10 per day, and nothing but the subject headers gets downloaded unless I click on the message. nntp is the only way to go (IMO). Imagine trying to do the same on a dialup and/or metered service. I have the advantage of the mail list email subscriber in that I can: - view and compose a response off line, - archive sent/received msgs directly - search the same sent/received msgs for content, author etc. - I can view sort search my lists threaded, by subject, by date, by sender, by recipient, etc. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: 3.4
There is an archive of LO's installs. But if you tell me what OS you have, I should be able to find it. On 07/19/2012 08:32 PM, anne-ology wrote: I have the original, complete version still on my machine - if there's some way to get it to you, I'd be happy to so do. [just need to know how where to upload it] On Thu, Jul 19, 2012 at 2:39 PM, digisan digi...@sbcglobal.net wrote: Steve, I was using 3.4 and installed 3.5.5. Here is a portion of the screen shot. Does anyone know where to download 3.4, it looks like it is no longer available on the website. http://nabble.documentfoundation.org/file/n3996499/Screen_Shot_2012-07-19_at_12.36.57_PM.png -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Workaround for the Java 1.7.x compatibility problem
Dear all, There is a workaround for the Java 1.7.x compatibility problem on the Windows platform mentioned in earlier discussion. Please refer to Bugzilla https://bugs.freedesktop.org/show_bug.cgi?id=50371 to install MSVC2010 redistributable from http://www.microsoft.com/en-us/download/details.aspx?id=8328 . Thank you and Regards, Michael -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted