[users] Re: Information
Hello Benjamin, Everyone is free to use openoffice in any environment. You can read the license here: http://www.openoffice.org/license.html tc > > From: Benjamin Kovacevic >To: users@openoffice.org >Sent: Monday, March 12, 2012 5:27:25 AM >Subject: [users] Information > > > >Dear Mr./Ms., > >I need info rmation about licensing OpenOffice. Can we use OpenOffice in a company legaly, or we need to buy license for it. I need this info rmation fast. > >Thank you on understanding. > >___ >S poštovanjem / Best regards / Mit freundlichen Grüßen, >Benjamin Kovačević, dipl. ing. info rmacionih tehnologija / Bachelor of Information Technology >Manager prodaje / Sales Manager >e-mail: benjamin.kovace...@remex.ba > >REMEX d.o.o. >Prodaja filtera za sve vrste teretnih i putničkih vozila, građevinskih i rudarskih mašina i originalnih autodijelova za iste >Husinskih rudara 351, >75000 Tuzla >Tel: +387 (0)35 302 000 >Tel/fax: +387 (0)35 302 002 > > >-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Page Break Lines OOCalc
Hi Mark, Tools / option / calc / view. Uncheck 'Page Breaks' under 'Visual Aids'. tc > > From: Mark LaPierre >To: >Sent: Saturday, February 11, 2012 10:03:32 PM >Subject: [users] Page Break Lines OOCalc > >Does anyone know how to turn off the appearance of page break lines on OO >Calc? When I go to View/Page Break Preview the work sheet is displayed with >all the page breaks and the page numbers in phantom gray as would be expected, >but when I switch back to View/Normal the page breaks are still visible. They >look like I set a border around each page. Notice the vertical and horizontal >line to the left and below the selected cell on the attached screen shot. > >-- _ > °v° > /(_)\ > ^ ^ Mark LaPierre >Registerd Linux user No #267004 >-- - >To unsubscribe send email to users-unsubscr...@openoffice.org >For additional commands send email to sy...@openoffice.org >with Subject: help > > >-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Looking for a couple of functions in Calc
Hi John, http://openoffice.blogs.com/openoffice/2008/05/copying-only-th.html The link above will take you to a blog that explains how to achieve #2. As someone else pointed out, for #1, check the help for conditional formatting . tc > > From: John Meyer >To: users@openoffice.org >Sent: Saturday, February 11, 2012 10:52:46 AM >Subject: [users] Looking for a couple of functions in Calc > >1. (noob alert). I'm looking for a function where I can check a particular >cell for text and color the cell based upon that value. >2. I'm also looking for a function that can either list the unique values in >a column, or the count of unique values in a column. >-- - >To unsubscribe send email to users-unsubscr...@openoffice.org >For additional commands send email to sy...@openoffice.org >with Subject: help > > >-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: hyphens
Hi Thomas, It appears that it only works when the two hyphens are preceded by a space. So you must type a space, the two hyphens then another space to get the em dash.. To get what you want, you'll the have to remove the extra spaces. I just did some experimenting and got the results below. I don't know i\f the formatting will survive the list, so I've described the results as well. A—B - typed A--B result is "A/no space/em dash/no space/B" A – B - typed A--B result is "A/space/en dash/space/B" tc > > From: thomas steel >To: users@openoffice.org >Sent: Saturday, January 28, 2012 10:37:48 AM >Subject: [users] Re: hyphens > >Thanks! At last I understand. BUT the setting I am trying to return to (& >have used in OOWriter for years) is"A/no space/em dash/no space/B" (which >used to work simply by typing 2 hyphens). That seems to have been removed >from the normal auto options. How can I recreate it? TS > >-Original Message- >From: openoffice.mbou...@spamgourmet.com >Sent: Saturday, January 28, 2012 3:12 PM >To: users@openoffice.org >Subject: [users] Re: hyphens > >The "specific options" I was referring to are those under the Tools menu >> AutoCorrect Options, which I described below. Apologies that wasn't >clear. For the "replace dashes" option, make sure it's ticked under [T] >and not just [M] - options under [T] affect text as you type, while >those under [M] only have an effect when you use Format > AutoCorrect > >Apply. > >If they're all set and it's still not working, perhaps you could show an >example of what you're typing and expect to be changed? e.g. >"A - B " (A space dash space B space) > should replace the dash with an en-dash >"A-B " (A dash B space) - note no spaces around the dash > is not expected to change the dash, even with the options set > >Mark. > > >thomas steel: >> >> Format>AutoCorrect>WhileTyping is ticked, but it doesn't work. You >> advise that I 'Check that the specific options are set'. I suspect that >> the problem lies here. Can you tell me how to do that? I'd be so >> grateful. TS >> -Original Message- From: openoffice.mbou...@spamgourmet.com >> Sent: Saturday, January 28, 2012 11:36 AM >> To: users@openoffice.org >> Subject: [users] Re: hyphens & apostrophes >> >> thomas steel: >>> I am struggling to recustomise OOWriter for a new computer after >>> burglary. >>> Am trying (1) to enable replacement of some hyphens by em & en dashes >>> (used to work by hitting hyphen twice). >> >> As Anthony pointed out, make sure Format menu > AutoCorrect > While >> Typing is ticked (click the menu item to toggle it if not). If that >> doesn't work, check that the specific options are set... >> >> From the Tools menu > AutoCorrect Options > Options tab, tick the box >> in the [T] column next to "Replace dashes". Clicking the "Help" button >> in that dialog gives a description of the options, including which >> combinations of dashes are replaced. >> >>> Trying (2) to replace apostrophe mark (small vertical mark) with an >>> apostrophe comma---permanently. >> >> From the same dialog (Tools > AutoCorrect Options), but on the Custom >> Quotes tab, tick "Replace" for the types of quotes (single or double) >> you want to replace. You can also check that the replacement characters >> are correct (not easy to tell in the dialog, but clicking them shows the >> currently selected characters more clearly and allows you to change them). >> >>> Have spent hours using Help to no effect. Please can someone help me? TM >>> Steel >> >> Hope that helps, >> Mark. >> > >-- >- >To unsubscribe send email to users-unsubscr...@openoffice.org >For additional commands send email to sy...@openoffice.org >with Subject: help > >-- >- >To unsubscribe send email to users-unsubscr...@openoffice.org >For additional commands send email to sy...@openoffice.org >with Subject: help > > >-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: hyphens & apostrophes
Hi Thomas, I have OOo 3.0 (build 9358) at home and 3.3 (build 9567) at work. In both, the first auto-correct item is em-dash for two hyphens. In order to have the substitution made as you type check Format - AutoFormat - While Typing. tc > > From: thomas steel >To: users@openoffice.org >Sent: Friday, January 27, 2012 5:34:16 PM >Subject: [users] hyphens & apostrophes > > > >From: THOMAS STEEL >Sent: Friday, January 27, 2012 9:44 AM >To: users-h...@openoffice.org >Subject: hyphens & apostrophes > I am struggling to recustomise OOWriter for a new computer after burglary. >Am trying (1) to enable replacement of some hyphens by em & en dashes (used to work by hitting hyphen twice). >Trying (2) to replace apostrophe mark (small vertical mark) with an apostrophe comma---permanently. >Have spent hours using Help to no effect. Please can someone help me? TM Steel > >-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: using functions inside functions
Hi Wade, The programmer's answer is =QUOTIENT(SUM(C35:C40);10)+MOD(SUM(C35:C40);10) tc Whatever happened to DIV? > > From: Wade Smart >To: users@openoffice.org >Sent: Tuesday, November 22, 2011 7:52:53 AM >Subject: [users] Re: using functions inside functions > >On Tue, Nov 22, 2011 at 02:02, Brian Barker wrote: >> =SUM(C35:C40)-9*INT(SUM(C35:C40)/10) > >Brian, the values of C35 - 40 are (right now) >4,1,5,9,5,3 = 27 >2 + 7 = 9 > >But when I used your function it produces 0 > >Wade > >Jacek, Im on Ubuntu and use , not ;. Thanks. >-- >-- >Registered Linux User: #480675 >Registered Linux Machine: #408606 >Linux since June 2005 >-- >- >To unsubscribe send email to users-unsubscr...@openoffice.org >For additional commands send email to sy...@openoffice.org >with Subject: help > > >-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: using functions inside functions
Hi Wade, I'd guess that the problem is that the SUM function result can't be passed to a string function unless it is first evaluated in a cell. Why not just use: =IF(SUM(C35:C40)>9,LEFT(STR(SUM(C35:C40)),1)+RIGHT(STR(SUM(C35:C40))),1) I'm assuming that you're using whole numbers and anything greater than nine will have two digits. tc > > From: Wade Smart >To: users@openoffice.org >Sent: Monday, November 21, 2011 8:52:38 PM >Subject: [users] using functions inside functions > >=IF(LEN(SUM(C35:C40))>1,LEFT(C56,1)+RIGHT(C56,1)) > >Im suming a set of numbers into a cell. >If the number is over 1 digit - and it always is, I want >to take the left and right digit and add them together. >This works if I do it in two steps but I dont want to >use up column space. > >Wade > >-- >-- >Registered Linux User: #480675 >Registered Linux Machine: #408606 >Linux since June 2005 >-- >- >To unsubscribe send email to users-unsubscr...@openoffice.org >For additional commands send email to sy...@openoffice.org >with Subject: help > > >-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: question to OpenOffice
Hi Karl, I'm running v3.3 on a win 7 64bit installation. I haven't encountered any problems. tc > >From: Karl Hofbauer >To: users@openoffice.org >Sent: Thursday, October 27, 2011 10:32:42 AM >Subject: [users] question to OpenOffice > > > >Hallo, > >does "OpenOffice.org 3.3" work with >Windows 7, 64bit ??? > >thanks for answer > >Greetings from Vienna in Austria > >Karl Hofbauer >A-1150 Wien >karl.hofba...@chello.at > > >-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Big problem
Hi Franje, There were several pages of junk in the 'content.xml' portion of the file. I deleted them and the file now loads. There may be some data missing, though. Check it before proceeding. tc > >From: biograd sithoniis >To: users@openoffice.org >Sent: Friday, October 14, 2011 1:15:39 PM >Subject: [users] Big problem > > >Hello, > > >respect, >I can not open this file. Please let me correct the mistake and go back to >my email because it is a very important job! > >I hope your understanding > >Best Regards > >-- > >SITHONIIS d.o.o. >DR.Franje Tuđmana 82 >23210 Biograd n/M >OIB: 02791388741 >tel: 023/383-262 >fax: 023/383-268 >biograd.sithon...@gmail.com > > > Pretplate T-Mobile Biograd.ods Description: Binary data
[users] Re:
Hi Tuula, Insert the scanned image into your document and use the crop feature to remove the parts of the page you don't want to include. Right-click the image. Select 'Picture', then the 'Crop' tab. tc > >From: Keith Bainbridge >To: users@openoffice.org >Sent: Monday, October 3, 2011 4:24:56 PM >Subject: [users] Re: > > > > >On Wed 28Sep2011, at 14:45 , tuula ruuskanen wrote: > >Help me!! >> >> >>I scan a page of one book. Then I want only a piece of that pace on my own >>drawing page or writing page. I have a permission on do it. But How can I do >>it ? Help me.!! > > > >Sounds to me like you want to scan only part of a page and that is for your >scanner to do, not the software you are inserting the scan into > > > > >Keith Bainbrdge >PO Box 324 >BELMONT Vic 3216 Australia > > >+61 (0)408 522 706 >ke...@akrb.name > > > >-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Calc: Sort double columns
Hi Dotan, If you're willing to jump through a couple of hoops and the real database is not too different from your example it can be done. I've attached your example that I sorted using the following steps: 1) In E1 enter =A1&"A" 2) In E2 enter =A1&"B" 3) Select E1..E2 and copy. 4) Select column E down to the end of the data and paste. 5) Select the used cells in E, copy and paste values. 6) Sort columns B to E by E. 7) In A2 enter =A1+1 8) Clear the format (merge) from column A below A2. 9) Select A2 and copy. 10) Select column A down to the end of the data and paste. 11) Unmerge column A to the end of the data. 11) Select the used cells in A, copy and paste values. 12) Merge A1..A2 and copy. 13) Select the used cells in A (+1) and paste format 14) Delete the data in E. tc > >From: Dotan Cohen >To: openoffice-users. >Sent: Monday, October 3, 2011 7:40:48 AM >Subject: [users] Calc: Sort double columns > >I am reviewing the records of a local shop to help him convert to Open >Office. I have found no problems with the simple Word documents that >he uses, but he is using MS Excel where he should have a real >database. We all know about efforts to teach an old dog new tricks, so >let's just be glad that he is interested in this new trick called Open >Office. He will _not_ be moving to Base or anything else, it will be >either in Excel or another spreadsheet. > >In this particular case, he has information that should be in a single >row (record) divided into to rows, with the A column's cells merged >between the two and the "sorting key" stored in that cell. He now >wants to sort based on the merged cells, keeping the dual-row records >intact. > >Example: >--- >1 | Some info > | More info >--- >3 | Yet some more info > | And more info >--- >2 | Some important info > | More important info >--- > >He now needs to sort that! Does anybody know how this can be done? >Trying the regular sort function returns an error that range >containing merged cells can only be sorted without formats. > >Example document here: >http://dotancohen.com/images/examples/sort-example.ods > >Thanks. > >-- >Dotan Cohen > >http://gibberish.co.il >http://what-is-what.com >-- >- >To unsubscribe send email to users-unsubscr...@openoffice.org >For additional commands send email to sy...@openoffice.org >with Subject: help > > > sort-example.ods Description: Binary data
[users] Re: Question
Hi Cory, You want to use the validate feature to pick from the 'Select' column in your table. Put the cursor in the 'key' cell (I'll use A2), then select 'data / validity'. On the 'criteria' tab allow 'Cell Range', then enter the address of the 'Select' data in the 'Source' box in the form A3:A99, assuming that the data is in column A from row 3 to row 99. An arrow should appear next to A2 when that cell is selected. Clicking the arrow should pop up a list with the data in column A. In each of the three cells beside the key cell enter the following formulae: In B2: =IF(A2<>"";VLOOKUP(A2;$A$3:$D$99;2;0);"") In C2: =IF(A2<>"";VLOOKUP(A2;$A$3:$D$99;3;0);"") In D2: =IF(A2<>"";VLOOKUP(A2;$A$3:$D$99;4;0);"") When you select an item from the list, the data from that item's row in your table should appear in the three cells next to it. I've attached a sample file. I'm not sure if it will make it to the list. tc > >From: Cory Heskamp >To: users@openoffice.org >Sent: Thursday, September 29, 2011 7:21:00 PM >Subject: [users] Question > > >I am sure this is a stupid question but I can not seem to find the answer. I >want to be able to set it up that in Calc I select one entry (Primary Key) >from a database from a combo box but that it will update the rest of the >entries in that field in other areas. Not sure if I am explaining this right. >I have a database with the following table called payroll. Inside the table >there is 4 items in each entry. Select, Type Description, and Code. What I >want is that in Calc I have a cell that is setup as a combo box linked to the >Select field of the table, but I want it that when I select that item it will >take the information in the rest of the item (Type, Description, and Code) and >put that stuff in other individual cells. Basically I select the entry I want >from the combo box and it fill out the corresponding information into a cell >for Type, a cell for Description, and a cell for Code. That way all I have to >do is edit the database and then in the Calc select the item and it will fill in all the cells. Does this make sense? Can someone help me? > >Thanks in advance > >Cory > > PickDataExample.ods Description: Binary data
[users] Re: Help with writing macro
Hi GS, Check this out: http://www.pitonyak.org/oo.php tc > >From: Grzesiek Sójka >To: users@openoffice.org >Sent: Tuesday, September 20, 2011 4:48:46 PM >Subject: [users] Help with writing macro > >Hi there. > >I need to write a macro accepting variable length parameter list. I was tryint >to googl but no luck. So the question is how to write (preferably in >OpenOffice Basic) macro accepting variable length parameter list. > >Thanks in advance for any help > >-- - >To unsubscribe send email to users-unsubscr...@openoffice.org >For additional commands send email to sy...@openoffice.org >with Subject: help > > >-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: subtracting rows from a constant number
Hi Wade, Make the references to the fees absolute by adding a $ before them: =IF(b2=125,b2-$ay$2,'') Column and row are absolute =IF(b2=125,b2-ay$2,'') Row is absolute =IF(b2=125,b2-$ay2,'') Column is absolute When you copy the formula, the absolute parts stay the same, non-absolute references will increment. tc > >From: Wade Smart >To: users@openoffice.org >Sent: Sunday, August 7, 2011 4:33:56 PM >Subject: [users] subtracting rows from a constant number > >Im working on another form for the soccer leage. > >I have a row like this: > >Payment First Last etc > >This is the player information, if they registered for the year or >season and how much they paid. > >Out on column AW I have the start of some constants. >Field Fee year >Field Fee season >Ref fee >reg fee >etc. > >So what I want to do is: > >Registration Payment - (the fees(based on if its a yearly payment or >seasonal payment)) > >which I can do but, what I cant seem to figure out is, >when I start on the next row, how can I tell row three to look at the >same constants? > >So: =IF(b2=125,b2-ay2,'') > >On line this what happens is >=if(b3=125,b3-ay3,"") >which throws an error because I just have those numbers in aw2-ba2. > >How can I do the rest of the lines without populating all those field >unnecessarily? > >Wade > >-- >--- >Registered Linux User: #480675 >Linux since June 2005 >-- >- >To unsubscribe send email to users-unsubscr...@openoffice.org >For additional commands send email to sy...@openoffice.org >with Subject: help > > >-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: OO calc-copy/paste
Hi Helen, You can copy and paste to and from a google spreadsheet, but the results are not what you'd expect. Text works both ways OK. It seems that there's no way to copy an area and get the formulae to paste int OOo. What you get is much the same as 'paste values'. What you can do is use 'File / Download' to get a local copy in excel or OOo format. tc > >From: Helen >To: users@openoffice.org >Sent: Tuesday, August 2, 2011 10:00:01 AM >Subject: [users] OO calc-copy/paste > >Can the contents of a google spreadsheet be copied and pasted >into a LO or OO spreadsheet? How do you get the contents >to go into the correct cells? >Thanks, >Helen >Using Linux, suse 11.4, LibreOffice 3.3.1 >-- >- >To unsubscribe send email to users-unsubscr...@openoffice.org >For additional commands send email to sy...@openoffice.org >with Subject: help > > >-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Pasting numbers in Calc
Assuming the data are in column A. Insert a column next to the data. Add the formula =value(a1). Fill down. Copy the result. 'paste special' back into the same location, but uncheck 'formulas'. tc From: Eustace To: users@openoffice.org Sent: Thu, June 9, 2011 7:48:31 AM Subject: [users] Pasting numbers in Calc When copying from http://www.invincibleamerica.org/tallies.html the 4 columns and pasting them in Calc as Unformatted text separated by Tab, the first column of numbers pastes with some code in the beginning, so I have to double-click in each cell, then something that resembles a ' (single quote) appears in front of the number, and delete it. If I try to copy and paste these ' in the search box to have it replaced with nothing it does not find them. How can I easily change the column to simple numbers? emf -- It ain't THAT, babe! - A radical reinterpretation https://files.nyu.edu/emf202/public/bd/itaintmebabe.html -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Adding 1 hour
Hi Wade, Assuming A1 has properly formatted time and not text, this should give you what you want: =TIME(HOUR(A1)+1;MINUTE(A1);0) tc From: Wade Smart To: users@openoffice.org Sent: Wed, February 23, 2011 8:05:10 PM Subject: [users] Adding 1 hour I have a column with times in it: 09:00 - 10:00, and I would like to add one hour to it, or subtract from it. Basically its a time zone issue. Ive gone through the functions, some forums but Im not sure this can be done in spread sheets. Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
Re: [users] Lock formulas from being changed in Calc?
Select all the cells that you want to be editable. Click 'format / cells' (or press ctrl 1) select the 'protection' tab uncheck the 'Protected' box. click OK Click 'Tools / Protect document / Sheet' Save tc From: . To: users@openoffice.org Sent: Thu, January 6, 2011 10:25:06 PM Subject: [users] Lock formulas from being changed in Calc? I want to lock specific cells with formulas in a sheet so that they can't be changed while the remainder of the sheet must be editable How is it done?
Re: [users] Using an OR inside an IF
Hi Wade,
Sorry for the late reply. Yes, the second formula worked for me. I copied yours
and modified it to get the first formula. You had stated in a previous message
that in your build the comma works in a formula. When I pasted it into a
spreadsheet to test it, I had to change the commas to semicolons.
tc
From: Wade Smart
To: users@openoffice.org
Sent: Thu, January 28, 2010 8:24:15 AM
Subject: Re: [users] Using an OR inside an IF
Were you able to run this in a spread sheet cell?
Documentation says you can compare words, only numbers.
Wade
Anthony Chilco wrote:
> Hi Wade,
> Off the top of my head, I'd say it should read
> =IF(OR(F8="yellow",F8="y"),5,0)
> Of course, I had to use semicolons to test it.
> =IF(OR(F8="yellow";F8="y");5;0)
> tc
>
>
>
>
>
> From: Wade Smart
> To: OpenOffice
> Sent: Tue, January 26, 2010 8:59:58 AM
> Subject: [users] Using an OR inside an IF
>
> =IF(F8=(OR("yellow","y")),5,0)
>
> IF, F8 is equal to the word "yellow" or the letter "y" then return the number
> 5, otherwise return 0.
>
> Im getting that #VALUE! error.
>
> ah.. I just read that any text cells are ignored.
> How would I do that then?
>
> Wade
> -- Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.org
> For additional commands, e-mail: users-h...@openoffice.org
>
>
> __
> Looking for the perfect gift? Give the gift of Flickr!
> http://www.flickr.com/gift/
-- Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
__
Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your
favourite sites. Download it now
http://ca.toolbar.yahoo.com.
Re: [users] Using an OR inside an IF
Hi Wade,
Off the top of my head, I'd say it should read
=IF(OR(F8="yellow",F8="y"),5,0)
Of course, I had to use semicolons to test it.
=IF(OR(F8="yellow";F8="y");5;0)
tc
From: Wade Smart
To: OpenOffice
Sent: Tue, January 26, 2010 8:59:58 AM
Subject: [users] Using an OR inside an IF
=IF(F8=(OR("yellow","y")),5,0)
IF, F8 is equal to the word "yellow" or the letter "y" then return the number
5, otherwise return 0.
Im getting that #VALUE! error.
ah.. I just read that any text cells are ignored.
How would I do that then?
Wade
-- Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
__
Looking for the perfect gift? Give the gift of Flickr!
http://www.flickr.com/gift/
Re: [users] Find Page Breaks?" Harold?
Hi Twayne I created a small file and added a manual page break with the text "before break" before the break and, well you know, after the break. I renamed the file, adding ".zip" and opened the content.xml using 7-zip and this is what I found: Line1 Line2 before break after break Line3 Line4 There isn't a page break code per se, but the text style of the line after the page break is changed to "P1". If you delete the text from the slash after "Standard" up to the > after "P1" and save into the zip file, then remove the ".zip" and open it, the page break will be gone. You should be able to do this with search and replace if you extract the xml, open it in OOo, then put it back into the zip file. Line1 Line2 before break after break Line3 Line4 tc From: Twayne To: users@openoffice.org Sent: Wednesday, August 19, 2009 1:21:33 PM Subject: [users] Find Page Breaks?" Harold? Is there any way, short of a hex editor, to look inside the file, or even the zip format, and somehow determine where the page break code is located? And if so, would it be searchable? Do you happen to know what the code IS? Yes, I realize a zip reader would have some gotchas that way, but ... covering all the bases since that's the only way I know to do anything with an OOo file. Regards, Twayne` - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org __ Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now http://ca.toolbar.yahoo.com.
Re: [users] Add text next to a table?
Hi PJ, I dislike working with tables, so have little experience with them, but can offer this suggestion: Add a frame, place it next to the table and enter the text in the frame. tc From: PJH To: users@openoffice.org Sent: Monday, July 13, 2009 8:55:58 PM Subject: [users] Add text next to a table? I created a table by inserting a CSV file and using "convert text to table". The resulting table was full-width. I made it narrower hoping to be able to add text to the right of that table, but I cannot get an insertion point in that area. Can someone please help? Thanks. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org __ The new Internet Explorer® 8 - Faster, safer, easier. Optimized for Yahoo! Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/
Re: [users] mixed positive and negative numbers
Hi Walter, *=(A1-B1)/ABS(B1)* should do the trick. tc From: Walter Hildebrandt To: Users Group Sent: Friday, April 17, 2009 11:54:01 AM Subject: [users] mixed positive and negative numbers Putting *=(A1-B1)/B1* in C1 sometimes gives the wrong answer in C1 when positive and negative numbers are involved. For these example cells A1 and B2 are formatted to dollars and C1 is formatted to percent. When A1 is $10 and B1 is $5 C1 is 100% which is correct When A1 is -$10 and B1 is $5 C1 is -300% which is correct When A1 is $10 and B1 is -$5 C1 is -300% which is not correct. 300% would be the correct in C1 When A1 is -$10 and B1 is -$5 C1 is 100% which is not correct -100% would be correct in C1 What formula can be used in C1 to get the correct answer __ Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail. Click on Options in Mail and switch to New Mail today or register for free at http://mail.yahoo.ca
Re: [users] Office 2003 Contacts
cc to Jim From: Anthony Chilco To: users@openoffice.org Sent: Sunday, April 5, 2009 7:38:52 PM Subject: Re: [users] Office 2003 Contacts Hi Jim, If you can export your contacts in CSV format (comma separated), you can open the file with calc, save as a spreadsheet, then register tat file as an address database. tc From: Jim Novacek To: users@openoffice.org Sent: Sunday, April 5, 2009 4:03:56 PM Subject: [users] Office 2003 Contacts How do I find out how to move my office 2003 contacts to open office.org ?? Thanks in advance Jim jnova...@embarqmail.com Yahoo! Canada Toolbar :Search from anywhere on the web and bookmark your favourite sites. Download it now! __ Connect with friends from any web browser - no download required. Try the new Yahoo! Canada Messenger for the Web BETA at http://ca.messenger.yahoo.com/webmessengerpromo.php
Re: [users] Office 2003 Contacts
Hi Jim, If you can export your contacts in CSV format (comma separated), you can open the file with calc, save as a spreadsheet, then register tat file as an address database. tc From: Jim Novacek To: users@openoffice.org Sent: Sunday, April 5, 2009 4:03:56 PM Subject: [users] Office 2003 Contacts How do I find out how to move my office 2003 contacts to open office.org ?? Thanks in advance Jim jnova...@embarqmail.com __ Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now http://ca.toolbar.yahoo.com.
RE: [users] Impress basics - HELP!/Chilco
Hi Brewster, I ran through the process again on a different pc and recorded it so you could see what I was doing. Here's a link to the file. It's swf format. http://www.screencast.com/t/QwtuF0MH hope this helps tc > From: b...@fdi.us > To: users@openoffice.org > Date: Wed, 1 Apr 2009 20:21:16 -0800 > Subject: Re: [users] Impress basics - HELP!/Chilco > > On Wed, 2009-04-01 at 12:48, Anthony Chilco wrote: > > Hi Brewster, > > For what you want to do, the simplest method would be to type all your text > > in > > writer first. Select all and copy. Next open a blank presentation. > > bg: > > Did fine up to that point. > > > Click 'view / slide master' and stretch the title text object to cover the > > entire slide. > > I think that with some difficulty I have figured out how to do that > part. It would be a lot better if there were a truly blank slide, > without the often totally unneeded title object. > > > Select the text in it and choose the font and size you want. > > I think I am getting that, though I don't know why there has to be > any default text in that window in the first place. > > > Close the master. > > I'm afraid I could not find anything on how to "close the master". > Seemingly clicking on a different tab, like "outline", may have > that effect, though I don't know exactly how one could tell. > > > With the 'Normal' tab selected, click on the title text, select all, > > This doesn't entirely make sense - presumably at this point I should > not have anything in the newly expanded title text box - it should be > empty, waiting for me to past into it, shouldn't it? Why would I be > selecting anything in the title text box? > > > then paste your text. > > I pasted it, but I only got the first two lines, and in a font so small > that it was impossible to verify which lines they were. > > > Select the 'Outline' tab. Position the cursor where you want each > > slide break, and press enter. > > Once having selected the "outline" tab, the system would not allow me to > position the cursor. > > I really begin to wonder whether my installation of OO has, after > all these reliable years, become corrupted somehow. > > > Each time you do that a new slide will be created > > where the title contains the remainder of the text. I made a 26-slide > > presentation using your text below in about two minutes. > > tc > > So I guess what you're saying is that when I first paste, I am pasting > my entire OOWriter file, with all 25 items in it, then doing cursor > positioning and line feeds in order to break from one slide to the next. > > I guess if the "Outline" tab view were letting me position my cursor, > I could test that. But I'm getting an unresponsive cursor on that view. > > Thanks for your very comprehensive explanation. I'm quite close to > deciding to install a newer version of Open Office, and maybe I can get > that accomplished in time to finish this slide presentation. > > Brewster > > > bg wrote: > > > I am attempting without much success to create a very simple, > > > basic slideshow, consisting of 25 slides, each of which needs to > > > contain no more than one to four lines of text. > > > > > > No graphics. > > > > > > No colors. > > > > > > No special effects. > > > > > > Especially, no special pre-designed formats. > > > > > > I have read every word of the incorporated Help pages. > > > I have downloaded the three significant-appearing Impress "tutorials", > > > and read every single word of those. Nowhere does it demonstrate how to > > > do basic editing of simple text imported from an Open Office text > > > document. The default toolbar apparently assumes > > > that one would never want to change the font size. I could go on. > > > > > > I expect to be presented with a WYSIWYG default, but apparently > > > Impress, like so much modern software, has a mind of its own. > > > > > > *Is* it possible to create simple pages with nothing but words > > > on them, in Impress? Without having to deal with graphical > > > "text object" fields and such? Can it operate as a simple editor? > > > > > > Or should I construct my 25 pages in OOWriter, then import them into > > > slides, one by one, with an expectation that they will make the > > > transaction in something roughly resembling their
Re: [users] Impress basics - HELP!/Suzanne
bg wrote: > On Wed, 2009-04-01 at 19:46, S Perry wrote: >> It looks like you've covered everything except what you need. >> Your solution lies on the VIEW MENU> TOOLBARS> TEXT and TEXT >> FORMATTING. You can cut and paste your material into the textbox >> you draw on the screen. > > That works, up to a point. One thing I cannot find in the docs, and that > nobody has mentioned thus far, is how one proceeds, having > finished a slide, to the next blank slide. I've been all over the docs, > and you would think that would be a pretty basic element, > but it does not seem to be described. I tried just giving it > a carriage return, but that didn't seem to do it. > > The other thing about it that is worrisome is that when I paste > in the appropriate text for the first slide, it displays in > what looks like 4-point type. This despite the fact that I have already > instructed it that I want 44-point. So I guess another thing > that I haven't seen in the docs is, to what extent are we WYSIWYG > here, if at all? Hi Brewster, You can get around that by first pasting into a non-WSIGWIG processor like notepad. If the incoming text has text attributes, Impress will use them. If not, it will use the text attributes defined in the master slide for the place-holder text. tc _ Experience all of the new features, and Reconnect with your life. http://go.microsoft.com/?linkid=9650730
Re: [users] Impress basics - HELP!
Hi Brewster, For what you want to do, the simplest method would be to type all your text in writer first. Select all and copy. Next open a blank presentation. Click 'view / slide master' and stretch the title text object to cover the entire slide. Select the text in it and choose the font and size you want. Close the master. With the 'Normal' tab selected, click on the title text, select all, then paste your text. Select the 'Outline' tab. Position the cursor where you want each slide break, and press enter. Each time you do that a new slide will be created where the title contains the remainder of the text. I made a 26-slide presentation using your text below in about two minutes. tc bg wrote: > I am attempting without much success to create a very simple, > basic slideshow, consisting of 25 slides, each of which needs to > contain no more than one to four lines of text. > > No graphics. > > No colors. > > No special effects. > > Especially, no special pre-designed formats. > > I have read every word of the incorporated Help pages. > I have downloaded the three significant-appearing Impress "tutorials", > and read every single word of those. Nowhere does it demonstrate how to > do basic editing of simple text imported from an Open Office text > document. The default toolbar apparently assumes > that one would never want to change the font size. I could go on. > > I expect to be presented with a WYSIWYG default, but apparently > Impress, like so much modern software, has a mind of its own. > > *Is* it possible to create simple pages with nothing but words > on them, in Impress? Without having to deal with graphical > "text object" fields and such? Can it operate as a simple editor? > > Or should I construct my 25 pages in OOWriter, then import them into > slides, one by one, with an expectation that they will make the > transaction in something roughly resembling their original basic form? > > The help files and tutorials do not address this at all, from what I can > see. Like most modern documentation, they make the twin errors > of assuming prior knowledge not necessarily in evidence, and its > companion assumption that the user wants to start right in with the most > complicated features of the program, rather than launch with > some basics and complexify up from there. > > Thanks for whatever advice you can offer > > Brewster Gillett > _ Create a cool, new character for your Windows Live™ Messenger. http://go.microsoft.com/?linkid=9656621
Re: [users] Consolidate data in Calc
Hi Walter,
I'd do that with the indirect function. Put the names of the spreadsheet that
you want to look into in cells A1, B1 and C1. In A2 enter a formula like:
=INDIRECT("'file:///E:/My Documents/"&A1&".ods'#$Sheet1."&"A1")
then fill right into B2 and C2. The path must be where your spreadsheets live.
This will give you the value of A1 in each of the three spreadsheets. You can
then copy the formula and change &"A1" to &"W20" in the formula to give you a
look at the contents of W20 in each sheet. If you want to get fancy, you can
enter the cell address you want in another cell and reference that in the
formula. For instant, put 'A1' (no quotes) in cell A3 and the formula becomes:
=INDIRECT("'file:///E:/My Documents/"&A1&".ods'#$Sheet1."&A3)
to return the same result.
tc
Walter Hildebrandt wrote:
> I have several large spreadsheets that are exactly the same except cells
> have different numbers. I would like to create a new spreadsheet to
> compare the data in just some of the cells of the original spreadsheets
>
> As a example I would like the new spreadsheet to show the numbers from the
> A1 cells of the original spreadsheets and also the numbers from the W20
> cells of the original spreadsheets.
>
> The new spreadsheet would show that Spreadsheet A had some number in cell A1
> and Spreadsheet B had some number in in cell A1 and spreadsheet C had some
> number in cell A1. Also, The new spreadsheet would show that Spreadsheet A
> had some number in cell W20 and Spreadsheet B had some number in in cell W20
> and spreadsheet C had some number in cell W20
>
> How can the above be done? Is there some way to "consolidate" just some
> cells from different spreadsheet into a new spreadsheet?.
>
_
Share photos with friends on Windows Live Messenger
http://go.microsoft.com/?linkid=9650734
Re: [users] Dates In Calc - value highlighting
TomW wrote: >> > > For issues like this, I like the 'value highlighting' option in Tools | > Options | OpenOffice.org Calc | View. Anything that is a number is a > blue font. Text is displayed in a black font. The two data types stand > out nicely. > > TomW Hi Tom, I had to try this. I get three colours: blue for numbers, black for text and green for either type when it's the result of a formula. The greens change to blue or black if I copy and paste values. tc _ Share photos with friends on Windows Live Messenger http://go.microsoft.com/?linkid=9650734
Re: [users] Products:
Hi Pat, Microsoft Word and Word Perfect are commercial packages that are for sale only. Here you may download, for free, OpenOffice.org, which is an open source (free) package that will do the same job as the two programs you mentioned. tc Pat Bozeman wrote: > I don't know what is expected of me here, but I am looking for Microsoft Word > or Word Perfect - for word processing. > > I haven't the slightest clue about this web site. Afriend said I needed to go > here to get the programs I need.. WHAT MUST I DO TO OBTAIN EITHER OF THESE > TWO PROGRAMS? > > Pat Bozeman > > > _ Share photos with friends on Windows Live Messenger http://go.microsoft.com/?linkid=9650734
Re: [users] Copy a Text File to a Floppy Disk
Harold Fuchs wrote: > On 26/03/2009 19:00, L. P. Prete wrote: >> The document I want to copy to a floppy is a simple letter, maybe 3 or >> 4 Kbytes. I used the word "send" rather than copy to replicate the >> command I am offered when I right-click on the file name as it is >> listed in My Documents. When I right-click, one of the options given >> me is to "Send To" four or five possible places. The one I choose is >> the D drive where my floppy is waiting. It works fine for any Word >> file or Spreadsheet file, but it will not accept the text file that I >> prepared with OpenOffice 3. Are you able to copy your text files to a >> floppy? If so, what commands do you use? >> >> --- On Tue, 3/24/09, Harold Fuchs wrote: >> >> From: Harold Fuchs >> Subject: Re: [users] Copy a Text File to a Floppy Disk >> To: users@openoffice.org, louispr...@yahoo.com >> Date: Tuesday, March 24, 2009, 3:42 PM >> >> On 24/03/2009 17:54, L. P. Prete wrote: >> >>> When I try to send my text documents to a floppy, I get a message >>> that the >>> >> disk cannot accept it. It takes Microsoft Word documents readily. What >> is the >> secret I have failed to discover in OpenOffice 3? >> >>> >> How big are the documents you want to put onto the floppy. Floppies >> can only >> take about 1.4 MB. >> >> Why do you use the word "send"? What are you actually doing, in >> detail? >> >> -- Harold Fuchs >> London, England >> Please reply *only* to users@openoffice.org >> >> >> >> >> > I haven't used a floppy disk in maybe 5 years (my laptop doesn't have > one) but, if I did, I would double click it in Windows to open it like a > normal folder and then drag & drop the document from where it is to the > floppy. I have never used Send To so I don't even know what it is for. > It seems that Send To should work but I'm afraid I don't know why it > isn't. Perhaps someone else here can help. **Please** > The problem may be that the file is current open for editing in openoffice. There's nothing about an openoffice file that would prevent it being copied to a floppy, but if you have the file open, OOo's file locking feature may prevent it being copied. tc _ Chat with the whole group, and bring everyone together. http://go.microsoft.com/?linkid=9650735
Re: [users] Where is the errors?
Hi Eugénio, Below is a example that's similar to your case. The first row is the actual data. The second row is a copy of the first, but formatted to display as shown. The numbers are the same, just rounded to fit the format. A B = A * B 4.104 4 16.416 4.1004 16.42 tc Eugénio Varejão wrote: > Greetings! > > I have a template in calc that have an error but I don't know where it > is and how can I correct it. > > A B CD > FE G H > *POS* *Quant.**Cod* *Marca* *Descrição* *PU* > *Desc.* *PT* > *01* 04 SICHCS03T SI Chassis Porsche 962 4,10 € > 16,42 € > > > The formula under PT is "=IF(B7<>"";(F7*B7)-(F7*B7)*G7;"")" for this > result should be 16.40 €. > > Where is the error? > > Kind regards, > Eugénio Varejão > > > _ Chat with the whole group, and bring everyone together. http://go.microsoft.com/?linkid=9650735
Re: [users] Re: [moderated] -- June 2007 dated email received March 17th 2009
>> >> You should turn it off... it's pretty irritating :-) >> > > Are you saying I should turn off my Anti-Virus protection? > Turn off my system that makes sure the email coming in > are not infected and the email I send are not infected? Perish the thought! The notice that gets added to your message can be turned off, though. _ Share photos with friends on Windows Live Messenger http://go.microsoft.com/?linkid=9650734
RE: [users] Updating ranges after inserting line
Hi Adam, If you add the row between b7 and b8, then the formula will update the range. If you plan to add rows, set up the sum with an empty row at the bottom and include it in the sum range. Adding rows above the empty row will cause the formula range to change. tc > Date: Thu, 6 Nov 2008 18:12:53 -0200 > From: [EMAIL PROTECTED] > To: users@openoffice.org > Subject: [users] Updating ranges after inserting line > > Hi, people! > > I have a spreadsheet with a list of values, let's say, at the interval > B2:B8. At B9, I have the formula =SUM(B2:B8). If I insert a new row > between B8 and B9, the formula at the now B10 cell is not updated. > > Is there a simple way to make this formula automatically update > itself? I'm leaving a blank row between the last value and the sum > cell; I believe I could do some black magic with info functions and > such; also, I know I could use macros, but I'm looking for something > easier, since I'm going to teach it. > > Thanks in advance! > > -- > Adam Victor Nazareth Brandizzi > http://brandizzi.googlepages.com/ > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > _
Re: [users] Default Save Directory.?
Drew Jensen wrote: Hi, snip What I would like is for OO.o to use the last location I saved to as the default location for new files, until I of course save to a different place. snip Thanks Drew This is the default behaviour for most windows programs that I use and it would be a welcome change in OOo. It can sometimes be annoying, so having the ability to turn the feature on and off would be nice. Being able to specify the default save location when the program is not using the 'last used' location would be even better. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] copying from one sheet to another, skipping 2
bill wrote:
Joe Conner wrote:
bill wrote:
My spreadsheet has blood pressure values in sets of 3. I average
each them and then use the average of each set, which works fine.
But, I now have 2 rows that have the original data and nothing else,
and distract from the presentation.
So, I need to either copy every 3rd row to a new sheet or
automagically make the other 2 rows disappear from the original sheet.
I could do it manually, but I get new data frequently and would
prefer not to do all the work by hand.
Is there a way to tell calc to copy just every 3rd row from one sheet
to another, or
to hide 2 of 3 rows ?
Perhaps if you put your raw data on one sheet and your averaged data
on a second sheet?
Good idea, but that still leaves the problem of moving every 3rd row to
the new sheet with the averaged data.
Hi Bill,
Assuming data in Column A only, fill a column in the second sheet with this
formula:
=INDIRECT("Sheet1.A"&TEXT(ROW()*3;"0"))
Replace "Sheet1.A" with the actual sheet name and column address of you data.
This will return the data from rows 3, 6, 9, etc. If those aren't the correct
rows, you may have to do some math in the ROW()*3 section.
tc
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Transfer personal data to 3.0 was Re: [users] Uninstall previous versions
Dotan Cohen wrote: 2008/10/15 John Jason Jordan <[EMAIL PROTECTED]>: Over the years I have added hundreds and hundreds of words into the "standard" dictionary in OOo, which is currently version 2.4.1. However, I don't really know how dictionaries work. Do I understand correctly that these entries are in a separate dictionary file? If so, can I just add the dictionary to the configuration folder for 3.0 when and if I install it? Untested, as I do not yet have OOo3: Open the dictionary file (it is plain text) in OOo3 Writer. The program will mark all the words as misspellings. Add each one to the dictionary. It may take some time, but it is a one-time procedure. That sounds like a lot of work. If the dictionary is plain text, couldn't the old file be pasted into the new one? tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Templates for Form Filling
Hi Keith, I'd scan the documents, then drop them, one to a page in a writer file. Check the size to make sure that it's correct. Set up a spreadsheet with the information for the forms, then place a field that's linked to the spreadsheet for each bit of information that you want to import. When you print, turn off graphics in the print options. tc Keith Bates wrote: This is probably really easy to do, but I'm not sure where to look for instructions. When I perform marriages I need to fill in about three or four forms plus statutory declarations with the names of the bride and groom, addresses, occupation, mother's maiden name etc. The forms are not all the same format. At the moment, most of them are filled in by hand because it's easier than making the effort to organise templates etc. to print the information into the right spot on the form. What I'm thinking is make a document (spreadsheet?) to enter the information then have OO put that into the right places so I can print onto the forms. Can somebody please suggest how I might do that and point me towards a relevant tutorial or help file? Thanks - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] calc
Link the sections into a writer document. tc Joe Grech wrote: Hi I wish to print selections from different sheets on one page for comparison purposes. Can it be done? Tks. _ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Printing handouts from impress
Hi Gary, It's not as cool, but you could copy the slide once for each callout and make the dissolve part of the slide transition. tc Gary Cowell wrote: Hi I'm creating a presentation in OO.o impress 2.4.1. I will want to create printouts/handouts of this presentation once it's done but I'm really only at the start of it and have hit a problem/question. One of my early slides has a row of boxes about 2/3rds of the way down the page, evenly spaced out. I then use custom animations to disolve in a callout underneath the first one, describing it. The next click of the animation dissolves the first callout out, at the same time as dissolving in another callout a little way along, describing the second box, and so on to the end when the last one dissolves out. Looks great on screen (well, as great as I can make it anyway) but I can't see a way of printing this as a handout. Ideally I'd like to print individual pages as at the endpoint of each animation step, but I really can't see how to do this. Can this be done? The printouts are unreadable as they stand as all the callouts overlap each other along the page. Thanks! Gary - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] v3.0 beta - Dictionary & Spell Check software for Open Office Writ
jonathon wrote: On Tue, Sep 23, 2008 at 05:52, Anthony Chilco wrote: where do I find Dictionary & Spell Check software for Open Office Write File-Wizards - Install new dictionaries In 2.4, but not in 3.0 beta. What's up with that? In 3.0 dictionaries are treated as extensions, and installed using the extension manager. I'd give more specific instructions, but version 3.0 is not available for my system, and I haven't yet compiled it for my system. :( [For once in my life, I am on the far side of the bleeding edge. The only software I have, is the software that I compile myself. ] xan jonathon Thanks Jonathon. That answers my question. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] v3.0 beta - Dictionary & Spell Check software for Open Office Write
Russell Butler wrote: Allan Hardess wrote: where do I find Dictionary & Spell Check software for Open Office Write Hi Allan File-Wizards - Install new dictionaries for starters, then Very useful tutorial at http://user.services.openoffice.org/en/forum/viewtopic.php?f=7&t=67 Russell In 2.4, but not in 3.0 beta. What's up with that? tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: OOo 3 How much disk space should it need
NoOp wrote: snip I think folks are missing a few folders (linux): ooo-dev = 343.5 MB which contains: - basis3.0 = 333.6 MB - ure = 9.9 MB ooo-dev3 (for the development m4 version) = 39.5 MB So that adds up to around 383 MB of disk space. Then of course you need to add in anything that is added to your user profile folder (~/.ooo-dev3 or .ooo-dev). I'm not on my system with OOo3Beta nor on a Windows system right now, but I can pretty much guarantee that it will be similar. Maybe this is the first step toward OOo being upgradeable. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OOo 3 How much disk space should it need
TomW wrote: Graham Smith wrote: Thanks both, This seems an amazing reduction in resource use. I'm surprised it hasn't been commented on. What little I have read has assumed that 3 will be bigger than 2. Indeed I had assumed this would be the case. and one of the reasons of looking at it was getting an eeepc and I wondered how much extra room it would need. Graham 2008/9/4 Anthony Chilco <[EMAIL PROTECTED]>: 322meg for 2.4, 56meg for 3. Nothing in common files or application data that I can find. tc Graham Smith wrote: Out of curiosity, I could not resist having a look at the latest beta of 3, but it seems to be only taking up 50Mb of disk space, compared with 300Mb plus for 2.4 (WinXP in both cases). Does OOo 3 scatter its files around, or am I missing something obvious, or have the OOo team really got the footprint down to 50Mb. Graham - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] OOo3.0 DEV on Vista shows 335Mb in the add/remove program dialog. There are two folders in the "Program Files" directory. One is OOo-dev and the other is OOo-dev3, totaling 335Mb. TomW Hi Tom, I found the same thing last night when I did a new install of beta 3. Oh well... tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OOo 3 How much disk space should it need
322meg for 2.4, 56meg for 3. Nothing in common files or application data that I can find. tc Graham Smith wrote: Out of curiosity, I could not resist having a look at the latest beta of 3, but it seems to be only taking up 50Mb of disk space, compared with 300Mb plus for 2.4 (WinXP in both cases). Does OOo 3 scatter its files around, or am I missing something obvious, or have the OOo team really got the footprint down to 50Mb. Graham - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OOwriter equivalent of html tag?
Hi Larry, Use shift-return to go to the new line. When you want the next number in the list, use return. tc Larry Evans wrote: In a numbered list, there's several items in which I want several paragraphs; however, whenever I hit carriage return, the next numbered item appears instead of just another paragraph under the current item. What I need is someway to emulate the html ... or the xml ...; however, I can't figure how to do that. The closest I've got is a manual line break. Is there a way to just say I want another paragraph under the existing list item? -Larry - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Cell formatting question
Hi Mark, The author of the original spreadsheet probably used conditional formatting. The cell is hidden if M33 is zero. tc Mark Knecht wrote: Hi, I'm looking at a prebuilt spreadsheet in Excel and trying to duplicate some of its functionality in OOCalc. I'm having trouble with one formatting issue. In Excel there is a cell that has the following contents: ="Option "&M33 M33 is a cell that contains a number from 0-160. In Excel when M33 is 1 or greater Excel displays Option 1 or whatever number is in cell M33. However when M33 is 0 Excel displays nothing. The cell is completely blank. It does not say Option 0. When I try to build this myself, in Excel or OOCalc I see Option 0 in my version. How did the guy who created this spreadsheet get Excel to do this? I've checked all the formatting for the cell and I just don't see it. Thanks, Mark - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How can I sort a column alphabetically on Spreadsheet?
Hi Albert, I must select the data that you want to sort before the sort buttons will become active. tc p.s. Where's Fonthill? I'm in Brooklin, north of Whitby. p.p.s. It's not a good idea to include personal details like address and phone number. This is a public mailing list and all messages are available to anyone on the internet. Albert J. Mettler wrote: Fonthill, Ontario, 20 August 2008. Dear Sirs and Ladies, Having recently acquired a new computer with OpenOffice, I have tried to sort Column B alphabetically on the Spreadsheet, but have been unable to do so. The "Sort" buttons at the top don't seem to work. With anticipated thanks for your response, I remain, Yours truly, Albert J. Mettler, P.O.Box 35, Fonthill, Ontario L0S 1E0 Canada Tel.1-905-892-3800. E-mail: [EMAIL PROTECTED] [no dots or hyphens in the name and the J must be included] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Dividing a very long string
Hi Bashar, Use find and replace. Click 'more option' and check the 'regular expressions' box. In the 'Search for' box enter "..". In the 'Replace with' box enter "&\n". Click 'Replace all'. In both boxes do not enter the double quotes. If the string is not the entire file, select the string and check the 'Current selection only' box. tc Bashar Maree wrote: Hi, I have a very long string of characters in a Writer document that I'd like to separate into lines with (let's say) 10 characters each. Is there a way to automate this task in OOo, maybe using 'Find&Replace' in some manner. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] filled cells cannot be shifted beyond the sheet
Hi Ramzi, You have data on the last row in the spreadsheet. Inserting a new row will push this data off the sheet. tc Ramzi El Halabi wrote: Dear All, I am trying to insert a row in Microsoft Excel file and I am getting this message "filled cells cannot be shifted beyond the sheet" ? I am using open office Calc version 2.4.1 on Windows XP computer. Why it is giving me this message and preventing me from inserting new Rows? Regards, Ramzi Al Halaby IT Department Societe Ets Michel Najjar Email : [EMAIL PROTECTED] Office : 01884830 / 01877250 Ext. 126 Fax : 01 882364 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Problem produsing Word and PDF documents
Hi Jan-Henry, When you 'save as' check the 'automatic file name extension' box on that dialogue. tc Jan-Henry Steen wrote: I have problems produsing Word and PDF documents with OpenOffice.org v2.4 when i save as Microsoft word 97/2000/XP(.doc) or export as PDF format the document is saved without .doc or .pdf and are not readable for other people. They are not opened in OpenOffice when i dobbleclick on them, but i can open then i i explisitly use openOfiice. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to insert floating table/figure?
Hi Grant, Insert a frame, then put the table into it. tc Grant Edwards wrote: How does one insert a floating table/figure in oowriter document? None of the choices for positioning objects seems appropriate. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] macros help
Hi David,
This may help:
http://documentation.openoffice.org/HOW_TO/various_topics/VbaStarBasicXref.pdf
tc
David Cummings wrote:
Thank you for the replies so far, just wish we could get somewhere. Do any
of you know of a site where I could get the VB command=OO command? If I
could get that, I could then translate the program with just a bit of work.
On the pedigree section of the program not even Microsoft professional were
able to help. We just experimented until we finally got the right combo.
David Cummings
-Original Message-
From: Anthony Chilco [mailto:[EMAIL PROTECTED]
Sent: Friday, August 15, 2008 1:14 PM
To: users@openoffice.org
Subject: Re: [users] macros help
Hi David,
OOo v3 beta has limited support for VB macros. I opened your spreadsheet
with
it, but the macros would not run.
tc
David Cummings wrote:
Hi
I have a little Excel program that works on several macros and I want to
add some more to it. However, I cannot get it to work in Open Office
Calc. I have been working with this for several years on and off and my
brother and I finally got the pedigree section to work right. However,
when I bring over to OP, I cannot get any thing to work like I wish.
I am a canary breeder and we who are breeders must keep very accurate
records. This is important for us though it is just a hobby. Most of us
do not make any money with our birds, just recover food cost.
Here are the macros. I can attach the sheets if you all wish.
David Cummings
Sub DataEntryForm1()
'
' DataEntryForm1 Macro
' Macro recorded 11/23/2002 by Unknown User
'
'
Sheets("BirdData").Select
Range("A1").Select
ActiveSheet.ShowDataForm
Sheets("Tree").Select
Range("A1").Select
End Sub
Sub BuildTreeForm2()
'
' BuildTreeForm2 Macro
' Macro recorded 11/23/2002 by Unknown User
Sheets("BirdData").Select
Range("A1").Select
frmBuildTree.Show
Sheets("Tree").Select
Range("A1").Select
End Sub
Sub PrintTree()
Sheets("Tree").Select
Range("B1").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Range("B1").Select
End Sub
Suspicious files found in the attachments
Bird Record Book.xls: Contains macros
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.6.3/1613 - Release Date: 8/15/2008
5:58 AM
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] macros help
Hi David,
OOo v3 beta has limited support for VB macros. I opened your spreadsheet with
it, but the macros would not run.
tc
David Cummings wrote:
Hi
I have a little Excel program that works on several macros and I want to
add some more to it. However, I cannot get it to work in Open Office
Calc. I have been working with this for several years on and off and my
brother and I finally got the pedigree section to work right. However,
when I bring over to OP, I cannot get any thing to work like I wish.
I am a canary breeder and we who are breeders must keep very accurate
records. This is important for us though it is just a hobby. Most of us
do not make any money with our birds, just recover food cost.
Here are the macros. I can attach the sheets if you all wish.
David Cummings
Sub DataEntryForm1()
'
' DataEntryForm1 Macro
' Macro recorded 11/23/2002 by Unknown User
'
'
Sheets("BirdData").Select
Range("A1").Select
ActiveSheet.ShowDataForm
Sheets("Tree").Select
Range("A1").Select
End Sub
Sub BuildTreeForm2()
'
' BuildTreeForm2 Macro
' Macro recorded 11/23/2002 by Unknown User
Sheets("BirdData").Select
Range("A1").Select
frmBuildTree.Show
Sheets("Tree").Select
Range("A1").Select
End Sub
Sub PrintTree()
Sheets("Tree").Select
Range("B1").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Range("B1").Select
End Sub
Suspicious files found in the attachments
Bird Record Book.xls: Contains macros
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.6.3/1613 - Release Date: 8/15/2008 5:58 AM
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Calc question
>> emf wrote: >>> I have a few Quattro-Pro files, containing charts. I am wondering if >>> there is any way to transfer them to OOo Calc, maybe be a combination >>> of Quattro-Pro and Calc filters... >>> >>> Also, how can I create a chart with bars that represent the lower and >>> higher values from 2 columns (B and C), while A contains dates? >>> >>> Eustace >>> On 2008-08-13 12:05 Anthony Chilco wrote: Hi Eustace, OOo v2.4.0 has an input filter for Quattro v6 (*.wb2) files. tc emf wrote: Yes, but QuattroPro v11 does not seem to preserve the charts when saving as QuattroPro v6... Eustace Try saving in Doc format, then importing into OOo. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc question
Hi Eustace, OOo v2.4.0 has an input filter for Quattro v6 (*.wb2) files. tc emf wrote: I have a few Quattro-Pro files, containing charts. I am wondering if there is any way to transfer them to OOo Calc, maybe be a combination of Quattro-Pro and Calc filters... Also, how can I create a chart with bars that represent the lower and higher values from 2 columns (B and C), while A contains dates? Eustace - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] how to open a spreadsheet file with password
Richard Detwiler wrote: [EMAIL PROTECTED] wrote: obviously i do not recall the password Obviously not -- but also obviously, w/o the password, no one else can open it either. snip You need the password to open it. Without the password, there isn't any realistic way to open it. It may go without saying, but that's the purpose of password-protecting a file -- that it can't be opened w/o the password. There is an OOo macro available that takes a list of possible passwords and will attempt to open the file. If your password was a random sequence of letters and/or numbers, it won't work. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Rotate column of data to create an array?
Mark Knecht wrote: In my case, since the values in the X column remain valid for the rotated version I could even accept that these values weren't changed at all, but unfortunately it's a huge amount of work to go back and make every entry $X$64, $X$65, etc. I'll do it if I have to but I'd rather not. Any ideas how I get around this? If this is too complicated to do in words I'll post a small spreadsheet as an example. Thanks, Mark Hi Mark, As a quick fix, you can use find and replace to change X64 to $X$64. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Two situations ...
Julian wrote: Hello Phil, You wrote: Julian: Two, shortly after I joined this group, the amount of spam I receive, shot up a lot. I suspect that one or more of the members have spyware on their computer system, which is sending out addresses to a spammer. There's nothing to stop an actual spammer from subscribing to this list and adding everyone that posts to their spam database. Hi, spammer! Feel free to fill up my Google Mail account with spam that I'll never see! Phil Hibbs. I have only one thing to say, "Rats! That is the one comment I never expected to get." Thanks for your insight, though. Kind regards, Julian Aronowitz Hi Julian, When my spam level got to be intolerable, I opened a Hotmail account and started to use it exclusively for this list. All mail to that address that doesn't originate here goes straight to the junk bin. Since then, the spam on my home email has been declining. tc p.s. I made the mistake of posting a question on a Microsoft Windows forum once and used my work email. The spam deluge was almost instant, and lasted for about two years. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Maintaining macro compatibility between OO.o basic and VBA
Julian wrote: Hello Anthony, Anthony Chilco wrote: Hi Jerry, As long as the macros use plain VB code without any Excel specific functions or variables, they should run in OOo v3. I haven't had much luck, though. I've found that the OOo VB implementation will choke on stuff like this: Dim LastUsedRow As Integer Dim LastUsedCol As Integer ActiveCell.SpecialCells(xlLastCell).Select LastUsedRow = ActiveCell.Row LastUsedCol = ActiveCell.Column The assignments to lastused row and col work, but xlLastCell isn't there. I don't know if there's a method to accomplish this that will work in both packages. tc Jerry Feldman wrote: At work, we have a spreadsheet that serves as a specification for the C++ product that I am working on. The previous maintainer of the spec implemented the math as forulae, and was very compatible with OO.o. I work exclusively on Linux, and I need the spec in OO.o. The new maintainer of the spec wants to convert this to be macro based (which is better than the old spec for a number of reasons), but he wants to maintain it in Excel because he knows VBA, and the spec will be sent out to other people within the company and to some customers. While we have agreed that he will also maintain an OO.o document, I was wondering if there is a good document that compares OO.o basic to VBA. My premise at work is that the document must be available as an OO.o document because Excel does not run under Linux. I know and have used several programming languages, including more than one form of BASIC. One of the reasons a past client of mine asked for my help was because I am able to translate the source code from one BASIC to another. At that time it was being able to translate AppleSoft (a Microsoft product) BASIC to an extended BASIC (also written by Microsoft, but designed for the Spectrovideo 328 computer). If one tried running the program on the Spectravideo computer, as it was written in AppleSoft, it would finally fail because the interpreter would not know what to do. The basic set up was the same, but certain types of system calls were totally different or not needed when programming for the Spectravideo computer. If you or Jerry wish to have the Macros work under OpenOffice, you MUST translate, by hand, that code which is different. How do you do that? You do that by first having a good idea of how one of those structured BASICs work, and by having a manual for each one in front of you. Then, you go over each line of code, carefully making sure what is written will operate in the same way. If it will not operate in the same way, or will not operate at all, you must know how to change it and with what to change it. This is painstaking work. I wish I knew an easier and faster way, but I do not. But it can be done and done quite successfully. BTW, you might want to have a look at the original developers of structured BASIC. It is called, "True BASIC." It will give you some insight about all the brands of structured BASIC. Hope this helps. Regards, Julian. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Hi Julian, I'm aware of the problems of trying to run the same code with different interpreters. I think you're missing an important point, though. V3 of OOo has introduced MS VBA compatibility as a new feature. It's there for the plain vanilla code, but not yet complete. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Maintaining macro compatibility between OO.o basic and VBA
Hi Jerry, As long as the macros use plain VB code without any Excel specific functions or variables, they should run in OOo v3. I haven't had much luck, though. I've found that the OOo VB implementation will choke on stuff like this: Dim LastUsedRow As Integer Dim LastUsedCol As Integer ActiveCell.SpecialCells(xlLastCell).Select LastUsedRow = ActiveCell.Row LastUsedCol = ActiveCell.Column The assignments to lastused row and col work, but xlLastCell isn't there. I don't know if there's a method to accomplish this that will work in both packages. tc Jerry Feldman wrote: At work, we have a spreadsheet that serves as a specification for the C++ product that I am working on. The previous maintainer of the spec implemented the math as forulae, and was very compatible with OO.o. I work exclusively on Linux, and I need the spec in OO.o. The new maintainer of the spec wants to convert this to be macro based (which is better than the old spec for a number of reasons), but he wants to maintain it in Excel because he knows VBA, and the spec will be sent out to other people within the company and to some customers. While we have agreed that he will also maintain an OO.o document, I was wondering if there is a good document that compares OO.o basic to VBA. My premise at work is that the document must be available as an OO.o document because Excel does not run under Linux. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Reading PDF Files
Hi again, I just downloaded and installed OOo 3 beta. In order to import pdf, you need to add the pdf import extension. You can get it here: http://extensions.services.openoffice.org/project/pdfimport?intcmp=1549 tc A Chilco wrote: Hi Helene, The current version of OOo won't read PDF files. Version 3 is supposed to be able to. You'd have to download the beta version to try it out. An alternative would be to use Foxit Reader. It has the facility to add notes and text to a pdf. You can't change the existing text, but it works for redlining and markup. The free version is supposed to be for evaluation only and will add a banner to all modified pages. tc You appear not to be subscribed to the users' mailing list. You could miss many of the replies to your post unless you do subscribe. Just send a blank message addressed to <[EMAIL PROTECTED]> using the e-mail account through which you want to receive it. You will receive a message asking you to confirm your subscription by replying to it. See http://support.openoffice.org/index.html for more options. Subscribing is optional. Be aware that after subscribing, you may receive many messages from the list. Be prepared to set up mail filters in your email client in order to deal with them. [EMAIL PROTECTED] wrote: Hello! I am about to start proofreading for another organization. I am used to receiving my articles in Word Files and want to update my creaky Word 97. The new group sent me PDF files and I don't have Adobe.? Can OpenOffice read/edit PDF files? Please answer ASAP. Thanx. Helene O'Neill - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] If statements
Hi Keith, Possibly because G2 holds a numeric value and you're comparing it to a string. tc Keith Clark wrote: Why would the following happen? G2=08:57 if(g2>"08:00";1;0) results in 0 if(g2<"09:00";1;0) results in 1 Keith - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Don't want files converted to OO
Hi Phil, OOo doesn't change the description, Windows does. tc Phil Hibbs wrote: If you choose to make OO the default handler, does it change the description of the files? That would rather annoy me - they aren't OpenOffice files, they are Microsoft Word files. My brother keeps recommending IrfanView but I won't install it because I don't want every file on my computer to be called an IrfanView File. Applications should not claim all files as their own! Phil Hibbs. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Don't want files converted to OO
James Knott wrote: Ray Cooper wrote: When I downloaded the most recent version of OO writer, it converted all my word files to Open Office files. I want to keep them as Word files. How can I convert them back? It doesn't change them to OpenOffice files. It changes the file association, to make OpenOffice the default application for them. This changes the icon, but the files are still Word files. Even when you run the conversion utility, which creates ODT files, the original files are unchanged. Hi Ray, It would help if you turned off the feature in Windows that hides the extensions on files. Then you would be able to see that your *.doc files are unchanged. If you have Word installed and want to change the association back to Word, you can find instructions for doing that in the FAQ sections on www.openoffice.org tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Please take my email address off of your mailing list. I'm getting sometimes 20 or more mailings. Much more than I can handle. Thanks.
Hi Kenneth, Only you can remove yourself from the list. Here's how: To unsubscribe, e-mail: [EMAIL PROTECTED] Just send a blank message to the address above. You will receive a confirmation message. Reply to it. I've done this and the whole operation took less than an hour. Others have reported that it has taken several days. Be patient. tc Kenneth Chauvin wrote: Please take my email address off of your mailing list. I'm getting sometimes 20 or more mailings. Much more than I can handle. Thanks. [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] No virus found in this incoming message. Checked by AVG. Version: 8.0.101 / Virus Database: 270.4.1/1521 - Release Date: 6/26/2008 11:20 AM - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [users] Re: PDF Forms
> To: users@openoffice.org > From: [EMAIL PROTECTED] > Date: Wed, 25 Jun 2008 15:18:18 +0200 > Subject: [users] Re: PDF Forms > > NoOp wrote the following on 25/06/2008 6:16: > > > I see that no one has responded. Perhaps this is because it is not clear > > (to me anyway) exactly what you wish to do. Could you please provide snip > > My only problem now is that these PDF forms, created by using Writer, are not > allowed by the Acrobat > Reader to save the data which is filled in. One can only print it, nothing > more. I would prefer one > could simply save and return it, or just the requested data, by email. > > Has any one experience with similar forms and thus problems? > > I hope this is a little bit more clear. > > Regards, > > Pieter > Hi Pieter, I did a quick test... created a form using writer, exported a PDF, then added some data (text box, check boxes) using Acrobat Reader v8 and Foxit PDF reader. With acrobat, I cannot save. Foxit allows me to save and the changes are there if I then open the file using acrobat. Foxit is a free for any use program. The other suggestion, which Mike has put forth, is to install a pdf print driver to output the filled in form as a pdf. There is an advantage to using this method, as the form can't be changed after submission. tc _ Try Chicktionary, a game that tests how many words you can form from the letters given. Find this and more puzzles at Live Search Games! http://g.msn.ca/ca55/207
Re: [users] [OpenOffice] Calc Issue or not: filled cells cannot be shifted beyond the sheet
Hi DPD, There is a hard limit to the number of columns in calc. It seems logical that, if all columns have data in them, you would be unable to add more columns. Normally, when you add a column to a sheet that is not filled, the last column is dropped to make room for the incoming column. If you put some data in the second last column, then add a culumn to the left of it, you'll see that the data is now in the last column. Attempts to add more columns will result in the message you've described popping up. tc [EMAIL PROTECTED] wrote: Greetings: First, if the users@openoffice.org list is not an appropriate starting place for the issue/non-issue I am about to describe and you know which is /are better, please let me know. I am getting the error "filled cells cannot be shifted beyond the sheet" when I try to add one or more columns into my spreadsheet that already contains data in each and every column up to an including the IV column. From my initial research of this matter, it is not clear to me of this is indeed an issue or it is simply a hard-coded/built-in limitation? If it is an issue and it has been resolved, how do I go about applying/getting the fix? I've seen a bug report on qa.OpenOffice.org (http://qa.openoffice.org/issues/show_bug.cgi?id=80302) that implies this is an issue and has been fixed in 2.4.x. Well, I've tried 2.4.1 and I am getting the same error. I think at this point I may have to logically break down this particular spreadsheet into smaller ones; this is not what I'd want to do, but if I have no other option, then so be it. I have purposefully left out details b/c I think this is a well known problem (or, expected function?) for those well versed in OpenOffice's Calc component. If you need/want details, just ask. Lastly, I am not subscribed to this list, so please do include my e-mail address in your response. DPD. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 270.4.1/1516 - Release Date: 6/24/2008 7:53 AM - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Writer - duplicating Frame
Gordon wrote: "Drew Jensen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Gordon wrote: Is there an easy way of duplicating a frame? I need to have a document with three identical frames on the page. Copy Paste? No, doesn't work. That was the first thing I tried! Hi Gordon, Works for me. Try unselecting the frame after you copy. If it's selected, the paste operation will replace the existing frame. The pasted frame will be in the same location as the original. Move it and you'll see the original below it. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Probably another stupid calc question
Hi Jerry, If you insert rows or cells from 200 down to 300, the formula will change to reflect the new position of A200. tc Jerry Feldman wrote: If I have a column of numbers, say A1 to A200 and a =SUM(A1:A200) Now, I replicate A200 down to A300. Is there any good technique I can set up the sum so that it will reflect this change without manually having to change is to =SUM(A1:A300). The actual problem I have is that I have a number of columns I need to replicate as well as a number of different sums. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: How hidden calc in OO Comand mode ?
Hi Jorge,
I found this in help by searching for 'command line':
Starting the OpenOffice.org Software From the Command Line
1.Under Windows, select Run from the Windows Start menu, or open a Shell under
UNIX® based platforms.
2.Under Windows, type the following text in the Open text field and click OK.
3.Under UNIX based systems, type the following line of text, then press Return:
{install}\program\soffice.exe {parameter}
Replace {install} with the path to your installation of the OpenOffice.org
software (for example, C:\Program Files\Office, or ~/office)
Where required, replace {parameter} with one or more of the following command
line parameters.
-invisible
Starts in invisible mode.
Neither the start-up logo nor the initial program window will be visible.
However, the OpenOffice.org software can be controlled and documents and dialogs
opened via the API.
When the OpenOffice.org software has been started with this parameter, it can
only be ended using the taskmanager (Windows) or the kill command (UNIX based
systems).
It cannot be used in conjunction with -quickstart.
More information is found in the OpenOffice.org Developer's Guide.
Jorge Grate wrote:
I ask in English, my English is not very good, but you can understand your
me.
Regards
"Harold Fuchs" <[EMAIL PROTECTED]> escribió en el mensaje
news:[EMAIL PROTECTED]
On 27/05/2008 17:24, Jorge Gárate wrote:
Hi:
Need Speed and i think in hidden Calc, not show Sheet and like work, to
try and check how much time is less.
What is command or sintax ?
Thanks
If you prefer to discuss your problem in Spanish, please visit
http://es.openoffice.org/ and follow the links to the Spanish speaking
support group.
No virus found in this incoming message.
Checked by AVG.
Version: 8.0.100 / Virus Database: 269.24.1/1470 - Release Date: 5/28/2008 7:20 AM
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] need help to open a file
Richard Detwiler wrote: saran kumar wrote: sir, I saved a word document with password. Unfortunately i forget it... now I want that software. how can i open it by saran My understanding is that the password protection that OpenOffice uses is very good, thus it is essentially impossible to open a password-protected document without knowing the password. (Which, of course, is the point of using password protection.) There is a macro available that will take a list of possible passwords and try them all, with variations. If you have some idea what your password could be, this method may work. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Download time for open office
John Kaufmann wrote: In a message dated 2008.05.07 11:37 -0500, Lisi Reisz wrote: coining their own federal currency, I don't believe they ever actually made a 1/8 dollar coin (though individual colonies may have done so) -- but tradition dies hard. - John A quarter is still referred to as '2 bits', as in 'Shave and a haircut - 2 bits'. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Saving .xls to .csv with full precision for numbers
Rick Bilonick wrote: On Tue, 2008-05-06 at 10:46 -0400, James Knott wrote: Rick Bilonick wrote: I have a spreadsheet with numbers like 71.08929399 which when save end up to be 71.09. I need to save all numbers in the exact precision in which they are stored. I'm using OOo 2.3 (Red Hat). I don't see any options to force this. You can set up to 20 decimal places for a number. Is that sufficient? Also, if you're not doing calculations with that number, you could use the text format. The number 71.08929399 is what is actually in the .xls spreadsheet but only 2 decimal places display in the cell. When I save the spreadsheet to a .csv file, only 71.09 is saved. I want to always and automatically save the full precision to the .csv file (otherwise I'm inadvertently changing the contents). You say I can save up to 20 decimal places but you give ABSOLUTELY NO INFORMATION on how to do it. Using text format makes no sense. The data comes in a spreadsheet with 2 decimal places formatted for display. I want to keep ALL the real precision when saving to .csv. I don't want to round or truncate when saving to .csv. I can change the format for viewing but that is a real pain plus it makes viewing the spreadsheet difficult. There must be some way to force Calc to save all numbers with complete precision. I've looked through all the options and tried changing some but nothing I've done so far does the trick. Rick B. Hi Rick, When you save your CSV file, check the box labeled 'Edit filter settings'. After you've entered a file name and clicked 'ok', you'll get a dialogue that allows you to set the character set, field and text delimiters. Uncheck the box labeled 'Save cell content as shown'. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] problem using open office
Barbara Duprey wrote: Tony and Christine King wrote: We have been using Open Office for about 3 years, but a couple of days ago found we could not open attachments to emails, files on our computer which have been in regular use without any problem, or even open Open Office Writer to create a new document. Help!! Your advice is eagerly anticipated. Tony and Christine King I see two possibilities here, there may be others. 1. Sometimes OOo seems to leave obsolete instances of soffice.bin running, and that can cause attempts to open any OOo application to silently fail with no messages or anything. In Windows, this can be fixed by using the Task Manager to end any such process, or by restarting the computer. 2. Your copy of OOo may have become corrupted. If you still have the original downloaded file, you can reinstall; otherwise, you'd have to download either that version (if available) or the current version, and install that. If your older version was in the 2.x series, the new version will replace it. If your personal settings files (.xcu files) have been messed up, you may have to delete them and let OOo create the default versions, then re-establish your settings. (I have no experience with this sort of thing, somebody else on the list will probably help you through it if necessary.) I'm copying you directly on this message, since you seem not to be subscribed, but please respond only to the list. Since your version of OOo is at least three years old, you may want to download the latest version. If you haven't customized it in any way with macros or personal dictionaries, just uninstall the current version and delete the program directory (program files\openoffice.), then install the new verion. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] PW problem - fairly new user - Sherra Hinkle
Hi Sherra, It's still not clear what's wrong. Are you saying that you've created files using a copy of openoffice that was installed on your computer, but saved them with a password and now you can't open the files? Or were you using an online version of openoffice to create files that are stored online and now can't access the account you created to use it? tc [EMAIL PROTECTED] wrote: Thanks for your prompt response. I did utilize this program before with my email address, but the program is not allowing me to use my password. If I create a new account, I can't retrieve the infor I had before. -- Original message -- From: James Knott <[EMAIL PROTECTED]> [EMAIL PROTECTED] wrote: I signed up on openoffice.org and started using the program, unfortunately our computer crashed and we have to reinstall everything - when I tried to retrieve my openoffice.org access, there was a record of my user name, but not my password - I followed the instructions to have my pw sent to my email/user name, but I have not yet received it - its been several weeks now. Can you help me? There is no password to obtain OpenOffice, if you get it from www.openoffice.org. I suspect you paid someone to download what is available for free from www.openoffice.org. -- Use OpenOffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Free AVG8.0 Is Now Available
Did I miss something? I read the privacy policy and I understand that any data collection, storing or sharing relates only to avg websites or their affiliates, and only if you register, which is optional. tc Ike Dawson wrote: Good Evening All I've used AVG for a long time and it is really quite good though not perfect: never the less I intended to continue using it. However, I noted that the company has been restructed as of Jan 08 so I read the End Users Licence Agreement very carefully and found what agreement to the EULA meant was quite unacceptable to me. May I respectfully suggest that if you intend to put AVG 8 on your computer, do read the EULA and particularly the privacy policy which you have to dig for but it is there to find for those who persist, and make sure that the conditions of use are fully acceptable to you. Yours aye Ike Dawson At 16:42 30/04/2008, you wrote: From: "Jonathan Kaye" Sent: Wednesday, April 30, 2008 3:29 AM Subject: [users] Re: Free AVG8.0 Is Now Available JOE Conner wrote: Off topic, but of general interest, free AVG 8.0 is now available for home use: http://free.grisoft.com/ww.download?prd=afe "general interest"??? I don't think so. ;-) Jonathan -- That is news to me Last week they still had only the version 7.x.x for free - which I have. I will give it a look and see. Thanks -- No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.6/1404 - Release Date: 4/29/2008 6:27 PM - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OOCalc problem
Hi Thomas, Sorry for not being clear. I was referring to folder option in windows explorer, not in calc. OOo refers to any of the openoffice.org modules... calc, writer etc. If you can run OOcalc, the use file / open to load one of your files, then the problem may be in the name of the file. Windows uses the file extension to identify the file type. OOCalc will read the contents to determine if the file is a spreadsheet. If you had used 'save as' to make the copy and didn't have 'automatic file extensions' enabled in the save as dialogue, the files could have been saved with no extension. This would leave windows no way to tell what the file type is. Though you did state that the file type was listed as 'Excel'. tc thomas steel wrote: Thank you, Anthony Chilco for responding. I hope you still have patience! Here are my initial replies to your 3 questions: 1. I can't find anything remotely like Folder Options in Tools on OOCalc. Please can you tell me how to find that? 2. I can't see what you mean by opening one of the files by running OOo. What is OOo? & where would I find 'File open'? 3. Unfortunately I can't remember which method I used to get the files into the new folder. I made copies first, for new use & then deleted the old figures in the new copies & started afresh. Then I created a New Folder. Then I think I used the right click method to move the old ones. But I may have used 'Save as'. TMS - Original Message - From: "Anthony Chilco" <[EMAIL PROTECTED]> To: Sent: Thursday, April 24, 2008 9:53 PM Subject: Re: [users] OOCalc problem Hi Thomas, The icons and the file description displayed in windows explorer don't tell you much about a file, but rather what windows thinks the file is. This is set up in the windows file association. Have you got file extension display turned off? If so, turn it on using 'tools / folder options / view' and uncheck the box 'Hide extensions...'. Tell us what the extensions on the files are. Can you open one of these files by running OOo, and using 'file / open', then browsing to the file? How did you get the files into the new folder? Did you copy them or use 'file / save as'? tc thomas steel wrote: Still no response to my OOCalc problem, so let me put it another way. Old Excel files, which converted happily to OOCalc & were regularly worked on, now, after having been put in a new folder, describe themselves as Excel and won't open. If no-one can tell me how to open them, can someone at least tell me what their icons (new to me) mean---or where I can find them described? One is green with a cross in the middle. Others are blue bottom half and pink across the top. I am am really stuck with this. T.M. Steel - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OOCalc problem
Hi Thomas, The icons and the file description displayed in windows explorer don't tell you much about a file, but rather what windows thinks the file is. This is set up in the windows file association. Have you got file extension display turned off? If so, turn it on using 'tools / folder options / view' and uncheck the box 'Hide extensions...'. Tell us what the extensions on the files are. Can you open one of these files by running OOo, and using 'file / open', then browsing to the file? How did you get the files into the new folder? Did you copy them or use 'file / save as'? tc thomas steel wrote: Still no response to my OOCalc problem, so let me put it another way. Old Excel files, which converted happily to OOCalc & were regularly worked on, now, after having been put in a new folder, describe themselves as Excel and won't open. If no-one can tell me how to open them, can someone at least tell me what their icons (new to me) mean---or where I can find them described? One is green with a cross in the middle. Others are blue bottom half and pink across the top. I am am really stuck with this. T.M. Steel - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OpenOffice 2.4--Automatic Update failure
James Knott wrote: David Rittenberg wrote: 4/23/08 I have Open Office 2.4. In Writer, when I click Help--Check for Updates, I receive this message: "Checking for an update failed. Could not establish Internet connection to update24.services.openoffice.org." Presumably, the problem concerns connection between my system and the internet. My OS: Windows XP. My firewall (a part of McAfee Security Suite) is version 9.0.136. I connect to the internet via DSL. Is there a solution for this problem? I would appreciate any recommendations or information. Thanks, [EMAIL PROTECTED] I've noticed that the OpenOffice server appears very sluggish today. That may be the cause of your problem. Hi David, You may have to set McAffee to allow soffice.exe to have access to the internet. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OT: Free Storage for Users' Files
Harold Fuchs wrote: That works. I wonder why Harold didn't mention that? 'Cos he's an idiot, that's why. Sorry, James and everyone else. For the sake of clarity, the login name is "[EMAIL PROTECTED]" and the password is "storage". I prefer to call that a 'brain fart'. It happens to the best of us. Those of us who are the best know that it can happen any time. :-) tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OT: Free Storage for Users' Files
James Knott wrote: Harold Fuchs wrote: I have created a free account for this purpose at < https://www.dropboks.com/> The Account Name is "oouploads" and the password is "storage". If you or your respondents have problems with the facility please email [EMAIL PROTECTED] with details. Perhaps I'm missing something. You state the account name is "oouploads" and the password is "storage". When I use those to log in, I get an invalid user or password error. I don't see where you provide an email address, other than the one for reporting problems. Hi James, [EMAIL PROTECTED] works. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Text file import to Calc
Hi Victor,
If you change the extension to CSV, you'll get a text import dialogue when you
open the file ('file / open' or drag and drop). Click the 'Fixed Width' radio
button, then set the columns by clicking on the ruler.
tc
Victor Chapman wrote:
I have a text file that is columnized (is that a word!) by spaces not
commas or tabs. The first row has the column headings. How do I import
this file into calc (or base).
TIA
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] insert text in column using styles
Julio Sotolongo wrote: Peter, Thanks for your response, it was helpful. I did not know columns in styles were newspaper style, flowing from 1 to the other. Regarding the other, the correct path was insert, tables, not columns. What I want is to format 2 columns where text can be entered independently of each other, as in a flyer. With the tables format text in 1 column moves text in other column. Are these the only options or is there a third? Thank you for the help. Hi Julio, You may want to try inserting two text frames. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] why i am unsubscribing from this list
Hi Phil, I checked out the link below, but still have a question: What's ezw and what does it have to do with open office? tc [EMAIL PROTECTED] wrote: I posted a request asking what I should do with ezw attachments - I got no response that I can read, couldn't even read my own post! I found a program that read's ezw files, but it could not decode the ones that I am getting via this newsletter - here's the link, http://pesona.mmu.edu.my/~msng/EZW.html. This provides the C source code which you'll have to build to test it. As a near convert to OOo this issue is making me wonder if we'd be better off sticking with MS Office, at least the support material is available in human readable form rather than some obscure image format. PhilD - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] YOUR PROGRAM IS LOUSY AND USELESS - Deaf Troll
Hi Howard, Actually, the OP hasn't seen very many of the replies as he's unsubscribed and most of the replies went to the list only. Probably not a problem, since I doubt that there's much that we could say to him that would help. tc Howard wrote: If the program sucks that much why are you even here,why even ask,just delete it. Obviously,if you`ve looked at all the emails here you`ll see that most of those that have a problem can solve it with a question here. snip - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] please help in open in read this files
Michele wrote: giuseppe botturi wrote: maybe create another document and replace the contents.xml of the new file with that of this file? Cheers, Michele I did that with both files and sent the results to Giuseppe. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] RS232 communication
Dave Barton wrote: Original Message From: Roland Wik <[EMAIL PROTECTED]> Date: Wed 19 Mar 2008 19:43:41 EST Hello, I have an application made in VBA where I import data through the serial interface to an Excel spreadsheet. How can import serial data to OpenOffice Writer? /Roland I don't know if what you want to do is possible or not, but if it is you will need to convert/translate your VBA script into Star Basic. As a starting point for information about this migration go to: http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Migration_Guide/Calc_and_Excel scroll down to the "Macros" and follow the links given there. Hope this helps. Dave Hi Roland, If your application is an Excel macro, you can try downloading the Novell version of Openoffice. It will run VBA macros and may be able to run yours. If it is a stand alone application, you can use the OOo API to dump the data into a spreadsheet. You may be able to generate XML data and add it to an existing spreadsheet. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] transfer calc data to base ?
Hi Kenn, If you create a new base file, you can copy data from a spreadsheet and paste it directly into a new or existing table in it. You'll have to enter the field names in row one if you don't already have a header in your spreadsheet. I've done it only one or twice, so I'm not sure of the exact steps, but it seemed straightforward at the time. tc Kenn Goutal wrote: I have a bunch of things that I've been keeping in (OO/Calc) spreadsheets. They're at the point where I really need to have them in databases or, if possible, in a single database. (They're not very closely related, but I don't want to have to open up a different database every time I want to enter a single piece of data, and over the course of a single day that may mean entries into half a dozen different spreadsheets.) However, I've looked in the Help info in OO/Base, and found no way to make such a transfer. At first I thought maybe I could just have the database (or each database) open the .ods file as a data source or some such, but didn't find that. So then I thought that I could at least export the data from the Calc file into a .csv file, then import that into Base. However, when I run Base, and open a .csv file, or I'm in Windows Explorer and click on a .csv file and click on "Open with ... Base", it opens it in Calc instead. Recommendations? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Cut/Paste Rows in Calc
Anthony Chilco wrote: Mike Field wrote: Harold Fuchs wrote: Hi Harold, I'm using OpenOffice 2.3.1 under Windows Vista Business. I tried to use the Paste-Special-with-shift-cells idea, but when I'm trying to move a row, the "Shift Down" radio button is greyed out, and conversely, when I'm trying to move a column, the "Shift Right" button is greyed out. This seems backwards - surely it's a bug? Hi Mike, I get the same graying out if I don't delete the column or row that I've cut. If I delete the area that's been cut, all the shift options are selectable. I can even undo the deletion and the buttons will still work as they should. tc What is odd about it is that when all the buttons are active, the default action is the wrong one: i.e. if I cut a row, right is selected and if I cut a column, down is selected. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Cut/Paste Rows in Calc
Mike Field wrote: Harold Fuchs wrote: Hi Harold, I'm using OpenOffice 2.3.1 under Windows Vista Business. I tried to use the Paste-Special-with-shift-cells idea, but when I'm trying to move a row, the "Shift Down" radio button is greyed out, and conversely, when I'm trying to move a column, the "Shift Right" button is greyed out. This seems backwards - surely it's a bug? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Hi Mike, I get the same graying out if I don't delete the column or row that I've cut. If I delete the area that's been cut, all the shift options are selectable. I can even undo the deletion and the buttons will still work as they should. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] converting an open office document to windows office document
Paul wrote: Shalom, I used open office until today and had to change to Microsoft because of works need. I am trying to find a way to open several document in the new format but I can't and I really need these documents. Please note that I erased the openoffice from my computer and have no way to open these documents. MS Office cannot help you on this one. /paul Actually, it may be able to help. There is a plugin for MSO 2007 that will allow it to read and write ODF. It's available from the SUNN website. I don't have the address handy, but search for it. tc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] posting questions
Hi Bob, This is not a forum, but a mailing list. If you do post a question, please do so by starting a new message addressed to users@openoffice.org and enter a meaningful subject line. You must have subscribed to the list if you're receiving these emails. tc tenbob wrote: This is not on this subject. I recently installed OOo after 30 years with other editos, etc. I don't remember why I am getting emails from [users] but would like to get to this forum to ask some questions OR do I just write emails like this Bob K. == - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Heading and outline numbering driving me back to M$Word
Hi Pierre, I just did a two-page document with numbering going three levels deep. I had a lot of trouble until I removed all the numbering and started from scratch. If you make everything top-level and use the tab key to demote lines, it seems to work well. When you've entered the final line of a sub-level and want to ascend, just press enter, then shift-tab. tc Cor Nouws wrote: Hi Pierre, Pierre wrote (4-3-2008 13:23) That's where I am stuck. I don't get that. Sometimes it gives me a number, sometimes not. And if I am lucky enough to get a number, it is always the origin, never the next logically sequential number. Can't really understand what is going wrong for your documents. Can you send me one off list? I'll be glad to have a look see if I can help you out. Regards, Cor - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Hi my dear suport.
Forgot to include the OP. Anthony Chilco wrote: Hi Jörgen, Here is one method: 1) Assuming that the phone numbers are in column 'P' and column 'R' is empty, enter into cell R1: ="0"&P1 2) Select cells R1 down to the last used row (R1 - R2600). 3) Select 'edit / fill down'. 4) Select 'edit / copy'. 5) Go to cell P1. 6) Select 'edit / paste special'. Uncheck 'Paste all', then uncheck 'Formulas'. 7) Click 'ok'. tc Jörgen Waldemark wrote: I got a question about openoffice 2.10 If i want to add a zero in the beginning of a cell that already have information. How do i do that?? I got 2600cells with phone numbers and all i need to add 0 in front of all the numbers. It would be great if you learn me how i could do that, Then i save like 4hours work for the company. :) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Hi my dear suport.
Hi Jörgen, Here is one method: 1) Assuming that the phone numbers are in column 'P' and column 'R' is empty, enter into cell R1: ="0"&P1 2) Select cells R1 down to the last used row (R1 - R2600). 3) Select 'edit / fill down'. 4) Select 'edit / copy'. 5) Go to cell P1. 6) Select 'edit / paste special'. Uncheck 'Paste all', then uncheck 'Formulas'. 7) Click 'ok'. tc Jörgen Waldemark wrote: I got a question about openoffice 2.10 If i want to add a zero in the beginning of a cell that already have information. How do i do that?? I got 2600cells with phone numbers and all i need to add 0 in front of all the numbers. It would be great if you learn me how i could do that, Then i save like 4hours work for the company. :) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Removing and editing spaces ??
Hi Bill, I would just use search and replace with two spaces in find and one in replace. You would have to run it several times until none are found. If you like to have two spaces following a period, finish by replacing period space with period space space. tc William Case wrote: Hi; I am looking for suggestions or hints on how to make a particular macro(s) for editing text. After I finish several drafts of an article or speech, I would like a macro that will go through my text and check for proper spacing. Cutting and pasting text, shifting paragraphs around, re-writing etc. ends up leaving unwanted spaces between words or at the end of paragraphs. Up to now I have just been turning on my non-printing symbols and manually going through my text making adjustments to the spacing. I thought I might write a macro to do it for me. The core problem seems to be to get the right regex or regexs, but I am not sure. Perhaps some combination of macro + manual will work, Any suggestions on how to go about this would be helpful. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: NOT SATISFIED-Who ARE
Most of the recent complaints have been from people who have paid for a download. tc [EMAIL PROTECTED] wrote: Actually, the program takes eons to download if you are on dial up, It is therefore expedient to pay for the program on a CD Brian On Wed, 27 Feb 2008 19:11:06 +, Brad Rogers <[EMAIL PROTECTED]> wrote: On Wed, 27 Feb 2008 11:19:26 -0600 scmarcos <[EMAIL PROTECTED]> wrote: Hello scmarcos, Who ARE these people who keep shelling out money for open source apps? Are they from outer space? No, just unfamiliar with the idea of researching a product & pricing before they buy. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Proposal OOo Writer: Move and Copy selection using mouse
Hi Jurg, You don't mention which version of OOo you're using, but in the windows 2.3.1 version, 2a works as you describe. 3b - use ctrl-drag to copy text. tc Jürg Ruchti wrote: 1. Select text 2.a move text: drag text with left mouse button to new location 3.b copy rext: ALT-drag text with left mouse button to new location I miss this on the Mac - may be this is implemented on the other platforms? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
