Recent Forum Posts

From categories:

All categories KOffice 1.: KOffice 1 KOffice 2.0: KOffice 2 Community matters: guest book Community matters: site design and layout Community matters: sandbox

page 1 of 212next »

Re: How to center the printsheet

Kingfisher 1210222681|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » How to center the printsheet

I would use blank columns to centre the data. Could you not use the margins in Page Layout?

As far as filtering goes, can you use formulas together with companion columns?

Re: How to center the printsheet

Anonymous (90.19.152.153) 1210170723|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » How to center the printsheet

Page Layout do not allow you to center the selection printed.

I wish I had filters on kspread like in Open office to filter a selection from a column header.

Re: How to center the printsheet

Kingfisher 1210052398|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » How to center the printsheet

You can also use Format >Page Layout.

Re: How to center the printsheet

Kingfisher 1209865781|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » How to center the printsheet

I don't see any way using the print instructions. You can, of course, centre the text using Format >Cell format : Position.

What is your requirement for filters?

How to center the printsheet

Anonymous (90.8.203.135) 1209802513|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » How to center the printsheet

Bonjour, Hello,

does anyone know how to center the printing in kspread?
It is the only feature I dunno (if it exists) as well as filters in kspread.
Otherwise it is quite a good material.

Thanks

Re: Questions on kspread

Kingfisher 1206401851|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » Questions on kspread

You can use Python script with Koffice now. See Tools >Script Manager | Scripts

Re: Questions on kspread

Anonymous (24.161.209.36) 1206392277|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » Questions on kspread

Thanks Kingfisher. I'll try to take a look at 2.0.0 when it is released. BTW, will the new version handle macros?

klee12

Re: Questions on kspread

Kingfisher 1206329262|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » Questions on kspread

Hi. The new version 2.0.0 to be released this year will contain new features. Dealing with the specific questions you raise,

1. Sorting is limited to 3 fields.
2. For copying from the clipboard, try Insert >External Data >From clipboard
3. You can set cell backgrounds with Format >Cell Format : Background
4. I don't find any method for freezing titles. There is the possibility of splitting the view, which achieves much the same thing. See View >Split View.

Re: Questions on kspread

Anonymous (65.28.145.135) 1206164395|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » Questions on kspread

A few more questions on Kspread

3. Is it possible to highlight cells by changing he background color (say to red)?

4. I have a spread sheet with over 50 columns and 100 rows. I would like to keep the column headings visible when I scroll down, and the row headings visible when I scroll to right. Is there a way to lock the headings so that they are always visible?

Thanks

klee12

Questions on kspread

Anonymous (65.28.145.135) 1206160572|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » Questions on kspread

Hello,

I have an important (to me) spreadsheet running under Xess, and I would like to replace Xess with another program, perhaps Kspread. The new program should be able to do everything I did with Xess without too much trouble. Kspread seems to be able to do what I want, except for two items. They are:

1. It seems I can only sort on 3 sort fields, whereas I would like to have 5 or 6. Is there a way to do this. I can think of a workaround, but it's not pretty.

2. With my old spreadsheet program I could use the X11 to copy several columns of numbers, space delimited, into the X11 clipboard. Then I could go into my spreadsheet program, and paste from the X11 clipboard into the spreadsheet. The numbers would go into different columns in Xess but in Kspread, all the columns would go into one column. Is there a way to paste from the X11 clipboard directly into the spreadsheet and preserve the column structure? Again I can think of a workaround but it isn't pretty.

Thanks in advance for any suggestions.

BTW, I really like the look and feel of Kspread.

klee12

Re: kspread - formatting text in cell - just some text , not the whole cell

Kingfisher 1205364888|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » kspread - formatting text in cell - just some text , not the whole cell

I would expect to find a command to format characters in the Format menu. There's none there or elsewhere. You can underline all or nothing.

kspread - formatting text in cell - just some text , not the whole cell

Anonymous (60.49.108.169) 1205324792|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » kspread - formatting text in cell - just some text , not the whole cell

Hello members,

I was wondering if someone can shed some light on this issue . How do we just underline some lines in cell. when u underline just some lines, all the text in the cell is underlined ! Pls help.

Re: Can I convert "end of line" codes with Kword?

john_r_hudson 1195256370|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » Can I convert "end of line" codes with Kword?

Normally KWord handles these conversions automatically; if you save them as plain text (.txt) files you should get an option to save them in either Unix, Windows or Mac formats when you save them as this is the only time it isn't handled automatically.

Re: kword/kspread *very* spread out horizontally

Kingfisher 1194754338|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » kword/kspread *very* spread out horizontally

I'm sorry to be so long replying. There is a later post by Thomas Zander in the same thread.

I followed the advice in the Pclinuxos thread, even though I was having no problem and I have found that in some situations the fonts render much better. I used 96 rather than 100. The sky did not fall down when I inserted the code into xorg.conf.

Re: kword/kspread *very* spread out horizontally

tuubaaku 1194730854|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » kword/kspread *very* spread out horizontally

OK, I found the answer to this in an email from Thomas Zander on the mailing list.
http://lists.kde.org/?l=koffice&m=119340201820544&w=2

I don't understand it all, but basically the x-DPI settings are wrong. A quick work-around is to open the apps like this: kword —dpi 100,100

The real solution is to fix the xorg configuration, I guess. This thread has someinformation:
http://www.pclinuxos.com/index.php?option=com_smf&Itemid=58&topic=17276.0

kword/kspread *very* spread out horizontally

tuubaaku 1194563249|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » kword/kspread *very* spread out horizontally

I open up KWord and KSpread, and the layout of both is very messed up. The document or spreadsheet is stretched way out, so that you have to scroll multiple screen-widths to see elements that should be beside each other on the page. It's like my horizontal ruler is stretched so far out it's useless.

Any thoughts on how to fix this? Are there any places I can check for weird settings?

Re: forum sections for 1.6 & 2.0

Kingfisher 1193630429|%e %b %Y, %H:%M %Z|agohover
in discussion Community matters / site design and layout » forum sections for 1.6 & 2.0

I've mentioned it on tuxmachines and a couple of other places. Content is the main thing to concentrate on, I think. My to do list includes studying and writing. Three subjects that come to mind are

1. Installing, particularly when your distro does not have the package or the version you want and (in time) installing on Windows.
2. Templates, styles and dictionaries in KWord.
3. Scripting (on my agenda for KSpread).

I found some tutorials on a kde site. If anyone is disposed to writing articles rather than wiki pages, I can add an index to the sidebar.

Re: forum sections for 1.6 & 2.0

tuubaaku 1193545335|%e %b %Y, %H:%M %Z|agohover
in discussion Community matters / site design and layout » forum sections for 1.6 & 2.0

looks great. Now we just need publicity for this site… :)

Re: Can I convert "end of line" codes with Kword?

Kingfisher 1193274224|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » Can I convert "end of line" codes with Kword?

What document format is in use? You can import some documents using File >Import. For details of filters, see http://koffice.org/filters/

Can I convert "end of line" codes with Kword?

Mamadu 1193162125|%e %b %Y, %H:%M %Z|agohover
in discussion KOffice 1. / KOffice 1 » Can I convert "end of line" codes with Kword?

Hi,

I often get documents with Windows or Apple end of line codes (CR and CRLF respectively). Since I use Ubuntu Linux I would like to convert that to UNIX-like "line feeds" (LF).

Can I do this with Kword 1.6.3 either for a full document or with a text selection?

Thanks

Mamadu