Log in

16 March 2010 @ 01:08 am
The documentation for Calc clearly says that the ceiling and floor functions are compatible with negative numbers, but every time I try [for example, CEILING(-3.1, 1)], I get a 502 error, "Invalid argument". What's going on here?

I'm using OpenOffice on Debian.
11 April 2009 @ 11:42 pm
I forgot a new password for some crucial .odt files created in Open and NeoOffice (currently running Neo). Is there ANY program or way to recover the files, or crack the passwords?
11 April 2009 @ 04:27 am
Suppose I have a very large data set in Calc and I want to enter a formula into several thousand cells. Is there a way to do so besides typing the formula into one cell and then dragging it over 46 655 more cells?
21 January 2009 @ 05:07 pm
has anyone on here used the open source Solaris operating system, and what are your thoughts on it? 

and thanks to the person who helped me with the Openoffice spreadsheets!
30 December 2008 @ 01:56 pm
Now I am not a spreasheeting (or maths) wizz, and have to create a pie chart for a University essay showing levels of information publically available from a range of colleges, a certain amount had none, a few had brief mention, and two had full policies available. How on earth do I input this into Calc to create a pie chart? 

sorry if it sounds thick, spreadsheeting and numbers are not my strong point in life!
18 November 2008 @ 04:52 pm
For those of you who are ever in my situation (have Windows OOo at work and need to merge multiple presentations), this tip works absolutely perfectly. Thanks tip-provider.

Tip reproduced under the cut for the link-averse.

Read more...Collapse )

Now for my question. It has to do with columns. As a teacher, I do a lot of formatting and sometimes I want to type in columns and then sometimes I suddenly realize that I want to type out of columns in a section of text immediately below. I can do that if I originally type one-column and then highlight text and change the number after it is already typed. However, if I've already typed in say, two columns, I cannot figure out how to have a section break and get it to go back to just one.

I have a feeling that the solution is amazingly easy but I'm just failing to see it. Help?
09 October 2008 @ 02:10 am
x-posted to ubuntu_users

I fumble-fingered something, I think, and as we all know that can activate all kinds of crazy commands sometimes. Anyway, my caps-lock is now reversed: caps-lock on, all lowercase, lock off, all upper case.

24 September 2008 @ 01:41 pm
Hello All,
Is there any similar to MSO functionality in OO Writer for protecting table cells from editing by user?
It is possible to protect cell, but user is able to turn protection off from the same menu. And I need to create a document’s template, which should be edited by many users and they shoud have no opportunity to change several of template’s cells and margins. In MSO it can be easily done with password protection, but I haven’t seen such a thing in OO. Any ideas? Thanks!
24 June 2008 @ 12:32 pm
Hi, hope someone can offer some insight here.

I use OOo 2.4.1 under Ubuntu 8.04 (Hardy Heron), regularly updated. Ubuntu updates native applications through its updater, so they are current for OOo, but also for Ubuntu. Which means that they sometimes leapfrog: Ubuntu will generally not supply application updates -- e.g., for Firefox or OpenOffice -- if that change also needs to be vetted in concert with a not-yet-vetted Ubuntu update. Even so, OOo updated through Ubuntu is usually more up-to-date than what most people will have on their systems if they're not using regular updates, and I think that may be the problem here. (I'm running this on a new Toshiba Satellite, for whatever it's worth.)

My boss uses OOo under Mac, and I'm sorry I don't know what model or OS, though I assume it's fairly recent, and latest MacOS (X11?). But I'm also pretty sure that Mac is usually last in line for OOo updates -- which again, may be the issue here. Other than that, we're sharing the same ODT files in the same native application.

I've been sending him periodic redrafts of an evolving document, and there have been no problems until yesterday. As I believe I understand it, he was working with the draft I'd just sent him, and then found that he was unable to save his changes. Worse, OOo locked up and is no longer working, though it apparently shakes itself loose for brief periods once in awhile, though still won't save changes. He seems to have some reason to believe that it may have something to do with fonts, though I can't imagine how that would lock an application. At one point, he converted the ODT to WinWord DOC format, to see if he could work with it under that application -- and he says Word is now locked also, and not working at all. He lost all his changes, and is unable to use either WP app now.

I've never heard of anything like this before. It's obviously very damaging to our shared work. (I had to recreate the entire document in raw text, including hand-pasted inline citations in place of original formatted footnotes, and port out all graphical elements as images to be manually inserted later.)

The only thing I can think of us that my Ubuntu-updated OOo version has incorporated changes not supported under his (presumably not-as-current) OOo Mac version. Because as near as I can tell, that's the only difference between earlier drafts I sent him, and the latest one. I don't know what these changes might be; I let Ubuntu updater do its thing, and don't pay attention to individual package updates, which are nearly daily. I could probably find out, but I don't think I'd make much sense of it even if I could see them.

Anyone have any thoughts at all about this? Very much appreciated, thanks!!