[users] Calc restore failure
Hello: My install of OO (3.3.0, build 9567), when initiated without the command line option -norestore, says that it wants to restore a small CSV file that ALWAYS exists on my system. If I click OK, it aborts after throwing an instance of 'com::sun::star::uno::RuntimeException'. A long dump of registers follows. Does anyone know what file I have to delete or tweak to eliminate this annoying problem? Dean -- Dean Provins, P. Geoph. dprov...@alumni.ucalgary.ca http://www.telusplanet.net/~provinsd KeyID at at pgpkeys.mit.edu:11371: 0x9643AE65 Fingerprint: 9B79 75FB 5C2B 22D0 6C8C 5A87 D579 9BE5 9643 AE65 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Calc: Sort double columns
I am reviewing the records of a local shop to help him convert to Open Office. I have found no problems with the simple Word documents that he uses, but he is using MS Excel where he should have a real database. We all know about efforts to teach an old dog new tricks, so let's just be glad that he is interested in this new trick called Open Office. He will _not_ be moving to Base or anything else, it will be either in Excel or another spreadsheet. In this particular case, he has information that should be in a single row (record) divided into to rows, with the A column's cells merged between the two and the sorting key stored in that cell. He now wants to sort based on the merged cells, keeping the dual-row records intact. Example: --- 1 | Some info | More info --- 3 | Yet some more info | And more info --- 2 | Some important info | More important info --- He now needs to sort that! Does anybody know how this can be done? Trying the regular sort function returns an error that range containing merged cells can only be sorted without formats. Example document here: http://dotancohen.com/images/examples/sort-example.ods Thanks. -- Dotan Cohen http://gibberish.co.il http://what-is-what.com -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Calc. Checking a cell against a column and if it is not alady there adding the data to the column
I checked the archive and I could not find anything like this. I want to take data from one sheet from a series of cells that will be changing but might repeat themselves and take that data and check it against the data in a column on another sheet and if the data is already listed there do nothing but if the data is not listed in the column cell range that I will define then add the data to the first open spot in that cell. I also want it to take the cell that has been added and grab the corresponding data from the other cells in that row and fill those in also. Example. Sheet 1 cell A4 to A13 also A15 to A27 (which the data in the cells will repeat themselves occasionally) Check against Sheet 2 Cells A4 to A15 If the Data that is being checked is not already somewhere in the A4 to A15 range then add the data to the first open cell in the A4 to A15 range. Also when adding the data add the corresponding data from the row that the data came from and add that to the same row that the data from the check is being added to. Example Sheet 1 cell A8. Check against the Range of A4 to A15 on sheet 2. It does not find the same data listed there yet so it adds the Data from Sheet 1 A8 to Sheet 2 A7. Then grab the data listed in Cells B8, C8, and D8 and put it into cells B7, C7, and D7 on Sheet 2. If it makes a difference the data in the cell range on sheet one is added by selecting a unique ID that is Validated from another sheet and that selection is what fills in the data for columns B,C, and D. I have attached the Calc file I am working on. It is in the end for tracking what type of service calls I am on each day and fill in my time sheet so I can print it out on fridays. Thanks for the help. Cory -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help Test.ods Description: application/vnd.oasis.opendocument.spreadsheet
[users] CALC
Can someone please help me? I open CALC and there is a large window offering a selection of themes, backgrounds, etc. How do I make this window go away? Many thanks, Irv. -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Calc fails inexplicably
Hello: Calc now offers VERY LARGE numbers of rows and columns. On the surface this seems great, but I have recently encountered problems updating a spreadsheet which uses just IT columns and 1055 rows on the main sheet, and about 9 subordinate sheets, mostly with just a few cells filled. One sheet has graphs based on the contents of the main sheet (and it can be a little slow to update). The specific problem was that Calc simply aborted without warning when I did an Edit-Fill-Down on several dozen columns. The version is 3.3.0, M20, build 9567. Another issue is that adding a reference takes forever - not just a long time as the maintainers suggested. One last issue is that OO when initiated without the command line option -norestore, it says that it wants to restore a small CSV file that always exists on my system. If I click OK, it aborts, again without warning. Anyone else had similar problems? Are these bugs that need to be reported? Dean -- Dean Provins, P. Geoph. dprov...@alumni.ucalgary.ca KeyID at at pgpkeys.mit.edu:11371: 0x9643AE65 Fingerprint: 9B79 75FB 5C2B 22D0 6C8C 5A87 D579 9BE5 9643 AE65 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] calc collaboration feature
Hi, I have got a question concerning your experiences with the collaboration feature of openoffice.org calc. Does this feature work well? Are there any problems likely to occur? I am aware of the limitations mentioned in: http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Sharing_documents_among_reviewers Background of the question: At work a group of four needs to collect comments on various documents in one single spreadsheet. I know that this is not an ideal solution but at the moment we are working with Microsoft Excel 2003 which has a rather limited collaboration function. At the moment no collaboration function is used at all. We have to close the document if anybody wants to edit it. I would like to use openoffice.org portable to work on a ods-file. When we have finished we can conert it to xls. We don't need special features and the conversion works. I am just interested if there are any problems which might occur. All four clients are working with Windows XP, collaboration document would be located on a network share to which all involed team members have read and write access. Thanks for your advice Franz -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Calc: Restart Page Numbering On Each Sheet
OOo 3.2.1 (I know, I know; but as far as I'm concerned it ain't broke so ...) on Vista Home Premium. How do I get Calc to restart its page numbering at the start of each new sheet? Also, I'd like each sheet to have its pages numbered in the form Page n of m where m is the number of pages *for this sheet* and *not* for the entire document. Is this possible? How, please? -- Harold Fuchs London, England Please reply *only* to users@openoffice.org -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Calc to Excel converters?
I'm running Windows XP with Oo 3.3 Can anyone tell me where I can get a converter to change a Calc ODS as an XLS file for Excel 2003 or 2007? In Ubuntu 10.04 the Oo I have will convert to 2003 xls. With 3.3 the only option is to save the ODS as an Excel 2000 XLS. -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Calc: Calculating Time Totals for a Time Card
Hello, I have a Calc spreadsheet I use to keep track of time, kind of a time card. I use the 24 Hrs. format. I have a Sheet for each client for the current month (so it would include 31 rows maximum, not including the first one used for the headers): Column A has the Start Time (i.e.: 09:15) Column B has the End Time (i.e.: 13:25) Now, I want Column C to have the total time for each row, and another cell to have the total time spent for this client that month (say, H3) I guess I'd have to sum the total for C2:C32, but I can't figure out how to calculate it as time and what to put as a formula in H3. Thanks! Amichai. -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Calc- reference a bunch cells into 1 cell?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 My spreadsheet has a tiny monthly calendar on it that has 1 cell for each day. So, it has 7 columns across and 8 rows down. When you select the cells it has a range like this- A1:G8 I want to put the contents of cells A1 to G8 into 1 cell on different sheet in the same file. It can be done by; - - Selecting and Copying A1:G8 - - Pasting it into Writer (at this point it appears like a graphic that you can rescale) - - Copying it from Writer and pasting it into the single cell using Paste Special- GDI metafile That works well but there's got to be an easier way. Any ideas? -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJNXt0NAAoJEF4giPX/zzyYjU4IAKxnXkhSDKOngw9AwQ3fQKUo Iv6COVKeUWMCr2IszhdyXxk+AGkwyKKiJxWl9WjPlI6BBQtkImifKvW/ltL0Gk+p aL3oVcTzq/IyY3REZB8r5YJNYV18X+Qbylz4BOR+2b2g3UfvDwP2P08Euv+5/4qk /JQkTP90BrefVH8ttWUIqrjtVj4YmNzJAp+GMMyrPnfwO+moeTdG1p6NRddtyyLj NU4fk4JpLLfKXkzmz9QiUBk626QEBXny+g0kwUkkXU4mEBASkZqWzbUH1muq3yFR U2t+sh6dLE0HGCkgO9pRISzLvyvXN5sceIIxeZ4sfyZx+jtVqcryGB8D01d78Ts= =hxA7 -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc- reference a bunch cells into 1 cell?
Den 2011-02-18 21:56:45 skrev . pe...@aleksandrsolzhenitsyn.net: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 My spreadsheet has a tiny monthly calendar on it that has 1 cell for each day. So, it has 7 columns across and 8 rows down. When you select the cells it has a range like this- A1:G8 I want to put the contents of cells A1 to G8 into 1 cell on different sheet in the same file. It can be done by; - - Selecting and Copying A1:G8 - - Pasting it into Writer (at this point it appears like a graphic that you can rescale) - - Copying it from Writer and pasting it into the single cell using Paste Special- GDI metafile That works well but there's got to be an easier way. Any ideas? I am just curios; why would you want to do something like that? I would guess (and yes, it's only a guess, nothing more) that nobody ever wanted to do that before, so there is no special feature for it. Again, only a guess… One possible solution would be to write a macro for it. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc- remove Trace Dependents
On 2/4/2011 2:05 PM, . wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I hit Shift- F5 so I can Trace Dependents. How do I remove the Trace Dependent lines as they're all over my sheet? -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJNTFwPAAoJEF4giPX/zzyYfOMH/i+/b5ayfbPlFtU05TWK2ANI itaM+5fBc+WmeaRPNWvGX6GaZARAtdpsuemNY8pHE83bgyOqGAGbQZ51SQ6wzcBu PpB9kDvxoK9Qenkn8v9hBy+3PJVbnzvA8JbaQi7N4Mrf7z1H6mRHxfC1FLpaLvLc SopHWdI0Hb11R6D7PXxAvhr6PWCvmGv95b+XrbbQLNBs4GL/GjMI72CbYXm8uPlZ pFOwegQLwGWEjAbauBLUdq1XdFIJfMTmRM/H0LR2nkipVQAGggW046PNJrqEu2+p AAn1g/sqZ0l8wCq4hLPUYAdV4tm+0us7hDcI+hG/jpkZgT2kk/nfEv98nz5HTIs= =8R3P -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Tools Detective Remove All Traces Or from the keyboard: Alt+T Alt++D Alt+A - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc- remove Trace Dependents
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I hit Shift- F5 so I can Trace Dependents. How do I remove the Trace Dependent lines as they're all over my sheet? -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJNTFwPAAoJEF4giPX/zzyYfOMH/i+/b5ayfbPlFtU05TWK2ANI itaM+5fBc+WmeaRPNWvGX6GaZARAtdpsuemNY8pHE83bgyOqGAGbQZ51SQ6wzcBu PpB9kDvxoK9Qenkn8v9hBy+3PJVbnzvA8JbaQi7N4Mrf7z1H6mRHxfC1FLpaLvLc SopHWdI0Hb11R6D7PXxAvhr6PWCvmGv95b+XrbbQLNBs4GL/GjMI72CbYXm8uPlZ pFOwegQLwGWEjAbauBLUdq1XdFIJfMTmRM/H0LR2nkipVQAGggW046PNJrqEu2+p AAn1g/sqZ0l8wCq4hLPUYAdV4tm+0us7hDcI+hG/jpkZgT2kk/nfEv98nz5HTIs= =8R3P -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc- remove Trace Dependents
Thank you On 02/04/2011 03:55 PM, openoffice.mbou...@spamgourmet.com wrote: . - pe...@aleksandrsolzhenitsyn.net wrote: I hit Shift- F5 so I can Trace Dependents. How do I remove the Trace Dependent lines as they're all over my sheet? Tools Detective Remove All Traces There is no shortcut set for this by default on my install (3.2.0 on Windows Vista), but if you use it a lot you can define one of your choice under Tools Customise Keyboard. Remove All Traces is in the Options category there. Hope that helps. Mark. signature.asc Description: OpenPGP digital signature
[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
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
[users] Calc unSync screen split?
Does Calc have an unsync option for window splits? Even though you can split the window vertically the scrolling is simultaneous between the split window. signature.asc Description: OpenPGP digital signature
Re: [users] Calc unSync screen split?
On 01/02/11 13:34, . wrote: Does Calc have an unsync option for window splits? Even though you can split the window vertically the scrolling is simultaneous between the split window. Don't forget the screen splits horizontally too. And both at once, for those with a clear head :-) -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc unSync screen split?
All I want to know is how to unsync them. On 02/01/2011 08:38 AM, Mike Scott wrote: On 01/02/11 13:34, . wrote: Does Calc have an unsync option for window splits? Even though you can split the window vertically the scrolling is simultaneous between the split window. Don't forget the screen splits horizontally too. And both at once, for those with a clear head :-) signature.asc Description: OpenPGP digital signature
Re: [users] Calc unSync screen split?
Hi, 2011/2/1 . pe...@aleksandrsolzhenitsyn.net: All I want to know is how to unsync them. I don't think that this is possible. This kind of defeats the purpose of this feature. You can split the window of a large table. The intention behind this feature is, that you always see the row/column names, so that you know, at which number you're looking at the moment. (Helps you navigate and organise your data. Might also help you to not delete something by accident.) Having those rows/columns unsynced would deny the the wanted functionality. Sigrid - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc month and year together?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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 Please don't reply unless you know exactly how to do it. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJNSDEWAAoJEF4giPX/zzyYqusH/ilpuKCmeSg/KrT84b7tt9F7 BnpBCMYVjz2PIfseGT4kfhi5Q7dwkURh33ZPF3ByaK03LWodxzD5nrW3b4+fn5AZ j3SppcusW4ptH96w8Doi8Cs/OGGNcCM7kvNyzdkEIvY5FA9XYzuPxFchWQSmkp6H mBa0vjFisTE0bhq1oDD5jbHGBOmJUrBxDCCRYT7Zb3saAAA9Jb0+lf3pq3vHqe67 s7ayEglZY3tJrrAShxj4mhXlBcVlwtFwOBY6VgCpKDoanog4jF4OgS8aJgDyFxi6 6i31pjROljaqwE+MspTsmqvzcsrRGiWD1paZgon5fzmX+T9RM4J43P6BmsbU4Lc= =SaGK -END PGP SIGNATURE- - 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-01 17:13:10 skrev . pe...@aleksandrsolzhenitsyn.net: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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 Please don't reply unless you know exactly how to do it. In A1, you have, for example, 2011 and in B1 the text ”January”, is that the starting point of this problem? If so, type this into C1: =B1 A1 Is B1 rather a number, like 1 for January or 9 for September? Then do the following: In C1, enter the following: =DATE(A1,B1,1) Right click C1 → Format cells… → Numbers → Enter the following into the Format description field: Click OK. I have Swedish OpenOffice.org, so things might be named differently than the above description, so you probably need to use your imagination a bit, perhaps… -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc month and year together?
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. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org signature.asc Description: OpenPGP digital signature
Re: [users] Calc IF function?
On 1/26/2011 9:27 AM, Sigrid Carrera wrote: Hi, 2011/1/26 .pe...@aleksandrsolzhenitsyn.net I figured it out. Due to very poor explanation at this link- http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_IF_function the author fails to mention one important part; the necessity of putting the = sign before the function. On 01/26/2011 10:04 AM, . wrote: [...] You didn't read my post. Which post? I got an empty email from you. The only text that was contained in your mail was the subject line. So no, there was nothing to read from you. If you had it in an attachment, afaik attachments aren't allowed to the maillist. Sigrid Ditto here; the original email contained nothing in the body, and in the atttachment section it showed a file attachment signature.asc I avoid opening attachments without a clue as to what it's about. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc IF function?
signature.asc Description: OpenPGP digital signature
Re: [users] Calc IF function?
yes, calc has one. 2011/1/26 . pe...@aleksandrsolzhenitsyn.net If you need more information, you should describe, where you have problems. I don't have a glass sphere that can tell me, what everyone needs to know. Sigrid PS: Please reply to the list only.
Re: [users] Calc - printing rows on every page
Den 2011-01-09 02:11:52 skrev Brewster Gillett b...@fdi.us: On Sun, 2011-01-09 at 01:45 +0100, Johnny Rosenberg wrote: I ran into a few other bad bugs with the Ubuntu-version of OpenOffice.org and finally I just couldn't stand it any more, so I kicked it out and installed the ”real” OpenOffice.org. Worked like a charm since then. I don't know if that would help in this very case, but I would certainly try. brewster: I guess that is a distinction of which I was not aware. Are you saying that Ubuntu is shipping a slightly different version from that which is available directly from OOo? That I should download the latest version directly from OOo and install it over the Ubuntu version? I am definitely not inclined to use RCs or betas. Just out of curiosity, is there a detectable rationale for Ubuntu's provision of a buggier version of OOo than Open Office itself ships? Brewster Well, the Ubuntu version is actually Go-oo (as far as I know) rather than OpenOffice.org. So is the case with other well known GNU/Linux-distributions as well, for example OpenSUSE and more. Go-oo has some advantages over OpenOffice.org, so maybe it's better for some users in some cases. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc - printing rows on every page
I have explicitly followed the OOHelp instructions - FORMAT-PRINT RANGES-EDIT, done the instructed highlighting for the top two rows that I seek to have printed on every page, and have gotten the echo that is displayed on the help screen - $1:$2. But when I go to exit, I get a tiny popup that informs me: invalid sheet reference In searching the list of error messages for Calc, I find no specific mention of invalid sheet reference. I went back and attempted various combinations of A1 and A2, and kept getting the same message. What am I missing, here? Thanks, Brewster -- *** Embrace a sharing community of sustainable justice low-carbon diversity *** W. Brewster Gillett b...@fdi.usPortland, OR USA *** Simply because you don't like to hear it, that doesn't make it untrue. *** - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc - double-spacing in printing
I have scoured the OOHelp files for an answer and cannot come up with one. Is it even possible to print out a Calc spreadsheet in double-space? Thanks, Brewster -- *** Embrace a sharing community of sustainable justice low-carbon diversity *** W. Brewster Gillett b...@fdi.usPortland, OR USA *** Simply because you don't like to hear it, that doesn't make it untrue. *** - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - printing rows on every page
At 13:12 08/01/2011 -0800, Brewster Gillett wrote: I have explicitly followed the OOHelp instructions - FORMAT-PRINT RANGES-EDIT, done the instructed highlighting for the top two rows that I seek to have printed on every page, and have gotten the echo that is displayed on the help screen - $1:$2. But when I go to exit, I get a tiny popup that informs me: invalid sheet reference In searching the list of error messages for Calc, I find no specific mention of invalid sheet reference. I went back and attempted various combinations of A1 and A2, and kept getting the same message. What am I missing, here? Are you using OpenOffice version 3.1 as provided by/with Ubuntu? This appears to have been a bug in that version. See https://bugs.launchpad.net/openoffice-pkgs/+bug/374708 . I cannot reproduce your experience in my version 3.1.1 under Windows XP. What are you missing? Possibly the original version of OpenOffice. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - double-spacing in printing
On 1/8/2011 4:14 PM, Brewster Gillett wrote: I have scoured the OOHelp files for an answer and cannot come up with one. Is it even possible to print out a Calc spreadsheet in double-space? Thanks, Brewster Increase the row height of all rows to double what it is currently. The effect will be double line spacing. -- Gene Young n2kvs - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - double-spacing in printing
At 13:14 08/01/2011 -0800, Brewster Gillett wrote: I have scoured the OOHelp files for an answer and cannot come up with one. Is it even possible to print out a Calc spreadsheet in double-space? First, it's not generally helpful to think of doing anything double-space. This is typewriter thinking, where the hardware allows you to print lines only at well-regulated intervals. Computer printers are more flexible than that, and it is better to think of output from a word processor or spreadsheet as having additional spacing between lines or paragraphs or whatever. But no: I think you are right that there is no immediately obvious way to increase the spacing between rows of values. That probably makes sense, since if you are printing a grid you are unlikely to want space between neighbouring rows of the grid. There are many ways, though, of achieving what you probably want: 1. Put your spreadsheet values in alternate rows. 2. Increase the row height without changing the text size: o Go to Format | Row | Height... (or right-click in the row headers | Row Height...) and increase the value there. o You may then wish to move the values to somewhere other than the (default) bottom of the cells (e.g. Middle), at Format | Cells... | Alignment | Text alignment | Vertical (or right-click | Format Cells... | Alignment | Text alignment | Vertical). 3. Increase the spacing above or below (or both) the text in your cells: o Go to Format | Cells... | Borders | Spacing to contents (or right-click | Format Cells... | Borders | Spacing to contents). o Untick Synchronize. o Increase the values for Top or Bottom (or both). I suggest technique no. 3 is probably the most flexible. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - printing rows on every page
At 13:12 08/01/2011 -0800, Brewster Gillett wrote: I have explicitly followed the OOHelp instructions - FORMAT-PRINT RANGES-EDIT, done the instructed highlighting for the top two rows that I seek to have printed on every page, and have gotten the echo that is displayed on the help screen - $1:$2. But when I go to exit, I get a tiny popup that informs me: invalid sheet reference In searching the list of error messages for Calc, I find no specific mention of invalid sheet reference. I went back and attempted various combinations of A1 and A2, and kept getting the same message. What am I missing, here? Brian Barker wrote: Are you using OpenOffice version 3.1 as provided by/with Ubuntu? This appears to have been a bug in that version. See https://bugs.launchpad.net/openoffice-pkgs/+bug/374708 . brewster: My apologies for not including version and platform information - I should know better. Using Open Office 3.2 (build:9483) running under Ubuntu 10.04. I guess that I must assume that 3.1 bug was not fixed since it is still reproducing under my later lashup. barker: I trust this helps. Brian Barker brewster: Actually it helped on a couple of counts; I'd always rather find out that it's a bug instead of my lack of competence :-)... ... and your bug-blog link had a workaround that someone had discovered, that appears to do the trick. The lesson for me is that when a problem seems intractable or has no plausible explanation, check the bug reports first. Thanks, Brewster -- *** Embrace a sharing community of sustainable justice low-carbon diversity *** W. Brewster Gillett b...@fdi.usPortland, OR USA *** Simply because you don't like to hear it, that doesn't make it untrue. *** - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - printing rows on every page
Den 2011-01-09 01:11:42 skrev Brewster Gillett b...@fdi.us: At 13:12 08/01/2011 -0800, Brewster Gillett wrote: I have explicitly followed the OOHelp instructions - FORMAT-PRINT RANGES-EDIT, done the instructed highlighting for the top two rows that I seek to have printed on every page, and have gotten the echo that is displayed on the help screen - $1:$2. But when I go to exit, I get a tiny popup that informs me: invalid sheet reference In searching the list of error messages for Calc, I find no specific mention of invalid sheet reference. I went back and attempted various combinations of A1 and A2, and kept getting the same message. What am I missing, here? Brian Barker wrote: Are you using OpenOffice version 3.1 as provided by/with Ubuntu? This appears to have been a bug in that version. See https://bugs.launchpad.net/openoffice-pkgs/+bug/374708 . brewster: My apologies for not including version and platform information - I should know better. Using Open Office 3.2 (build:9483) running under Ubuntu 10.04. I guess that I must assume that 3.1 bug was not fixed since it is still reproducing under my later lashup. barker: I trust this helps. Brian Barker brewster: Actually it helped on a couple of counts; I'd always rather find out that it's a bug instead of my lack of competence :-)... ... and your bug-blog link had a workaround that someone had discovered, that appears to do the trick. The lesson for me is that when a problem seems intractable or has no plausible explanation, check the bug reports first. Thanks, Brewster I ran into a few other bad bugs with the Ubuntu-version of OpenOffice.org and finally I just couldn't stand it any more, so I kicked it out and installed the ”real” OpenOffice.org. Worked like a charm since then. I don't know if that would help in this very case, but I would certainly try. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - double-spacing in printing
On 1/8/2011 4:14 PM, Brewster Gillett wrote: I have scoured the OOHelp files for an answer and cannot come up with one. Is it even possible to print out a Calc spreadsheet in double-space? Thanks, Brewster Gene Young wrote: Increase the row height of all rows to double what it is currently. The effect will be double line spacing. brewster: But, regrettably, lacking the half-tone gridlines at the interval that are my preference in the printing. Brewsterr -- *** Embrace a sharing community of sustainable justice low-carbon diversity *** W. Brewster Gillett b...@fdi.usPortland, OR USA *** Simply because you don't like to hear it, that doesn't make it untrue. *** - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - double-spacing in printing
At 13:14 08/01/2011 -0800, Brewster Gillett wrote: I have scoured the OOHelp files for an answer and cannot come up with one. Is it even possible to print out a Calc spreadsheet in double-space? Brian Barker wrote: First, it's not generally helpful to think of doing anything double-space. This is typewriter thinking, where the hardware allows you to print lines only at well-regulated intervals. Computer printers are more flexible than that, and it is better to think of output from a word processor or spreadsheet as having additional spacing between lines or paragraphs or whatever. brewster: I sort of knew all that, but considered it of somewhat more academic than practical interest :-) barker: But no: I think you are right that there is no immediately obvious way to increase the spacing between rows of values. That probably makes sense, since if you are printing a grid you are unlikely to want space between neighbouring rows of the grid. brewster: But as it happens, that is *exactly* what I want. A blank line, every other row, demarcated by the half-tone grid I prefer. IOW a space in which to manually add new data as it arises, for later transcription. barker: There are many ways, though, of achieving what you probably want: 1. Put your spreadsheet values in alternate rows. brewster: That would have the exact effect I seek, but doing it reminds me so much of using a goose nib and an inkwell that I have a difficult time accepting it as a solution :-) barker: 2. Increase the row height without changing the text size: o Go to Format | Row | Height... (or right-click in the row headers | Row Height...) and increase the value there. o You may then wish to move the values to somewhere other than the (default) bottom of the cells (e.g. Middle), at Format | Cells... | Alignment | Text alignment | Vertical (or right-click | Format Cells... | Alignment | Text alignment | Vertical). brewster: I considered that, but realized that I would not have the grid separation I prefer. barker: 3. Increase the spacing above or below (or both) the text in your cells: o Go to Format | Cells... | Borders | Spacing to contents (or right-click | Format Cells... | Borders | Spacing to contents). o Untick Synchronize. o Increase the values for Top or Bottom (or both). I suggest technique no. 3 is probably the most flexible. brewster: Perhaps but in my 3.2 under Ubuntu 10.4 it refuses to even lift its wheels off the runway. The increased values are not retained - system goes back to the default values as if the changes were never made. And of course it labors under the same deficiency as No. 2 - I didn't especially want a double-sized row - I wanted two separated rows - i.e. a blank row every other one. I imagine I'll probably settle on No. 2 in the event - even though I will find the result a trifle sloppier than I would like :-) Going back and manually inserting a row after every existing row, as in No. 1, doesn't even bear thinking about. Thanks for your help. Brewster -- *** Embrace a sharing community of sustainable justice low-carbon diversity *** W. Brewster Gillett b...@fdi.usPortland, OR USA *** Simply because you don't like to hear it, that doesn't make it untrue. *** - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - printing rows on every page
On Sun, 2011-01-09 at 01:45 +0100, Johnny Rosenberg wrote: I ran into a few other bad bugs with the Ubuntu-version of OpenOffice.org and finally I just couldn't stand it any more, so I kicked it out and installed the ”real” OpenOffice.org. Worked like a charm since then. I don't know if that would help in this very case, but I would certainly try. brewster: I guess that is a distinction of which I was not aware. Are you saying that Ubuntu is shipping a slightly different version from that which is available directly from OOo? That I should download the latest version directly from OOo and install it over the Ubuntu version? I am definitely not inclined to use RCs or betas. Just out of curiosity, is there a detectable rationale for Ubuntu's provision of a buggier version of OOo than Open Office itself ships? Brewster -- *** Embrace a sharing community of sustainable justice low-carbon diversity *** W. Brewster Gillett b...@fdi.usPortland, OR USA *** Simply because you don't like to hear it, that doesn't make it untrue. *** - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - printing rows on every page
Hi Brewster, 2011/1/9 Brewster Gillett b...@fdi.us: On Sun, 2011-01-09 at 01:45 +0100, Johnny Rosenberg wrote: I ran into a few other bad bugs with the Ubuntu-version of OpenOffice.org and finally I just couldn't stand it any more, so I kicked it out and installed the ”real” OpenOffice.org. Worked like a charm since then. I don't know if that would help in this very case, but I would certainly try. brewster: I guess that is a distinction of which I was not aware. Are you saying that Ubuntu is shipping a slightly different version from that which is available directly from OOo? That I should download the latest version directly from OOo and install it over the Ubuntu version? I am definitely not inclined to use RCs or betas. You don't have to use the RCs or Betas, you can go to the latest stable release, which is 3.2.1. The original OOo version installs itself in /opt, so you could run both versions, if you need them. Just out of curiosity, is there a detectable rationale for Ubuntu's provision of a buggier version of OOo than Open Office itself ships? Depends. I wouldn't say, that the Ubuntu (or any other distro version) is buggier than the OOo one. It's just, that they have different features. For example, if you get many Excel files with a lot of VBA Macros in them, you might want to use the Ubuntu version, since the vanilla version cannot handle those. And there are a few other differences (which I don't remember at the moment). Hope, this helps. Sigrid - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - printing rows on every page
On Sat Jan 08 2011 17:11:52 GMT-0800 (PST) Brewster Gillett wrote: On Sun, 2011-01-09 at 01:45 +0100, Johnny Rosenberg wrote: I ran into a few other bad bugs with the Ubuntu-version of OpenOffice.org and finally I just couldn't stand it any more, so I kicked it out and installed the ”real” OpenOffice.org. Worked like a charm since then. I don't know if that would help in this very case, but I would certainly try. brewster: I guess that is a distinction of which I was not aware. Are you saying that Ubuntu is shipping a slightly different version from that which is available directly from OOo? That I should download the latest version directly from OOo and install it over the Ubuntu version? I am definitely not inclined to use RCs or betas. Just out of curiosity, is there a detectable rationale for Ubuntu's provision of a buggier version of OOo than Open Office itself ships? Brewster First, the version that comes with Ubuntu is a modified version from Novell/Go-oo. There are problems and benefits of using the distro version. The current OOo version is 3.2.1 and has been out of beta from some time now, 3.3.0 is in RC8, so you do not have to worry about using beta software. Andy - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - double-spacing in printing
At 17:06 08/01/2011 -0800, Brewster Gillett wrote: But as it happens, that is *exactly* what I want. A blank line, every other row, demarcated by the half-tone grid I prefer. IOW a space in which to manually add new data as it arises, for later transcription. Aha! That wasn't clear anywhere ... 1. Put your spreadsheet values in alternate rows. That would have the exact effect I seek, but doing it reminds me so much of using a goose nib and an inkwell that I have a difficult time accepting it as a solution :-) Sorry, but if you want a grid with alternate rows empty, what is old-fashioned about constructing exactly that: a spreadsheet with alternate rows empty? Going back and manually inserting a row after every existing row, as in No. 1, doesn't even bear thinking about... Er, no-one suggested doing this manually. If you knew this was what you wanted, you could have entered your data this way originally, of course. If not, there will be fairly simple ways of converting what you have into what you want. Suppose, for example, you have data in consecutive cells of column A on Sheet1. In Sheet2, put into cell A1 =IF(ISODD(ROW());INDIRECT(Sheet1.A(ROW()+1)/2);) Now fill this down the column. A1 on Sheet2 becomes a copy of A1 on Sheet1, A2 on Sheet2 is empty (a null string), A3 on Sheet2 is a copy of A2 on Sheet1, and so on. The ROW() function identifies the row number in which the formula appears. ISODD() distinguishes odd-numbered rows - in which a value is copied - from even-numbered ones - in which the null string is the result. (ROW()+1)/2 calculates the row number on Sheet1 from which the current value should be copied: row 1 from row 1, row 3 from row 2, row 5 from row 3, and so on. Concatenating this row number with Sheet1.A creates the description of the required source cell, but this is still a text string and not a cell reference. The INDIRECT() function makes this last conversion and retrieves the value you require. If you do this for a few columns and perhaps reconstruct formulae for any derivative columns, you will soon have what you need. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc error
Dear Sir/Madam, We have one ods file attached which has some problem, Please check and tell how to rectify the problem. Thanks Regards. Shabbir Shaikh. There is no substitute for hard work. Girish K.ods Description: application/vnd.oasis.opendocument.spreadsheet - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc- several sheets all in sync
Original message Date: Tue, 04 Jan 2011 09:42:28 -0500 From: . pe...@aleksandrsolzhenitsyn.net Subject: [users] Calc- several sheets all in sync To: users@openoffice.org I've created a Monthly Calendar Generator in Calc- you can see the template here- http://templates.services.openoffice.org/en/node/4973 All you do is enter an Event (like your birthday) in one cell and the date of the event in the cell next to it. The Event is automatically entered in the appropriate calendar's date. You only enter Event data in the sheet named January-Main The primary formula used for referring to sheet named January-Main is =January-Main.cell location The problem is I can't figure out how to get all of the Event and dates next to them to look exactly like the Event and dates entered in January-Main. That is- if you insert a row between two of the Events I want to see that row added in all other calendar sheets. Sorry for making this so confusing but any help would be appreciated. signature.asc (1k bytes)
Re: [users] Calc- several sheets all in sync
Original message Date: Tue, 04 Jan 2011 09:42:28 -0500 From: . pe...@aleksandrsolzhenitsyn.net Subject: [users] Calc- several sheets all in sync To: users@openoffice.org I've created a Monthly Calendar Generator in Calc- you can see the template here- http://templates.services.openoffice.org/en/node/4973 All you do is enter an Event (like your birthday) in one cell and the date of the event in the cell next to it. The Event is automatically entered in the appropriate calendar's date. You only enter Event data in the sheet named January-Main The primary formula used for referring to sheet named January-Main is =January-Main.cell location The problem is I can't figure out how to get all of the Event and dates next to them to look exactly like the Event and dates entered in January-Main. That is- if you insert a row between two of the Events I want to see that row added in all other calendar sheets. Sorry for making this so confusing but any help would be appreciated. signature.asc (1k bytes)
Re: [users] Calc shows Sort greyed-out
Original message Date: Mon, 03 Jan 2011 11:42:05 +0100 From: Uwe Fischer uwe.fisc...@oracle.com Subject: Re: [users] Calc shows Sort greyed-out To: users@openoffice.org On 12/31/10 05:29, Lee wrote: Using version 3.2.1 in OoCalc, I have a list of movie names to sort. Whether I select all (CTRL A), select the specific columns, or select the range of cells, the Sort function under Tools is greyed out. Saving the file, closing and reopening didn't help. Please advise; thanks much. Lee Hello Lee, Calc cannot sort with Edit-Changes-Record enabled. Temporarily disable recording changes, sort, then enable change tracking again (if you need that at all). Uwe -- Uwe Fischer | Technical Writer Oracle Office GBU ORACLE Deutschland B.V. Co. KG | Nagelsweg 55 | 20097 Hamburg ORACLE Deutschland B.V. Co. KG Hauptverwaltung: Riesstr. 25, D-80992 München Registergericht: Amtsgericht München, HRA 95603 Komplementärin: ORACLE Deutschland Verwaltung B.V. Rijnzathe 6, 3454PV De Meern, Niederlande Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697 Geschäftsführer: Jürgen Kunz, Marcel van de Molen, Alexander van der Ven - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc
Original message Date: Sat, 01 Jan 2011 11:15:29 +0100 From: Franz Wein f.w...@f-wein.com Subject: Re: [users] Calc To: users@openoffice.org Hi Joe use the right mousebottom - on the tabulator at the screenbuttom. Select the in the dropdown-menue insert spreadsheet - its siimilar to excel. Franz J Halka schrieb: I have used Lotus 123 and later some Excel. How do I open a new spreadsheet in Calc. Thanks, JoeH - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc
Original message Date: Thu, 30 Dec 2010 10:53:16 -0800 (PST) From: J Halka jhjh...@yahoo.com Subject: [users] Calc To: users@openoffice.org I have used Lotus 123 and later some Excel. How do I open a new spreadsheet in Calc. Thanks, JoeH
Re: [users] Calc
Original message Date: Sat, 01 Jan 2011 11:15:29 +0100 From: Franz Wein f.w...@f-wein.com Subject: Re: [users] Calc To: users@openoffice.org Hi Joe use the right mousebottom - on the tabulator at the screenbuttom. Select the in the dropdown-menue insert spreadsheet - its siimilar to excel. Franz J Halka schrieb: I have used Lotus 123 and later some Excel. How do I open a new spreadsheet in Calc. Thanks, JoeH - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc error
At 14:17 05/01/2011 +0530, Shabbir Shaikh wrote: We have one ods file attached which has some problem, Please check and tell how to rectify the problem. May I be bold and say that you are expecting a lot here? You shouldn't, I suggest, expect subscribers to a mailing list simply to take over when you have a problem. There is no substitute for hard work. Indeed. And there is no substitute for saying what the problem is, doing what you can with your problem file, and explaining what you did and what response you got, so that anyone trying to help doesn't have to repeat your work. In fact, although your attached file has the .ods extension, it is not a valid OpenOffice (Calc) spreadsheet document file. So it is not surprising that OpenOffice is reluctant to open it. The file contents start as if it is a Portable Document Format (PDF) file, but it also contains what appears to be parts of a Microsoft Excel document file as well as what appears to be garbage. The most likely explanation is that your disk drive has become corrupted, with the result that what appears to be your spreadsheet file is actually a mixture of parts of other files - perhaps even ones that you thought you had deleted. If this is so, the only solution is to go back to your most recent back-up copy of the spreadsheet document file and continue working from there. You will also want to run your system's disk checking software to sort out any other problems on the disk; there will almost certainly be some. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc- several sheets all in sync
I've created a Monthly Calendar Generator in Calc- you can see the template here- http://templates.services.openoffice.org/en/node/4973 All you do is enter an Event (like your birthday) in one cell and the date of the event in the cell next to it. The Event is automatically entered in the appropriate calendar's date. You only enter Event data in the sheet named January-Main The primary formula used for referring to sheet named January-Main is =January-Main.cell location The problem is I can't figure out how to get all of the Event and dates next to them to look exactly like the Event and dates entered in January-Main. That is- if you insert a row between two of the Events I want to see that row added in all other calendar sheets. Sorry for making this so confusing but any help would be appreciated. signature.asc Description: OpenPGP digital signature
Re: [users] Calc shows Sort greyed-out
On 12/31/10 05:29, Lee wrote: Using version 3.2.1 in OoCalc, I have a list of movie names to sort. Whether I select all (CTRL A), select the specific columns, or select the range of cells, the Sort function under Tools is greyed out. Saving the file, closing and reopening didn't help. Please advise; thanks much.Lee Hello Lee, Calc cannot sort with Edit-Changes-Record enabled. Temporarily disable recording changes, sort, then enable change tracking again (if you need that at all). Uwe -- Uwe Fischer | Technical Writer Oracle Office GBU ORACLE Deutschland B.V. Co. KG | Nagelsweg 55 | 20097 Hamburg ORACLE Deutschland B.V. Co. KG Hauptverwaltung: Riesstr. 25, D-80992 München Registergericht: Amtsgericht München, HRA 95603 Komplementärin: ORACLE Deutschland Verwaltung B.V. Rijnzathe 6, 3454PV De Meern, Niederlande Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697 Geschäftsführer: Jürgen Kunz, Marcel van de Molen, Alexander van der Ven - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc
Hi Joe use the right mousebottom - on the tabulator at the screenbuttom. Select the in the dropdown-menue insert spreadsheet - its siimilar to excel. Franz J Halka schrieb: I have used Lotus 123 and later some Excel. How do I open a new spreadsheet in Calc. Thanks, JoeH - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc
I have used Lotus 123 and later some Excel. How do I open a new spreadsheet in Calc. Thanks, JoeH
[users] Calc shows Sort greyed-out
Using version 3.2.1 in OoCalc, I have a list of movie names to sort. Whether I select all (CTRL A), select the specific columns, or select the range of cells, the Sort function under Tools is greyed out. Saving the file, closing and reopening didn't help. Please advise; thanks much.Lee -- View this message in context: http://openoffice.2283327.n4.nabble.com/Calc-shows-Sort-greyed-out-tp3169095p3169095.html Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc Shifting Cell Contents [was issues]
Had you meant to attach a file? Anyway, this is certainly highly unusual behavior, not at all what I've ever seen (admittedly, I'm only a very casual user of Calc). I built a simple spreadsheet with some empty cells and could not reproduce this behavior (Windows 7 64-bit, OOo 3.1.1). This is such an obvious and dramatic problem that there should have been tons of messages about it, and there haven't been any. So it seems likely that it's something about either your spreadsheet or your configuration that is causing this, and if you can supply the file we can at least see if any such thing happens for anybody else. On 11/30/2010 12:52 PM, Frank Altamirano wrote: I'm working on a HP, MS Windows 7 64bit and am working with OOs v3.2.1 and my issues are with Calc. I'm setting up a very simple spreadsheet for a song list for church. Its just a basic list of songs and there corresponding versions in Spanish and Italian. Now most of column A is filled in (e.g. A48) but if a cell is empty to the left of it (e.g. B48, C48, D48) the following happens. After saving and reopening wherever there was an empty cell it would shift all cells to the left to fill in the empty cells, thus, messing up entire order. To temporarily solve the issue, so that i can actually save all they work i have put in, I found that if I just put a space bar character in all empty cells it would serve as a place holder and no cells would shift. ). However, in testing the sheet again before sending it to you, I deleted some of the spaces from the empty cells, saved, closed and reopened... expecting the cells to shift, however, they did not. The issue was reproduced on row 554 when i entered characters into A554, left B554 blank, and entered data into C554. Once I saved and reopened, the data that was C554 had shifted to B554. Please help On Thu, Nov 25, 2010 at 2:43 PM, Barbara Duprey b...@onr.com mailto:b...@onr.com wrote: On 11/24/2010 7:50 PM, Frank Altamirano wrote: I'm having a major problem with my spreadsheet and i want to try to log on to your site and its says it cant find my email then i go to software and open the link from there to register and it says i can't because my email is already registered. UUUGGHHH PLEASE HELP [Frank (frank.altamir...@gmail.com mailto:frank.altamir...@gmail.com) is not subscribed and will probably not see any responses unless directly copied.] First, you should have no need to register or log on to the site -- if you got OpenOffice.org from a site other than www.openoffice.org http://www.openoffice.org, that may be the beginning of the problem. Registration is optional during the installation process, but has no function operationally, it's just trying to get statistics about how many users there are. If you describe your problem here, including what operating system and version, and what version of OOo you are using, and as much as possible about the details of the problem and how you've tried to solve it, the users on this mailing list will try our best to help you. -- Regards, Frank Altamirano tel 201.719.3007
Re: [users] [calc] Date question
Eustace wrote: Is there a way to set my own day of week abbreviation? Instead of Mon Tue... I would rather have MO TU... -emf Yes there is. You first need a spreadsheet open in OpenOffice.org. Then open Help using the F1 key. Click the Index tab near the top. Enter sort lists in the Search term box without the double quotes. Click the Display button at the bottom. The instructions needed to create a new list containing your day of the week abbreviations will appear on the right side of the Help window. Dan - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] [calc] Date question
At 22:42 25/11/2010 -0500, Eustace Fril wrote: Is there a way to set my own day of week abbreviation? Instead of Mon Tue... I would rather have MO TU... At 15:38 26/11/2010 -0500, Eustace Fril wrote: ... I have a column with dates, that use 1999-12-31 Fri in the Format Cells - Numbers - Category:Date - Format field, with Format Code -MM-DD NN. How do I change this to 1999-12-31 FR? I guess I could change the format of the dates column to -MM-DD, the add the double-letter date abbreviations on the next column, and then merge each 2 cells on each line. But then I would have to do it for each line, which is tiresome. Is there a way to expedite the process? It may be a little easier than that: o Somewhere out of the way - perhaps even on another sheet - create a table with Sun, Mon, Tue, etc. in the first column and SU, MO, TU, etc, in the second. o Select the whole two by seven table and go to Insert | Names | Define... and give the table a name, e.g DayNames. o Suppose your original dates are in column A. (The format of these cells doesn't matter.) In B1 enter: =TEXT(A1;-MM-DD )VLOOKUP(TEXT(A1;NN);DayNames;2;0) o Now copy or fill this down column B. o You can hide the original column A if desired. How does this work? The first TEXT() reference produces a text string of the date in -MM-DD format (but note also the trailing space in the format). The second TEXT() reference produces just the day of the week indicator - in the normal form - and the VLOOKUP() then uses this indicator to look up your preferred form from the small table. The ampersand concatenates the two parts of the date. Note that the resulting value is a text string and cannot be used in date calculations - but you have column A (even if hidden) for that. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] [calc] Date question
Wow, elegant! Thanks, Brian, for the tutorial. Tony
[users] [calc] Date question
Is there a way to set my own day of week abbreviation? Instead of Mon Tue... I would rather have MO TU... -emf -- It ain't THAT, babe! - A radical reinterpretation https://files.nyu.edu/emf202/public/bd/itaintmebabe.html - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] [calc]Howto keep solver specs between editing sessions
By solver specs I mean the data entered in the Solver dialog box, i.e. the data labelled: * target cell * Optimize result to * By changing cells * Limiting Conditions in that dialog box. Unfortunately, each time I exit calc and restart with the same file, I have to reenter this data. Is there anyway to save and retrieve the data? TIA. -Larry - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc: How to see list of sheets
Hi, In Excel 2K3, you can right-click on the sheet navigation arrows and have a list of all the sheets in the current workbook, so you can click on the one you need and go there directly. It makes it easier to navigate from one sheet to the other. What's the equivalent in Calc? Thanks, L -- Get free public speaking and communication tips by registering at http://www.duperval.com Bring out the speaker in you! - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc: How to see list of sheets
Hi try the navigator press F5 key HTH Laurent - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc: How to see list of sheets
Dear Laurent:
I create this easily on a regular basis in Calc, However it is not just
1 click.
I add an extra sheet at the beginning (leftmost tab) then add hyperlinks
to each of the sheets in Column B or C. Column A is a sequence number
(or a priority number) so that I can sort by arbitrary criteria.
With this I can jump to any sheet in a {ctrl-click}. This sheet can also
use added columns for items such as a total from each of the other
sheets if these sheets are, say accounts. Since the accounts can be
part of an ongoing inventory reconciliation, Their end results can be
in Lbs., Kg. Litres, Gallons, etc or the calculated value of the current
stock level for each, also taking account of value from different
currencies, Metric/English conversions,
Averaged unit value across multiple purchases of the same stock item,
differences in taxable status, etc. One of these applications I did was
for an industrial inventory of powdered pigments that were subject to
daily ins and outs, U.S. and Canadian currency, Metric and English
Purchasing units, and other freight -in costs.
This one was also used to do pre-production reservation of stock, so
that nobody could end up using stock that was earmarked for another
production batch.
This application later served in another application where liquids were
involved, and conversion to weight was needed.
Another such large workbook application was a sales tracker for a car
dealership. The dealership had 20 regular salesmen, each of which could
sell up to 100 cars a month. Added to that was the fleet salesman, who
could sell double that, as he was selling fleets typically to car rental
companies.
The workbook was about 25 sheets wide. 1 sheet for each salesman,
another for the fleet salesman (total 21 sheets so far), then there were
2 summary sheets at the beginning.
The sales department secretary entered all the sales data throughout the
month, as each vehicle or fleet was sold, along with the model name,
edition code for the model sold, length of the lease, profit figure for
the sale, etc.
At the end of the month, the 2 summary sheets were sorted and printed.
Each of these sheets were about 1800 lines deep, and the formulate in
most of the cells ran right off the edit line, they were so long.
When the sheets were printed, each one only printed as many lines as
there were records active, not the whole 1800 lines.
The first of these print-out takeoffs went to the sales manager so he
had a fast summary of what his sales staff were doing.
The second went to the general manager, who, as far as I know used this
to decide what cars he would order from the manufacturer for the next
business cycle. since he was financially committed to the cost of those
vehicles from the time they left the manufacturer, this made for a big
financial responsibility.
In this case, as we see, the application was serving 2 diverse sets of
needs at the same time.
My fee at the time to do that was about $CDN 365.00, although today it
would be somewhat higher.
I also have another application which related to an industry whose
production is based on a recipe by weight which may also have ongoing
experimental changes in the batch. Usually in this type of production,
the recipe is predicated on a specific final batch weight which is based
on the capacity of the mixing machinery used. When a client places an
order for a much larger quantity, another part of the workbook
calculates the total weight of each product needed for the whole order,
which then becomes the pre-reservation in the inventory as previously
mentioned.
At the point where this transition happens, any stock shortages
resulting from the calculation of the bill of materials for the client
order are then passed to the purchasing agent who obtains the added
stock needs.
The purchasing agent, on advice from the marketing dept. and with
financial executive approval, may increase the order to provide for
expected demand, possibly getting a better price in the process due to
his larger order.
Best Regard$$$
On 11/18/2010 08:22, L Duperval wrote:
Hi,
In Excel 2K3, you can right-click on the sheet navigation arrows and have
a list of all the sheets in the current workbook, so you can click on the
one you need and go there directly. It makes it easier to navigate from
one sheet to the other.
What's the equivalent in Calc?
Thanks,
L
--
Best Regards, Bruce Martin
Re: [users] Calc: How to see list of sheets
Den 2010-11-18 14:22:19 skrev L Duperval lduper...@yahoo.com: Hi, In Excel 2K3 Very OT: 2K3? In my world that means 2300 (except that the ”k” shouldn't be capitalised…), like 2k3 Ω means 2,3 kΩ and so on. Well, have a nice day. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc Group By Analog in Charts
I have a set of data (from bonnie++) that represents different test cases each with 3 samples. I would like to chart the data but average the samples. Subtotals and Data Pilot give me nearly what I want but not quite. Ideally I would like to be able to paste data in one sheet and have charts generated from the averaged samples on another sheet. My data looks something like: name,size,putc,putc_cpu foo-sda-test1, 16G, 36000, 90 foo-sda-test1, 16G, 36001, 89 foo-sda-test1, 16G, 36002, 88 foo-sda-test2, 16G, 38000, 80 foo-sda-test2, 16G, 38001, 79 foo-sda-test2, 16G, 38002, 78 And I want to chart: foo-sda-test1, 16G, 36001, 89 foo-sda-test2, 16G, 38001, 79 Where the 2 rows above are the averages of the 2 sets of 3 rows above that. I could do a macro but there has to be a way to do this more elegantly. Any thoughts? Regards, -Alan
Re: [users] Calc Group By Analog in Charts
On 11/15/2010 4:53 PM, Alan Evans wrote: I have a set of data (from bonnie++) that represents different test cases each with 3 samples. I would like to chart the data but average the samples. Subtotals and Data Pilot give me nearly what I want but not quite. Ideally I would like to be able to paste data in one sheet and have charts generated from the averaged samples on another sheet. My data looks something like: name,size,putc,putc_cpu foo-sda-test1, 16G, 36000, 90 foo-sda-test1, 16G, 36001, 89 foo-sda-test1, 16G, 36002, 88 foo-sda-test2, 16G, 38000, 80 foo-sda-test2, 16G, 38001, 79 foo-sda-test2, 16G, 38002, 78 And I want to chart: foo-sda-test1, 16G, 36001, 89 foo-sda-test2, 16G, 38001, 79 Where the 2 rows above are the averages of the 2 sets of 3 rows above that. I could do a macro but there has to be a way to do this more elegantly. Any thoughts? Regards, -Alan Charts may be cut and pasted. Create your chart - it will naturally fall on the same worksheet. Then cut it, change to a new worksheet, and paste it. Then, you can size it, and rename the worksheet tabs if you wish. Joe Conner, Poulsbo, WA USA - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - how to count cells by background color
Seems that's unique from Microsoft 2007, don't know on this function in Calc till now. Xiaoqi On 10/30/10 6:29 AM, Phil Pinkerton pcpinker...@gmail.com wrote: I found a way to do this using MS Excel 2007 and was looking for a way to do the same in OpenOffice Calc. Anyone had success with counting of cells of a particular color ? Phil - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - how to count cells by background color
On 29/10/10 23:29, Phil Pinkerton wrote: I found a way to do this using MS Excel 2007 and was looking for a way to do the same in OpenOffice Calc. Anyone had success with counting of cells of a particular color ? Phil Nothing's new :-) See http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=2741 where it suggests there's no easy way. But that page asks a pertinent question - /why/ do you want to do this? Cell colours are surely not the real issue of the problem you're solving - they ought (probably!) to be derived from something more fundamental, which is what you could be checking. An old work colleague used to say, if you want to go there, don't start here, when people asked how to complete a half-solution to a problem. Maybe a problem rethink is in order? -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc - how to count cells by background color
I found a way to do this using MS Excel 2007 and was looking for a way to do the same in OpenOffice Calc. Anyone had success with counting of cells of a particular color ? Phil - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On 06/10/10 18:34, JOE Conner wrote: On 10/6/2010 10:22 AM, AG wrote: Hello all Two (unrelated) questions on using Calc: (1) How do I freeze a row so that scrolling through the rest of the spreadsheet the top/ frozen row remains visible? (2) When mousing over the various menus, the yellow text bubble that explains what the item does conceals the menu items concerned. How can I shift the bubble so that it no longer obscures the menu item it describes? Thanks for help on both or either of these two issues. AG 1. Click on the cell below and to the right of the rows and columns you want to freeze. 2. Click WINDOW - FREEZE (or CTRL F) A further question on this theme: If I wanted to freeze row 1 as well as column A, is there a way of doing this? From my attempts so far, I can only do a row or a column, but not both together. It may not possible, and after loads of data I may find that it is not even desirable to do so, but curious minds and the desire to experiment and all that jazz ... ;-) Cheers AG - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
AG wrote: On 06/10/10 18:34, JOE Conner wrote: On 10/6/2010 10:22 AM, AG wrote: Hello all Two (unrelated) questions on using Calc: (1) How do I freeze a row so that scrolling through the rest of the spreadsheet the top/ frozen row remains visible? 1. Click on the cell below and to the right of the rows and columns you want to freeze. 2. Click WINDOW - FREEZE (or CTRL F) A further question on this theme: If I wanted to freeze row 1 as well as column A, is there a way of doing this? From my attempts so far, I can only do a row or a column, but not both together. It may not possible, and after loads of data I may find that it is not even desirable to do so, but curious minds and the desire to experiment and all that jazz ... ;-) Cheers AG Yes. To freeze Row 1 and Column A, select (click in) cell B2. The select Window Freeze. The general case: everything above and to the left of the cell you've selected will be frozen. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On 23/10/10 20:01, Richard Detwiler wrote: AG wrote: On 06/10/10 18:34, JOE Conner wrote: On 10/6/2010 10:22 AM, AG wrote: Hello all Two (unrelated) questions on using Calc: (1) How do I freeze a row so that scrolling through the rest of the spreadsheet the top/ frozen row remains visible? 1. Click on the cell below and to the right of the rows and columns you want to freeze. 2. Click WINDOW - FREEZE (or CTRL F) A further question on this theme: If I wanted to freeze row 1 as well as column A, is there a way of doing this? From my attempts so far, I can only do a row or a column, but not both together. It may not possible, and after loads of data I may find that it is not even desirable to do so, but curious minds and the desire to experiment and all that jazz ... ;-) Cheers AG Yes. To freeze Row 1 and Column A, select (click in) cell B2. The select Window Freeze. The general case: everything above and to the left of the cell you've selected will be frozen. Nice one! Thanks Richard. AG - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc malfunction - won't recalculate
On 10/08/2010 10:21 AM, Mike Scott wrote: On 08/10/10 16:52, John Bowling wrote: OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4 On openSUSE 11.3 Work fine until an update in the last few days. Now simple calculations such as =A15+1 (in A16) will not change if the value in A15 changes. A16 remains the old value. It does effect other calculations also, but that's the simplest to describe. It does the calculation if you are entering new calculations into a spread sheet, but will not anytime after that. Closing and reopening the file or Calc will not make it recalculate. I suggest you check Tools | Cell Contents | Autocalculate is on. Thanks, I checked that. It does not have a check mark on it. A right click or left click will not add a check mark. Yet now it does recalculate on a new spread sheet by changing a value or by F9. Auto-calculate and Auto-input are checked. Even so, it now seems to work (before and I looked at and tried changing things). I checked the spreadsheet that had the problem before, and Auto-calculate was not checked. It was a sheet that had been used a few hundred times over the last few years without changes except data additions at the bottom. Auto-calculate had been checked origionally. This is not something that changes with an inadvertent slip of the fingers on the keys (how could you? given the above) or some F- key. So why did it change? It does now work. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc malfunction - won't recalculate
At 20:14 11/10/2010 -0700, John Bowling wrote: I checked the spreadsheet that had the problem before, and Auto-calculate was not checked. It was a sheet that had been used a few hundred times over the last few years without changes except data additions at the bottom. Auto-calculate had been checked originally. This is not something that changes with an inadvertent slip of the fingers on the keys (how could you? given the above) ... By pressing Alt+T, N, C. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] (Calc) Text output for cell based on other cell values
Den 2010-10-08 20:44:00 skrev Brad Rogers b...@fineby.me.uk: On Fri, 08 Oct 2010 10:50:09 -0700 JOE Conner joeconner2...@gmail.com wrote: Hello JOE, You could have just hidden the column. FORMAT = COLUMN = HIDE. You're right, but as the column was being used as a spacer anyway, I opted for white on white. Well, you could insert a new column and then hide it… -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] (Calc) Text output for cell based on other cell values
On Sat, 09 Oct 2010 14:57:46 +0200 Johnny Rosenberg gurus.knu...@gmail.com wrote: Hello Johnny, Well, you could insert a new column and then hide it… :-) -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent Dream on white boy, dream on black girl Original Sin - INXS signature.asc Description: PGP signature
[users] (Calc) Text output for cell based on other cell values
Hello All, I'm trying to get text printed in a cell in Calc based on the values found in other cells, as follows; Col1 Col2 Row1 Cat2 Row2 Dog4 Row3 Mouse 3 The text I want to output to the result cell is from Col1, based on the values in Col2. Specifically, the lowest value. SO, in this instance, I'd like Cat as the o/p. Finding the MIN value is easy but after that, I'm stuck. I've tried googling, but don't seem able to invoke the right incantations. Any help will be appreciated, thanks. -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent That's what I call you Heaven Sent - INXS signature.asc Description: PGP signature
Re: [users] (Calc) Text output for cell based on other cell values
On 08/10/10 15:00, Brad Rogers wrote: Hello All, I'm trying to get text printed in a cell in Calc based on the values found in other cells, as follows; Col1 Col2 Row1 Cat2 Row2 Dog4 Row3 Mouse 3 The text I want to output to the result cell is from Col1, based on the values in Col2. Specifically, the lowest value. SO, in this instance, I'd like Cat as the o/p. Is vlookup() of any help? It seems in the right sort of direction -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc malfunction - won't recalculate
OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4 On openSUSE 11.3 Work fine until an update in the last few days. Now simple calculations such as =A15+1 (in A16) will not change if the value in A15 changes. A16 remains the old value. It does effect other calculations also, but that's the simplest to describe. It does the calculation if you are entering new calculations into a spread sheet, but will not anytime after that. Closing and reopening the file or Calc will not make it recalculate. John - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc malfunction - won't recalculate
John Bowling wrote: OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4 On openSUSE 11.3 Work fine until an update in the last few days. Now simple calculations such as =A15+1 (in A16) will not change if the value in A15 changes. A16 remains the old value. It does effect other calculations also, but that's the simplest to describe. It does the calculation if you are entering new calculations into a spread sheet, but will not anytime after that. Closing and reopening the file or Calc will not make it recalculate. John Did you get the latest version from openSUSE or from the OOo website? If you got it from SUSE, that might be the problem. Seems that every Linux distribution modifies OOo is some way. It might be a bug in the SUSE flavor of OOo. I download my version of OOo from the OOo website, and I don't have that problem. When I change the value in A15, the value in A16 changes as soon as I use the Enter key or any other method to move from A15 to another cell. To recalculate, use the F9 key. (Unless SUSE has changed that option.) Dan
Re: [users] Calc malfunction - won't recalculate
On 08/10/10 16:52, John Bowling wrote: OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4 On openSUSE 11.3 Work fine until an update in the last few days. Now simple calculations such as =A15+1 (in A16) will not change if the value in A15 changes. A16 remains the old value. It does effect other calculations also, but that's the simplest to describe. It does the calculation if you are entering new calculations into a spread sheet, but will not anytime after that. Closing and reopening the file or Calc will not make it recalculate. I suggest you check Tools | Cell Contents | Autocalculate is on. -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] (Calc) Text output for cell based on other cell values
On Fri, 08 Oct 2010 15:58:57 +0100 Mike Scott m...@scottsonline.org.uk wrote: Hello Mike, Is vlookup() of any help? It seems in the right sort of direction It is indeed; I don't seem to be able to get that function to do a lookup right to left, rather than left to right, but I've overcome that by duplicating the numerical data on the left of the text, but in white text on a white background, so it can't be read. Many thanks for your help, Mike. I was tearing what little hair I have left out, trying to figure this one. -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent Your life is like a schedule, you run to meet the bills Life Kills - Human League signature.asc Description: PGP signature
Re: [users] (Calc) Text output for cell based on other cell values
On 10/8/2010 9:10 AM, Brad Rogers wrote: On Fri, 08 Oct 2010 15:58:57 +0100 Mike Scottm...@scottsonline.org.uk wrote: Hello Mike, Is vlookup() of any help? It seems in the right sort of direction It is indeed; I don't seem to be able to get that function to do a lookup right to left, rather than left to right, but I've overcome that by duplicating the numerical data on the left of the text, but in white text on a white background, so it can't be read. Many thanks for your help, Mike. I was tearing what little hair I have left out, trying to figure this one. You could have just hidden the column. FORMAT = COLUMN = HIDE. Joe Conner, Poulsbo, WA USA - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] (Calc) Text output for cell based on other cell values
On Fri, 08 Oct 2010 10:50:09 -0700 JOE Conner joeconner2...@gmail.com wrote: Hello JOE, You could have just hidden the column. FORMAT = COLUMN = HIDE. You're right, but as the column was being used as a spacer anyway, I opted for white on white. -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent You don't entertain ideas you simply bore them I Don't Like You - Stiff Little Fingers signature.asc Description: PGP signature
Re: [users] Calc - freezing rows and text on menus
On Thursday 07 October 2010 06:22, AG wrote: Hello all Two (unrelated) questions on using Calc: (1) How do I freeze a row so that scrolling through the rest of the spreadsheet the top/ frozen row remains visible? (2) When mousing over the various menus, the yellow text bubble that explains what the item does conceals the menu items concerned. How can I shift the bubble so that it no longer obscures the menu item it describes? It is the tip of the arrow that does the work*. You only need this tip on your menu item to see the tooltip bubble. The tooltip position is set by the Operating System and is usually bottom right of the pointer arrow when the pointer is top left where the toolbars normally sit. Finetune your pointer placement if you wish to read the menus is the best answer. * the single pixel at the tip of the arrow is a hotspot which is where the actual click happens. On the text I-beam pointer this hotspot is midway up the I HTH -- Michael - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc - adjusting font effects in header
Hi all I cannot figure out how to make the header on a spreadsheet bold (/ or underlined). On a regular sheet I do the following: Format Page Header Edit Custom Text Attributes Font Effects Overlining Bold But this doesn't seem to have any influence on the actual text in the header field. Experimenting, I have ticked the Individual words option, as well as manually selected the colours for the text. Again, nada. I'm (reasonably?) sure there must be a straight forward way of doing this, but the print preview and actual print out of the sheet do not reflect the changes I think that I am making. Any thoughts - am I missing a step? TIA AG - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - adjusting font effects in header
On 07/10/2010 18:57, AG wrote: Hi all I cannot figure out how to make the header on a spreadsheet bold (/ or underlined). On a regular sheet I do the following: Format Page Header Edit Custom Text Attributes Font Effects Overlining Bold But this doesn't seem to have any influence on the actual text in the header field. Experimenting, I have ticked the Individual words option, as well as manually selected the colours for the text. Again, nada. I'm (reasonably?) sure there must be a straight forward way of doing this, but the print preview and actual print out of the sheet do not reflect the changes I think that I am making. Any thoughts - am I missing a step? I've just looked at this quickly - never tried it before. Format | Page | Header then click Edit shows 3 header areas. I entered some text, picked a word and selected it, then applied the required font and effect. Seems to work, at least as far as page preview goes. 3.1.1/XP -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - adjusting font effects in header
On 07/10/10 19:09, Mike Scott wrote: On 07/10/2010 18:57, AG wrote: Hi all I cannot figure out how to make the header on a spreadsheet bold (/ or underlined). On a regular sheet I do the following: Format Page Header Edit Custom Text Attributes Font Effects Overlining Bold But this doesn't seem to have any influence on the actual text in the header field. Experimenting, I have ticked the Individual words option, as well as manually selected the colours for the text. Again, nada. I'm (reasonably?) sure there must be a straight forward way of doing this, but the print preview and actual print out of the sheet do not reflect the changes I think that I am making. Any thoughts - am I missing a step? I've just looked at this quickly - never tried it before. Format | Page | Header then click Edit shows 3 header areas. I entered some text, picked a word and selected it, then applied the required font and effect. Seems to work, at least as far as page preview goes. 3.1.1/XP Mike Just tried that and that does the trick. I wasn't highlighting the text I wanted to have altered. Many thanks - job done! AG - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On Thursday 07 October 2010 06:22, AG wrote: Hello all Two (unrelated) questions on using Calc: (1) How do I freeze a row so that scrolling through the rest of the spreadsheet the top/ frozen row remains visible? (2) When mousing over the various menus, the yellow text bubble that explains what the item does conceals the menu items concerned. How can I shift the bubble so that it no longer obscures the menu item it describes? It is the tip of the arrow that does the work*. You only need this tip on your menu item to see the tooltip bubble. The tooltip position is set by the Operating System and is usually bottom right of the pointer arrow when the pointer is top left where the toolbars normally sit. Finetune your pointer placement if you wish to read the menus is the best answer. * the single pixel at the tip of the arrow is a hotspot which is where the actual click happens. On the text I-beam pointer this hotspot is midway up the I HTH -- Michael - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc - freezing rows and text on menus
Hello all Two (unrelated) questions on using Calc: (1) How do I freeze a row so that scrolling through the rest of the spreadsheet the top/ frozen row remains visible? (2) When mousing over the various menus, the yellow text bubble that explains what the item does conceals the menu items concerned. How can I shift the bubble so that it no longer obscures the menu item it describes? Thanks for help on both or either of these two issues. AG - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On 10/6/2010 10:22 AM, AG wrote: Hello all Two (unrelated) questions on using Calc: (1) How do I freeze a row so that scrolling through the rest of the spreadsheet the top/ frozen row remains visible? (2) When mousing over the various menus, the yellow text bubble that explains what the item does conceals the menu items concerned. How can I shift the bubble so that it no longer obscures the menu item it describes? Thanks for help on both or either of these two issues. AG 1. Click on the cell below and to the right of the rows and columns you want to freeze. 2. Click WINDOW - FREEZE (or CTRL F) Sorry, I cannot help you with the yellow bubbles. Joe Conner, Poulsbo, WA USA - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On Wed Oct 06 2010 10:22:48 GMT-0700 (PDT) AG wrote: Hello all Two (unrelated) questions on using Calc: (1) How do I freeze a row so that scrolling through the rest of the spreadsheet the top/ frozen row remains visible? On the top of the scroll bar, just above the up arrow, you should see a dark line. Place the mouse pointer on this and the pointer changes to a double headed arrow. Right click and hold to move where you want the separation. For columns the line in on the right end of the lower scroll bar. (2) When mousing over the various menus, the yellow text bubble that explains what the item does conceals the menu items concerned. How can I shift the bubble so that it no longer obscures the menu item it describes? There is no way to reposition the help pop-up. You can turn off the tips, Tools Options OpenOffice.org General . At the top select/deselect Tips. HTH - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On 2010-10-06 1:34 PM, JOE Conner wrote: 1. Click on the cell below and to the right of the rows and columns you want to freeze. 2. Click WINDOW - FREEZE (or CTRL F) Interesting, didn't know you could do it this way. Thanks! - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On 06/10/10 18:34, JOE Conner wrote: On 10/6/2010 10:22 AM, AG wrote: Hello all Two (unrelated) questions on using Calc: (1) How do I freeze a row so that scrolling through the rest of the spreadsheet the top/ frozen row remains visible? (2) When mousing over the various menus, the yellow text bubble that explains what the item does conceals the menu items concerned. How can I shift the bubble so that it no longer obscures the menu item it describes? Thanks for help on both or either of these two issues. AG 1. Click on the cell below and to the right of the rows and columns you want to freeze. 2. Click WINDOW - FREEZE (or CTRL F) Sorry, I cannot help you with the yellow bubbles. Joe Conner, Poulsbo, WA USA - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Thanks Joe, that's useful to know as a shortcut. AG - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On 06/10/10 18:36, RA Brown wrote: On Wed Oct 06 2010 10:22:48 GMT-0700 (PDT) AG wrote: Hello all Two (unrelated) questions on using Calc: (1) How do I freeze a row so that scrolling through the rest of the spreadsheet the top/ frozen row remains visible? On the top of the scroll bar, just above the up arrow, you should see a dark line. Place the mouse pointer on this and the pointer changes to a double headed arrow. Right click and hold to move where you want the separation. For columns the line in on the right end of the lower scroll bar. Wasn't aware of that as an option. Thanks for pointing that out. (2) When mousing over the various menus, the yellow text bubble that explains what the item does conceals the menu items concerned. How can I shift the bubble so that it no longer obscures the menu item it describes? There is no way to reposition the help pop-up. You can turn off the tips, Tools Options OpenOffice.org General . At the top select/deselect Tips. Unfortunately that kind of defeats the object. I want the pop ups because they do help explain the menu option. I just don't want the little buggers obscuring the actual menu items. I've tried dragging them off to the side and it just doesn't work, so I was curious as to whether or not there was an option to reposition them. Oh well. HTH It did, thanks. AG - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On 06/10/10 18:40, Tanstaafl wrote: On 2010-10-06 1:34 PM, JOE Conner wrote: 1. Click on the cell below and to the right of the rows and columns you want to freeze. 2. Click WINDOW - FREEZE (or CTRL F) Interesting, didn't know you could do it this way. Thanks! Fascinating. Something new every day :-) Except on my copy ^F throws up the search and replace dialogue (3.2.0 on ubuntu 10.04) But there's an alternative. At the top of the vertical scroll bar there's a thick line. Grab this and drag down to split the screen into two independently scrollable regions. Similarly for the horizontal scroll. This too can effectively freeze part of the display. (I see now that window|freeze and window|split are mutually exclusive menu options.) -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - freezing rows and text on menus
On Thursday 07 October 2010 07:09, Mike Scott wrote: On 06/10/10 18:40, Tanstaafl wrote: On 2010-10-06 1:34 PM, JOE Conner wrote: 1. Click on the cell below and to the right of the rows and columns you want to freeze. 2. Click WINDOW - FREEZE (or CTRL F) Interesting, didn't know you could do it this way. Thanks! Fascinating. Something new every day :-) Except on my copy ^F throws up the search and replace dialogue (3.2.0 on ubuntu 10.04) You are right [Ctrl]+[F] is find. [Alt] [W] [F] is the correct keyboard shortcut for this. Alt is not held like a shift key here. These three keys are tapped one at a time. All menu options are available via the Alt key and the underlined letters. My favourite on a hundred+ page thesis is Dutch Elm disease - [Alt] [E] [L] [M]. Though on some versions of OO.o it was the eating disorder - [Alt] [E] [A] [T]. Of course after the screams settle down [Ctrl]+[Z] fixes things. But there's an alternative. At the top of the vertical scroll bar there's a thick line. Grab this and drag down to split the screen into two independently scrollable regions. Similarly for the horizontal scroll. This too can effectively freeze part of the display. (I see now that window|freeze and window|split are mutually exclusive menu options.) Ooh! I learned something new - thanks. -- Michael - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc
I have a OOoo Calc file that looks fine on the screen but when I preview it, the page is blank. When I try to print it, I only get one blank page.
Re: [users] Calc
Den 2010-09-21 21:06:11 skrev Sam Warren sambookwar...@yahoo.com: I have a OOoo Calc file that looks fine on the screen but when I preview it, the page is blank. When I try to print it, I only get one blank page. Did you define a print range? -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc
Sam Warren wrote: I have a OOoo Calc file that looks fine on the screen but when I preview it, the page is blank. When I try to print it, I only get one blank page. Check to see if you have a print range set, on any of the sheets in the file. If you've set a print range on any sheet in the file, there is no long a default print range for other sheets. To remedy this, manually set a print range for the sheet you're trying to print. You can do this by highlighting the range you wish to print, and then selecting Format Print Ranges Define. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc, rotating axes
I have a csv file (3 rows x 25 columns) which when I read it in, displays across the page, as expected. But I would like to change the display so the columns become rows, ie: so that it displays down the page. I am sure there is an easy way to do this, but I don't know what it is. bill - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
