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.

View 2 Replies


ADVERTISEMENT

Software :: OpenOffice.org Calc Formula To Check If Day Is Last Day Of Month

Jan 19, 2009

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.

View 1 Replies View Related

Fedora :: Importing Formula Into A Ppt In Openoffice

Apr 6, 2011

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

View 1 Replies View Related

Ubuntu :: OpenOffice Doesn't Allow Formula Numbering Relative To A Chapter?

Nov 3, 2010

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!

View 1 Replies View Related

Ubuntu :: After Update Openoffice Documents Page Numbers And Other References Are Destroyed

Sep 27, 2010

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.

View 1 Replies View Related

Software :: Looking For System (Ubuntu) OpenOffice Calc Spreadsheet?

Jul 11, 2009

I'm looking for a Linux Open Office Calc Spreadsheet template to replace Intuit's Quicken. I prefer a spreadsheet over a stand alone. Anyone?

View 1 Replies View Related

Fedora :: Fill Series Window In OpenOffice Calc?

Dec 10, 2009

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.

View 4 Replies View Related

OpenSUSE :: OpenOffice Calc Page Break Preview?

Oct 30, 2010

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.

View 4 Replies View Related

General :: How To Delete Empty Lines In OpenOffice Calc

Jun 17, 2011

How can I delete empty lines in OpenOffice Calc?

View 2 Replies View Related

Software :: Openoffice Calc Not Running MS Excel Macros

Oct 18, 2010

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?

View 4 Replies View Related

Software :: Setting Data Types In OpenOffice Calc?

Mar 3, 2010

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.

View 5 Replies View Related

Ubuntu :: OpenOffice Calc: Macro Command To Select Entire Row / Column

Feb 4, 2010

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.

View 1 Replies View Related

OpenSUSE Hardware :: Printing Multiple Pages Per Sheet Fails In 11.4

Mar 28, 2011

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),

View 3 Replies View Related

Software :: OpenOffice Calc - Sticky Selections In "Paste Special"?

Jan 27, 2011

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.

View 7 Replies View Related

Debian :: Print An OpenOffice Or LibreOffice Calc With An Image And Text, The Image Is Not Printed (the Space Is Blank)

May 11, 2011

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.

[Code]..

View 3 Replies View Related

Software :: "link" One Column To Another In OpenOffice Calc?

Jul 28, 2011

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.

View 2 Replies View Related

Software :: Openoffice Fails To Launch?

Jan 21, 2011

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 run Fedora 14 64 bit gnome desktop

View 2 Replies View Related

Ubuntu :: 2530 Konica Printing Fails With OpenOffice And Maverick 10.10

Oct 18, 2010

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.

View 1 Replies View Related

Fedora :: OpenOffice - Fails To Start For One User?

Apr 13, 2010

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

View 2 Replies View Related

Fedora :: Openoffice Base Fails To Launch On 14?

Jan 9, 2011

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.

View 14 Replies View Related

Fedora :: OpenOffice Fails To Start After F14 Updates

Feb 14, 2011

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.

View 2 Replies View Related

OpenSUSE :: 11.3 Fails To Correctly Import Pps / Ppt Files - Openoffice 3.2.1

Dec 27, 2010

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?

View 9 Replies View Related

Ubuntu :: Difference Between /usr/local/include And /usr/include?

Jul 11, 2010

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?

View 1 Replies View Related

Software :: Difference Between /usr/include And /usr/local/include?

Jul 8, 2010

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

View 2 Replies View Related

Debian :: Installation Graphic Card HD 6750 Formula With Ubuntu

Sep 5, 2011

However I have problem to install my graphics card Asus ATI Radeon HD 6750 Formula....

View 4 Replies View Related

Ubuntu Installation :: What Formula Does The Installer Use To Decide The Default Sizes Of /, Swap, And Home

Mar 25, 2010

What formula does the installer use to decide the default sizes of /, swap, and home?

View 2 Replies View Related

Ubuntu :: Get The Printer Take Out All The Sheet In Blank?

Aug 26, 2010

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]

View 3 Replies View Related

Ubuntu :: Making Extra Boot Log References?

Feb 3, 2011

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.

View 1 Replies View Related

Ubuntu :: How To Print Multiple Photos On Sheet

Jan 10, 2011

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.

View 1 Replies View Related

Ubuntu :: Spread Sheet To Web-form Automation?

May 6, 2011

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.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved