Software :: 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
ADVERTISEMENT
Ubuntu :: 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"
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 RelatedSoftware :: 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 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.
Software :: How To Get 80 Rows By 130 Columns?
Aug 27, 2010I have been messing with a2ps in order to print a text file I have that has 130 columns by 80 rows per page. It appears that a2ps automatically scales the number of rows based upon the number of columns I try to print.The file prints properly for the columns but a2ps scales the rows to be 97 rows per page. So the 80 rows print but the next 17 rows are blank. It is not scaling the font for for 80 rows.
View 1 Replies View RelatedProgramming :: Convert Columns To Rows
Aug 10, 2009I bet this is a Perl one-liner (or very simple python script).I have a tab separated files in which each row looks like:Unique_Eight_Character_Sequence [3 tabs] data1~moredata1~moredata1 [3 tabs] data2~ moredata2~ moredata2 ... dataN~.The output file should have each column converted into a row (with the unique character sequence copied in for the first column), and then each "~" replaced by a comma.
View 14 Replies View RelatedGeneral :: Transform Rows Into Columns In Bash
Jul 29, 2011I would like to transform rows into columns from a file in bash.
View 4 Replies View RelatedSoftware :: Convert Columns Of Data Into Rows
Jun 28, 2010I need to create an out put file, last two columns as a row of data (using the first columns as heading) with the file name as first row. For an example the out put file should look like; system_name,0900_in,1000_in,1100_in,1200_in,1300_in,1400_in,0900_out,1000_out,1100_out,1200_out,1300 _out,1400_out
system1,15,17,19,21,23,25,24,26,28,30,32,34
I need to run a script to do above conversion. Need your help.
Programming :: AWK (or TCL/TK): Matching Rows And Columns Between Multiple Files?
May 26, 2011I've been hitting my head against a wall for awhile with this one:As the last part of some data analysis I performing I would to construct a matrix from a series of different files. These files have the format:
file 1 file 2 file 3
AAAAA .1 AAAAA .1 BBBBB .1
BBBBB .2 BBBBB .1 CCCCC .9
[code]...
Programming :: Get Number Of Rows And Columns Support In Screen?
Jul 18, 2011In linux terminal; how can we get the number of rows ad columns from linux kernel? I tried from environment variables(LINES,COLUMNS) but, I could not retrieve them as my editor program is a child process to linux terminal process.
View 7 Replies View RelatedGeneral :: Determine Number Of Rows And Columns Of File In Shell?
Mar 4, 2010if there's a tab-delimited file under /usr/desktop, how can I determine the number of rows and columns of the file in shell?And, if told the the 3rd column of the file contains only numerical values and all values in the 5th column are unique, how can I verify these in shell?
View 13 Replies View RelatedUbuntu :: OpenOffice Draw - Insert A Basic Table With 6 Columns And 3 Rows?
Feb 23, 2010the color from the table I insert? All I want to do is insert a basic table with 6 columns and 3 rows. I get that, but it has a gradient blue color.
View 1 Replies View RelatedOpenSUSE :: Delete Libre Office Writer And Install Open Office Again?
Apr 28, 2011Is it possible to delete Libre Office Writer and install open office again as Libre seems to be full of bugs and unusable? I have 11.3.
View 9 Replies View RelatedUbuntu :: Open Microsoft Office File Without Installing Microft Office For Sur?
Feb 22, 2011how to open microsoft office file in ubuntu without installing microsoft office for sure
View 2 Replies View RelatedUbuntu :: Libre Office: Can It Read Open Office Documents
Mar 28, 2011I just found out about Libre Office. I am currently using Open Office on my Netbook (ubuntu 10.10), and NeoOffice on my Macbook (OS/X 10.6.7).
QUESTION: I have some backups using these formats: .sdw, and .odt. Can Libre Office read documents saved in these (StarOffice / Open Office) formats?
FWIW: I would have preferred to use OO on both machines, but unfortunately OO never fixed a problem with printing envelopes in the Macintosh version. Hence my use of NeoOffice.
Ubuntu :: Switching From Open Office To Libre Office?
Apr 22, 2011I have both installed, but since LO is going to be the way Ubuntu goes for office applications, can I easily have my system setup for native LO? Native being if I double clock on a .doc file it will start up LO's Write program instead of OO.Will just removing OO achieve this or is there an easier way? I looked for file associations and didn't find it.
View 9 Replies View RelatedUbuntu :: Get KDE Office Instead Of The Regular Open Office?
Sep 14, 2010Sometime ago I realized my Open Office had changed, I don't remember having done anything in particular but today it isn't the regular open office but what I believe is a KDE version or idk. The theme changed and instead of regular menus I get "window" menus, in the sense that they get effects as regular windows. It's hard to explain it.
[URL]
I tried uninstalling it and installing open office and also in the soft center open office is more than once, but I tried the different versions and I still get the same problem.
Debian Multimedia :: When Open An Open Office Document From An NFS Share It Always Opens As Readonly
Apr 27, 2010When I open an open office document from an NFS share it always opens as readonly. This was a problem I had on Arch linux and the fix was to change the locking options in the soffice script but I've tried that fix here and it doesn't work. I've seen a lot of discussions but they all go back to changing the locking options in soffice, has anyone got any alternative fixes or one that definitely works with locking?
View 4 Replies View RelatedUbuntu :: Data Lost - Open Office Or Pdfs - Have No Information And They Won't Open
Dec 14, 2010I don't know if I'm doing something wrong but I've been running Ubuntu or a variant for about a year now and suddenly every now and then one or two of my documents (open office or pdfs) have no information and they won't open.
View 6 Replies View RelatedUbuntu :: Sporadic With The Openoffice.org Program - Can't Open Any Open Office Programs Without Rebooting Computer
Jan 28, 2011I'm having sporadic issues with the openoffice.org program. Sometimes, power point presentations will crash the program and then I can't open any open office programs without rebooting the computer. The problem seems to be just with powerpoint files and I'm not sure what the issue could be.
View 7 Replies View RelatedDebian Multimedia :: Open Office 4 Installation - Can't Open Display
Feb 15, 2016I installed Open Office 4 on Debian 8 but when I run the program I get this error message.
root@localhost:/home/paul# openoffice4
No protocol specified
No protocol specified
/opt/openoffice4/program/soffice.bin X11 error: Can't open display:
Set DISPLAY environment variable, use -display option
or check permissions of your X-Server
(See "man X" resp. "man xhost" for details)
Open Office works fine when I run the command "startx" in the Konsole but so far I haven't been able to configure it.
Software :: Cant Open Xls Files In A Shared Folder Using Open Office 3.1?
Oct 12, 2010I cant open xls files in a shared folder using open office 3.1. Its all started when i install a new open office version. when im using open office 3.0.8 i can open all the files but now i cant even open it. Its always display untitled documents.
View 14 Replies View RelatedApplications :: Open A MS Access File In Open Office?
Mar 17, 2009I have a MS Access database I would love to able to use in OOo. How do I do it
View 2 Replies View RelatedSoftware :: 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 View RelatedFedora :: Can't Run Open Office
Sep 13, 2009I can't get open office to run. I believe I need jre1.60 to run this. I have jdk installed since I need this for java programming. Can I also install jre1.60 and use jdk as well? I am taking a class in Java programming so I don't want to screw up my programming environment. However, I need to use OO powerpoint for class as well.
View 3 Replies View RelatedUbuntu :: If / Where Can One D/l Open Office 3.2 DEB
Mar 12, 2010I have been on the open office site, and tried several different downloads for Open Office 3.2. However, once I unpack the gzipped file, I get several deb packages from within the archive. Could someone kindly point me to a link where I can d/l a single deb package so I may easily install / (upgrade to)version 3.2? FWIW, I am using Karmic with the latest updates and OO ver. 3.1.1 on my netbook.
View 4 Replies View RelatedRed Hat :: Can Not Install Open Office ?
Jul 13, 2009I got this error msg when I try to install Open Office 3.
View 3 Replies View Related