Log in

No account? Create an account
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 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!!
25 May 2008 @ 03:16 pm
Problem with Writer: When editing the very first character at the start of a header or text body in style-driven docs, entire string turns to superscript. This is not reversible through Undo, but can be fixed by directly reformatting through Format>Character. So it's fixable, but it's very annoying. Workaround is to make changes after first character, then delete leading text. But this shouldn't be necessary, right?

Pretty sure this is a bug, as I can't imagine any toggle for "superscript entire string on edit first character" heh.