[users] Re: Calc: protect Rows against ordering of columns

2005-06-28 Thread Uwe Brauer
Dan == Dan Lewis [EMAIL PROTECTED] writes: Hello Dan, Dan Thank you for being persistent. This is something that I need to Dan add to the Getting Started section of the User's Guide for Dan version 2.0. I would not have thought this was this Dan important if

[users] Re: Calc: protect Rows against ordering of columns

2005-06-27 Thread Uwe Brauer
Jonathon == Jonathon Blake [EMAIL PROTECTED] writes: Jonathon Uwe wrote: I know the basics of the data base, and must say that the spreadsheet is more comfortable, for example printing tables is not easily possible, Jonathon Using a database? Jonathon Select

Re: [users] Re: Calc: protect Rows against ordering of columns

2005-06-27 Thread Dan Lewis
On Monday 27 June 2005 07:02 am, Uwe Brauer wrote: Jonathon == Jonathon Blake [EMAIL PROTECTED] writes: Jonathon Uwe wrote: I know the basics of the data base, and must say that the spreadsheet is more comfortable, for example printing tables is not easily

[users] Re: Calc: protect Rows against ordering of columns

2005-06-27 Thread Uwe Brauer
Dan == Dan Lewis [EMAIL PROTECTED] writes: Uwe Dan When you are printing tables, are you entering the table Dan or tables Dan in a text document (Writer) or spreadsheet (Calc)? In either Dan case, using the Data to text icon in the Data Display

Re: [users] Re: Calc: protect Rows against ordering of columns

2005-06-27 Thread Dan Lewis
On Monday 27 June 2005 10:11 am, Uwe Brauer wrote: Dan == Dan Lewis [EMAIL PROTECTED] writes: Uwe Dan When you are printing tables, are you entering the table Dan or tables in a text document (Writer) or spreadsheet (Calc)? Dan In either case, using the Data to text icon

[users] Re: Calc: protect Rows against ordering of columns

2005-06-27 Thread Uwe Brauer
Dan == Dan Lewis [EMAIL PROTECTED] writes: Calc, but you are taking here about 2.0? in my 1.1.4 there is now data to text icon in the display. I just wanted to point out that OO does *not* have the feature of printing a table _directly_ form the data display window.

Re: [users] Re: Calc: protect Rows against ordering of columns

2005-06-27 Thread Dan Lewis
On Monday 27 June 2005 02:51 pm, Uwe Brauer wrote: Dan == Dan Lewis [EMAIL PROTECTED] writes: Dan On Monday 27 June 2005 01:45 pm, Uwe Brauer wrote: [snip] Ok I see now what you mean, I see this in my 1.1.3 Debian version, however this has never (as far as I

[users] Re: Calc: protect Rows against ordering of columns

2005-06-27 Thread Uwe Brauer
Dan == Dan Lewis [EMAIL PROTECTED] writes: DanIn version 1.9.104 and 1.1.4, the two are Dan linked. If you make a change in the database, it Dan will also show up in the spreadsheet if you do Danthis: Data RefreshRange in thetop Dan

[users] Re: Calc: protect Rows against ordering of columns

2005-06-24 Thread Uwe Brauer
Dan == Dan Lewis [EMAIL PROTECTED] writes: Dan If I understand you correctly, you want to sort one column Dan and that is it. The information in the other columns remains Dan in the order it was in the beginning. If this is the case, Dan click the letter at the top of

Re: [users] Re: Calc: protect Rows against ordering of columns

2005-06-24 Thread Peter Kupfer OOo
Uwe Brauer wrote: Dan == Dan Lewis [EMAIL PROTECTED] writes: Dan If I understand you correctly, you want to sort one column Dan and that is it. The information in the other columns remains Dan in the order it was in the beginning. If this is the case, Dan click the

[users] Re: Calc: protect Rows against ordering of columns

2005-06-24 Thread Uwe Brauer
Peter == Peter Kupfer OOo [EMAIL PROTECTED] writes: Peter I don't follow understand what is wrong with selecting both Peter column and hitting sort, you get the result. I suppose you Peter could write a macro that would select the rest of the Peter colummns and sort, then

Re: [users] Re: Calc: protect Rows against ordering of columns

2005-06-24 Thread Jonathon Blake
Uwe wrote: This is uncomfortable, Your options are: a) Use a tool that is known to cause , and will cause _all_ your data results to be invalid. (A spreadsheet) b) Learn a new tool. (A database.) Pick option A, and explain to your oversight committee why your data is corrupt. [At least the

[users] Re: Calc: protect Rows against ordering of columns

2005-06-24 Thread Uwe Brauer
Anthony == Anthony Chilco [EMAIL PROTECTED] writes: Anthony Hi Uwe, Anthony So what you want is to prevent sorting unless all the data Anthony are selected, right? Unless you take Jonathon's advice and Anthony use the database tool, the only method I can suggest would

[users] Re: Calc: protect Rows against ordering of columns

2005-06-24 Thread Uwe Brauer
Jonathon == Jonathon Blake [EMAIL PROTECTED] writes: Jonathon Uwe wrote: This is uncomfortable, Jonathon Your options are: Jonathon a) Use a tool that is known to cause , and will cause Jonathon_all_ your data Jonathon results to be invalid. (A spreadsheet)

Re: [users] Re: Calc: protect Rows against ordering of columns

2005-06-24 Thread Jonathon Blake
Uwe wrote: I know the basics of the data base, and must say that the spreadsheet is more comfortable, for example printing tables is not easily possible, Using a database? Select the fields you want printed, and voila. to operate between columns by functions is less comfortable.