Re: [graphics-users] File format change demand for regression curve (trend line)
Hi Stephan, On 07/03/09 22:07, Stephan van den Akker wrote: Thanks for the information, Ingrid. Reading this, I have some more questions: - What is blocking this issue from entering ODF now? The OASIS committee is still busy with finalizing ODF 1.2. During this period additional feature changes are postponed. - What happens after ODF 1.2? I heard talk of a full revision (ODF 2.0). That sounds to me like something that takes years. Will there be an faster 1.3 round where the new regression curves can be introduced? As far as I know there is no decision about that yet. My personal expectation is that after 1.2 is finished there will be committee drafts for the future version that can be worked with even before the future version is absolutely final. Kind regards, Ingrid Greetings, Stephan van den Akker - To unsubscribe, e-mail: users-unsubscr...@graphics.openoffice.org For additional commands, e-mail: users-h...@graphics.openoffice.org
Re: [graphics-users] File format change demand for regression curve (trend line)
Hi Ingrid, Is the proposal for regression curves ready to go into the next draft of ODF? Stephan van den Akker - To unsubscribe, e-mail: users-unsubscr...@graphics.openoffice.org For additional commands, e-mail: users-h...@graphics.openoffice.org
Re: [users] Re: [Resolved?] Re: Major data loss: Calc formatting numbers
Is there a particular version they were using (between x and y) that they noticed the issue? I can only test from 2.4.1 to current. Thanks, Gary. The problem was just noticed last week, already on 3.1. I should note that I insist that this is an OOo issue because I have had a similar problem, also on a spreadsheet that was created in OOo 2.x. However, I do have backups so when I get to my mother-in-law's place (I only keep the latest backup on-site) I intend to copy those backups and see exactly where the problem occured. When I know more I will file an issue and report back. Thank you! -- Dotan Cohen http://what-is-what.com http://gibberish.co.il - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: [Resolved?] Re: Major data loss: Calc formatting numbers
OK - done. I suspect operator error and/or some other problem with your rounding issue. I have tested (as you suggested: quote in 2.x try entering this into a cell: 317907977. Open it and modify in a later version of 2.x then in 3.0 then 3.1. See if it rounds up. /quote with WinXPPro: 2.4.1 == 2.4.2 == 3.0.0 == 3.1.0 No rounding errors, no issues. I created a file for each version can send to you directly if you wish. Thanks. Send to me the latest, I will see if it rounds here and at the Latet office. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: 答复: [users] uno python/calc
Am Montag, den 06.07.2009, 11:55 +0800 schrieb 陈浩(Chen Hao): Johnny Rosenberg sent this to the list ,months age . I think maybe it's what you need. 2009/5/22 陈浩(Chen Hao) chen@neusoft.com: When I use the MS-Excel , I offen use Ctrl+; to insert the current date to a cell or after some strings in a cell. But i find OOo-Calc did not supply this function or I haven't found it. So i want to write a Macro to do this , but there are two problems , and i think maybe someone could give me a hand. 1. how to get the current selected cell with basic ? So that i could modify it . 2. how to change the path that saving the user-defined macros? I offen forgot to backup those things in C-disk when i reinstall my Windows OS _ Thanks very much! Chen Hao Dalian , China Here's a macro I fou(nd in a forum somewhere: REM * BASIC * Option Explicit Sub InsertDate Dim oCell As Object oCell=ThisComponent.getCurrentController().getSelection() If oCell.SupportsService(com.sun.star.sheet.SheetCell) Then ' Selection is a single cell oCell.setValue(Now()) Else MsgBox You can't do that here EndIf End Sub So obviously the currently selected cell is ThisComponent.getCurrentController().getSelection() To get the current stuff from it there are things liks getValue() and getString(). To change the value, you can use, for example, setValue(47.3) and setString(Hello World) respectively. I think there are also a getFormula() and setFormula() available, but I am not sure. Use Xray to find out what methods are available for a specific object. It's the most helpful tool I used so far with OpenOffice.org BASIC. I think it is installed by default these days, if not you can find it somewhere, use google… Well, I guess you got it by now. Johnny Rosenberg -邮件原件- 发件人: Julius [mailto:julius.jungh...@gmx.de] 发送时间: 2009年7月5日 1:36 收件人: users@openoffice.org 主题: [users] uno python/calc Hi, i found this example http://www.linuxjournal.com/content/python-pyuno-hello-world-addon-openoffic e there they select a cell with: cell = sheets.getByIndex(0).getCellByPosition(0, 0) How can i select a cell in calc and then run my script with that cells location as argument? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org --- Confidentiality Notice: The information contained in this e-mail and any accompanying attachment(s) is intended only for the use of the intended recipient and may be confidential and/or privileged of Neusoft Corporation, its subsidiaries and/or its affiliates. If any reader of this communication is not the intended recipient, unauthorized use, forwarding, printing, storing, disclosure or copying is strictly prohibited, and may be unlawful.If you have received this communication in error,please immediately notify the sender by return e-mail, and delete the original message and all copies from your system. Thank you. --- Ah, thx. Yes the method is available in pyuno. greets - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Major data loss: Calc formatting numbers
Robin Laing wrote: I have used OOo since before it was OOo. I have not lost data due to the software in any case. As for data in spreadsheets. I don't agree with using information on users being stored in a spreadsheet. It isn't what it was designed for. It makes it to easy for a simple user error to make a mistake and corrupt the data. I'm a bit confused by the statement about how information on users shouldn't be stored in a spreadsheet, because it is so easy to corrupt the data. Does this suggest that the only information that should be put in a spreadsheet is data where it doesn't matter if it gets corrupted? If so, that would significantly reduce the usefulness of spreadsheets. I assume there is some key point that I'm missing, so please enlighten thanks. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Major data loss: Calc formatting numbers
Richard Detwiler wrote: Robin Laing wrote: I have used OOo since before it was OOo. I have not lost data due to the software in any case. As for data in spreadsheets. I don't agree with using information on users being stored in a spreadsheet. It isn't what it was designed for. It makes it to easy for a simple user error to make a mistake and corrupt the data. I'm a bit confused by the statement about how information on users shouldn't be stored in a spreadsheet, because it is so easy to corrupt the data. Does this suggest that the only information that should be put in a spreadsheet is data where it doesn't matter if it gets corrupted? If so, that would significantly reduce the usefulness of spreadsheets. I assume there is some key point that I'm missing, so please enlighten thanks. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Basically a database is for storing and retrieving information. A spreadsheet is primarily for performing calculations on data. In common usage, people have come to use spreadsheets to store information because the learning curve is much shallower than learning to work with a database. -- Gene Y. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Major data loss: Calc formatting numbers
On Mon, 6 Jul 2009, Gene Young wrote: Richard Detwiler wrote: I'm a bit confused by the statement about how information on users shouldn't be stored in a spreadsheet, because it is so easy to corrupt the data. Does this suggest that the only information that should be put in a spreadsheet is data where it doesn't matter if it gets corrupted? If so, that would significantly reduce the usefulness of spreadsheets. I assume there is some key point that I'm missing, so please enlighten thanks. Basically a database is for storing and retrieving information. A spreadsheet is primarily for performing calculations on data. In common usage, people have come to use spreadsheets to store information because the learning curve is much shallower than learning to work with a database. The answer you stated addresses why people tend to use spreadsheets to store data. What I would like to know is why you think information in a spreadsheet can be corrupted more easily than that in a data base. As the previous said: I assume there is some key point that I'm missing, so please enlighten -- Bob Holtzman AF9D 8760 0CFA F95A 6C77 E125 BF90 580F 8D54 9279 If you think you're getting free lunch, check the price of the beer - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Major data loss: Calc formatting numbers
Robert Holtzman wrote: On Mon, 6 Jul 2009, Gene Young wrote: Richard Detwiler wrote: I'm a bit confused by the statement about how information on users shouldn't be stored in a spreadsheet, because it is so easy to corrupt the data. Does this suggest that the only information that should be put in a spreadsheet is data where it doesn't matter if it gets corrupted? If so, that would significantly reduce the usefulness of spreadsheets. I assume there is some key point that I'm missing, so please enlighten thanks. Basically a database is for storing and retrieving information. A spreadsheet is primarily for performing calculations on data. In common usage, people have come to use spreadsheets to store information because the learning curve is much shallower than learning to work with a database. The answer you stated addresses why people tend to use spreadsheets to store data. What I would like to know is why you think information in a spreadsheet can be corrupted more easily than that in a data base. As the previous said: I assume there is some key point that I'm missing, so please enlighten People do not generally protect data in a spreadsheet, so every time it is opened by another user, there is the risk that that user might accidentally (or deliberately) change something. Perhaps they have their own favorite formats they want to see the spread sheet in. Maybe they prefer everything in 14 point Albertus Medium. They may apply a style to the sheet that gives that appearance and inadvertantly change some other format that isn't readily apparent until someone notices that the wrong numbers are rounded inappropriately. There are many scenarios that are less than pleasant. In a properly designed database that possibility is reduced. Not eliminated, but definitely reduced. -- Gene Y. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Return Receipt (displayed) - [users] Re: Windows 7 Upgrade Advisor says OO.o won't install.
On 06/07/09 04:58, davidbtea...@verizon.net wrote: This is a Return Receipt for the mail that you sent to davidbtea...@verizon.net. Note: This Return Receipt only acknowledges that the message was displayed on the recipient's computer. There is no guarantee that the recipient has read or understood the message contents. Mr. Teague, please stop your mail system sending receipts to this list. We get enough noise as it is. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Return Receipt (displayed) - [users] Re: Windows 7 Upgrade Advisor says OO.o won't install.
On 06/07/09 04:58, davidbtea...@verizon.net wrote: This is a Return Receipt for the mail that you sent to davidbtea...@verizon.net. Note: This Return Receipt only acknowledges that the message was displayed on the recipient's computer. There is no guarantee that the recipient has read or understood the message contents. Mr. Teague, please reconfigure your mail system so that it does not send receipts to this list. We get enough noise as it is. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Keyboard Shortcuts
I don't see a limited list; indeed, the list appears much larger than anything that can be obtained by default using the mouse. What was meant, I assume, was that one cannot add their own key-bindings. I perceive this as a problem as well: ... ctrl-f to move forward one character, ... This is at Navigate | Go Right. It is bound to the right-arrow key by default. How does one bind this function (Go Right) to ctrl-f? I have no ctrl-f in the list of key bindings. http://www.nabble.com/file/p24360905/Picture%2B1.png -- View this message in context: http://www.nabble.com/Keyboard-Shortcuts-tp22236277p24360905.html Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
RE: [users] Return Receipt (displayed) - [users] Re: Windows 7 Upgrade Advisor says OO.o won't install.
-Original Message- From: Harold Fuchs [mailto:hwfa.openoff...@googlemail.com] [...] On 06/07/09 04:58, davidbtea...@verizon.net wrote: This is a Return Receipt for the mail that you sent to davidbtea...@verizon.net. Note: This Return Receipt only acknowledges that the message was displayed on the recipient's computer. There is no guarantee that the recipient has read or understood the message contents. Mr. Teague, please stop your mail system sending receipts to this list. We get enough noise as it is. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org Mr. Fuchs, There is no guarantee that Mr. Teague has read or understood your message content. gdrh - Kevin (possibly safely out of reach in Ottawa, Canada) The information contained in this electronic mail transmission may be privileged and confidential, and therefore, protected from disclosure. If you have received this communication in error, please notify us immediately by replying to this message and deleting it from your computer without copying or disclosing it. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Major data loss: Calc formatting numbers
Gene Young wrote: Richard Detwiler wrote: Robin Laing wrote: I have used OOo since before it was OOo. I have not lost data due to the software in any case. As for data in spreadsheets. I don't agree with using information on users being stored in a spreadsheet. It isn't what it was designed for. It makes it to easy for a simple user error to make a mistake and corrupt the data. I'm a bit confused by the statement about how information on users shouldn't be stored in a spreadsheet, because it is so easy to corrupt the data. Does this suggest that the only information that should be put in a spreadsheet is data where it doesn't matter if it gets corrupted? If so, that would significantly reduce the usefulness of spreadsheets. I assume there is some key point that I'm missing, so please enlighten thanks. Basically a database is for storing and retrieving information. A spreadsheet is primarily for performing calculations on data. In common usage, people have come to use spreadsheets to store information because the learning curve is much shallower than learning to work with a database. Also, a database can have fields, records and other areas locked to protect data from user input or changes. Spreadsheets can be sort of locked but that isn't perfect either as I have seen so many times in my work. A find and replace in a spreadsheet can be very dangerous if used wrong. A find and replace in a database is much harder to do outside the current open record. Also, linking between data fields is much easier in a database. I agree that most users know how to use a spreadsheet and have to learn a data base program. It is well worth the time to learn how to use a database program for storing records like employee information. -- Robin Laing - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Keyboard Shortcuts
At 11:51 06/07/2009 -0700, Rusonly Moronly wrote: What was meant, I assume, was that one cannot add their own key-bindings. I perceive this as a problem as well: ... ctrl-f to move forward one character, ... This is at Navigate | Go Right. It is bound to the right-arrow key by default. How does one bind this function (Go Right) to ctrl-f? I have no ctrl-f in the list of key bindings. Really? o If you want the binding to work in one component only - perhaps Writer or Calc - open a document of that type. o Go to Tools | Customize... | Keyboard. o At the top right, select OpenOffice.org or the component, as appropriate. o Under Category, select Navigate. o Under Function, select Go Right. o In the Shortcut keys panel, scroll down to and select Ctrl+F. o Click Modify. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Return Receipt (displayed) - [users] Re: Windows 7 Upgrade Advisor says OO.o won't install.
Harold Fuchs wrote: On 06/07/09 04:58, davidbtea...@verizon.net wrote: This is a Return Receipt for the mail that you sent to davidbtea...@verizon.net. Note: This Return Receipt only acknowledges that the message was displayed on the recipient's computer. There is no guarantee that the recipient has read or understood the message contents. Mr. Teague, please reconfigure your mail system so that it does not send receipts to this list. We get enough noise as it is. Mr Fuchs, I do not now and I have never caused email to request read-receipts for messages. Such things are a waste of everyone's time and resources. I get the noise just as you do, and in fact you have generated a bit of it yourself. You generated a bit of this noise. You made several unnecessary requests to the list about this. I suggest you read your messages more carefully, give your answer more thought and make such complaints in off-list email to the real offender. A request person, privately, (you have my email address) would have been sufficient, and would have produced less noise for everyone. I did however respond to such a request, and it appears that is what you are complaining about. I did not originate the request. I repeat, you should read your email a bit more carefully. David Teague - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Major data loss: Calc formatting numbers
Q) As for data in spreadsheets. I don't agree with using information on users being stored in a spreadsheet. It isn't what it was designed for. It makes it to easy for a simple user error to make a mistake and corrupt the data. A) That is what this organization does. They have pretty good reasons for not using Base or Access. This is not the place to discuss their strategies, however, rather how we can help them achieve the goals that they have set for themselves. An Q A: The answer is from Dotan himself in an other mail here at the forum... We all know that a database is made for, well, databases... but in this case it´s not suitable /( sorry Dotan if I took the liberty to give this answer, but can´t they read the mail you wrote earlier ???);-) / // Per Robin Laing skrev: Gene Young wrote: Richard Detwiler wrote: Robin Laing wrote: I have used OOo since before it was OOo. I have not lost data due to the software in any case. As for data in spreadsheets. I don't agree with using information on users being stored in a spreadsheet. It isn't what it was designed for. It makes it to easy for a simple user error to make a mistake and corrupt the data. I'm a bit confused by the statement about how information on users shouldn't be stored in a spreadsheet, because it is so easy to corrupt the data. Does this suggest that the only information that should be put in a spreadsheet is data where it doesn't matter if it gets corrupted? If so, that would significantly reduce the usefulness of spreadsheets. I assume there is some key point that I'm missing, so please enlighten thanks. Basically a database is for storing and retrieving information. A spreadsheet is primarily for performing calculations on data. In common usage, people have come to use spreadsheets to store information because the learning curve is much shallower than learning to work with a database. Also, a database can have fields, records and other areas locked to protect data from user input or changes. Spreadsheets can be sort of locked but that isn't perfect either as I have seen so many times in my work. A find and replace in a spreadsheet can be very dangerous if used wrong. A find and replace in a database is much harder to do outside the current open record. Also, linking between data fields is much easier in a database. I agree that most users know how to use a spreadsheet and have to learn a data base program. It is well worth the time to learn how to use a database program for storing records like employee information.
[users] Re: Return Receipt (displayed) - [users] Re: Windows 7 Upgrade Advisor says OO.o won't install.
On 2009/07/06 3:00 PM David B Teague wrote: Mr Fuchs, I do not now and I have never caused email to request read-receipts for messages. Such things are a waste of everyone's time and resources. I get the noise just as you do, and in fact you have generated a bit of it yourself. Reread the thread. You did not request a read-receipt, you sent a return receipt. Here is the message you sent: From: davidbtea...@verizon.net Newsgroups: gmane.comp.openoffice.questions Subject: Return Receipt (displayed) - [users] Re: Windows 7 Upgrade Advisor says OO.o won't install. Date: Sun, 05 Jul 2009 23:58:47 -0400 This is a Return Receipt for the mail that you sent to davidbtea...@verizon.net. Note: This Return Receipt only acknowledges that the message was displayed on the recipient's computer. There is no guarantee that the recipient has read or understood the message contents. You generated a bit of this noise. You made several unnecessary requests to the list about this. I suggest you read your messages more carefully, give your answer more thought and make such complaints in off-list email to the real offender. He made two postings requesting that you do not send receipts.I'd suggest you read them more carefully. He asked you to not send receipts to this list, which you had done. You are the real offender. Your sent the receipt he is writing about. I did however respond to such a request, and it appears that is what you are complaining about. I did not originate the request. I repeat, you should read your email a bit more carefully. He did not say you sent the request. You did send the reply, which he complained about. It is your fault and responsibility for sending a reply to the request to this list. Take responsibility for your own actions and learn to read more carefully before telling others to do so. -- Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Major data loss: Calc formatting numbers
Per wrote: Q) As for data in spreadsheets. I don't agree with using information on users being stored in a spreadsheet. It isn't what it was designed for. It makes it to easy for a simple user error to make a mistake and corrupt the data. A) That is what this organization does. They have pretty good reasons for not using Base or Access. This is not the place to discuss their strategies, however, Why not? This is a users group and the question was asked by Richard Detwiler as to why not to store data in a spreadsheet? It might be stretched that he hijacked the thread but it is pertinent to the original problem and this forum is for users to help users. rather how we can help them achieve the goals that they have set for themselves. An Q A: The answer is from Dotan himself in an other mail here at the forum... We all know that a database is made for, well, databases... but in this case it´s not suitable /( sorry Dotan if I took the liberty to give this answer, but can´t they read the mail you wrote earlier ???);-) / Can't you read the email you are quoting? Do not be so quick to criticize others. We all understand that Dotan's hands are tied. We were not suggesting that he force his friends to use Base. Merely discussing the pros and cons for someone who asked. // Per Robin Laing skrev: Gene Young wrote: Richard Detwiler wrote: Robin Laing wrote: I have used OOo since before it was OOo. I have not lost data due to the software in any case. As for data in spreadsheets. I don't agree with using information on users being stored in a spreadsheet. It isn't what it was designed for. It makes it to easy for a simple user error to make a mistake and corrupt the data. Note the question to which we responded: I'm a bit confused by the statement about how information on users shouldn't be stored in a spreadsheet, because it is so easy to corrupt the data. Does this suggest that the only information that should be put in a spreadsheet is data where it doesn't matter if it gets corrupted? If so, that would significantly reduce the usefulness of spreadsheets. I assume there is some key point that I'm missing, so please enlighten thanks. Basically a database is for storing and retrieving information. A spreadsheet is primarily for performing calculations on data. In common usage, people have come to use spreadsheets to store information because the learning curve is much shallower than learning to work with a database. Also, a database can have fields, records and other areas locked to protect data from user input or changes. Spreadsheets can be sort of locked but that isn't perfect either as I have seen so many times in my work. A find and replace in a spreadsheet can be very dangerous if used wrong. A find and replace in a database is much harder to do outside the current open record. Also, linking between data fields is much easier in a database. I agree that most users know how to use a spreadsheet and have to learn a data base program. It is well worth the time to learn how to use a database program for storing records like employee information. -- Gene Y. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Major data loss: Calc formatting numbers
I have abandoned using BASE and use CALC instead. Very little of my CALC data is numeric. BASE was too hard to set up, the documentation was more confusing than helpful. But since the latest upgrade CALC has a serious bug. Copying a cell that is a formula into a set of other cells either crashes the job, or the copying works but the calculated values are not displayed. Something as simple as setting up a running total in a column (B2 = B1+A2 etc), or setting a date column of every Monday in a year so that the entries are automatically worked out (cell A1 = first date, then A2 =A1+7 and so on) Mike Shearer Townsville, Queensland, Australia - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Major data loss: Calc formatting numbers
On 07/07/09 00:10, Mike Shearer wrote: I have abandoned using BASE and use CALC instead. Very little of my CALC data is numeric. BASE was too hard to set up, the documentation was more confusing than helpful. But since the latest upgrade CALC has a serious bug. Copying a cell that is a formula into a set of other cells either crashes the job, or the copying works but the calculated values are not displayed. Errm. If you have a set of numbers in column A and then, starting in B3 you enter the formula =A1+A2 then B3 will contain the sum of A1 and A2. If you drag the formula down column B then B4 will contain the sum of B2 and B3 B5 B3 B4 etc. If you now copy, say B5 into E5, E5 will contain **0**. Why? Because Calc has automagically adjusted the formula to read =D3+D4. This is the way pretty much all spreadsheets work. When copying a *named* value (A1 is a name), the name's two parts (row number and column letter) are considered relative unless preceded by a $ symbol. Thus the value in cell A4 can be referred to in 4 different ways: 1. A4 meaning that both the A and the 4 are relative and thus subject to automagic adjustment as above. 2. $A4 meaning the A is fixed (not subject to automagic adjustment) but the 4 is relative. Copying such a value in the context above would result in the column letter being copied as is but the row numbers being adjusted as necessary. 3. A$4 meaning the A is relative but the 4 is fixed 4. $A$4 meaning both the A and the 4 are fixed. It is worth playing with these combinations to see the differences. In particular, try setting B3 in the above example to 1) =A$1+A$2 and then dragging B3 down column B 2) =$A$1+$A$2 and then, after dragging B3 down column B, copy/paste column B into, say, column F. Now, I'm not saying you haven't found a bug but your description of what you see represents correct behaviour on Calc's part. Of course I don't mean that crashing the job is correct behaviour. If you really get that repeatedly please file a bug and let us know its number. Please also tell us which version of OOo you are using and on which version of which Operating System. Something as simple as setting up a running total in a column (B2 = B1+A2 etc), or setting a date column of every Monday in a year so that the entries are automatically worked out (cell A1 = first date, then A2 =A1+7 and so on) Mike Shearer Townsville, Queensland, Australia - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Moving a Table
It does, but I meant moving it arund the screen in the same document. From: Harold Fuchs Sent: Sunday, July 05, 2009 1:20 PM To: users@openoffice.org ; marko.baloko...@ymail.com Subject: Re: [users] Moving a Table On 05/07/09 11:34, Dotan Cohen wrote: Greetings, I'd like to know how to move a table in Writer. Yes, I tried selecting it and then dragging it. Selecting the table then cut / paste works for me in OOo 3.1 on Kubuntu 9.04. Does this not work for you? Forwarding to unsubscribed OP. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org
[users] Re: Welcome to openoffice.org - already done
2009/7/6, webmas...@openoffice.org webmas...@openoffice.org: Welcome to openoffice.org! You are now a registered member of OpenOffice.org. This mail message is the first of two; the second message will contain your new password. It may take some time to reach you; please be patient. For information about the Project and about how you can get started, go to our Introduction page, http://www.openoffice.org/about_us/introduction.html. It also provides links to useful areas. As a registered member of OpenOffice.org, you can: - Join projects and contribute - Read project news and announcements. - Join project mailing lists. - View project files and documents. - Browse project source code. - Search project issue databases. If you are interested in joining our native-language projects (Native-Lang Projects), which offer information, resources and localized releases, please go to http://native-lang.openoffice.org/. If you want information on how to develop OpenOffice.org or how to work with the source, please look at our Developer page, http://website.openoffice.org/developer/ . An Open Source project is most alive in the mailing lists. Please consider joining the lists featured in our Mailing List page, http://www.openoffice.org/mail_list.html. The three most important lists are: - disc...@openoffice.org - annou...@openoffice.org - users@openoffice.org Our Support Area (http://support.openoffice.org/) offers information for users of all levels. Don't forget to check out the FAQs (http://www.openoffice.org/faq.html) and Help (http://www.openoffice.org/servlets/HelpTOC) to learn more about OpenOffice.org. Louis Suarez-Potts Community Manager OpenOffice.org -- We are paying expenses with checks and letters from banks, banking facilities used to assume that the check is yours. Does not use directly, send to the stock exchange for discounts on their own via the internet? The process is carried out ways of my lawyers in the United States of America. Use the change to 9000 times before settling the claim. Payment only in U.S. dollars if the dollar has changed to be changed into U.S. dollars. It is fair pay in U.S. dollars, only in U.S. dollars. David Roberto Schiavenin / * / MOSBRADARVI / * / OPIAL / Available at Http: / / www.Meebo.com/ email with davidschiave...@gmail.com / . sxw Open Office is a field . doc is a Microsoft domain . dwg is an area AutoDesck . zip is a field of compression of files to connect with other area davidschiave...@gmail.com / for details.
[users] HOW TO put sequential page numbers on any kind of document!?
I am having a terribly difficult time trying to figure out how to put sequential page numbers on any kind of document. for example: I have a 29 page document and the only thing I have been able to do is put in one number at a time. Could somebody please tell me how to put in sequential numbers for example one through 29 in the lower right-hand corner. Sincerely, EVA
Re: [users] Problem opening files
works! great! thank you! Giuseppe Gagliardi --- On Sun, 7/5/09, James Knott james.kn...@rogers.com wrote: From: James Knott james.kn...@rogers.com Subject: Re: [users] Problem opening files To: users@openoffice.org, gagli...@yahoo.com Date: Sunday, July 5, 2009, 8:09 AM gagli...@yahoo.com wrote: I have all my work in doc,xcl,ppt..I installed Openoffice hoping would work better than Office which I erased because it was a defective pirate copy. Now, when I try to open let's say an MS word doc the computer does not automatically know what program to usee to open it. I've read that this option of recognizing the right program can be modified during installation but I reinstalled three times without finding it. How do I geet the right program to recognixe the rghtfil. And last, what a ptoblem did mjkkl? A disc You have to set the file associations for those files. Assuming you're running Windows, you can follow these directions: Changing file associations Right click on file icon Select Open With Choose Program... Check Always use the selected program to open this kind of file and choose the desired application. If that method is not available, follow the directions listed here: http://support.microsoft.com/kb/307859 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Open Office 3.1
Recently I upgraded from Open Office 2 to 3.1. Since doing so I am unable to open emails with pps or xls attachments. Why? and how do I correct this? Hope someone can help, Thanks in advance, Don Jarvis
[users] Issues
I was a big supported of Open Office until recently, and today I encountered the last tip that filled de cup. I can't open Draw in my computer (I double click odg file and it doesn't open - I try opening Draw and then the file and it doesn't work either, Draw doesn't open at all) I tried to feedback this problem and I found the site doesn't have an easy bug report system. I won't recomend Open Office any more.
Re: [users] Issues
José Inda wrote: I was a big supported of Open Office until recently, and today I encountered the last tip that filled de cup. I can't open Draw in my computer (I double click odg file and it doesn't open - I try opening Draw and then the file and it doesn't work either, Draw doesn't open at all) I tried to feedback this problem and I found the site doesn't have an easy bug report system. I won't recomend Open Office any more. 20090706 2110 GMT-5 Okay. That only hurts you. Why? Because you didnt 1) ask for help 2) try to figure out why it wont work on YOUR computer as it works fine on others. Wade -- Registered Linux User: #480675 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] HOW TO put sequential page numbers on any kind of document!?
Eugene Abravanel wrote: I am having a terribly difficult time trying to figure out how to put sequential page numbers on any kind of document. for example: I have a 29 page document and the only thing I have been able to do is put in one number at a time. Could somebody please tell me how to put in sequential numbers for example one through 29 in the lower right-hand corner. Sincerely, EVA Place the cursor where you want the page number to be and then click on Insert Fields Page Number. You may want to have the page number in a header or footer, instead of the main part of the document. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Issues
José Inda wrote: I was a big supported of Open Office until recently, and today I encountered the last tip that filled de cup. I can't open Draw in my computer (I double click odg file and it doesn't open - I try opening Draw and then the file and it doesn't work either, Draw doesn't open at all) I tried to feedback this problem and I found the site doesn't have an easy bug report system. I won't recomend Open Office any more. What happens if you first open OpenOffice and then try to open the file using File Open? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Read: [users] Re: Windows 7 Upgrade Advisor says OO.o won't install.
This is a receipt for the mail you sent to Openoffice users list users@openoffice.org at 7/3/2009 11:00 PM This receipt verifies that the message has been displayed on the recipient's computer at 7/6/2009 8:24 PM bin1OAo0wFj4j.bin Description: message/disposition-notification
[users] Re: Issues
On 07/06/2009 10:11 AM, José Inda wrote: I was a big supported of Open Office until recently, and today I encountered the last tip that filled de cup. I can't open Draw in my computer (I double click odg file and it doesn't open - I try opening Draw and then the file and it doesn't work either, Draw doesn't open at all) I tried to feedback this problem and I found the site doesn't have an easy bug report system. I won't recomend Open Office any more. Isn't allowing unsubscribed posters wonderful... José Inda also posted the same to the discuss list (unsubscribed of course) and who knows how many others. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] problem
Dear Sir, Whenever I try to open a document a box pops up displaying : document opened in read only mode so basically I am stuck. Can you help, please? Jan Provost.
[users] Calc shortcuts for italicizing and decreasing font size?
Hello openoffice list: I am in search of a shortcut for both italicizing the selected text and decreasing the fontsize to 1 size smaller. I wonder who can point me to some info about that. I tried customizing keyboard shortcuts but it seems that it is not adequate for this task. Thanks and Have a nice Day/Evening. -- Zhengquan - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] problem
lynn provost wrote: Dear Sir, Whenever I try to open a document a box pops up displaying : document opened in read only mode so basically I am stuck. Can you help, please? Jan Provost. 20090706 2150 GMT-5 The icon tool bar under File Edit View etc., fifth button over is a little piece of paper with a pencil on it. Click it. It says Edit File. You'll be able to edit the file now. Wade -- Registered Linux User: #480675 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] High Contrast bug?
One reason I do not use a High Contrast theme in Windows Vista (as I hadn't in XP) is that the tables in OOo Calc pick up the windows colors even though in Tools Options OpenOffice.org Accessibility I have left all the checkboxes in Options for High Contrast appearance unchecked. Am I missing something or is it a bug? And if it is a bug has it been reported? emf -- It ain't THAT, babe! - A radical reinterpretation http://www.geocities.com/itaintme_babe/itaintme.html - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org