[PLUG] OO.o Calc Question

Fred James fredjame at fredjame.cnc.net
Tue Mar 22 04:00:31 UTC 2011


Ken Stephens wrote:
> 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
>>
>>     
> Just wondering instead of placing a '.', why not place 'NA', then paste 
> as prescribed.
>
> Ken
>   
When I did my test, I did use NA instead of . and it worked fine
Regards
Fred James




More information about the PLUG mailing list