Ubuntu :: OpenOffice Calc Fails To Include Sheet References In VLOOKUP Formula
Nov 1, 2010
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.
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.
i have edited a formula in formula editor and saved that file ... i wanna import that formula into my ppt (odt i think) .. ( i know its dumb question dumbest i ever asked .. i need to prepare my presentation real quick say 1/2 hr from now
I could not number formula in Open Office writer relative to a chapter. I would like to numbering like 1.1, 1.2, 1.2. 2.1 etc. Is it possible. I searched in Helps, but doesn't found anything!
I use Ubuntu 10.04 2.6.32-25-generic kernel After I did some automatic updates, in my Openoffice documets page numbers and other references are destroyed. Example, only "pagenumber" is written instead of page number.
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.
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?
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.
Unusual problem here -I'm posting in hardware as I'm not certain where it fits.Home laptop (mainly wife's in use) upgraded from 11.3x86 last week to 11.4x64, pretty much everything is awesome.However, when she attempts to print a PDF with multiple pages per sheet (study notes),
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.
When ever i try to open a document or even just a blank page with openoffice I get this message from the automatic bug reporting tool
Package: openoffice.org-impress-1:3.3.0-19.2.fc14 Latest Crash:Fri 21 Jan 2011 05:50:48 PM Command: /usr/lib64/openoffice.org3/program/simpress.bin -impress Reason: Process /usr/lib64/openoffice.org3/program/simpress.bin was killed by signal 11 (SIGSEGV) Comment: None Bug Reports:
I have a Konica 2530DL colour laser and have used it with versions from 6.06 onwards.
However now, with 10.10 I find I cannot print at from most apps eg OpenOffice or PDFs. I get errors on video frame showing on the printer but nothing obvious on the PC.
Test print and gedit text prints works fine and so does using a VM with Lucid running on the same host prints fine too from anything.
Can't see any other comments about this problem anywhere but I know the printer is fairly common and has worked well with Linux in the past.
Using it with IP printing on port 9100 and allow the installation to detect and select the driver. Not setup anything clever and I have the same issue with a Lucid upgrade to 10.10 or a clean install. However the VM running Lucid prints fine. Must be something changed on Maverick somewhere.
on the risk of starting another OO thread I would like to share my problem to resolve it... (found this 'challenge' nowhere on the forum) installed openoffice apps on my F11 64-bit box through add/remove software until some time ago everything worked well for all users now with one specific user OO hangs upon startup when opening a file (only displaying splash screen, nothing further). this user is nowhere blocked intentionally
to resolve I did:tried other users, all works well (starting from menu, opening files in Nautilus by double-click) renamed ~/.openoffice.org to ~/.openoffice.org.bak so new prefs are created, but new attempt results the same (freeze upon start) copied ~/.openoffice.org from well-run user, but new attempt results the same (freeze upon start)
installed gnumeric as an alternative but I like to bring this to a happy ending.giving enough eyeballs the solution must be out here somewhere
I have installed openoffice.org-base and openoffice.org-base-core in an updated fedora 14 environment. Clicking on openoffice-base in applications->office->openoffice-Base fails to lauch with the message:"This operation is not supported onhis operating ystem."Installation of mysql and mysql-server does not help.
I recently upgraded to Fedora 14, and was surprised to find that OpenOffice is not included in the distro like it was in previous versions. Anyways after installing it it was working until while ago when I downloaded the recommended updates, and now when I try to start it, nothing happens.
It would appear that novell openoffice 3.2.1.4 on opensuse 11.3 fails to correctly import pps/ppt files. Slide transition data is lost and this results in presentations without sound. This problem does not exist in openoffice from openoffice.org. openoffice from openoffice.org will play pps files with sound which will not play with openoffice from Novell. However the openoffice.org version requires JMF.
JMF is old and 32 bit. I have tested openoffice 3.2.1 from openoffice.org with JMF on a 32 bit 11.2 system and it works. I assume that JMF will not work with a 64 bit JRE. I also assume that it would be difficult to get a 32 bit jre to work with a 64 bit openoffice FMJ is an alternative to JMF. It plays various types of audio including mp3 and wav. It is packaged for installation on 11.3. Does anybody know if this works in place of JMF with openoffice from openoffice.org on a 64 bit system?
What is the difference between /usr/local/include and /usr/include? When I compile my program, is both /usr/local/include and /usr/include avaliable? Can I copy a file from /usr/local/include to /usr/include?
I just downloaded the SDL source code. i did compile and make of this code.then i did make install. but i didnt see the files of SDL.h and lib.SDL.*** in /usr/include/ but later i found out that these files are placed in /usr/local/include and /usr/local/lib. how can i specifically install libraries on /usr/include and /usr/lib
I have a Epson SX215 and despite of being apparently installed well, everytime I try to print something I only get the printer take out all the sheet in blank.[URL]
I have 10.10 64-bit on a Fujitsu T900. the hard drive has windows seven as well (64-bit). The win7 is the orginal from the manufacture. the boot log originally had (in this order): Win7, Windows Vista (about 100 MB not sure why but can't remove), recovery partition. I put ubuntu on after those three. Some times when the computer goes into suspend mode from ubuntu it will not wake up after wards. the only option it to power i down manually. when it comes back up there is now a second reference to ubuntu in the boot log. this has happened several times. there are now four valid references to ubuntu in the boot loader. I need to remove three of them, but i'm concerned that removing them will compromise ubuntu. Also I'm not sure where the boo log in windows seven is.
I was wondering how you might go about printing multiple images on a single sheet of paper...I used to know how to do it in Windows but have never done it in Ubuntu.
I'm looking for a means to automate filling out web-forms with data (names, addresses, etc...) from excel spreadsheets. I'm not sure how to do it with a macro, of if theres programs out there, or if a script could do the same work.
