[users] Calc Macro Problem
I have used a simple macro linked to a button to enter the current date and time in a cell for several years. It is not working now that I have installed version 3.3.0 on Windows XP, SP3. So I re-recorded the macro. But when I look at the macro, the =now() function is not included. The jump to next cell is all that shows. REM * BASIC * sub DateTime 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 -- dispatcher.executeDispatch(document, .uno:JumpToNextCell, , 0, Array()) end sub I checked macro security and made sure that it is set to medium. Where do I look next? Gene K. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: [Issue 116722] Install does nothing
As I can't add comments to the issue any more I will try users@openoffice.org After installing 3.2 and running with it for a while, I removed the install files. The uninstall needs at least one file of these, which I did not know. Therefore I cannot uninstall 3.2. I also don't know how to clean the registry. Do I have to go back to Microsoft?!?! Regards Bob On 02.02.2011 09:36, o...@openoffice.org wrote: To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116722 User of changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from o...@openoffice.org Wed Feb 2 08:36:11 + 2011 --- This is not a general OOo problem. I have no idea what went wrong on your computer. No one at 'users@openoffice.org' has an idea. Uninstall OOo 3.2. Remove the folder of OOo in c:\Program Files\. Maybe it would help to clean the registry before installing OOo 3.3. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Open Office.Org- 2 programs
I noticed that when I am in a spreadsheet and I want to create a word doc I have to close the spreadsheet. I cant work in 2 separate programs at one time or am I just trying to open the second program incorrectly ?? Please respond asap. Thank you so much, Theresa Nelson
[users] Landscape
How do I put the page in a text document in landscape format, please?Gary
Re: [users] Open Office.Org- 2 programs
On Tue Feb 01 2011 14:26:11 GMT-0800 (PST) Hanna170 wrote: I noticed that when I am in a spreadsheet and I want to create a word doc I have to close the spreadsheet. I cant work in 2 separate programs at one time or am I just trying to open the second program incorrectly ?? Please respond asap. Thank you so much, Theresa Nelson From the File menu you should be able to select New- Text Document and have a new document open in Writer without closing Calc. HTH - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc month and year together?
Den 2011-02-02 03:33:47 skrev . pe...@aleksandrsolzhenitsyn.net: On 02/01/2011 11:26 AM, Michael D. Roush wrote: On 2/1/11 11:13 AM, . wrote: How do I get Calc to put any year (listed in cell A1) and the month (listed in B1) into C1 so that it would look like this; January 2011 Given that you have 2011 in cell A1, and January in cell B1, the correct formula for cell C1 would be: =CONCATENATE(B1; ;A1) This will take the text from B1, put a space after it, and then the text from A1. Result... January 2011. Michael Perfect! Thank you so much. Which is the same thing as: =B1 A1 The character offers a way to ”concatenate” things without using the CONCATENATE function syntax. A matter of taste, I suppose. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Open Office.Org- 2 programs
Den 2011-02-01 23:26:11 skrev Hanna170 theresad...@yahoo.com: I noticed that when I am in a spreadsheet and I want to create a word doc I have to close the spreadsheet. I cant work in 2 separate programs at one time or am I just trying to open the second program incorrectly ?? Please respond asap. Thank you so much, Theresa Nelson I am not sure what you are doing, but I just tested this myself with OpenOffice.org 3.2.0 (for Linux) and there was no problem to open an odt, one odg and two ods at the same time, and I don't think there is an obvious limit involved. Exactly how do you try to create a new document? Please explain in as much detalils as possible. What do you do and exactly what happens? Error messages? Exactly what do they say? What operating system do you use and what version? What version of OpenOffice.org? -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Landscape
On Tue, 2011-02-01 at 12:27 -0800, Gary and Kati Smith wrote: How do I put the page in a text document in landscape format, please? Gary Right click on the page first. Click the Page tab. At the bottom of the Paper format section, click Landscape. This will change the orientation of all the pages from Portrait to Landscape. If you want one or more pages of the document in Portrait orientation and one or more pages of the document in Landscape orientation, you need to learn how to use page styles. If you are going to use Writer (OOo's word processor component) very much, I recommend downloading the Writer Guide. This is available at http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides. Dan
Re: [users] Landscape
The Write Guide suggestion is excellent, however, if you lookup Landscape in OOo help. The steps there will help you create a Page style. If you are not using styles now it will take some learning but well worth the effort. The trick is that first you first need to create a page style with the next style set (maybe to Default) then apply it to the desired page with the Insert Manual break (with the style set to the style you just created). Hope this helps Harold Hauge On Wed, Feb 2, 2011 at 9:41 AM, Dan Lewis elderdanle...@gmail.com wrote: On Tue, 2011-02-01 at 12:27 -0800, Gary and Kati Smith wrote: How do I put the page in a text document in landscape format, please? Gary Right click on the page first. Click the Page tab. At the bottom of the Paper format section, click Landscape. This will change the orientation of all the pages from Portrait to Landscape. If you want one or more pages of the document in Portrait orientation and one or more pages of the document in Landscape orientation, you need to learn how to use page styles. If you are going to use Writer (OOo's word processor component) very much, I recommend downloading the Writer Guide. This is available at http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides. Dan
Re: [users] Open Office.Org- 2 programs
Hanna170 wrote: I noticed that when I am in a spreadsheet and I want to create a word doc I have to close the spreadsheet. I cant work in 2 separate programs at one time or am I just trying to open the second program incorrectly ?? You certainly should be able to work on different types of documents at the same time. I often do so. What is happening that makes you think you can't? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] check if sheet is referenced
Hi, I have to tidy up a very huge spreadsheet. In this spreadsheet I have a lot of cross-sheet references e.g.: =(sheet_2.A3) I want to delete sheet which I don't need anymore. But first I have to check if another sheet needs a cell of the sheet which I want to delete. Thanks for your help Franz - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] [solved] Re: [users] check if sheet is referenced
Am 2011-02-02 23:27, schrieb Franz Waldmüller: Hi, I have to tidy up a very huge spreadsheet. In this spreadsheet I have a lot of cross-sheet references e.g.: =(sheet_2.A3) I want to delete sheet which I don't need anymore. But first I have to check if another sheet needs a cell of the sheet which I want to delete. Use Edit - SearchReplace activate advaced options: Search in Forumlas Search the sheet name which you want to delete. Just solved the issue on my own. Franz - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: [Issue 116722] Install does nothing
On 02/02/11 10:18, Bob McMinn wrote: As I can't add comments to the issue any more I will try users@openoffice.org After installing 3.2 and running with it for a while, I removed the install files. The uninstall needs at least one file of these, which I did not know. Therefore I cannot uninstall 3.2. I also don't know how to clean the registry. Do I have to go back to Microsoft?!?! Regards Bob Hi Bob, there has been a Microsoft tool Windows Installer Cleanup to remove old registry entries: http://support.microsoft.com/kb/290301/ This tool is still available on some ftp servers (ftp://ftp.uni-rostock.de/pub/tools/microsoft/Reskit/NT52/US/msicuu2.exe). Try this tool to remove the OOo entries (and only the OOo entries!) from the registry. Groetjes Olaf http://www.openoffice.org/ http://qa.openoffice.org/ooQAReloaded/FrameworkTeamsite/ooQA-TeamFramework.html -- ORACLE Deutschland B.V. Co. KG Olaf Felka Quality Assurance Engineer Nagelsweg 5520097 Hamburg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org