[users] OOo-Calc Error when moving tab?
Hi, I have a fresh install of openSuSe 11.2 and it comes bundled with OOo 3.1.1 build 3.1.1..4, which has been installed to facilitate continued use of OpenOffice. I had created a 17 sheet spreadsheet on the older version launched with openSuSe 11.0 and successfully opened the spreadsheet in the new version. The spreadsheet contains 2 tabs of text with the balance being graphs of the text data i.e. one of the text sheets is called data and contains readings, which are then graphed on the remaining sheets. The problem on the newer version of OOo is that when I want to move one the monthly tabs that contains a graph, or even the data tab that only contains numbers, when I click on it and move it OOo shuts down completely and needs to be restarted and the recovery of the open document needs to take place. To try and fix this eror I have checked for updates using Yast, and whilst newer versions are available they do not seem to be openSuSe 'supported'. Is there a fix for this, should I raise a bug report as it may be happening in the newset version too? Anyone point me in the right direction to get this resolved? Regards Hylton
Re: [users] Re: converting a .pdf to .odt???
Hi Bob, On 1 April 2010 23:01, Bob Long wrote: > Dave Stevens wrote, > >> I have to convert a .pdf for which I no longer have access to the original >> .odt format. I've installed the sun-pdfimport extension and can open the >> file in >> draw. If I read the documents right I should now be able to resave in .odt >> but >> neither save as nor export offers me this format. Does anyone know how to >> complete the saving process? > > As far as I can tell (with OOo 3.2, Windows), Draw can't save or export to > Writer format. > > The process you use will depend on how much layout you want to preserve. An > ordinary PDF Reader (Adobe Reader, at least) will let you select text and > paste into Writer, but losing layout. You can also individually copy and > paste images. > > But that process will treat every end of line as an end of paragraph. > > Yo may want to check out the free on-line PDF to .DOC converter that > preserves paragraphs: http://www.pdftoword.com/ > > -- > Bob Long Why not use an online file convertor as I recently did to convert PDF files to images. Try http://www.youconvertit.com/ HiH Hylton - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Calc-Time calculations for athlete
Hi Bob, Your solution is valid but it doesn't accomplish what I am looking for. I'll send you a calc spreadsheet so you can play. It does sort of help however entering the time value is a mission with the :'s. I'd much rather enter it as a decimal fraction ie 0.2947 being 29 minutes and 47 seconds. Also how would you calculate the speed as being a function of Distance / time? Sorry, still looking for a solution. Hylton - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc-Time calculations for athlete
Hi, I am keeping a Calc logbook of my own exercise times so that I can see what factors influence the readings. Currently I completes a 3km stretch of exercise in 31m and 34s and I would like to workout my speed and minutes per kilometre. I have a Sharp calculator(model EL 532) that takes a time value entered into the unit in the format of hh.mmss and converts it to a decimal value ie 0.3134 would become 0.526. Using the formula of Speed= Distance / Time the speed I walk at is 3 / 0.526111 = 5.7km/h. The minutes it takes me to complete 1km is 3 / 0.526111 = 0.1753694 BUT it is a decimal value and not in minutes and seconds.. The time value of that converted decimal value is 0.103133 or 10mins, 31 secs and 33 hundreds of a seconds per 1km. My problem is creating a spreadsheet formula that would allow me to enter a time value into a cell in the format of 0.mmss and have the speed and minutes per kilometer automatically calculated. An added bonus would be calculating the average time as that would indicate a performance drop or gain. It is further complicated by the fact that the base is a multiple of 60 and not 100. It is easy to work out a decimal value from a time value provide it is only minutes OR seconds. The problem comes in when they are combined, as is most often the case. To convert minutes (0.mm00) you take the number of minutes ie 12 (0.1200) / 60 * 100 = 0.2 which is the decimal value. Similarly converting 12 secs to a decimal value requires0.0012 / 3600 * 1 to give a decimal value of 0.0030. I have been punching numbers into my poor calculator trying to work out the method the calculator uses to convert a time value to a decimal one with out success. I know there is the ability to format cells in a time format but it is calculating the values that has got me foxed. I am looking for a calculated time value to be displayed in the format of hh.mmss. Any help appreciated. Regards Hylton - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] working with time
Hi Brian, 2009/3/22 Brian Barker : > At 14:30 22/03/2009 +0200, Hylton Conacher wrote: >> >> I am battling to convert time to a digital value ... > > Er, everything stored in a computer is digital! Seriously though convert a time value to a valid decimal value and vice versa. >> I would like to be able to enter a time value as mm:ss and then be able to >> calculate what the time is for a distance over a certain distance ie I walk >> 3km in 31:34, what is my speed and also my min/km? >> >> How should I format the cells and what formula will enable me to convert >> the time to a digital value that can be dived, and then re-formatted to show >> a mm:ss value? > > o A simple way to enter times as minutes and seconds is to prefix them with > a zero hours value. So enter your 31:34 as 0:31:34. > o Format your cell as MM:SS to see just the minutes and seconds and > suppress the (zero) hours. But be careful: any value over an hour will then > display incorrectly. > o Your actual time value is stored in the cell as a decimal value in days. > Your 31:34 is stored as 0.02192... - that fraction (a little over a > forty-sixth) of a day. If you wish to see this explicitly, use =VALUE(xx) > to show it. > o You can calculate with such values directly, as long as you remember they > are in days, not minutes; no conversion is necessary. To calculate your > speed in km/min, use =3/(xx*24*60). The number of minutes per kilometre is > the reciprocal of this, of course: =B2*24*60/3. > o Some calculations with times result in values that are understandably > displayed as times. If you need to avoid this, apply the VALUE() function. > But you generally won't need to do this. Thanks for the assistance but there is something wrong. Values I get from an old sharp EL-532 Scientific calculator, which I trust absolutely are different to the ones you give, and yet I cannot see how. My values are entered so: Distance(km) Time(0.mmss) 3.20.3407 The calculated values are: Speedkm/hr) Min/km 5.63 0.1039 ie 10m 39s How can these values be achieved with Calc formulae? Regards Hylton - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: [opensuse] Resurrecting VMware (6.5) After Kernel Update?
Hi Randall,
Although for n earlier version, I think as well as VMWare server, the
VMWare needs to be recompiled to know where the new kernel bits are.
Hence after a kernel update all I did was run, as root user, the
following command:
#> vmware-config.pl
Most of the defaults are fine or keep the old settings, at least
according to my notes.
ymmv but HIH
Hylton
2009/3/23 Dominique Leuenberger :
On 3/22/2009 at 19:43, Randall R Schulz wrote:
>> Hi,
>>
>> I'm sure I should know this, but I can't recall or find the answer...
>>
>> After updating a kernel, what must be done to restore VMware
>> functionality?
>
> Randall,
>
> In a perfect world: nothing.
> In a VMware world: the kernel modules need to be recompiled.
>
> now the trick:
> - VMware actually should detect if the modules are there, and if not ask for
> the root password and compile them.
> most likely though, when you start VMware, it just tells you which modules
> are not loaded and at segfaults.
>
> In this case, you will need this script:
>
> --- START SCRIPT ---
> #/bin/sh
> cd /usr/lib/vmware/modules/source
> for a in *.tar ; do tar xf $a; done
> pushd vmblock-only; make; popd
> pushd vmci-only; make; popd
> pushd vmmon-only; make; popd
> pushd vmnet-only; make; popd
> cp vmci-only/Module.symvers vsock-only/
> pushd vsock-only; make; popd
> find -name *.ko -exec cp \
> {} /lib/modules/$(uname -r)/kernel/drivers/misc/ \;
> depmod -aq
> --- END SCRIPT ---
>
> Sometimes I ended up also with the need to modify /etc/init.d/vmware.
> You would find a function vmwareLoadModule()
>
> I suggest to change it to:
>
> vmwareLoadModule() {
> /sbin/modprobe "$1" || exit 1
> return 0
> }
>
> then issue "/etc/init.d/vmware start" and you should be back in business.
> (that is, if you're using a kernel < 2.6.28! Otherwise it's getting really
> nasty with an additional patch to be applied to the modules.)
>
> Dominique
>
> --
> To unsubscribe, e-mail: opensuse+unsubscr...@opensuse.org
> For additional commands, e-mail: opensuse+h...@opensuse.org
>
>
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
[users] working with time
Hi, I am battling to convert time to a digital value and back again via Openoffice that my Sharp EL-532 calculator does with no problem. I would like to be able to enter a time value as mm:ss and then be able to calculate what the time is for a distance over a certain distance ie I walk 3km in 31:34, what is my speed and also my min/km? How should I format the cells and what formula will enable me to convert the time to a digital value that can be dived, and then re-formatted to show a mm:ss value? Regards Hylton -- Using Openoffice 3.0 on OpenSuSE 11.0 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] OOo 3 Calc Copy and Paste issues
Hi, Using openSuSE 11.0 and OOo 3(Build 9358). I have a Calc file that allows me to monitor my ADSL usage. This file has a total of 22 sheets that include data or charts. The procedure is as follows: 1. I copy the data from my ISP usage stats and then paste them into a Calc sheet.all the numbers and formats are fine and the formulae I have to use the ISP values to obtain the total monthly usage reflect the data correctly 2. I then copy the last day's usage, using the mouse and keyboard keys, and paste it into another sheet on the same file. On occassions OOo doesn't copy the selected text and I am presented with a box stating that there is no data to paste OR it pastes text from an earlier copy. 3. The total figures from my Data Sheet are also copied using the kb and mouse and then the Paste special command is used to only paste the numbers and formats. Very often I either get the error that there is nothing to paste or on selecting 'paste special' all the first block of boxes are selected despite me previously ensuring only Paste numbers and Formats are checked. The Calc file is on the Issue Tracker under Issue 2 Regards Hylton - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OOo Writer Cut & Paste Problem
2009/3/6 Ugly Me : > Something I've taken for granted in Microsoft Office (and virtually every > other word processor/text editor) is that if I cut or copy text from some > place and paste it to the program, the whole thing is copied over. With OOo > Writer it seems that only the first page is pasted in and the rest of it? > Who knows. I regard this a bug, and believe me - it bugs me. Is there any > plan to correct this? (Alas I can't program anything newer than GW-BASIC so > I can't do it myself). I have a similar issue with Calc's copy and pasting of cells between sheets but I will raise a new email about it. Regards Hylton - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Cacl Sheet linking with cell merge?
Hi, I have a contact list of over 100 lines that details the contact details for the residents in my suburb on Sheet 1. To make the data easier to use by the resident I have broken it up into resident street name. I have then created additional sheets for each of the street name and have copied from the main sheet(sheet 1) and pasted All with a Link onto each sections respective street name sheet. On Sheet 1 I have a background colour set on the street name(Dolphin) and there is no other data on the same line, other than the street name. in block A2. The data for Dolphin is ended by a row with the same background colour as the one behind the street name in A1. I copy a section from Sheet1 A1:J30 and then go to the sheet name bearing the name of the street ie Dolphin. I right click on the cell I want the paste to start, select Paste special and make sure Paste all and Link are selected. I then O and the text is pasted correctly. No problem so far :) Now I move back to sheet 1 and change the formatting of the Dolphin street name ie I merge some of the cells in the street name row so that the street name is more centralised. I now visit the Dolphin sheet and see that the street name format is exactly the same as before I changed it ie no changes to the format have been made. Given that the sheets contents and formats are linked, why is Calc refusing to adopt the changes in a linked sheet? Regards Hylton P.S: To make sure I didn't get caught out with 'hidden cell' contents again I checked that all the cells were blank, bar the background colour, before merging them. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc AVERAGE function faulty
2009/1/16 Brian Barker : > At 11:25 16/01/2009 +0200, Hylton Conacher wrote: >> >> 2009/1/14 Brian Barker: >>> >>> At 10:08 13/01/2009 +0200, Hylton Conacher wrote: I have merged a few cells and entered a SUM formula in there to provide a numerical result. I have a column next to that that takes the AVERAGE of all the merged cells and represents it as a single number. I recently added a 10th merged cell to the AVERAGE formula and the result came back that it cannot divide by zero, however the result is far far away from zero if I calculate manually. > I think the problem is fairly straightforward. It seems that merged cells > do not work exactly as you may imagine (and, I have to admit, as I would > have expected them to behave). You will have noticed that my first reply > above referred to the "hidden cells" that are present when you merge cells. > What happens when you merge cells is apparently that a single (upper, > leftmost) cell expands to fill the space occupied by the merged cells, with > the other cells being not destroyed but only hidden. If your answer to > Calc's question "Should the contents of the hidden cells be moved into the > first cell?" is "No", any values in the hidden cells remain there. > > If you demerge the merged cells that you need to average, you will see that > two of them (U4 and U47) retain values in the hidden cells - four values in > one case and five in the other. The parameter you have given in your > AVERAGE() function reference is not a list of the separate merged cells, but > - reasonably enough, one might think - a cell range (U3:U53) which thus > includes all those hidden cells as well as the visible cells you need. Even > before you saw the error result, these rogue hidden values will have been > giving you incorrect results for your average. But the bigger problem is > that three of these hidden cells contain formulae that refer to rows in > which you have yet to enter data and happen themselves to result in #DIV/0! > errors. Your AVERAGE() formula is giving a #DIV/0! error not because it is > finding itself required to divide by zero but simply because it is reporting > on - and repeating - the error values it is being asked to calculate with. Brian, Thank you. I had not realised that the 'hidden' cells in a merged block would influence the answer. I have cleaned out the 'hidden cells' and now the formula works as expected. I also did not realise that I didn't need the SUM function as I thought all formula had to have a function before the brackets. I may edit it but at the moment the SUM function is doing no harm there. Thanks again Regards Hylton - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc AVERAGE function faulty
2009/1/14 Brian Barker : > At 10:08 13/01/2009 +0200, Hylton Conacher wrote: >> >> I have merged a few cells and entered a SUM formula in there to provide a >> numerical result. I have a column next to that that takes the AVERAGE of all >> the merged cells and represents it as a single number. I recently added a >> 10th merged cell to the AVERAGE formula and the result came back that it >> cannot divide by zero, however the result is far far away from zero if I >> calculate manually. > > The result of the average is not particularly relevant, of course. The > AVERAGE() function would not be trying to divide anything by this final > result. Instead, AVERAGE() needs to divide by the number of elements it is > given, of course, so the obvious possibility is that you are asking it to > average a set with no elements. Yes I agree, an average is the sum of the elements divided by the number of elements. On further checking I see I made a slight error in the number of cells used to calcukate the average. The real number is 9 cells. > If you give the AVERAGE() function a set of cells that contain nothing > numerical, it will count the number of values as zero and divide the (zero) > sum by that zero to get its result - with exactly the effect you describe. > Its not clear what you are merging here, but my guess is that you have > merged a number of cells that previously contained numerical values. There > are two alternatives when you do this: did you leave the values in the > hidden cells or did you allow the merge to move them into the visible, > merged cell? If the latter, what you now have is not any numbers but a text > item, formed by concatenating the former numerical values with intervening > spaces. An attempt to average this will find no values and certainly give > you a #DIV/0! error. All the merged cells in question have numbers in them calculated by a non circular formula. These cells are then averaged again to obtain a Mean. > It may still be that AVERAGE() is doing the right thing with what you have > given it ... It would seem that the Average function is NOT doing the right thing, unfortunately. I have checked and re-checked all the cell formulae and cannot find an error, yet the moment I add the ninth average number to the mean, I get the error that it cannot be divided by 0. > I trust this helps. Unfortunately not Brian, I will try and send the spreadsheet to you under separate cover. Regards Hylton - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc AVERAGE function faulty
Hi, I have an extensive spreadsheet on Calc 3.0 that contains many, many calculations, although none circular, to my knowledge. . I have merged a few cells and entered a SUM formula in there to provide a numerical result. I have a coloumn next to that that takes the AVERAGE of all the merged cells and represents it as a single number. I recently added a 10th merged cell to the AVERAGE formula and the result came back that it cannot divide by zero, however the result is far far away from zero if I calculate manually. I worked around the error by doing a SUM of the merged cells and then dividing by the number of merged cells and this displayed the correct answer. It would be nice to know that the functions included in Calc actually work though, without having to know a long work around. Any ideas? Regards Hylton PS: Spreadsheet can be mailed to you on request. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Exporting individual sheets Calc sheets to a Master Document?
Hi, How do I insert particular sheets from a Calc file into a Master document? Is this feature available or should I raise an RFE? If so where? I am using OOo.org 3.0 op openSuSE 11.0. Regards Hylton - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Master documents: Inserting a single tab from a multiple tab file
Hi, I am currently interested in keeping updated records of the rainfall that we receive in our suburb and then publishing the data to a Google Group all the suburban residents are members of. To draw the graphs, which include 4 years of data, I use Calc and have configured a number of sheets in a single Calc file to show what I want. When the information is ready to be published to the Google Group, I make a PDF of selected sheets and upload the PDF document to the Google Group.. I would like to see how many ppl are viewing the work I put in and have decided to use Google Analytics on the Files section of the Google Group. I will have to craft the HTML by hand so that I can insert the necessary tracking code Google Analytics needs but that I'll cover later. What I would really like to know how I can choose to insert particular sheets from a Calc file into a Master document? Is this feature available or should I raise an RFE? If so where? I am using OOo.org 3.0 op openSuSE 11.0. Regards Hylton - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Multi-format document?
2009/1/3 Brian Barker : > At 23:15 02/01/2009 +0200, Hylton Conacher wrote: >> >> I have a fellow openSusian who wants to create multi-format document. The >> first page or two would be cover letter. The later pages would be >> spreadsheets. Can that done in OO? > > Yes. > o Create your spreadsheet material as a spreadsheet document. > o Create your final document as a text document. > o Either copy and paste the spreadsheet material into your text document or > use Insert | Object > | OLE Object... . > o If you now double-click the incorporated spreadsheet material you will > find that you can edit it in place. > > By selecting the options available at Insert or at Paste Special, you can > incorporate either a frozen snapshot of the spreadsheet or else a live link > to the spreadsheet file. > > I trust this helps. Found a better resource ie Master Documents. Have a look here for an explanation: http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1230368,00.html Regards Hylton - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Multi-format document?
Hi all, I have a fellow openSusian who wants to create multi-format document. The first page or two would be cover letter. The later pages would be spreadsheets. Can that done in OO? Regards Hylton - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Secondary HDD as installation and update repository/source
I have opened a bug for this. You can view at https://bugzilla.novell.com/show_bug.cgi?id=293100 Vote for it and see it come alive :) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] I would like to be added to the mailing list
Ty Swales wrote: > I would like to help out where I can. Please add me to the mailing list. The addition, and removal, of your email address can only be done by you. To subscribe to the users mailing list at openoffice.org send an empty mail to [EMAIL PROTECTED] You will receive a message wishing to confirm your addition to the users list of the address you sent the request from. You will need to reply to this email and thereafter tyou should receive a welcome message and also start receiving email from the list. To unsubscribe you would need to send an email from the subscribed address to [EMAIL PROTECTED] and reply to the confirmation email to stop receiving group email. I hope this helps Regards Hylton - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] quick question about formula entering
Hi Jake, Tecmar wrote: > Is there a way in CALC to set it so a formula can start with the plus sign? > > It is so much easier as the plus sign is on the number pad. Office has > been doing this forever, am I missing something? I think you mean and equals sign ie = as opposed to +? To enter a formula in Excel and OO it needs to start with an equals sign. Please reply to [EMAIL PROTECTED],org Regards Hylton - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Identifying subscribed vs unsubscribed members
Aaahh, the guilty one speaks :) Klaas Visser wrote: > On 16-Apr-07 21:21 (+1000 UTC), *Hylton Conacher (ZR1HPC)* posted: > >> Something is screwy here, either with my filters or the list or summat >> else... > As the person in question, I can answer that . > > I use an IMAP account for this and a few other mailing lists. The > address is properly subscribed to the list. > > I use Thunderbird for all my emails, and I filter all the mail received > on the IMAP account to a number of folders in my local store (ie, it > moves them off the IMAP server and into Local Folders), just to make it > a little easier to sort through. Ditto on using TB. Why are you moving them off the IMAP store as that is what it is designed to do ie store email? My workstation is a caching mailserver (IMAP store) that collects mail from my ISP POP a/c and stores it. I read the emails on the 'server'. I have all my folders under the Inbox in TB and not under local folders. > However, because I'm no longer "in" the IMAP account, when I reply, it > uses my default email address, and I need to manually change it, before > sending. This is what happened in the above thread - I forgot to change > it before sending. Not changing an address has plagued us all at some time. :) > I thought it would bounce or die, and resent my reply using the > subscribed address. I was surprised to see the reply from my default > address actually show up, as well as my reply from the subscribed email > address. > > So sorry for the confusion, hope it all makes sense. It does now. Tnx for letting me know before I wrecked my OOo filter. Regards Hylton - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Identifying subscribed vs unsubscribed members
Something is screwy here, either with my filters or the list or summat else. To identify users who are not subscribed to the OOo-users list, I was informed by both CPH snd Peter Kupfer to look for the 'Delivered-To: moderator for users@openoffice.org' string. I set up a filter like that and presto the unsubbed users showed up in red so I was able to Cc them in offering a reply. My problem is that on a recent thread started by me on the 15/04/07 I had a reply from a supposed un-subscribed user, [EMAIL PROTECTED], as the entry showed up in red. My main concern is that the 'Delivered-To' string is not functioning as it should or there might be anoter rule/string I could add in to make the identifying of the unsubbed users more accurate. How is this possible? I can only guess that the responder (KA Visser) saw my entry in the archive, not been subscribed, but still sent a reply on that thread to the list? Is there something else that can be used to stop unsubbed users replying to subbed memers threads? Just curious - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc 2.04 cell colouring dependant on formula result - SOLVED
Johnny Andersson wrote: > 2007/4/15, Hylton Conacher (ZR1HPC) <[EMAIL PROTECTED]>: >> >> Klaas Visser wrote: >> > On 15-Apr-07 16:50 (+1000 UTC), *Hylton Conacher (ZR1HPC)* posted: >> > >> >> I have a formula in a cell >> >> (=SUM(Apr.D3:Apr.D30)/(COUNT(Apr.D3:Apr.D32)*30)*1000) and would like >> >> the cell background of that same cell change colour as the formula >> >> result changes. >> >> >> >> If the formula result is 0-758, the cell can be Light Green. If the >> >> value of the formaula is 751-900 the cell colour would be orange. If >> the >> >> formula result was over 1000 then the cell must be coloured Light Red. >> > > I'm glad you solved your problem. Just of curiosity, what will happen if > the > vallue is 901-999? > It would also be interesting to see what happens if the value is 751-758. I > think it will be Light Green, since only the first condition that match is > "executed". Tnx Johnny, It would seem that when I created the formatting, I erroneously didn't think of what would happen if the number was +-950. When tested the cell stayed white so I will need to tweak those conditional styles :) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc 2.04 cell colouring dependant on formula result - SOLVED
Klaas Visser wrote: > On 15-Apr-07 16:50 (+1000 UTC), *Hylton Conacher (ZR1HPC)* posted: > >> I have a formula in a cell >> (=SUM(Apr.D3:Apr.D30)/(COUNT(Apr.D3:Apr.D32)*30)*1000) and would like >> the cell background of that same cell change colour as the formula >> result changes. >> >> If the formula result is 0-758, the cell can be Light Green. If the >> value of the formaula is 751-900 the cell colour would be orange. If the >> formula result was over 1000 then the cell must be coloured Light Red. >> >> I was thinking of exploring the IF function but am not sure: >> >> 1. If this can be done >> 2. What the correct formula to use would be. >> >> Any thoughts/suggestions? >> > > I'd be using Conditional Formatting for this. > > Create three cell styles, one for each of the result states / fill colours. > > Go to Format | Conditional Formatting, and specify the appropriate cell > values, and the style to use in each case. Tnx Klaas, Once I had figured out how to make the three conditions I was able to set it up easily. Tnx Hylton - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Calc 2.04 cell colouring dependant on formula result
I have a formula in a cell (=SUM(Apr.D3:Apr.D30)/(COUNT(Apr.D3:Apr.D32)*30)*1000) and would like the cell background of that same cell change colour as the formula result changes. If the formula result is 0-758, the cell can be Light Green. If the value of the formaula is 751-900 the cell colour would be orange. If the formula result was over 1000 then the cell must be coloured Light Red. I was thinking of exploring the IF function but am not sure: 1. If this can be done 2. What the correct formula to use would be. Any thoughts/suggestions? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Varying sheet specific master formula?
TerryJ wrote: > > > Hylton Conacher(ZR1HPC) wrote: >> Sorry for the delay in replying. >> >> TerryJ wrote: >>> >>> Hylton Conacher(ZR1HPC) wrote: >>>> TerryJ wrote: >>>>> Hylton Conacher(ZR1HPC) wrote: >>>>>> Hi, >>>>>> >>>>>> I have a complex spreadsheet system ... >> >> >>>> If no one else has any ideas, I have decided to put up with changing the >>>> cell formula instead of linking them. The $ you mentioned, solved most >>>> problems, and the rest can seemingly only be sorted out via checking >>>> each sheet individually and adapting the formula therein as there re too >>>> many variables in the formulae. >>> You can't give up that easily. I have problems following Help and >>> HowTos. >>> If you ever try Linux, you will discover one of the most frustrating >>> experiences known to humankind is trying to make sense of "man" pages. >> I have been 'using' Linux for over a year, but have to admit mainly the >> KDE GUI. Those 'man' pages can sometimes be frightening :) >> >>> I find the best way to work out how to use something is to start trying. >>> This is a simple example: >>> >>> In Sheet1.A1 type some data. >> snip> >> >> I tried the example but got a couple of 502 errors. I gotta say the >> INDIRECT function seems nice but I am unsure how it is going to help me. >> To me it seems the INDIRECT function is referring to the value of >> another sheets cell but requires the referenced cell to be defined in >> another cell? >> >> I would assume that I could use the INDIRECT function on each sheet to >> create a link to the Master template formulae? The problem comes in >> where I must not use the data on the Master sheet but the data of the >> sheet where the formula is pasted. Seems to me like a copy and 'paste >> special' without selecting 'Link'. >> >>> Having said that, I should belatedly ask about your example >>> =Sum($Totals-.d2). Is the part of a sheet name >>> and >>> why use SUM for what seems to be a single cell? >> Sorry, error in the above formula. Copying the formula from cell E5 from >> the current sheet named(Apr) gives: >> >> =SUM(($Totals.B5-SUM(D3:D4))/(30-COUNT(D3:D4))) >> >> I still do not see how implementing the INDIRECT function is going to >> allow me to link to the Master sheet formulae but use the data from the >> sheet that the formula is pasted onto. >> >> > > Ok. I admit that I've got no idea now what you're trying to do. I take it > the document has changed since you provided a copy previously. How about > uploading a copy to http://www.mytempdir.com/ and providing a link. Not > everyone on the list wants to receive a copy. Not a bad idea at all. Tnx Terry. Users can now get the file with a file ID of 1282246. > When providing the link, please identify by name the sheet which is the > "master sheet". The Master sheet is named as such and is the second sheet in the file. :) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Varying sheet specific master formula?
Sorry for the delay in replying. TerryJ wrote: > > > Hylton Conacher(ZR1HPC) wrote: >> TerryJ wrote: >>> >>> Hylton Conacher(ZR1HPC) wrote: >>>> Hi, >>>> >>>> I have a complex spreadsheet system ... >> If no one else has any ideas, I have decided to put up with changing the >> cell formula instead of linking them. The $ you mentioned, solved most >> problems, and the rest can seemingly only be sorted out via checking >> each sheet individually and adapting the formula therein as there re too >> many variables in the formulae. > > You can't give up that easily. I have problems following Help and HowTos. > If you ever try Linux, you will discover one of the most frustrating > experiences known to humankind is trying to make sense of "man" pages. I have been 'using' Linux for over a year, but have to admit mainly the KDE GUI. Those 'man' pages can sometimes be frightening :) > I find the best way to work out how to use something is to start trying. > This is a simple example: > > In Sheet1.A1 type some data. snip> I tried the example but got a couple of 502 errors. I gotta say the INDIRECT function seems nice but I am unsure how it is going to help me. To me it seems the INDIRECT function is referring to the value of another sheets cell but requires the referenced cell to be defined in another cell? I would assume that I could use the INDIRECT function on each sheet to create a link to the Master template formulae? The problem comes in where I must not use the data on the Master sheet but the data of the sheet where the formula is pasted. Seems to me like a copy and 'paste special' without selecting 'Link'. > Having said that, I should belatedly ask about your example > =Sum($Totals-.d2). Is the part of a sheet name and > why use SUM for what seems to be a single cell? Sorry, error in the above formula. Copying the formula from cell E5 from the current sheet named(Apr) gives: =SUM(($Totals.B5-SUM(D3:D4))/(30-COUNT(D3:D4))) I still do not see how implementing the INDIRECT function is going to allow me to link to the Master sheet formulae but use the data from the sheet that the formula is pasted onto. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Calc 2.0 Link pasting error
I have an OOo Spreadsheet ods file that has several sheets in it. One of the sheets I have dedicated as a Master formula and format sheet that details the columns and formulae for each column as well as the colour of the text of the formulae answers and plain text headings. I copy and link a line of multicoloured text from the Master sheet into the other sheets but the pasted text colouring is the default colour(black) as opposed to the colour I have chosen(red) as well as the colour of the text in the Master sheet. When I link the text I choose to Paste special and unselect the 'Paste All' option, and only have 'Strings', 'Format' and 'Link' selected. How can I fix the problem? Can someone confirm for me that this does/doesn't exist in OOo 2.2 and if it does, how do I go about raising the issue for the developers to work on? Regards Hylton - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Varying sheet specific master formula?
TerryJ wrote:
>
>
> Hylton Conacher(ZR1HPC) wrote:
>> Hi,
>>
>> I have a complex spreadsheet system to calculate my expected ADSL usage
>> based on my previous usage.
>>
>> The speasheet has a master sheet, 12 monthly sheets, a total sheet, and
>> a number of sheets that contain graphs.
>>
>> The formulae on each month relate to data on that monthly sheet and the
>> formulae do not change much ie all the formula will depend on the number
>> of days in the month ie 28,29, 30, 31 but there basic structure will
>> stay the same. Each formula is pulling information from a particular
>> cell on the Totals sheet, per month, and then further calculating on it
>> using the dat on the current month sheet ie All the formulae in January
>> pull data from $totals.B1 and then further calculate it using
>> information on Jan sheet. ie cont..All the formuale in February pull
>> data from $totals.B2 and then further calculate it using information on
>> the Feb sheet.
>>
>> What I would like to do is have a Master sheet which contains all the
>> formulae (31 rows in total), that will allow for the linked formulae to
>> use the sheets data they are pasted onto e If I need to use the
>> formulae in another month then I would like to link the correct number
>> of cells, as per the number of days in the month, from the Master sheet
>> to the new month.
>> This way if there is a small change in the formula, I can change it on a
>> single sheet and that same change will be reflected on all of the 12
>> monthly sheets.
>>
>> This is however where the SNAFU comes in. I only want the formulae
>> pasted BUT I want to use the data on the sheet tey were pasted onto, not
>> the data from the Master sheet, which are all blank.
>>
>> I have thought about creating a HUGE master sheet with all the months
>> formulae listed but this does not help.
>>
>> The formulae are still using the data values from the Master sheet and
>> not from the month onto which the formulae were posted.
>>
>> I was thinking of a formula syntax that will change as it is pasted onto
>> each sheet ie on the Jan sheet it might be =Sum($Totals-.d2)
>> where > =Sum($Totals-.d2) where would be Feb.
>>
>> Any ideas. If you need to get an idea of the spreadsheet, please ask for
>> it and I will mail it to you.
>>
>> Regards
>> Hylton
>>
>>
>
> I take it that what you call the "master sheet" is a template. I suggest
> you have a look at the INDIRECT function. That would enable you to have the
> name of the month in a set cell in each month's sheet - say A1. Your
> formula (obviously you need to work out the details) would be something
> like:
> A1 contains February. B1 contains =INDIRECT("$Totals." & A1 & "D2") - you
> do not need to use SUM for a single cell.
>
> Help contains an example if you need to use SUM with INDIRECT.
>
> Perhaps you need to reorganise the document. I would have thought the
> Totals sheet should contain a summary of the contents of the various monthly
> sheets. Still, I don't have the full picture and don't necessarily want it.
Wow that INDIRECT function is a SERIOUS mother of a formula and I have
to admit, even after reading teh help 4 times, I was still confused :)
If no one else has any ideas, I have decided to put up with changing the
cell formula instead of linking them. The $ you mentioned, solved most
problems, and the rest can seemingly only be sorted out via checking
each sheet individually and adapting the formula therein as there re too
many variables in the formulae.
Tnx
Hylton
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[users] Varying sheet specific master formula?
Hi, I have a complex spreadsheet system to calculate my expected ADSL usage based on my previous usage. The speasheet has a master sheet, 12 monthly sheets, a total sheet, and a number of sheets that contain graphs. The formulae on each month relate to data on that monthly sheet and the formulae do not change much ie all the formula will depend on the number of days in the month ie 28,29, 30, 31 but there basic structure will stay the same. Each formula is pulling information from a particular cell on the Totals sheet, per month, and then further calculating on it using the dat on the current month sheet ie All the formulae in January pull data from $totals.B1 and then further calculate it using information on Jan sheet. ie cont..All the formuale in February pull data from $totals.B2 and then further calculate it using information on the Feb sheet. What I would like to do is have a Master sheet which contains all the formulae (31 rows in total), that will allow for the linked formulae to use the sheets data they are pasted onto e If I need to use the formulae in another month then I would like to link the correct number of cells, as per the number of days in the month, from the Master sheet to the new month. This way if there is a small change in the formula, I can change it on a single sheet and that same change will be reflected on all of the 12 monthly sheets. This is however where the SNAFU comes in. I only want the formulae pasted BUT I want to use the data on the sheet tey were pasted onto, not the data from the Master sheet, which are all blank. I have thought about creating a HUGE master sheet with all the months formulae listed but this does not help. The formulae are still using the data values from the Master sheet and not from the month onto which the formulae were posted. I was thinking of a formula syntax that will change as it is pasted onto each sheet ie on the Jan sheet it might be =Sum($Totals-.d2) where .d2) where would be Feb. Any ideas. If you need to get an idea of the spreadsheet, please ask for it and I will mail it to you. Regards Hylton - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Question regarding Word
Hi Monica, monica karpinski wrote: > Hi I am using OpenOffice for Word Processing, and have saved my files, > in what I thought was MicroSoft Word. > I sent my resume to a friend to look over and she was not able to open > the file with a message appearing as such: > > You should only open attachments from a trustworthy source. Attachment: > Monica_Karpinski_Resume_1.odt from Hi-Message (HTML) > Would you like to open the file or save to your computer? OpenOffice Writer saves files in its own format as a default (odt) and only a similar version of OpenOffice will be able to view those files. What I would suggest to you is to keep the original document in OpenOffice format on your machine as a master document and then also create a copy in Microsoft Word format. You can create a MS Word readable file by opening you master document i.e. the resume with the odt extension, then choose File -> Save As. On the windows that pops up you will see a white space next to something called Location. You need to insert the name of the file here i.e. Monica_Karpinski_Resume_1 Directly below that there is a Filter. Click once on the filter, directly under the file name and you will see a list of formats the file can be saved in. Select the Microsoft Word 97/2000/XP one make sure there is a cross on the box next to 'Automatic File Name Extension'. Now click 'OK' and the file will be saved in the directory you specified, with the file name you specified and with a .doc extension. Send this file as your attachment and the recipient is sure to be able to read it. Hope that helps and best of luck in getting employed. Please reply to users@openoffice.org Regards Hylton - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OO Calc 2.04 Cell linking and Copy and Paste error
TerryJ wrote:
>
>
> Hylton Conacher(ZR1HPC) wrote:
>> TerryJ wrote:
>>>
>>> Calc is behaving normally and appropriately. This requires a simple
>>> amendment of the formulas. The sheet references in the formulas should
>>> be
>>> absolute, not relative.
>> I do not understand the difference between a relative and an absolute
>> formula. Can you give an example of a relative formula and then the same
>> formula in absolute syntax?
>>
>> Please indicate where on the spreadsheet there are relative formulae and
>> what the syntax would be to correct them to absolute formulae.
>>
>> Tnx
>> Hylton
>>
>>
>
> This is the example you gave:
>
> - - - - - quote - - - - -
> The formula for E3 as per the master is =SUM((Totals.B5-D2))/(31-0) yet the
> formula in E3 in April Month is =SUM(('Monthly usage'.B5-D2))/(31-0)
> - - - end quote - - -
>
> What you need to do is insert a $ before the sheet name so that the above
> formula reads:
> =SUM(($Totals.B5-D2))/(31-0) . If you do that, the sheet name will not
> change when you copy the formula to another sheet.
>
> You can change references to various shades of absolute and relative with a
> keyboard shortcut (by default SHIFT+F4, not now working on my system for
> some unknown reason). Look in the Help index under "absolute addresses in
> spreadsheets".
Tnx Terry.
The & solved the main problem of cell sheet references changing. I have
identified another issue which I wil start a new thread for.
Rgards
Hylton
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OO Calc 2.04 Cell linking and Copy and Paste error
TomW wrote:
> TerryJ wrote:
>>
>> TomW-3 wrote:
>>> Hylton Conacher (ZR1HPC) wrote:
>>>> TerryJ wrote:
>>>>> Hylton Conacher(ZR1HPC) wrote:
>>>> Hi Terry,
>>>>
>>>> I am Cc'ing you the spreadsheet file so that you can see wheat I mean.
>>>>
>>>> As a test copy the cell range of E3:G35 from the Master tab and paste
>>>> them into a forthcoming month sheet in exactly the same place ie
>>>> starting at E3.
>>>>
>>>> The formula for E3 as per the master is =SUM((Totals.B5-D2))/(31-0) yet
>>>> the formula in E3 in April Month is =SUM(('Monthly
>>>> usage'.B5-D2))/(31-0)
>>>>
>>>> See how a cell reference has changed which I do not want/need to
>>>> happen.
>>>> ie Totals' has become 'Monthly usage'.
>>>>
>>>> I am happy to change the Master tab each month, copy the formulae and
>>>> then work in the monthly sheet. By doing this I cannot link the
>>>> cells to
>>>> the Master tab as it changes once a month. ie B4 becomes B5 when we
>>>> move
>>>> from March to April.
>>>>
>>>> Further input?
>>>>
>>>> Hylton
>>>>
>>>
>>> Using the workbook you attached on your 3/20/07 6:24am e-mail. (Date
>>> received in Thunderbird)
>>>
>>> Calc does behave very strangely when pasting cells with links to
>>> other worksheets. It is not keeping track of links correctly. I
>>> tried a number of different scenarios with copying cells with links
>>> and duplicating worksheets.
>>>
>>> If you duplicate a worksheet, the links will not be correct, unless
>>> the worksheet is duplicated just to the right of the parent
>>> worksheet. Any other location to the right of the 'parent' will give
>>> #REF! error.
>>>
>>> If you duplicated the worksheet to the left of the 'parent', the
>>> linked cell reference will be to the worksheet to the left of the
>>> last worksheet, in this case 'Mar'. This progression of the link
>>> reference will continue to shift left for any duplication to the left
>>> of the 'parent' (If you duplicate the worksheet 5 worksheets to the
>>> left of the 'parent', the linked cell reference will be shifted the
>>> same amount.)
>>>
>>> If you try to 'copy'/'paste from the parent to the 'copied'
>>> worksheet, the pasted cell links will reference the next worksheet
>>> beyond the 'Totals' tab.
>>>
>>> If you paste to any other worksheet, I get the #REF! error.
>>>
>>> Once you duplicate a worksheet you can move it around in the workbook
>>> with no reference issues as long as you do not 'paste' any cells that
>>> reference the 'Totals' worksheet.
>>>
>>> I have not tried to duplicate these issues in any other workbook to
>>> see if it is related only to this particular workbook or my OO
>>> application.
>>>
>>> TomW
>>> WinXP SP2 OO 2.1
>>>
>>>
>>
>> Calc is behaving normally and appropriately. This requires a simple
>> amendment of the formulas. The sheet references in the formulas
>> should be
>> absolute, not relative.
>
> I find this behavior illogical. Maybe it is my MS background with
> Excel. I would expect that when I link a cell to another worksheet,
> that the reference would be to that sheet and not to its tab position in
> the workbook
I too have had many years of Excel use and therefore cannot understand
why the referenced cell in a particular worksheet is changing the sheet
of the referenced cell.
Do/where do I log an error about the 'feature'?
Regards
Hylton
P.S: Anyone wanting the spreadsheet only has to ask for it.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OO Calc 2.04 Cell linking and Copy and Paste error
TerryJ wrote:
>
> TomW-3 wrote:
>> Hylton Conacher (ZR1HPC) wrote:
>>> TerryJ wrote:
>>>> Hylton Conacher(ZR1HPC) wrote:
>>> Hi Terry,
>>>
>>> I am Cc'ing you the spreadsheet file so that you can see wheat I mean.
>>>
>>> As a test copy the cell range of E3:G35 from the Master tab and paste
>>> them into a forthcoming month sheet in exactly the same place ie
>>> starting at E3.
>>>
>>> The formula for E3 as per the master is =SUM((Totals.B5-D2))/(31-0) yet
>>> the formula in E3 in April Month is =SUM(('Monthly usage'.B5-D2))/(31-0)
>>>
>>> See how a cell reference has changed which I do not want/need to happen.
>>> ie Totals' has become 'Monthly usage'.
>>>
>>> I am happy to change the Master tab each month, copy the formulae and
>>> then work in the monthly sheet. By doing this I cannot link the cells to
>>> the Master tab as it changes once a month. ie B4 becomes B5 when we move
>>> from March to April.
>>>
>>> Further input?
>>>
>>> Hylton
>>>
>>
>> Using the workbook you attached on your 3/20/07 6:24am e-mail. (Date
>> received in Thunderbird)
>>
>> Calc does behave very strangely when pasting cells with links to other
>> worksheets. It is not keeping track of links correctly. I tried a
>> number of different scenarios with copying cells with links and
>> duplicating worksheets.
>>
>> If you duplicate a worksheet, the links will not be correct, unless the
>> worksheet is duplicated just to the right of the parent worksheet. Any
>> other location to the right of the 'parent' will give #REF! error.
>>
>> If you duplicated the worksheet to the left of the 'parent', the linked
>> cell reference will be to the worksheet to the left of the last
>> worksheet, in this case 'Mar'. This progression of the link reference
>> will continue to shift left for any duplication to the left of the
>> 'parent' (If you duplicate the worksheet 5 worksheets to the left of the
>> 'parent', the linked cell reference will be shifted the same amount.)
>>
>> If you try to 'copy'/'paste from the parent to the 'copied' worksheet,
>> the pasted cell links will reference the next worksheet beyond the
>> 'Totals' tab.
>>
>> If you paste to any other worksheet, I get the #REF! error.
>>
>> Once you duplicate a worksheet you can move it around in the workbook
>> with no reference issues as long as you do not 'paste' any cells that
>> reference the 'Totals' worksheet.
>>
>> I have not tried to duplicate these issues in any other workbook to see
>> if it is related only to this particular workbook or my OO application.
>>
>> TomW
>> WinXP SP2 OO 2.1
>>
>>
>
> Calc is behaving normally and appropriately. This requires a simple
> amendment of the formulas. The sheet references in the formulas should be
> absolute, not relative.
I do not understand the difference between a relative and an absolute
formula. Can you give an example of a relative formula and then the same
formula in absolute syntax?
Please indicate where on the spreadsheet there are relative formulae and
what the syntax would be to correct them to absolute formulae.
Tnx
Hylton
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OO Calc 2.04 Cell linking and Copy and Paste error
Pradeep Srinivas wrote: > On Thursday 22 Mar 2007, Hylton Conacher (ZR1HPC) wrote (regarding Re: > [users] > OO Calc 2.04 Cell linking and Copy and Paste error): >> Pradeep Srinivas wrote: > <> > > Hylton: > Sorry, I tried to recreate your problem, and therein a solution. I regret I > could not find a suitable solution to your problem (in fact, I created some > for myself !!!) Pradeep, Tnx for trying. You may not have solved the problem. Your offer of assistance was appreciated. > My apologies for wasting your time. The time was not wasted, it was used by you and me in trying to solve the problem. Regards Hylton - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Excel macros
Jan Altman wrote: > Will Excel macros work in the Open Office spreadsheet program? > > I am curious about *both* VBA macros, and those written with Excel 4's > original macro language. In short NO. Openoffice,org has its own macro language I believe. Regards Hylton Please reply to users@openoffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OO Calc 2.04 Cell linking and Copy and Paste error
TerryJ wrote:
>
>
> Hylton Conacher(ZR1HPC) wrote:
>> TerryJ wrote:
>>> Hylton Conacher(ZR1HPC) wrote:
>>>> Hi,
>>>>
>>>> I have an extensive spreadsheet which I use to monitor my ADSL usage on
>>>> a monthly basis. Asides from a tab for each month I also have a Master
>>>> tab and the tabs for the graphs I have drawn from the data. All the
>>>> monthly sheets have the same layout as the master tab so therefore
>>>> changing the master tab would allow me to have a single source to copy
>>>> from so that I could paste in all the months tabs to reflect the new
>>>> data set-up/formula.
>>>>
>>>> What I would like to be able to do is link all the monthly static tab
>>>> details to my master sheet i.e. column headings and formulae but this
>>>> does not seem possible, or rather is possible with Paste..Special..Link
>>>> but then the actual data values, all being zero in my Master tab are
>>>> carried forward to wherever I have pasted the link and the data in the
>>>> monthly tab is not used.
>>>>
>>>> To try and get around this error I copied parts of the Master tab and
>>>> pasted it onto the monthly tab. This also did not work as the cell
>>>> references in the formulae I had in the Master tab changed to different
>>>> values when I pasted them.
>>>>
>>>> If anybody wants the spreadsheet concerned or if I can upload it to a
>>>> central bugs repository, please let me know where or what your email
>>>> address is.
>>>>
>>>> Regards
>>>> Hylton
>>>> Using OpenSUSE 10.2 with KDE
>>>>
>>>>
>>> I suggest that, instead of using the "master tab" as your template, you
>>> create a separate sheet as a template and copy that each time you need a
>>> new
>>> sheet. It could be hidden when not required.
>> I'm confused as I am already doing this, or did I misunderstand?
>>
>> Each new sheet is opened in a new tab ie I have 12 tabs, one for each
>> month. There is another tab('Master') which holds all the formula that
>> need to be addplied to each monthly range of data. and there are
>> additional tabs for the graphs I have drawn.
>>
>> The problem is copying the cells from the 'Master' tab and pasting them
>> into each month as the cell references in the formula change ie with no
>> data the formula in the 'Master' tab and any of the monthly tabs is
>> different.
>>
>> Regards
>> Hylton
>>
>>
>
> My suggestion was to avoid the need to copy formulas from the "master tab" -
> your formulas would be in the template. I probably do not understand what
> you mean by "master tab" - perhaps it refers to a template sheet rather than
> a sheet which contains summaries of data on the other sheets?
>
> Could you give an example of a formula and how it is changing when you copy
> it. So far, I cannot reproduce the problem. The formulas
> =COUNTIF($D$1:$D$26;$D1) (absolute references) and
> =SUM(OFFSET(A1;1;0;1;$A$1)) (mixed references) both copy without change from
> one sheet to another in my test document.
>
> You may have to have the template in another document and use Insert >Sheet
> from file.
>
Hi Terry,
I am Cc'ing you the spreadsheet file so that you can see wheat I mean.
As a test copy the cell range of E3:G35 from the Master tab and paste
them into a forthcoming month sheet in exactly the same place ie
starting at E3.
The formula for E3 as per the master is =SUM((Totals.B5-D2))/(31-0) yet
the formula in E3 in April Month is =SUM(('Monthly usage'.B5-D2))/(31-0)
See how a cell reference has changed which I do not want/need to happen.
ie Totals' has become 'Monthly usage'.
I am happy to change the Master tab each month, copy the formulae and
then work in the monthly sheet. By doing this I cannot link the cells to
the Master tab as it changes once a month. ie B4 becomes B5 when we move
from March to April.
Further input?
Hylton
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OO Calc 2.04 Cell linking and Copy and Paste error
TerryJ wrote:
>
> Hylton Conacher(ZR1HPC) wrote:
>> Hi,
>>
>> I have an extensive spreadsheet which I use to monitor my ADSL usage on
>> a monthly basis. Asides from a tab for each month I also have a Master
>> tab and the tabs for the graphs I have drawn from the data. All the
>> monthly sheets have the same layout as the master tab so therefore
>> changing the master tab would allow me to have a single source to copy
>> from so that I could paste in all the months tabs to reflect the new
>> data set-up/formula.
>>
>> What I would like to be able to do is link all the monthly static tab
>> details to my master sheet i.e. column headings and formulae but this
>> does not seem possible, or rather is possible with Paste..Special..Link
>> but then the actual data values, all being zero in my Master tab are
>> carried forward to wherever I have pasted the link and the data in the
>> monthly tab is not used.
>>
>> To try and get around this error I copied parts of the Master tab and
>> pasted it onto the monthly tab. This also did not work as the cell
>> references in the formulae I had in the Master tab changed to different
>> values when I pasted them.
>>
>> If anybody wants the spreadsheet concerned or if I can upload it to a
>> central bugs repository, please let me know where or what your email
>> address is.
>>
>> Regards
>> Hylton
>> Using OpenSUSE 10.2 with KDE
>>
>>
>
> I suggest that, instead of using the "master tab" as your template, you
> create a separate sheet as a template and copy that each time you need a new
> sheet. It could be hidden when not required.
I'm confused as I am already doing this, or did I misunderstand?
Each new sheet is opened in a new tab ie I have 12 tabs, one for each
month. There is another tab('Master') which holds all the formula that
need to be addplied to each monthly range of data. and there are
additional tabs for the graphs I have drawn.
The problem is copying the cells from the 'Master' tab and pasting them
into each month as the cell references in the formula change ie with no
data the formula in the 'Master' tab and any of the monthly tabs is
different.
Regards
Hylton
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[users] OO Calc 2.04 Cell linking and Copy and Paste error
Hi, I have an extensive spreadsheet which I use to monitor my ADSL usage on a monthly basis. Asides from a tab for each month I also have a Master tab and the tabs for the graphs I have drawn from the data. All the monthly sheets have the same layout as the master tab so therefore changing the master tab would allow me to have a single source to copy from so that I could paste in all the months tabs to reflect the new data set-up/formula. What I would like to be able to do is link all the monthly static tab details to my master sheet i.e. column headings and formulae but this does not seem possible, or rather is possible with Paste..Special..Link but then the actual data values, all being zero in my Master tab are carried forward to wherever I have pasted the link and the data in the monthly tab is not used. To try and get around this error I copied parts of the Master tab and pasted it onto the monthly tab. This also did not work as the cell references in the formulae I had in the Master tab changed to different values when I pasted them. If anybody wants the spreadsheet concerned or if I can upload it to a central bugs repository, please let me know where or what your email address is. Regards Hylton Using OpenSUSE 10.2 with KDE - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Testing the Gmail filter for OO.o
Peter Kupfer wrote: [EMAIL PROTECTED] wrote: If hack's Gmail marks this as an unsubscribed email, I might just put together a how-to on filtering unsubscribed OO.o mailing listers in the Gmail web interface. -hackmiester Mine showed you as unsubscribed. Ditto here. Remember hackmeister the email address that you are subscribed to the list with must have the filter. -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] WHOA!! OO.o mailing list grows up a little?
hackmeister, hackmiester wrote: [snip] I told it to filter any messages that contain the phrase "moderator for users@openoffice.org". I'll be testing that with my other email, [EMAIL PROTECTED] Having posed a VERY similar if not the same question a few days/weeks back, here is my solution for Mozilla 1.4: 1. Once your email client is open, perhaps even GMail, Create a filter called OOo unsubbed users 2. Edit that filter so that the 'Delivered-To' field contains the word moderator. You will have to customise the field and add it in EXACTLY as above( sans quotes). 3. Move the messages to your normal Users folder but mark them as important. With the above I have all my messages threaded and the moment I get to an unsubbed user, the message shows up in red, which is a personal reminder to also Cc the user if replying to it. [snip] Hope that helps -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Aborting a document save
I have a document whose data changes daily via my personal editing. At times I manually click on the floppy disk icon to start saving the document. No problem so far, except that the save takes about 2 mins to complete. As it is saving I might see a single character or number that needs changing. How do I abort the current saving process so that I can make the change and reinstitute the save. I am currently using OOo 1.1.3 Is this perhaps available in later versions or should I perhaps raise an RFE? -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OpenOffice.org Knowledgebase reaches 500
Jonathon Coombes wrote: Hi All, Just a quick note to let you know that the OOo Knowledgebase now contains over 500 possible question and answers. The good part is, the software can try and deduce answers to new questions from existing ones. So have a look and provide the feedback for it to learn. Also, the OOo Tips feed is going slow, but steady, so if you have a good tip, please include it in appropriate tags in your email. If you are unsure how this works, just have a quick look back in the mailing list archives for examples. And where might I find it. I assuming from the same question I asked on the 10th of Feb 2005. Telling us all a knowledgebase is available is great but knowing where to find the knowledgebase is key to getting folk to use it. Can I/we assume the Knowledgebase is still at http://mindmeld.cybersite.com.au ?? -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc Doesn't Load CSV File
Hi Jim, J Shank wrote: I use OpenOffice version 1.1.4 with Microsoft XP-Home on an HP 3200+ with 512 MB. I am trying to open a .csv file in Calc. According to the OpenOffice Help documentation, Calc should invoke the TextImport dialog; however, when I open the file, it appears in the Text Document module rather than Calc and the TextImport dialog never appears. Although I have Excel (97 SR2) I don't want to have to load it into Excel and then save in .xls format, then load it into OpenOffice. That seems to be a very long way around this problem. What then is the simplest way to load the data into OpenOffice Calc? The easiest way if you have a text file that won't import into Calc is to go into Windows Explorer and locate the file and change its extension to .csv Then Calc will most definitely open it. Hope it helps -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Mozilla-Ooffice-Integration: no window comes up
Hi Bertram, Bertram Franz wrote: Hi, Is there anyone who could give me some hints how to troubleshoot OOo 1.1.3 on Linux and why it does not open a window when started by mozilla (where does the window go?). The window opens up in your current Mozilla Navigator session or in a new OpenOffice window if started from Mozilla Messenger. (Is this the wrong list for troubleshooting questions?) Perfectly correct list. Just make sure you subscribe by sending a blank email to [EMAIL PROTECTED] to get the rest of the answers as people reply to your query. You will need to confirm your subscription by replying to the confirmation email sent to the address you sent the subscribe request from, but once that is done you are subscribed. Hope it helps [snip] -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Importing Files
Hi Marcelo, [EMAIL PROTECTED] wrote: I need very much of help in importing text file into OpenOffice Calc, because i have a text file with fixed width columns, and the numbers are thousand separated by "," and decimal separated by "," and i'm not able to import it into OpenOffice Calc, with the numbers as numbers. The important thing in importing text or csv files into any spreadsheet or even database program, is the character that separates the fields. This character MUST be unique to the data being imported. Available field separators are , ; : TAB etc. I have found that the semi colon is the best field separator as even in URLs might contain a : but after 6 years never have I seen a URL contain a ; So your data, if opened in a text file editor would look like this: Field1;Numb.er1;Field3;Fi'el,d4; etc See after each Field on Number there is a unique field separator that does not appear anywhere in my data. Hope this helps -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Single chart for multiple sheets?
Hi, OOo 1.1.3 Calc charts I have 12 Calc sheets which each has data that must be displayed on a single chart on sheet 13. Let us assume that I need to chart the columns B,J, and K on each of the twelve sheets up to line 33 ie b1:b33 et al. The 12 resultant graphs must reside on a single chart on a separate sheet(13) so I can see how each compared with each other. I would assume that I would just need to specify the chart range for each of the 12 sheets ie Jan.B1:B33;Feb;Mar.;April etc but it does not work. How can I accomplish this? -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Can't change Printer settings of V1.1.3 when V1.1.4 is installed to
Martin Deppe wrote: Thank you G. Roderick Singleton, I know that you/we are volunteers here. I simply thought I would get some help here as it worked before. So, sorry and thank you for replying! [snip] Suse packages their own release of OOo so I haven't a clue. Please try asking on a Suse list/newsgroup. You wouldn't happen to have a Link eventually? But I'll try that! Send an email to [EMAIL PROTECTED] to subscribe to the SuSE Linux English list. Reply to the confirmation email and you're subscribed and can post and get lots and lots of additional info. This SLE list is also a high volume list and you can expect about as many messages, if not more, from this list than from this Users list. [BIG snip] -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: DATABASE SOFTWARE
Rod Engelsman wrote: Chris BONDE wrote: I am not sure what this means? Are you saying that MySQL is free but not that good, so people use spreadsheets. Or what. Chris MySQL is free. MySQL is a fantastic piece of software. But for the uses that a lot of people want a database, MySQL is like taking an 18-wheeler to get groceries. Here, here and very descriptive. :) Here's the big difference in my eyes between something like MySQL and Access -- and you would have had to use both to realize this: Install MSO Pro with Access. Go to Start => All Programs => (wherever) => Microsoft Access. You can immediately construct a new database using drag 'n drop, fill-in-the-blank, GUI stuff. You can construct a useful implementation without knowing a damn thing about SQL, OBDC or any of that mess. Those tools are available if you need them, but they aren't necessary to get going. From what I have seen on this list it is not the database itself that is causing the problem, it is the lack of a user interface or GUI front end and understanding required to install and make it work similar to M$ Access. In my opinion if the the MySQL database back end had a GUI like Access does, there would be far fewer questions on the list about an Access lookalike. all the users want to do is point, click, install and use the database without having to know how to drive an 18-wheeler to skin a cat just the way you like it. :) To my knowledge there are database front-ends like Rekall but I have not seen or experimented with it/them. [snip] -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Differentiating between subscribed and unsubscribed users
Anthony Chilco wrote: Hi Hylton, I'm using Mozilla 1.7.5 but it should work with 1.4. I just did this: Create a new account using users@openoffice.org as your email address. Don't worry too much about the pop and smtp info as you won't be downloading mail with it. I created a new account but it had to have a space value in the POP field. Set the 'reply to' address to [EMAIL PROTECTED] Uncheck the 'check mail every ..' box. Change your 'unsubscribed' filter to move the mail to the inbox of this new account. Anything you reply to from that inbox will fill in the 'reply to' and 'to' field with [EMAIL PROTECTED] I moved you message to that inbox and replied to it to test. I just have to figure out how to get the 'cc' field filled. :-) p.s. where's .za? tc Hylton Conacher (ZR1HPC) wrote: CPH wrote: On Monday 14 February 2005 15:44, Hylton Conacher (ZR1HPC) wrote: Hi, [snip] If you can give me something to look for in the headers that the filters will pick up, I'll gladly setup a filter this side to flag them and therefore let me know to CC the user. Easy, look for the field "Delivered-To" which has the value "moderator". I also explicitly set the "Reply-to" field to be users@openoffice.org so that the unsubscribed poster will reply only to the mailing list. Aaahh, Now I understand why it is done. So that the unsubbed user doesn't use the moderator as their 'personal OOo helper'. I would assume that if they then reply to the list from the email you sent them that they would be forwareded a message about subscribing to the list, accessing the archives etc, etc. I have set up a filter to look for moderator in the Delivered-to. How can I set the 'Reply-to' to [EMAIL PROTECTED] if I reply to the unsubbed users email that is in a different folder in my Mozilla 1.4 mail client, WITHOUT affecting the rest of my email folders. -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Differentiating between subscribed and unsubscribed users
CPH wrote: On Monday 14 February 2005 15:44, Hylton Conacher (ZR1HPC) wrote: Hi, [snip] If you can give me something to look for in the headers that the filters will pick up, I'll gladly setup a filter this side to flag them and therefore let me know to CC the user. Easy, look for the field "Delivered-To" which has the value "moderator". Tnx CPH. It would seem though that I have a filter as above it isn't perfect as Anthony Chilco, who seems to be a subscriber, had one on his emails struck in the unsubbed folder. Would that be because he maybe replied to an unsubbed user? [snip] -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Differentiating between subscribed and unsubscribed users
Anthony Chilco wrote: Hi Hylton, I'm using Mozilla 1.7.5 but it should work with 1.4. I just did this: Create a new account using users@openoffice.org as your email address. Don't worry too much about the pop and smtp info as you won't be downloading mail with it. Set the 'reply to' address to [EMAIL PROTECTED] Uncheck the 'check mail every ..' box. Change your 'unsubscribed' filter to move the mail to the inbox of this new account. Anything you reply to from that inbox will fill in the 'reply to' and 'to' field with [EMAIL PROTECTED] I moved you message to that inbox and replied to it to test. Well I received 2 of the same message :) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Differentiating between subscribed and unsubscribed users
Anthony Chilco wrote: > Hi Hylton, > I'm using Mozilla 1.7.5 but it should work with 1.4. I just did this: > Create a new account using users@openoffice.org as your email address. > Don't worry too much about the pop and smtp info as you won't be > downloading mail with it. > Set the 'reply to' address to [EMAIL PROTECTED] > Uncheck the 'check mail every ..' box. > Change your 'unsubscribed' filter to move the mail to the inbox of this > new account. > Anything you reply to from that inbox will fill in the 'reply to' and > 'to' field with [EMAIL PROTECTED] > I moved you message to that inbox and replied to it to test. > I just have to figure out how to get the 'cc' field filled. :-) All done, will check when I next download. > p.s. where's .za? .za = South Africa -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc: Stripping Numerics from alphanumerics strings and calculating
Anthony Chilco wrote:
Hi Hylton,
Hi Anthony,
Please bottom post in future.
=VALUE(MID(E17;1;FIND("m";E17)-1))+VALUE(MID(E17;FIND("
";E17)+1;FIND("s";E17)-FIND(" ";E17)-1))/60
should work.
Should and does in most cases, but sometimes doesn't ie if the initial
value is 0 or the value is similar to 1h 6m 02s . I decided that in
future I'll just calculate it manually. It also means I don't have to
edit a 4 foot long formula, which I have to admit I barely understand :)
Thanks though.
--
Hylton Conacher - Linux user # 229959 at http://counter.li.org
Currently using SuSE 9.0 Professional with KDE 3.1
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
[users] Calc: Stripping Numerics from alphanumerics strings and calculating
I have a many fields in the format of '21m 52s', with different values before the m and s. I would like to convert this time to a decimal value ie (52/60)+21. I can do this manually but I wondered if there was a way to do it automagically. I was thinking along the lines of using left, right and search but my mind maxed out and ran out of processing power. SUM(LEFT(E17;2):(RIGHT(e17;1))) But if I use the Left or right alone I get Left: 21 (Correct) Right: s (Wrong - It should read 52) (Tried changing the '1' to a '3' but it didn't help. The first part acts OK and can be added to the second part but it is getting the second part right and dividing it by 60 before adding it to the first part that is causing the problems. any ideas/solutions from the list?. -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Differentiating between subscribed and unsubscribed users
CPH wrote: On Monday 14 February 2005 15:44, Hylton Conacher (ZR1HPC) wrote: Hi, [snip] If you can give me something to look for in the headers that the filters will pick up, I'll gladly setup a filter this side to flag them and therefore let me know to CC the user. Easy, look for the field "Delivered-To" which has the value "moderator". I also explicitly set the "Reply-to" field to be users@openoffice.org so that the unsubscribed poster will reply only to the mailing list. Aaahh, Now I understand why it is done. So that the unsubbed user doesn't use the moderator as their 'personal OOo helper'. I would assume that if they then reply to the list from the email you sent them that they would be forwareded a message about subscribing to the list, accessing the archives etc, etc. I have set up a filter to look for moderator in the Delivered-to. How can I set the 'Reply-to' to [EMAIL PROTECTED] if I reply to the unsubbed users email that is in a different folder in my Mozilla 1.4 mail client, WITHOUT affecting the rest of my email folders. -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Differentiating between subscribed and unsubscribed users
Javier Rivera wrote: Hylton Conacher (ZR1HPC) escribió: A problem comes in, specifically for users like myself, who do not have the latest and greatest Mozilla/Thunderbird package or the understanding to download, compile and install it Usually you don't need to compile it. Since you're using linux you probably can obtain it with the package manager of your distro. Or you can download the tarball from http://www.mozilla.org , it's a windows-like installer. I'll try it, but hope it doesn't break anything. I am using Mozilla 1.4 and do not have the full headers displaying when I read email offline. It's a quite old version. Well thankfully this isn't M$ where you have to have the latest and greatest. :) If you can give me something to look for in the headers that the filters will pick up, I can't remenber how Mozilla 1.4 worked. You need to look for this heading: Delivered-To: moderator for users@openoffice.org [snip] Thank you for the HOWTO, It is the same on Mozilla 1.4. I've set the filter up so I'll see tonight when I download all those unsubbed user emails :) I'm working with the spanish version of Thunderbird, so the name of the menus or items can be somewhat different in your version (I'm translating them from Spanish). Your Spanish-English translation is better than most people can speak it. I personally did not notice any glaring errors. :) -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Differentiating between subscribed and unsubscribed users
Hi, I have been querying why the list has to receive two copies of the same email if a user is unsubscribed. One or two of the moderators have basically said that the way it is now, is the way it stays. For ease of understanding, it is assumed therefore that they will continue to let the unsubscribed user know that his/her question was answered by sending a repeat of an earlier mailing list message to them directly as well as to the list. What I would like to do is setup a filter to either put those unsubscribed users in another folder or at least make them differently from the other messages in the Users folder. A problem comes in, specifically for users like myself, who do not have the latest and greatest Mozilla/Thunderbird package or the understanding to download, compile and install it and therefore cannot determine if the person is subscribed or not. What would Mozilla look for as it filters and marks the incoming mail to make it different to the other received email in the folder. I am using Mozilla 1.4 and do not have the full headers displaying when I read email offline. If you can give me something to look for in the headers that the filters will pick up, I'll gladly setup a filter this side to flag them and therefore let me know to CC the user. -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Goto page x
> Paul wrote: On Sat, 12 Feb 2005 22:41:03 +, Mr. J. K M. McKean <[EMAIL PROTECTED]> wrote: Could anyone tell me how to goto a specific page in a document? Creating a macro to open Navigator, double clicking on a bookmark, and closing Navigator doesn't solve this. Thanks, Jerome K Maule M^c Kean Paul wrote: It is on the navigator. There is a field into which you can type the page number you want to go to and push enter. For more details on the navigator have a look at the help contents. According to the help there is also this method of moving to another page : To quickly move the cursor to another page while you are in a document, press ShiftCtrl+F5, type the number of the page that you want to jump to, and then wait a few seconds. HTH, Paul PAul, Al CTRL-SHIFT-F5 does is bring up the Navigator. I think the original poster, and myself now, was/are looking for a function that is available on M$O ie a 'Go to page' option, where a person can just enter a page number and be taken to it. -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Off-list: RE: forwarding unsubscribed posters responses
Peter Kupfer wrote:
Hylton Conacher (ZR1HPC) wrote:
{BIG SNIP}
I know this is a nuisance, but as far as I can tell, it is the best
system for all. What would help most, is if people that are here a lot
would make sure that they cc unsubsribed users.
All noted and agreed Peter, but I wasn't taking a particular pick on
you. CPH, Now there's a target :) CPH is a person not to be fscked with,
he just has too much power.
For ease of navigation during the archive I'll start a new thread titled
'Differentiating between subscribed and unsubscribed users'.
Tnx Peter et al
--
Hylton Conacher - Linux user # 229959 at http://counter.li.org
Currently using SuSE 9.0 Professional with KDE 3.1
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OpenOffice.org Knowledgebase
Jonathon Coombes wrote: Hi All, Apologies if you were trying to access the knowledgebase the last two days. I forgot to update some settings and I took the database for the tips away. This stopped the system from working and put and error instead. The good news is it is all fixed now, just that there is not tips currently display. Otherwise it works fine. So please have a look, give feedback to the questions both good and bad, and contribute questions and answers of your own. And the URL for the knowledgebase is, besides of course searching for it on http://www.openoffice.org ? -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] OOo upgrade (1.1.0 to 1.1.3)
Just like to report to the archives that I did an upgrade of my OOo installation on SuSE 9.0 from 1.1.0 to 1.1.3 on the 9.2 CD set I have. I had no problems, barring a few icon changes and some settings not being ported between versions but otherwise HAPPY DAYS. NICE Work DEVELOPERS, and the little people(application testers)!! I'm really looking forward to the improvements in 2.0 with the next SuSE as opening a file was faster. I haven't so far not experienced any problems with OOo 1.1.3 and Mozilla 1.4 either, although a 2400pg file is slowing the system response whilst working on Mozilla 1.4, but that's probably due to formatting. Very nice :)) -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Off-list: RE: forwarding unsubscribed posters responses
Peter Kupfer wrote: Hylton Conacher (ZR1HPC) wrote: I have just seen another reason why I should migrate to Thunderbird from Mozilla mail :), but I wonder what the purpose is of telling the list subscribers that an 'unwashed' person is not subscribed. Personally I couldn't give a hoot if they are or not. It is not meant to be a calling out. I do it, because that is what others do. Aahh, 'the sheep thing'. :) It makes sense though. It explains why the user has an unexpected e-mail from someone they haven't heard of in their inbox. Yes and No. It makes sense, I suppose to the unsubscribed user but it is a nuisance to those who receive email from this busy list. If they have the opportunity to post to the list from the web whilst not being a subscriber, perhaps rather send their message through as the list does now, but automate the sending of the normal 'As you are not subscribed you may not have seen..'. Not all replies to a topic need to go back to the poster, How come? Surely if they asked a question they should get a reply on it? ... and some come through with just the moderated subject, it would not work out particularly well. Agreed it does not work too well :) Perhaps a RFE needs to be requested on the OOo site? Should I post one? Also, there is an automated e-mail that goes out the user to tell them they are not subscribed when they post their message. OK. Or if that cannot be done then if the moderators feel the need to tell someone that they need to subscribe ala 'As you are not subscribed you may not have seen..', then rather just send the message to the original poster. The people on the list already have seen the posters message and do not need the additional traffic, especially those on dial-up. Why do they need to know that someone isn't subscribed? Sure its handy if they see the moderators note before replying to the message but otherwise? This is done, I would imagine, so that when the user replies, it goes back to the list instead of to the person that tried to help. ok. But it would be nice if the [users] list didn't have to receive 2 copies of the same reply to an unsubbed users query. Rather put in the forwarded answer to the unsubbed user that they must only reply to users@openoffice.org as all other communication will be ignored. The 'moderators' could even create a new account in their email programs that says the email is from [EMAIL PROTECTED] Then when the users reply it automatically goes to the list. [snip] So as an example and to re-iterate my point: 1) An unsubbed user has a OOo problem and poses a question on the OOo website. 2) Their message is forwarded through to the [users] list and a message informing them that they are not subscribed is also sent to them, telling them that they are not subscribed and will therefore most likely miss the responses unless they Google for them in the archive using 'site:lists.suse.com '. 3) A subbed users member then replies to the [users] query but does not see/know that the unsubbed user was indeed unsubbed, and therefore only replies to [users]. 4) A moderator then sees that the query was raised by an unsubbed member and therefore forwards the answer to them and the [users] list. Step 3 + 4 result in a duplicate copy of the same answer on the [users] list, Why? Rather just enter the unsubbed users' email in the To: field and leave [users] out of receiving the same email again as they have already seen it. -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Off-list: RE: forwarding unsubscribed posters responses
CPH wrote: On Tuesday 01 February 2005 09:39, Hylton Conacher (ZR1HPC) wrote: [snip] I wonder what the purpose is of telling the list subscribers that an 'unwashed' person is not subscribed. Personally I couldn't give a hoot if they are or not. If they have the opportunity to post to the list from the web whilst not being a subscriber, perhaps rather send their message through as the list does now, but automate the sending of the normal 'As you are not subscribed you may not have seen..'. I have a system to also do this. Fantastic! What would be needed to implement it to only send the unsubbed user a notification advising the user how to retrieve the article response from the archives. Or if that cannot be done then if the moderators feel the need to tell someone that they need to subscribe ala 'As you are not subscribed you may not have seen..', then rather just send the message to the original poster. The people on the list already have seen the posters message and do not need the additional traffic, especially those on dial-up. Why do they need to know that someone isn't subscribed? Sure its handy if they see the moderators note before replying to the message but otherwise? It's also a reminder to those who reply to unsubscribed users so that they can make sure that in future their message actually gets to the users. Please do not forget that many users are not advanced and really do appreicate the fact that we do CC: them. The service of advising the users that they may have missed answers to their question is great, but the list itself does not need to see the email that the unsubbed user receives ie 'As you are not subscribed you may not have seen this reply to your question.' All it does is increase duplicate list traffic as the answer goes through the list twice ie once, as though the unsubbed user was subbed and then again when you send it to them telling them that they probably missed the answer. I am all for telling them that they missed the answer and forwarding the answer onto them but such an email does not need to pass through the [users] list. In all honesty, if they want help, which we gladly provide, they are free to ask away however why have the [users] subscribers having to suffer the additional traffic of the moderators telling them they missed a reply. Rather just send it directly to the unsubbed user and do not Cc the list as we have already seen the answer. See teh number of "Thanks you's" on the list or replies *only* when the user is CC:ed. Oh I have seen them and do not want to stop them, all I am asking is that the notification to them not include the list address in the To: or Cc: field. BTW: have a look in the archive to see previous discussions on this. Sorry can't do. I am on expensive dialup and would need to remain connected for a substantial time. Asides what could I search for at Google? site:lists.suse.com "unsubbed replies" The notification about someone not being subscribed is by no means anything to do with OOo. Personally I think the OOo web page should be changed to allow people to submit via the web BUT warn them that they will not receive any replies unless they are subscribed to the list ie subscribe to the list and then ask the question. Your help would be greatly appreciated in helping to set this up or to improve the situation. Whom should I consult with, Daniel Carerra, one of the OOo web developers, other moderators? Any names/contact details you want to send me privately? -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Off-list: RE: forwarding unsubscribed posters responses
Crystle Numan wrote: On Sun, 2005-01-30 at 10:06 +1100, Brian wrote: Hi Crystle, I often see you forwarding posts with the message "As you are not subscribed, you may not have seen:", like the one below. Is there a better way for me/us to handle these? When the subjecy contains [users][moderated] should I/we post also to the author? Regards Brian Brian: (I'm replying to the list so that others will know). Thanks for asking! I do this because I'm trying to help the moderators (GRS & CPH). If I notice someone responds to another who is not subscribed, I do this. To tell if someone is not subscribed: look for the "Delivered-To: moderator for users@openoffice.org" header (third Delivered-To: header). I do this by setting a filter to mark those purple in my evolution. Generally, it is best to reply to these people through the list, cc-ing their address. The [users][moderator] is not always correct; the header is correct always. Anyone who wants to chime in to set me straight if I've got the proper etiquette wrong, please do. I have just seen another reason why I should migrate to Thunderbird from Mozilla mail :), but I wonder what the purpose is of telling the list subscribers that an 'unwashed' person is not subscribed. Personally I couldn't give a hoot if they are or not. If they have the opportunity to post to the list from the web whilst not being a subscriber, perhaps rather send their message through as the list does now, but automate the sending of the normal 'As you are not subscribed you may not have seen..'. Or if that cannot be done then if the moderators feel the need to tell someone that they need to subscribe ala 'As you are not subscribed you may not have seen..', then rather just send the message to the original poster. The people on the list already have seen the posters message and do not need the additional traffic, especially those on dial-up. Why do they need to know that someone isn't subscribed? Sure its handy if they see the moderators note before replying to the message but otherwise? The notification about someone not being subscribed is by no means anything to do with OOo. Personally I think the OOo web page should be changed to allow people to submit via the web BUT warn them that they will not receive any replies unless they are subscribed to the list ie subscribe to the list and then ask the question. Comments Moderators? Regards -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Cell linked to another in another sheet does not update
Nick Cooper wrote: This problem seems so basic that I must be missing something!... I'm an experienced Excel user (to a basic level), but new user of Open Office, forgive me! In Open Office, if I open Sheet 1 and Sheet 2, and make a cell in Sheet 1 refer to a cell in Sheet 2, it works OK. But if the contents of that cell in Sheet 2 then change, even while both sheets are open, and saved, Sheet 1 does not reflect that change. Be careful of circular references ie cell A1 on Sheet 2 is equal to cell A1 on sheet 1, which is equal to cell A1 on sheet 2. I have gone to Tools/Options/Spreadsheet/General and selected "Always" on Update links when opening, but to no avail. Even if both sheets are closed and reopened, the change in Sheet 2 is not reflected on cell 1. What data changes ie do you enter it or is it calculated? ie SUM? My own suggestion would be to have sheet 1 as your data sheet and have sheet 2 take data from sheet 1 or any other sheet. Do not however make sheet 1 get the same values from sheet 2. Hope it helps. -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Statistical Functions
Smith, Herb wrote: Hi all, Hello Herb, I'm interested in making use of the statistical functions discussed in the Help pages for the spreadsheet. It seems that these functions are not actually available for use in the spreadsheet, or at least I could not find out how to access them. Can someone shed some light on this? I'm new to the list, so I'm sorry if this is an old issue. I am sure we could send you to the list archivers and ask you to use Google to search them, but to me that method is unfriendly and doesn't get your problem solved as quickly as you'd like or inform others on the list who might have a similar problem. What I can say is that the statistical functions listed in the Help are indeed available for your use in a spreadsheet. So that we the members of this list can help you further, we would normally need further information. Please tell us what operating system you are using and also what version of OpenOffice.org as well, accessed by clicking 'Help'-'About OpenOffice.org' in OpenOffice. To my knowledge though all the mentioned statistical formulae can be accessed by clicking on the AutoPilot button(to the left of the Sigma or SUM sign). clicking this will then list a windows with two tabs being function and Structure. Just below the tabs is a drop down list box that you can choose what category of formula you would like to create. Select the 'Statistical' category and the list of functions will be displayed. Double clicking on one of them will present you with a dialog on the right hand side asking you to fill in details. Herb has been CC'd just in case he is not a subscriber. -- Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc: Not opwning the linked DDE files
Mark Kirchner wrote: On Monday, January 17, 2005, 3:54:51 PM, G. Roderick Singleton wrote: On Mon, 2005-01-17 at 07:33 +0200, Hylton Conacher (ZR1HPC) wrote: Using OOo 1.1.0 Is there a way to stop opening the sxc files that you have DDE links from ie A has links to data from B,C,D. When opening A I get asked if I want o t refresh the links. Saying 'yes' opens all the linked files (B,C,D) too. The first thing you should do is get the latest release. 1.1.0 is KNOWN to have problems and is replaced by 1.1.4. Until you test with 1.1.4 it is doubtful we can help very much. Tnx GRS. As it is a KNOWN error you would think it would be fixed in future releases right? As Mark points out this same behaviour is prevalent in the improved 1.1.4 edition. Thanks Mark for confirming it exists in 1.1.4. I wonder if anyone running the 'bleeding edge' stuff can also comment, as it sure would be nice to have 2.0 'on par' with MS Office. Well, this bug / annoyance / whatever-you-may-call-it also exists in 1.1.4. For linking single cells in a calc document, I use this workaround: Tnx again Mark for the workaround. I'll definitely investigate it. [snip] -- The Little Helper Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 Licenced Windows user - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc will not allow DDE Link pasting-SOLVED
Hylton Conacher (ZR1HPC) wrote: I have a total of 3 spreadsheets files with a summary sheet in each containing DDE links to other sheets within same same sxc file. I would now like to create a master summary sxc file with sheets showing where the data came from ie links, and then the totals on each summary page need to be DDE linked to another sheet within that sxc file so that the overall trend can be seen. To ease your understanding: File A.sxc contains 13 sheets of which the last is a summary of the totals in the previous 12 sheets File B.sxc contains 13 sheets of which the last is a summary of the totals in the previous 12 sheets File C.sxc contains 13 sheets of which the last is a summary of the totals in the previous 12 sheets I now want to create D.sxc which is a summary of the files A:C. Whilst I can quite easily copy and paste a DDE link of the files summary pages into sheets 1-3, I cannot copy or paste the summary totals into a 4th sheet as a summary of summaries. The sxc file(summary of summaries) is approximately 40k and each of files a-c are 35-50k each. I am using OOo 1.1.0 and whilst I know this is an old version and I should update, I feel that I might have stumbled upon an error even prevalent in the 'pre 2.0' release. I would be happy to send the file/s to anyone that asks so that they may try it on a 'pre 2.0' release and see if this is indeed a problem. DDE is Dynamic Data Exchange I believe and is a format created by our favourite Redmond Gate to enable data interchange between apps ie Excel and Word. The above problem seemed to stem from the fact that I was trying to create DDE links from DDE links, without a file opening in the interim. This has been solved by linking directly to the external sheets and not first linking them into a new worksheet and then DDE linking them from a sheet in the same workbook. Hopefully OOo 2.0 will not open the linked files when a file with linked data in it is opened ie open D and also get A,B,C opening as well. Can anyone comment on this sort of behaviour in 'pre-release' versions of 2.0? -- The Little Helper Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 Licenced Windows user - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Calc: Not opwning the linked DDE files
Using OOo 1.1.0 Is there a way to stop opening the sxc files that you have DDE links from ie A has links to data from B,C,D. When opening A I get asked if I want o t refresh the links. Saying 'yes' opens all the linked files (B,C,D) too. -- The Little Helper Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 Licenced Windows user - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Calc will not allow DDE Link pasting
I have a total of 3 spreadsheets files with a summary sheet in each containing DDE links to other sheets within same same sxc file. I would now like to create a master summary sxc file with sheets showing where the data came from ie links, and then the totals on each summary page need to be DDE linked to another sheet within that sxc file so that the overall trend can be seen. To ease your understanding: File A.sxc contains 13 sheets of which the last is a summary of the totals in the previous 12 sheets File B.sxc contains 13 sheets of which the last is a summary of the totals in the previous 12 sheets File C.sxc contains 13 sheets of which the last is a summary of the totals in the previous 12 sheets I now want to create D.sxc which is a summary of the files A:C. Whilst I can quite easily copy and paste a DDE link of the files summary pages into sheets 1-3, I cannot copy or paste the summary totals into a 4th sheet as a summary of summaries. The sxc file(summary of summaries) is approximately 40k and each of files a-c are 35-50k each. I am using OOo 1.1.0 and whilst I know this is an old version and I should update, I feel that I might have stumbled upon an error even prevalent in the 'pre 2.0' release. I would be happy to send the file/s to anyone that asks so that they may try it on a 'pre 2.0' release and see if this is indeed a problem. -- The Little Helper Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 Licenced Windows user - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
