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
ADVERTISEMENT
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
Jun 17, 2011
How can I delete empty lines in OpenOffice Calc?
View 2 Replies
View Related
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
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
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
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
Jun 1, 2010
Cannot paste URL When I middle-paste into the URL box in the Hyperlink toolbar, nothing happens. Misleading support link The support link in Help/Support shows the general Novell support page. It is not clear how to get support for OpenOffice from there (especially for openSuSE). Hyperlink toolbar button performs no action In order to place a hyperlink at the cursor, you have to click the pull-down menu by the hyperlink button on the toolbar. Clicking on the button has no effect.
I think it should be equivalent to inserting the hyperlink as text. Persistent extending hyperlink mode When you place the insertion point immediately following a hyperlink and start typing, the hyperlink text extends; there is no way to cancel that effect. In particular, in the situation when a new document contains only a hyperlink, everything you type, either in front or at the end, becomes a part of it. The only way out of this situtation is to clear the hyperlink text and press Enter; the hyperlink is then replaced with an explicit URL and you can type further without extending the hyperlink.
No apply on Close There is another undocumented button in the Standard Toolbar that opens the Hyperlink dialog box. This box behaves in a very peculiar way: when you click on the button [Close], the box closes without updating anything. In order to apply the changes you have to press [Apply] and only then [Close]. This is rather surprising (at least for me), although it is better understandable when you consider that the Hyperlink dialog box is modeless. Travelling paste Steps to reproduce:
1. Edit a long document (containing several pages).
2. Mark some text on Page 1.
3. Middle-paste the text on Page 3.
Observe how you get transferred back to Page 1.
View 9 Replies
View Related
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
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
View Related
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
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
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
Jun 5, 2011
I cannot print pdf files. I have tried using okular and xpdf. The documents display in the program, but print preview shows a blank page. The printer then sends out blank pages. I have tried printing on 2 different printers using usb cables. Using terminal to process the commands shows error:
Quote:
xxx@xxx:~$ xpdf
***** MediaBox = ll:0,0 ur:611.976,791.968
***** CropBox = ll:0,0 ur:611.976,791.968
***** Rotate = 0
Segmentation fault
Converting to .ps also is blank.
View 6 Replies
View Related
Jul 28, 2010
FC13/KDE. when typing text in writer, when I hit the tab key it places a solid line across the page.
Is this a setting in openoffice?
View 1 Replies
View Related
May 25, 2009
This is rather queer, as I know what I'm looking for, but I'm not sure what it is called, or whether it exists in Writer.
I'm writing a report, and I would like to have the content (index) page configured "automatically", so that it lists my headings in the rest of the document, but if I add something in the middle of what has already been written then it should pick that up and change the content page accordingly, without messing up the page numbers.
It's quite a pain to make a content page by hand. I think MS Word has a tool to allow you to do this, but I don't want to use MS Word in this case for various reasons. So does anyone know what this is called and perhaps how it is done on Writer. Although, if I know what it's called, I can use the Help.
View 1 Replies
View Related
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
May 18, 2010
I have a document with page numbers in the Table of Contents in Roman Numurals. I would like to change them to numbers 1, 2, 3. How would I do this? I'm not finding any help on the Internet and in Openoffice help. If I change the numbers manually, they will revert back when I update the Table of Contents.
View 1 Replies
View Related
Jan 24, 2011
I 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 Related
Jun 10, 2011
I always enjoyed the feature in Microsoft Word when in "Print Layout" where I could make the end of one page touch the beginning of the next page so the pages could be viewed seamlessly. There appears to be no way to do this in Writer Anybody know if this is possible in Writer?
As a work around I use WEb Layout to view documents. But everytime I reopen OpenOffice it defaults to Print Layout. Anybody know how to make it default to Web Layout when it is opened?
View 4 Replies
View Related
Feb 8, 2010
I am using m-audio delta 1010 ( break out box) works perfect with opensuse 11.1 and 11.2 but is is not on the hardware compatiblitiy list. How to add? it is using alsa-tools.
View 1 Replies
View Related
Apr 4, 2011
The libxml2 update specified by CVE-2010-4494 causes a notification that it will break Adobe AIR and TweetDeck on my machine.How can I blacklist this update so it won't keep showing up in the Updater applet?The applet says I should go into Yast and manually apply the update. When I do that and tell it not to apply the update, Yast exits and the Updater applet just tells me the update is still pending. I want to get rid of the update at least temporarily until Adobe fixes the dependency (assuming they ever do).
This is a major problem for me as I clearly don't intend to uninstall TweetDeck and AIR just for some security patch. Why didn't openSUSE test this patch for AIR compatibility?
View 6 Replies
View Related
Jul 11, 2010
I cannot use preview function in Dolphin to preview JPG files that the size is bigger than 3MB. It is no problem when the photos' size are smaller than 3MB. Do any one got the same problem?
View 4 Replies
View Related
Sep 15, 2010
Dolphin crashes when previewing PNG files - with other image files (PS, PDF, JPG, DVI) when you roll the mouse over the file you get a preview pic in the top right corner - when I roll it over a PNG file, it halts for a second then crashes.
View 9 Replies
View Related
Jul 20, 2010
When opening nautilus there are no image previews.Only if i watch the image with eye of gnome and than klick thereload button, the pictures are shown. is this a bug or feature?how can i switch this back to the default where image previews areshown when i open a folder without viewing it with eye of gnome?
View 5 Replies
View Related
Jul 28, 2010
Since I upgraded to 11.3 I don't see that the View > Preview mode is broken. Image icons are created, but they all look like the icons in the picture below. When I move the zoom slider the largest sized icons come out fine. Anyone an idea how to solve this problem? Is there any repository that I can use to get more recent versions that should have fixed these bugs? I just noticed that PNG images come out right, so it could be something related to JPG files.
View 3 Replies
View Related
Sep 14, 2010
I am running Opensuse 11.3, KDE 64 bit. I have a nvidia GeForce 9400 GT graphic card.Somehow Dolphin and Firefox cannot show picture preview.It comes out like this; ImageBam - Fast, Free Image Hosting and Photo Sharing ImageBam - Fast, Free Image Hosting and Photo Sharing.
View 9 Replies
View Related
Apr 18, 2010
I don't how long is has been happening for (I've just upgraded my old computer, so it is now my faster and better machinig), but Nautilus is failing to create thumbnails for anything other than text files.
I've swapped the settings around to try to trigger changes, but even on "Local only" or "Always" with a 10MB cap then Nautilus won't generate previews for anything other than text files. All images/videos/pdfs/web pages that should have thumbnails generated for them have the "pending" icon but never generate a thumbnail. If, however, I open the file (with Eye of Gnome or Gimp) and refresh the folder then the thumbnail appears for the one file I just opened (so I could go through and preview all images, but I'd really rather not!)
I've tried removing/renaming my .local/share/mime folder in case it was incorrectly handling file types, but that didn't help. I've looked in gconf at the thumbnailer apps, but that appears to be for everything except images. Running "evince-thumbnailer" on its own works fine as well and generates an image. There aren't any related errors in .xsession-errors, and I don't know where else Nautilus logs to (running "nautilus --browser" creates a browser window but then drops back to the command line and doesn't print any output).
I'm using openSUSE 11.2 and the default Gnome, with codecs from Packman. A fairly similar setup on my other machine is thumbnailing perfectly fine.
View 2 Replies
View Related
Aug 16, 2010
Just installed openSUSE 11.3 (KDE) and not expert about it yet, I am experiencing two problems.
Skype: just installed 2.1.0.81-suse.i586rpm, starting it I get just the icon jumping on the desktop a bit and nothing else.
If I try with the command line, this is the result:
After that, I dont have preview about stored file images and even online, Google Images does not showing preview, just colored strips; if I go with the mouse on it, the image comes out.
View 4 Replies
View Related
Jun 16, 2011
time ago when KDE 3.5 was still "the hype" konqueror file browser used to show a image of a frame of the video files when the mouse was over a selected video file.Is it possible to enable/install this functionality on Dolphin or the neutered Konqueror in KDE4?
View 6 Replies
View Related
