I'm using OpenOffice from repo. In Calc I want to fill in 2 cells under eachother, consisting of a name, space and a digit. Then, after selecting both cells, drag them down to get a list of this name, with only the digits being different. When using OpenOffice from original download, this gave no problem. Now however, I'm presented with a Fill Series window that gives me some options like Direction, Series type, etc. And whatever I fill in, it says �nvald value. How can I get rid of this Fill Series window. The Help function in OpenOffice doesn't give a clue on Fill Series.
I can't log in on my Acer Aspire One running Xubuntu 9.10. I restarted the computer half an hour ago, and when I fill in the log-in window, the pc spins a moment, and the log-in window comes back.I can start up the KDE session, and have done so to post this.Have any of you experienced something similar, and how can I fix it
In OpenOffice spreadsheet, using the Page break preview you should be able to move the thick lines that indicate the separation between pages. Some versions ago you could do it normally. But now it's impossible. You can just move the thick line that indicates the limit of the print area.Has anybody noticed this? Is there any solution? In Ooo for Windoze it's possible, but I prefer not to use it unless is absolutely necessary.
I prepare an MS Excel 2007 spreadsheet which includes macros and user defined functions on a Windows machine. I transfer that file to a Mandriva 2010 machine and I load the file with OpenOffice Calc 3.2.0 and it runs the macros properly. I transfer the file to a Fedora 13 machine and I load the file with OpenOffice Calc 3.2.0 but it doesn't run the macros. I set "Tools/Options/Security - Macro Security" to Low in both cases.I am very new to OpenOffice - is there any other setting of which I am not aware?
I've got a CD which does the monthly compounding on the last day of every month instead of every 30 days. The bank gave me a print-out (of course), but I'd like to make my own Calc spreadsheet too. My question is: How do I check whether a certain day is the last day of the month? In other words, I'm looking for something that returns TRUE if it's the last day of the month and FALSE if it isn't. I'm using OpenOffice.org 2.4.1 on Ubuntu 8.10.
you are using Calc to hold data, and you have a column of surnames. You enter True and it turns into TRUE: OO has decided you wanted a Boolean. Similarly, you enter a date as 12 Jan 09: it may appear in that format, but you can't search for Jan 09, only for 01/09. Is there any way one can set the data type of a cell as text, or prevent OO from carrying out unwanted type conversions? I suspect the answer will be no; I can't find anything in the pages, and I suspect the developers would say I should be using Base. Well, I don't want to use Base: I want my data displayed spread-sheet style There is a solution: to insert non-breaking spaces in dates and after words like "true", but it would be nice if the problem could be fixed just once.
What is the macro command (in OpenOffice Basic) to select an entire Row or Column? I tried to "Record Macro", then click on the Row/Column header, which would then select the entire row/column. But "Record Macro" failed to capture this action.
I am trying enter a VLOOKUP formula in Sheet1, where the array is in Sheet2. For both the items, I have used mouse to enter cell references, which I always do.
1. Search criterion has been entered as a range, which is different from previous versions and not a very comfortable situation.
2. array reference completely missed entering Sheet2! in front of A1:C13. Only way out of this is manually entering the sheet name, which is not only cumbersome but also ludicrous. Moreover, we never had to do it like this in the past. I am using OpenOffice.org 3.2.1 in Ubuntu 10.10.
Ubuntu 10.04 32bit Gnome 2.30.2 Compiz active Cairo Dock loaded
I've loaded Cairo-dock, deleted my bottom panel in Gnome & reduce my top panel to a minimum showing only "notifications". I can't get my windows to fill the top 10% of the screen on maximise without going full-screen and losing the window borders and the menu bar.how I can configure the maximise setting to use the whole screen?
I just upgraded to OOo v3.3.0, but it feels more like a downgrade; a real disappointment. In my previous version, I could choose 'Tab' in the 'Paste special' dialog and the choice would stick between pastings as well as between sessions. No longer so. In v3.3.0 I have to tick 'Tab' and 'Detect special numbers' each and every time I paste something. I am working with OOo all day and this regression is tiresome, to say the least. So, I am wondering whether there is a way to make the choices sticky? If not, I shall have to go back to the previous version, or perhaps try out LibreOffice.
I have a Canon iR3570/iR4570 PXL, and installed the driver CQue 1.0 TCP/IP Queue from Canon webpage.
The problem: - if i try to print an OpenOffice or LibreOffice Calc with an image and text, the image is not printed (the space is blank). - if i try to print an OpenOffice or LibreOffice Calc with just an image, it's printed great. - if i try to print an OpenOffice or LibreOffice Impress, the images are not printed but the text is printed great.
If I have say, a column of Months, eg. "January", "February" etc., with a "income" column to the right of it, for say, 6 months - eg. "423", "2342", if I highlight some or all of the months and Sort it, I would like the "income" column values to move up and down as well- eg. if the months become "February", then "January", I would like to see the corresponding change in the "income" column as well, eg. first "2342", THEN "423". I would like this even if I say, Manually move the "months" column data around, eg. put "February" at the bottom.
I have a problem with the latest Fedora. Installed it cleanly on a machine with Gigabyte H55M-S2 with Intel Core i3. There seems to be no sound and I checked to see if anything is muted but is not. The manual says that the sound chip is ALC888B so this could be the first problem. Any ide how I can make it work? Here is a dump of some things on my system.
Code: [weaz ~]$ lspci | grep Audio 00:1b.0 Audio device: Intel Corporation 5 Series/3400 Series Chipset High Definition Audio (rev 06) [weaz ~]$ uname -a Linux EarthwormJim 2.6.35.6-48.fc14.i686 #1 SMP Fri Oct 22 15:34:36 UTC 2010 i686 i686 i386 GNU/Linux
I have this really strange openoffice behavior. Normally to drag window i need to press alt+left_mouse_button and drug window. Exactly same result i'm getting while selecting text in OOo writer and impress. As simple as holding still for, literally, a second, while selecting text, will initiate dragging of the entire window. I'm running F14_64 KDE and using OOo from repos.
is it possible to dock the navigator window in Openoffice with the editor window? it is distrubing when we use the navigator window and it hide most part of the editor window.it would be nice if it works like msword outline window.
I have installed OpenOffice 3.2.0 on Ubuntu 10.04 (64-bit) and all seems to be working ok. Currently, I need to click on
Applications -> Office -> ,,,
and select which OpenOffice module I would like to execute. It would be much easier (and preferred) to be able to execute OpenOffice.org (Main window) directly from an icon in a panel. That is, I would like to have an icon in a panel that when clicked on would bring up the Main window for OpenOffice --- this Main window menu is shown in the attached screenshot.How can I get this single icon to give (when clicked on) this Main window for OpenOffice?
I'm trying to install a language-pack for my OpenOffice, but there seems to be a dependency-problem. Maybe someone has a suggestion. FC12, x64 OOo.x64 3.1.1
One of my friend ask me a favour. He asked me to download stock exchange's one year equity shares data and transfer into sql. So i downloaded all csv file saved in a calc file after done all most I saved it and closed calc. After that I found openoffic.bin was using my 50$ memory and cpu so I manually ended the process now when I open the file I get shocked I lost all most all data of 9 months have only 2 month's data but in file's properties it's still showing last modified time and size.
I must say I am newby using Fedora, but cannot find solution how to define print range in calc. I am using oo for almost ten years in windoze, but this is first time I have this problem. I'm using Fedora 14 L, on my lap compaq 6715b. During install, everything went just fine, only problem in last month, since I install F14 L I have find, was using oo calc. I need that rather quickly because I need to apply my tax income until end february,
If this post is correct [URL] I can expect that it will take more then 16 days to fill my 2TB partition from /dev/urandom. That's not workable for me. dd if=/dev/urandom of=/dev/sdxx has been running for 36 hours, and I need to finish setting up the filesystem. But I also need to make a "professional effort" at encrypting the partition. I am supposed to fill the partition with random data, to strengthen the encryption for a LUKS partition. It seems that if the bad guys get the drive, they have much more time to try and crack it, then I have to encrypt it. Ok, so I can try Code: sudo /sbin/badblocks -c 10240 -s -w -t random -v /dev/sdxx How long can I expect badblocks to run on a 2TB partition?.
I'm going to do a permanent install of fedora 10 soon, within the next couple of days.
1. When installing it asks if I need to log in as NIC, something about networks. What would that be about?
2. Is there any way to resize the screen to fill more of the monitor? Right now it leaves about an inch of blackness on the let side which is more than other os's that I've seen.
How to find out the series (i series or z series)in redhat enterprise linux If I give uname -a it gives Linux hostname 2.6.9-55.ELsmp #1 SMP Fri Apr 20 17:03:35 EDT 2007 i686 i686 i386 GNU/Linux Does this mean that my server is in i series as it says i386..?
I have been through a lot of posts and was still unable to connect to the internet using wvdial utility after doing all the changes. I being a newbie to this operating system, didn't know how to get started. After going through a lot of posts, I came across an application that is going to be a part of Fedora 12 called ' blueman '. It is used to connect to the internet using a gprs enabled phone via bluetooth. It integrates itself with Network Manager making it even more easier to use. To install it type the following commands in the terminal:
su
Type in your password and hit enter. Then type
yum install blueman
The application is only 575kb and will install instantly.And after a reboot fedora will show an applet related to that application. Open it and click search to list all available devices and select your phone and then select bond to pair your phone with your computer ( if it isn't already). After bonding right click your phone and select serial ports>dial up service. this will make the gprs/edge/3G connection to appear in network manager and selecting it will connect your computer to the internet.
This was the bluetooth way. If you want to connect through USB, just plug in your phone and select PC Suite mode in your phone. The fedora installation will automatically detect your phone as a modem and the connection will appear in the network manager.
This works on all N series Nokia phones and also most other phones as well.
I see there are lots of messages about fedora 12 freezing.Actually I have such a problem with fedora 11 since I updated to kernel 2.6.30. My laptop, all of a sudden, freezes. Everything is freezed: mouse is not working, keyboard not responding (hitting caps lock produces nothing), can't switch to terminals, ctrl+alt+canc don't work. I can just push the power button to shutdown the system. BUT the hard disk activity is still going on. I can see and hear the sleeping daemons that cause some usual disk activity while the rest of the system is completely freezed.My system is a HP DV5-1025el with an AMD Turion ZM-80, Ati Radeon HD3450, 4Gb of RAM and 250gb HDD.I got fedora 11 regularly updated, now has kernel 2.6.30.10-105.2.23.fc11, but it is used to happen also with older 2.6.30 kernels, NEVER happened with 2.6.29 kernels. Video driver isn't the cause, since it happens with both proprietary fglrx and OSS radeon drivers.
I recently bought an HP mini 1030NR and wanted to get fedora on it. I found this and it pretty much guided me right through the process. I thought it might be helpful for others.[URL]..
