[PLUG] OO.o Calc Question

[Ken Stephens]

Rich Shepard wrote:
> On Mon, 21 Mar 2011, Roderick A. Anderson wrote:
>
>    
>> Another is to turn the problem on its head. Lets say the last cell of your
>> sheet is E345. (You can find this by doing a CTL+END). Create a new sheet
>> put "." in A1 and copy the cell. In the range selection box (that's the
>> one next to f(x)) type A1:E345 and hit enter. Now hit CTL-V and paste. You
>> have now A1:E345 filled with dots. Now go the the original CSV download.
>> CTL-END then CTL-SHIFT_HOME to select the entire contents; copy it and
>> toggle over to the new dotty sheet. Now do a Space Special (CTL-SHIFT-V)
>> and check the "Skip Empty Cells" box. Job done. I know its a manual
>> exercise but it only takes 15 secs or so.
>>
>> Replace the '.' (dot) with NA.
>>      
>     Thanks, Rod.
>
> Rich
> _______________________________________________
> PLUG mailing list
> PLUG at lists.pdxlinux.org
> http://lists.pdxlinux.org/mailman/listinfo/plug
>
>    
Just wondering instead of placing a '.', why not place 'NA', then paste 
as prescribed.

Ken