Re: Drag and Drop in a Spreadsheet

2017-02-02 Thread John Hart 

On 2/1/2017 6:40 PM, toki wrote:

Another reason people should demand Congress establish a tax credit for
>contributions to Open Source Software.

_The Apache Software Foundation_  is a 501(c)(3) organization, and as
such, donations are tax deductible.
There is a great deal of difference between a tax credit, and a 
deduction. All business expenses are deductible. Companies and 
individuals providing

for the general good of society, need to be compensated if one wants them
to do as well as competitors that don't.


>Without a credit, companies and individuals that donate to OSS, are at a 
disadvantage in the marketplace.

Companies that donate to 501(c)(3) organizations can, and usually do
deduct it, when it comes to paying taxes.

I repeat, deductions and credits are vastly different.



For companies that contribute developers, their costs are no greater
than that organizations whose developers work on closed source software.

True, but competitors can use their work, but they can't use competitors.



jonathon

Re: Drag and Drop in a Spreadsheet

2017-02-01 Thread John Hart 

On 2/1/2017 2:05 PM, Martin Groenescheij wrote:



On 02/02/17 5:23 AM, Alan Pearce wrote:
Thanks to all for your help. Now I understand. I don't know why it 
can't be as easy as Excel.


Well, Microsoft has an army of engineers working on it and charge you 
for the use of their application.
OpenOffice has a couple of volunteers working on it and give you the 
application for free.


Even a simple change requires a lot of time for testing and 
documenting the changes.




Alan.


Another reason people should demand Congress establish a tax credit for 
contributions to Open Source Software. Closed software is dangerous

and poses a risk to society worse than terrorists. Open source software
is in the public interest, and needs to be funded. Without a credit, 
companies and individuals that donate to OSS, are at a disadvantage in

the marketplace. Those that don't pay, can use what they pay for and sell
it for less. OSS is the foundation for Blue ray players, but companies
that build them had no obligation or incentive to compensate people who
did the work. Inventors who want to contribute to the common good starve,
while companies that take advantage of their work get rich.

jrh

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Drag and Drop in a Spreadsheet

2017-02-01 Thread Martin Groenescheij 



On 02/02/17 5:23 AM, Alan Pearce wrote:

Thanks to all for your help. Now I understand. I don't know why it can't be as 
easy as Excel.


Well, Microsoft has an army of engineers working on it and charge you 
for the use of their application.
OpenOffice has a couple of volunteers working on it and give you the 
application for free.


Even a simple change requires a lot of time for testing and documenting 
the changes.





Alan.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Drag and Drop in a Spreadsheet

2017-02-01 Thread Alan Pearce 
Thanks to all for your help. Now I understand. I don't know why it can't be as 
easy as Excel.


Alan.

Re: Drag and Drop in a Spreadsheet

2017-01-31 Thread Dave 
 Original Message  
From: Martin Groenescheij 
To: users@openoffice.apache.org
Date: Tue, 31 Jan 2017 21:40:26 +1100

> On 31/01/17 9:37 PM, Alan Pearce wrote:
>> Something seems to have changed in recent times. I can no longer click
>> on a cell and simply drag the contents to a new cell. If I play around
>> long enough I can sometimes make it work. It has become quicker to cut
>> and paste. Please can someone tell me the correct procedure?
> 
> Step 1: Select the Cell(s)
> Step 2: Left click in on of the cells and drag to wherever you want.
> Step 3: save your work
>>
>> Thanks,
>> Alan.

I might be wrong (very possible), but I suspect Alan is missing the
little trick in step 1. for selecting a single cell which is:
  o Left click and hold down the mouse button inside the cell to be moved.
  o Drag the mouse pointer to an adjacent cell and back to the original
cell before releasing the mouse button.

Easier to do than to describe.

HTH

Dave


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Drag and Drop in a Spreadsheet

2017-01-31 Thread Brian Barker 

At 10:37 31/01/2017 +, Alan Pearce wrote:

Something seems to have changed in recent times.


Possibly not.

I can no longer click on a cell and simply drag the contents to a 
new cell. [...] Please can someone tell me the correct procedure?


You will know that you can do this very easily for a range of more 
than one cell, but the technique does not lend itself to a single 
cell. Note that if you select multiple cells, the range ends up 
highlighted and it is this highlighted range that is moved or copied 
by drag and drop. The problem is that if you click on a single cell, 
you move focus to that cell but do not highlight it. You need to find 
a way to highlight a single cell and your problem will be solved. 
Here are some techniques:


o Click the cell to move focus to it. Shift+click the cell to 
highlight it. Drag and drop.


o Click the cell to move focus to it. Ctrl+click the cell to 
highlight it. Drag and drop.


o Click the cell to move focus to it. Drag the mouse to a 
neighbouring cell until both are highlighted. Without releasing the 
mouse, drag back to the original, single cell - leaving it alone 
highlighted. Release the mouse. Drag and drop.


This last technique sounds complicated but is probably the easiest to use.

I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Drag and Drop in a Spreadsheet

2017-01-31 Thread Martin Groenescheij 



On 31/01/17 9:37 PM, Alan Pearce wrote:

Something seems to have changed in recent times. I can no longer click on a 
cell and simply drag the contents to a new cell. If I play around long enough I 
can sometimes make it work. It has become quicker to cut and paste. Please can 
someone tell me the correct procedure?


Step 1: Select the Cell(s)
Step 2: Left click in on of the cells and drag to wherever you want.
Step 3: save your work


Thanks,
Alan.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Drag and Drop in a Spreadsheet

2017-01-31 Thread Alan Pearce 
Something seems to have changed in recent times. I can no longer click on a 
cell and simply drag the contents to a new cell. If I play around long enough I 
can sometimes make it work. It has become quicker to cut and paste. Please can 
someone tell me the correct procedure?

Thanks,
Alan.