Forum Home
Press F1
 
Thread ID: 103949 2009-10-11 22:00:00 Any OpenOffice.org Users out there? Yorick (8120) Press F1
Post ID Timestamp Content User
819518 2009-11-12 11:09:00 It's good to note that there must be quite a few out there using it.
Last week saw the download counter on the OOo bouncers pass 100 million downloads since the launch of 3.0. Woohoo!


:banana :D :clap
Yorick (8120)
819519 2009-11-12 13:14:00 I wonder how many people actually keep using it though? Plenty of people download Norton or get it given but how many actually keep using it? (Too many but I digress) beeswax34 (63)
819520 2009-11-12 21:05:00 Originally Posted by Tbird650
Fantastic program..... and free as well!
I use the calc spreadsheet to manage data for occasional trademe sales. I notice the slowness at which it launches.
Like any fully featured application it can take a while to get ones' head around all the various functions.
Because I paste some data from trademe into the spreadsheet, I can end up with different font & sizes in the same column. Similar difficulty with date formats.
Perhaps it's a case of finding the right control but of course it all takes time.

Have you tried Paste Special > Unformatted text, that's always my first fallback position when copying from webpages. Of course when we're creating webpages the last thing we think about is how it will copy.
Paste special didn't fix it for me, but what else it does is randomly it will change the total of a column to: ###
Each time I wrestle with it because I have forgotten how I got to the fix but if I poke around enough, eventually I rectify it.... till next time.
Some times I paste from trademe.... other times I manual type the data.
Could there be a way to force the entire column to always have the correct format?
I start from a template I made and the figures get added over a period of time and with numerous restarts of the program.
I guess if I use the prog day in - day out, I'd pick up on the why's and whynots. Still, if any reader can throw some light onto this situation it would be fantastic.
Great programs! Fantastic work.
Tbird650 (6754)
819521 2009-11-13 00:10:00 I use it for all my doc's except for quick notes where I use Notepad
I use it because its not Microsofts
Roger Hunt (13648)
819522 2009-11-13 03:09:00 Hi

I'd like to see a solution (which can be turned on (default) or off as desired) in calc to the followinf scenario with relative formulae - after all, if you delete rows the formulae get "tidied up":

I've set up a simple spreadsheet for my monthly budget. In columns D, E and F I'm going to put Withdrawals, Deposits and Balance. Assuming that the entry for the first day of each month will be in row 5, in F6 to get the balance thus far I can enter the formula =F5-D6+E6 and then fill this down. However if an unexpected deposit or balance comes in I need to insert an extra row and enter the new data – assume I do this on row 12. At the moment when I do that the the cell F12 is now devoid of a formula so I have to go back to F11 and fill that formula down for the rest of the month, which seems a waste of time (imagine I had done it at row 12 of 2000 rows!!). Is there any way of getting the relative formula to appear automatically in the newly inserted row and thus be reflected in all the rows beneath it without filling it down manually?

Thanks
tuiruru (12277)
819523 2009-11-13 08:12:00 I have been using OO ever since it came out (and StarOffice before that). One of the biggest pluses fro me is that it is cross platform - I use it on MSWindows @work and Linux at home. johnd (85)
819524 2009-11-13 08:24:00 True but then when the Ubuntu version screws up (which it does on a reasonably regular basis cos they can't stop them selves from hacking with it), the Ubuntuites come to the users list and we say download and install the real one!:)

I am using the Ubuntu version with absolutely no issues - have more issues running under Vista at work.
johnd (85)
819525 2009-11-13 22:56:00 Another little trick I'd like is to be able to go "Save As" and have it suggest the first line of text as the document title. tuiruru (12277)
819526 2009-11-13 23:19:00 Daughter used it on our laptop to do her BA in microbiology.

It's still sitting on it, but wife has another pc with Office 2000 on it.

This pc has Microsoft Office XP student ver. on which she finalised her study

Lurking.
Lurking (218)
819527 2009-11-13 23:37:00 Another little trick I'd like is to be able to go "Save As" and have it suggest the first line of text as the document title.

Like MS office already does.
Sweep (90)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17