Software :: Looking For System (Ubuntu) OpenOffice Calc Spreadsheet?
Jul 11, 2009I'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
ADVERTISEMENT
Ubuntu :: ClamAV Finds Infected Calc Spreadsheet
Mar 4, 2011ClamAV tells me that three of my OpenOffice.org Calc spreadsheets may be infected (status "MBL_144360.UNOFFICIAL", if that means anything). This seems not entirely implausible, since yesterday I used a USB stick to transfer files from a Windows system. Anyway, I'd really like to keep these spreadsheets. Can I disinfect them somehow?
View 2 Replies View RelatedUbuntu :: Openoffice Spreadsheet Hyperlink Path?
May 12, 2010I'm having some trouble with hyperlinks in openoffice 3.2 spreadsheet, though it may be a begginers problem.
I wrote a script to execute a certain task (in my case, to open an DNA alignment file with bioedit) and then, in openoffice, I assigned a hyperlink button to the path needed to execute the script, which is in my /home ("./script_file"). When I do this the first time, clicking the hyperlink button runs the script perfectly. However, whenever I close openoffice and re-open it afterwards, the hyperlink doesn't work anymore. I've checked and this happens because the original URL, which was "./script_file" changes to /home/user/etc... or /temp/etc... and, obviously the file isn't found. If I manually correct the URL, the hyperlink is functional again... how to fix the URL of an hyperlink so that I won't have to correct it every time I close and re-open the program?
Ubuntu :: Converting PDF To ODS Format (OpenOffice Spreadsheet)
May 11, 2011I know this is more of the Openoffice question but I felt I would find some solution here for this. At my work I am using lot of PDF files which are created using Openoffice Calc (Spreadsheet). I want to convert those PDFs to Calc file again for editing. Currently I am using a windows Machine with able2extract pdf converter for converting PDFs to .xls file. But it is not ideal solution for Linux and Openoffice users here.
View 2 Replies View RelatedUbuntu :: OpenOffice Spreadsheet Slowdown When Copying Multiple Cells
Dec 13, 2010Does anyone else find that Openoffice 3.2's spreadsheet app becomes unresponsive when copying and pasting multi-cell selections? I've had this problem ever since I started using Ubuntu 10.04, which comes with OO.O 3.2. The problem becomes noticeable whenever I make a selection more than about 8-10 columns across. Once the flashing border appears around the selected cells, the spreadsheet app becomes very sluggish. The mouse still moves normally, but it takes several seconds after a click until the highlight moves to another cell, or to un-select the cells, or copy them. These slowdowns happen both in old spreadsheets and in freshly created ones. They didn't happen with Openoffice 3.1 or earlier. Haven't tried it under Windows, so I'm not sure whether this is an issue specific to Linux OpenOffice 3.2. Other apps don't seem to be affected.
View 1 Replies View RelatedSoftware :: OpenOffice Spreadsheet - How To Unhide Cells Properly
Nov 13, 2010I have a spreadsheet I have been using for years not and as I go I hide some of the cells. Today I unhide those cells and they came up but very thin and hard to read. I have tried to highlight the "thin" cells and do some type of format but I can not seem to get them back to the normal size.
View 4 Replies View RelatedFedora :: Fill Series Window In OpenOffice Calc?
Dec 10, 2009I'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 RelatedOpenSUSE :: OpenOffice Calc Page Break Preview?
Oct 30, 2010In 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 RelatedGeneral :: How To Delete Empty Lines In OpenOffice Calc
Jun 17, 2011How can I delete empty lines in OpenOffice Calc?
View 2 Replies View RelatedSoftware :: Openoffice Calc Not Running MS Excel Macros
Oct 18, 2010I 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 RelatedSoftware :: OpenOffice.org Calc Formula To Check If Day Is Last Day Of Month
Jan 19, 2009I'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 RelatedSoftware :: Setting Data Types In OpenOffice Calc?
Mar 3, 2010you 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 RelatedUbuntu :: OpenOffice Calc: Macro Command To Select Entire Row / Column
Feb 4, 2010What 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 RelatedUbuntu :: OpenOffice Calc Fails To Include Sheet References In VLOOKUP Formula
Nov 1, 2010I 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.
Software :: OpenOffice Calc - Sticky Selections In "Paste Special"?
Jan 27, 2011I 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 RelatedDebian :: Print An OpenOffice Or LibreOffice Calc With An Image And Text, The Image Is Not Printed (the Space Is Blank)
May 11, 2011I 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]..
Software :: "link" One Column To Another In OpenOffice Calc?
Jul 28, 2011If 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 RelatedUbuntu :: Libreoffice Calc 3.3.3 Causes System Freeze
Jul 29, 2011I frequently (i.e. after 10-20 minutes of use) get a complete system freeze when using LibreOffice Calc 3.3.3, on Ubuntu 11.04. At the time, I have an *.ods file open, and the freeze happens at various times, for example just after pressing the Page Up button. After the freeze occurs, nothing responds, not even Ctrl+Alt+F1, and I have to force power off my laptop.
how to debug this problem, as there's no error message, no error log (that I know of??)..
Ubuntu :: OpenOffice Makes System Freeze
Mar 22, 2010I am running Ubuntu 9.10 and trying to use OpenOffice 3.1. If I run OpenOffice, after 10 minutes or so, the whole computer freezes. Even if I have shut down OpenOffice it still happens. Only answer is to turn computer off and on again. I read some other people's posts listing the same problem and as a result uninstalled Open Office and then installed it again. I also uninstalled Compiz. Neither of these seem to be the solution. I have just installed Lotus Symphony and there are no problems with freezing and so the issue is definately with OO and Ubuntu.
I then on further advice uninstalled the bundled Ubuntu version of OpenOffice and installed directly from the OpenOffice website. The problem still remains. Next thing I tried was to uncheck autosave feature. The above problems only happen on my desktop. I also have an ASUS EEE Netbook running Ubuntu 9.10 Netbook remix. This is fine - the problem does not seem to affect the netbook. I would really like to continue to use OO - I like it a lot. Unfortunately this freezing issue is making it unusable.
Debian :: Cannot Update System After Unsuccessful Install Of OpenOffice
Mar 20, 2010I installed openoffice 3.2 but had insufficient diskspace at /opt. Thereafter I receive this message if I start the package/update manager.
"A unresolvable problem occurred while initializing the package information. Please report this bug against the 'update-manager' package and include the following error message:
'E:The package ooobasis3.2-math needs to be reinstalled, but I can't find an archive for it.'"
Uninstall and reinstall (at a different location (/usr/opt) is not possible although there is enough space.
Fedora :: No Suitable Windowing System Found, Exiting OpenOffice?
Dec 8, 2009I just installed fedora12 with seLinux active and OpenOffice:
Code:
# rpm -qa | grep openoffice
openoffice.org3-base-3.1.1-9420.i586
[code]....
OpenSUSE :: Running Suse 11.3 64bit And OpenOffice 3.2.1.4 It Installed With The System?
Feb 5, 2011I am running Suse 11.3 64bit and OpenOffice 3.2.1.4 it installed with the system.OpenOffice's latest is 3.3 something, is there a repository that I can add to continuously update the program? Or do I need to completely remove the present program and install the latest from OpenOffice.org? It would appear that the one that came with the system was pieced together by the Suse team - do they update this at all?
View 7 Replies View RelatedFedora Installation :: Openoffice Dead - Restart System And No Longer Works / Fix It?
Nov 22, 2010I have a problem with the openoffice 3.1, install it and I worked fine in Fedora 14, but I restart the system and no longer works. nothing happens with any file.
to download from the official site and install it manually.
I can not fix
Software :: Can't Download And Install Openoffice In RedHat Enterprise System / Done This Successfully?
Jul 3, 2010I am new user in RedHat Enterprise 5 Linux. I want to install openoffice. But i can't download & install it. Have any solution to done this successfully?
View 2 Replies View RelatedFedora :: OpenOffice - Install A Language-pack For OpenOffice?
Dec 14, 2009I'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
Code:
[root@sarah yum.repos.d]# yum install openoffice.org-langpack-de
Loaded plugins: fastestmirror, presto, refresh-packagekit, remove-with-leaves
Loading mirror speeds from cached hostfile
* fedora: ftp.astral.ro
* livna: rpm.livna.org
[Code]...
Ubuntu :: List Of Directories To Spreadsheet
Oct 23, 2010I have a large music directory that I'd like to somehow acquire, or generate, a list of each sub-folder within it, and then somehow get the list into a spreadsheet format. Is there a way to do this?
View 1 Replies View RelatedUbuntu :: How To Use Formulas In OneOffice.org Spreadsheet
Dec 29, 2010I'm trying to create a simple times table on OpenOffice.org Spreadsheet
I'm trying to use the "$" in the top tab (input line) i.e.
Quote:
=A3*$B2$
Quote:
=A3*$B3$
[Code].....
To make the question clearer. When I used to use Microsoft Excel in Windows I would do just as I said in the above and I would be able to construct simple multiplication tables to more bigger/harder to memorize kind of type. And that would be by dragging the rectangle from it's bottom-right corner
Screenshot-5.jpg
Screenshot-4.jpg
So my question is what's the alternative OpenOffice.org Spreadsheet symbol for the "$" symbol used in the formula bar in Microsoft Excel?
Ubuntu :: Open Challenge In OOO Spreadsheet?
Mar 21, 2011I have used the words 'Open Challenge'.I have attached a spreadsheet 'Sample file for filter.ods'.TASK: In a presentation, I would like to show what are the Topics of India on Day-1 , Day-2 , Day-3 , Day-4. That means I am going to Filter India and (Day-1, Day-2, Day-3, Day-4).
View 7 Replies View RelatedUbuntu :: Spreadsheet Becomes ZIP Folder When Renamed?
Aug 7, 2011I had a really important spreadsheet with my student's grades in it. I wanted to rename it so I right clicked and renamed (at least that's what I thought I did). After I looked again, the file somehow became a zip folder. I inside the zip folder are a bunch of files but I can't the spreadsheet anywhere! Here are some screens:
View 2 Replies View RelatedUbuntu :: Use Calc For Simple Calculations?
May 25, 2010i am trying to use Calc for simple calculations. How can i do so that a whole column uses a number from previous row? for example i want D2=B2+C2+D1 and the next row to be D3=B3+C3+D2?
View 5 Replies View Related