Viral, I can't comment on your request with the cursor but got an idea concerning typing numbers
displayed in a png-file into calc.
Did you consider already using an OCR SW to transfer your numbers into a
copy-enabled data form?
On 14.10.2012 15:45, Viral Orpe wrote:
Hi :)
I could not find a better line for SUBJECT, sorry!
Background:
I am copying a few numbers from a website generated .png in to Calc.
These numbers are neither download_able nor copy-paste_able.
They have to be manually seen in web browser and typed in Calc.
I typically tile the browser and Calc windows - manually, yet to find a "tile
windows" option,
(but that is not my query).
I switch between the browser and Calc for every new set of data - say every 2
minutes.
When I am inside the browser window, filling forms to request data or adjusting
the output so all numbers are seen together, the Calc window is obviously
deselected.
However, the Calc cell I was last present in does NOT show any change in
appearance.
It is showing that it is the selected cell but it is ignorant about whether the
application
(Calc) itself is selected or not.
Problem:
When I am done adjusting with browser window, I make a mental note of the number
to be transferred next. The browser window is still the selected window.
I look at the Calc window for putting in numbers. I happen to see the cell (and
not the window),
and just start typing which obviously goes somewhere in dump - the browser
window doesn't take
it and Calc window is not looking at it since it is not selected!
I have been doing this for a fairly looong time and this typing mistake is new
to me.
On some thought I came to this conclusion that these mistakes happen/ have
increased
because the cell keeps on the same look of "being selected" or "ready" to
accept data.
And I am sort of getting cheated every time (almost)!
This is a minor irritant, I agree.
Soon enough thanks to Gimp, LO draw, or Calc charts itself, I would get rid of
this inefficient,
tedious 16th century procedure. In the meanwhile, I am trying to pick-up
"Alt-Tab" habit.
In any case:
Que. Shouldn't along with the Calc application window, the Calc cell somehow
*show*
that it is "not active"
Thanks,
Regards,
Viral Orpe :)
---------------------------------------------------------------------------------------------------
Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz
Memory : 4GB, DDR3
OS : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686)
LibreOffice : LibreOffice 3.4.3 OOO340m1 (Build:302)
---------------------------------------------------------------------------------------------------
________________________________
From: Rolf Lochbühler <rolf.lochbueh...@yahoo.de>
To: "users@global.libreoffice.org" <users@global.libreoffice.org>
Sent: Friday, October 12, 2012 3:44 AM
Subject: Re: [libreoffice-users] function concatenate
Not sure if there's a way to do that with functions. How about this Basic macro?
~~~~~
Option Explicit
Public Function CONCAT( ByRef rng As Variant ) As String
Dim i, k As Long
CONCAT = ""
For i = 1 To UBound( rng(), 1 )
For k = 1 To UBound( rng(), 2 )
CONCAT = CONCAT & rng( i, k )
Next k
Next i
End Function
~~~~~
Call it
- with a column type argument like “= CONCAT(a1:a10)” or
- with a row type argument like “= CONCAT(a1:j1)” or
- with an array type argument like “= CONCAT(a1:b5)”
-rl
Am 2012-10-11 um 22:49 schrieb yahoo-pier_andreit <pier_andr...@yahoo.it>:
is there any way to have concatenate function works like sum??
they are the same function but the first with words the second with numbers
for example
=SUM(a1:a10) sum all the numbers from a1 to a10
=CONCATENATE(a1:a10) should put one after the other the words from a1 to a10
but it doesn't works
how can I have a such behaviour???
of course not =CONCATENATE(a1;a2;a3;a4;a5;a6....) :-)
thnx, :-) pier :-)
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
