Questions on kspread

summary:

How do I ...

Questions on kspread

Anonymous (65.28.145.135) 1206160572|%e %b %Y, %H:%M %Z|agohover

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: Questions on kspread

Anonymous (65.28.145.135) 1206164395|%e %b %Y, %H:%M %Z|agohover

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

Re: Questions on kspread

Kingfisher 1206329262|%e %b %Y, %H:%M %Z|agohover

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.

last edited on 1206329327|%e %b %Y, %H:%M %Z|agohover by Kingfisher + show more

Re: Questions on kspread

Anonymous (24.161.209.36) 1206392277|%e %b %Y, %H:%M %Z|agohover

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 1206401851|%e %b %Y, %H:%M %Z|agohover

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