Software :: Software Replacements For Open Ofiice Calc?
Jul 10, 2010some software replacements for open ofiice calc? i had fedora 13 lxde and i liked that one, but i don remember the name. maybe there are better ones than it too
View 3 Replies
ADVERTISEMENT
OpenSUSE :: Convert PDF To Open Office Calc?
Jan 24, 2011I don't know if such a thing exists but I would like to do convertion a PDF file to a spreadsheet. Do You know of any application to do this ?
View 2 Replies View RelatedUbuntu :: Repeat Rows In Open Office 3.2 Calc?
Oct 28, 2010I have been trying to repeat the first two rows in a Calc document but I keep getting an error.
Here are the instructions that I used.
Printing Rows or Columns on Every Page If you have a sheet that is so large that it will be printed multiple pages, you can set up rows or columns to repeat on each printed page. As an example, If you want to print the top two rows of the sheet as well as the first column (A)on all pages, do the following:
1.Choose Format - Print Ranges - Edit. The Edit Print Ranges dialog appears.
2.Click the icon at the far right of the Rows to repeat area. The dialog shrinks so that you can see more of the sheet.
3.Select the first two rows and, for this example, click cell A1 and drag to A2.
In the shrunk dialog you will see $1:$2. Rows 1 and 2 are now rows to repeat.
4.Click the icon at the far right of the Rows to repeat area. The dialog is restored again.
5.If you also want column A as a column to repeat, click the icon at the far right of the Columns to repeat area.
6.Click column A (not in the column header).
7.Click the icon again at the far right of the Columns to repeat area.
Rows to repeat are rows from the sheet. You can define headers and footers to be printed on each print page independently of this in Format - Page.
And here is the error.
"invalid sheet reference"
Software :: Filter By Color In Open Office Calc?
Jul 21, 2011Is it possible to filter data using color in Open Office Calc?? It's very easy to use this function in MS Excel.
View 1 Replies View RelatedUbuntu :: Libre Office Calc Won't Open File / Make It Possible?
Jul 8, 2011Okay so I have a file that I always save and close properly and get in my Ubuntu One folder for backup that will not open. Its called "Income.ods" and is quite important and I cannot seem to recover it. When I double click it, it shows the Libre Office Calc splash screen shows up then goes away and the nothing, no error messages, no nothing. I tried to open it on my Windows Vista machine and it said it was corrupted and could not open in Office Word. I tried a few recovery tools but to no avail.
View 9 Replies View RelatedSoftware :: Colorizing Rows/columns In Open Office Calc?
Jun 9, 2010I highlight a column by selecting "D" > format cells > background > I select a color and press OK. But the color on the document remains the same.
View 3 Replies View RelatedUbuntu :: Open Office Calc Print Portrait And Landscape?
Aug 12, 2009I have a Calc spreadsheet that has 3 sheets. The first page is set for Portrait and the remaining pages are Landscape. Currently I am printing each page as a separate print job.I would like to print the entire Calc pages as one job where the printer prints the first page as portrait and the remaining pages as landscape without user intervention.
I do not see any command in the print dialog or in open office dialogs that tell the printer to change orientation. It seems that OpenOffice fails to tell the printer the page orientation. Is there any way to accomplish this. If a macro is required how do you write it and how is it executed?
Software :: Automatic Method To Compare Two Open Office Calc Docs
Nov 4, 2010I have 2 versions of the same spreadsheet. Each spreadsheet is divided into many different workbooks.
I have googled this without success. I want to automatically find any lines in spreadsheet 1 which are not in spreadsheet 2 or vice versa.
CentOS 5 :: Virtualbox - Guest Additions Replacements Better?
Apr 27, 2011I use CentOS under VirtualBox. There are Guest Additions, but for Ubuntu are
virtualbox-ose-guest-utils and virtualbox-ose-guest-x11
There are GA replacements, better than GA (no problem with AppArmor). Are CentOS replacements ?
Ubuntu Installation :: Business Software / Replacements For Windows?
May 31, 2011all of those in business know that we will never be able to completely dispose of Windows - Linux just doesnt support business that well, as there arnt the number of users.However, does anybody know of any packages (free or commercial for Ubuntu) that will replace any of the following:email maketing similar to Group Mail (Windows)web stats program like Web Position (Windows)web button design tool like Xara Webstyle (Windows)Also, are there any shopping carts out there that work like Actinic? OK, I know there's oscommerce and Zen Cart, but they are a setup nightmare compared with Actinic for setting up ecommerce sites, albeit they are free (which is always good).
View 5 Replies View RelatedHardware :: HP Printer Still Reads Ink Level Empty Even After Replacements
Jan 25, 2010My father has an HP PSC 1510 All in One Printer - Scanner - Copier. I have recently managed to convert him over to Linux, his current distro of choice is Fedora 12.Everything was going surprisingly well until recently: the message came up on his screen saying that the ink levels were low. After replacing the cartridges the message continued to appear. However the main nuisance is that it will not allow the printer to print at all now.
The cartridges are working as he still has vista on his system and logged in and printed out from there without hassle. Is there a way to reset the memory of the printer in Fedora? I am not much help to him here as I know nothing about printers.
General :: SSH Client And Command Prompt Replacements Windows Look-and-feel?
Jun 9, 2010I've worked exclusively in Windows. I can handle that.I've worked exclusively in DOS (a long time ago!). I can handle that.I've worked exclusively in Unix.I can handle that.Right now, I am developing a command-line (python) application on a Windows machine, testing it in a DOS box (i.e. Windows' Command prompt), and then deploying it to Linux, and running it with PuTTY.
I cannot handle that. My productivity drops dramatically when CTRL-C cuts in one window (Windows) and kills the process in another (DOS, Linux).My productivity drops dramatically when Enter copies the selection in one window (DOS), and deletes the selection in another (Windows), and runs the current half-edited command in the third (PuTTY).My productivity drops dramatically when I cannot hit Undo, Home or End.The Solution I am Seeking
An SSH/Bash command-line client that runs on Windows and, to the extent possible, uses all the standard Windows shortcuts (Cut, Copy, Paste, Undo, Home, End, Insert, Shift-Arrows, etc.) work on a bash command line. Bonus points if it puts the cursor between letters, rather than on them.Plus, an equivalent DOS command-line drop-in that runs on Windows, and provides the same interface.need to be special buttons to actually transfer CTRL codes (like CTRL-C) through in the cases I need them.I suspect the SSH client will need to be specific to a shell (so it knows when it is at the command prompt, and when it is inside a running app.)I know there are many SSH clients, but I am looking for advice for a particular need.PuTTY feels like an escape route for Unix programmers stuck on Windows. I am the opposite.Can anyone recommend one (or maybe a combination of an SSH client and an Command-Line replacement)?
Update: After seeing the early answers here, I turned my requirements into a blog article, which may give more background in the direction I am looking.
Ubuntu :: Search And Indexing - Installing Beagle/Good Replacements?
Jul 3, 2011I know this has been asked before, but in case there are some significant changes in this area with Ubuntu/Kubuntu 11.04, I ask. Are there any good search and indexing tools available preferably something that also look at the content of files? Something along the line of Beagle. Is it still possible to install Beagle?
View 1 Replies View RelatedFedora :: Lost All Most Every Data In Calc
Dec 6, 2010One 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.
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 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??)..
Fedora :: 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 RelatedFedora :: Cannot Find - Define Print Range In Calc?
Feb 23, 2011I 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,
View 3 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 RelatedUbuntu :: 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 RelatedSoftware :: Excel Files Have Empty Comments In OO.o Calc
Jun 24, 2010Imported an Excel file into OO.o Calc. EVerything is fine except the comments are all blank. It knows that comments should be there, but they're all empty. how to recover the contents?
View 2 Replies View RelatedSoftware :: 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 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 :: Referencing Cells In OO Calc Data Range
Jun 17, 2010This is supposed to be possible right and better than naming each single cell?How do you do it?Also, maybe my approach is wrong as it's going to lead to a very big nested IF statement.There is a list of numbers which are price ceilings and another list of numbers containing the fees applied to these. I want to a formula that checks the item price against the ceilings and if it's less than or equal to that ceiling uses the fee in the adjacent row (which is the other data range).The only way I know how to do this is a big nested IF statement but does anyone know better?
View 5 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 :: Find - Restore Lost Libre Calc Spreadsheets?
Jul 2, 2011My low-down lousy computer crashed while I had two spreadsheets (Libre Calc) open. When I re-booted the 'tater, then clicked on the launchers for my spreadsheets, Libre Calc opened new, blank documents.
Is there a way to find the lost spreadsheets? If I can't have the whole things, then just the data would be OK.
Debian :: Calc Function To Return Numeric / Alphabet Or Remain Empty
Oct 17, 2015I need to make a function combination to get for: If cell A1 then for B1 as:
A1 B1
--- ---
abc abc
hello hello
empty empty
0 0
-3 -3
5 5
and like wise
Ubuntu :: 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 Related