On Wednesday 01 June 2005 11:35 am, mojo jojo wrote:
> I have a problem related to Filters in Open Office:
> I have attached a simple .xls file in wich the problem
> occurs
> There are 3 columns with AutoFilter: Date, Fruit,
> Number
> There are 5 steps:
> 1. I select on second column, the "Apple" - then I get
> 4 rows selected: 2,6,7,10
> 2. I want to replace the value in column "Number" with
> number 5. So:
> 3. I replace with 5 in row 2, then -> CTRL+C
> 4. I Select in the "Number" Column the next 3 rows,
> that means rows: 6,7,10
> 5. CTRL+V. Now all the rows with "Apple" have the
> "Number" set to 5.
> But my problem is:
> - when I select "all" in the second column (Fruit), I
> can see that also rows 8,9 have the "Number" set to
> 5!!
> - so I think the problem is that it replaces all the
> rows between 6 and 10 with "5", in spite of the fact
> that I have set it only on rows 6,7,10
>
> Can anyone help me?
If you want us to look at your file, you need to post it to a web
site. Attachments are stripped from this mailing list to prevent
viruses from being sent its members. Otherwise we may not be able to
help.
If you can post the file, send its address (URL) to this mailing
list: [EMAIL PROTECTED]
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
