[users] OpenOffice intergration with Google Docs...

2011-10-18 Thread Darren Forster
Hi, I've got a customer who is a Microsoft fanatic and was going to buy Office Live so she could edit documents and upload them to the cloud, etc. However when she heard about OpenOffice being free as opposed to the £150 price tag of Office (and the fact she could use Thunderbird with Gmail

[users] OpenOffice Basic - Converting Spreadsheet formulas into string

2009-09-18 Thread Darren Forster
Is there anyway to convert the Cell.Formula value into a Cell.String value in OpenOffice Basic? I've thought maybe Cell.Formula.String would work but it doesn't. Also the same for converting from Formula to Value it would be really handy if there was.

Re: [users] There seems to be a lot of people selling Open Office 2.2.1 on E-Bay!

2007-08-15 Thread Darren Forster
It's legal to sell Open Source software for enough to cover the costs of duplication/resources only, not to make a profit, I think the recommended maximum is somewhere about £5, although judging by the low-cost of CD's and the amount of time it takes to produce an OpenOffice disc I would say the

[users] Animated GIFs in Impress

2007-05-24 Thread Darren Forster
Hi Just wondering if anyone knows how to export a slide show in animated gif format. I've tried the instructions here http://plan-b-for-openoffice.org/ooo-help/en-US/WIN/simpress/simpress/simpress/guide/animated_gif_save and it just saves the first slide even if I select all of them (when

Re: [users] CSV data

2006-05-06 Thread Darren Forster
Scott Taylor wrote: Hello all, I'm running an old UNIX legacy system where all the apps are writen in PROGRESS. Often people want data to put into a spreadsheet, this is simple if I write the output as a TAB delimited file and call it blah.xls; then it just opens in their spreadsheet program

[users] Formulas in Base

2006-03-23 Thread Darren Forster
Hi Is it possible to created calculated fields in Base. I've got a book on Access 2 and notice that Access can do this in the Reports just by typing =[fieldname][operator][fieldname] e.g. =[quantity]*[price] but when I try that in Base it puts 0 on the top line of the report and the rest of

Re: [users] Date field on a spreadsheet

2006-02-14 Thread Darren Forster
Dennis J. Tuchler wrote: I have gone through the help files but have found no way to insert today's date in a cell. When I print out the list, I want the date the list was printed in a cell at the top of the sheet. I can put a date field on a document, but not on a spreadsheet. How do I do

Re: [users] [moderated]

2006-02-11 Thread Darren Forster
[EMAIL PROTECTED] wrote: HI, First of all I am no computer guru so please send answer in layman terms, thanks lol I love openoffice and have openoffice.org 1.1.3 and make newsletter for work, but I print it out and make copies for meetings. I would also like to mail it too and have not

Re: [users] calc -- Date Sort]

2006-02-09 Thread Darren Forster
Victor Chapman wrote: I have imported a table of health care benefits received into calc. One of the columns is headed Service Date. Originally the dates were text. They are all in the form DD MMM ( e.g.10 FEB 2005). I applied a user defined format to this column so that calc would

Re: [users] Calc question.

2006-02-09 Thread Darren Forster
There is kind of a way to do it by dividing the value you enter using FLOOR as follows... For Dates... Column A - Enter Date e.g. 020878 Column B - Enter the formula =FLOOR(A/[ROW_NO]//1;1) Column C - Enter the formula =FLOOR(A/[ROW_NO]//100;1)-B/[ROW_NO]/*100 Column D - Enter the formula

Re: [users] calc -- Date Sort

2006-02-09 Thread Darren Forster
Victor Chapman wrote: I have imported a table of health care benefits received into calc. One of the columns is headed Service Date. Originally the dates were text. They are all in the form DD MMM ( e.g.10 FEB 2005). I applied a user defined format to this column so that calc would

Re: [users] Smooth scaling of images

2006-02-06 Thread Darren Forster
Adalbert Dawid wrote: Hi list, I'm working on a presentation for my employer and decided to do it with OOo-Impress 2.0. This presentation includes a logo of the company I'm working for, which has to be properly down-scaled by Impress. Unfotunately, after scaling down the logo looks really bad

[users] OpenOffice Basic

2006-01-15 Thread Darren Forster
Hi Just wondering if anyone knows where I can find a list of properties and functions that can be applied to various items in OpenOffice basic. Is there a book or website available? e.g. I'm guessing that a table in OpenOffice must have loads of properties such as Visible, ReadOnly, Text,