Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

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!

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.

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"

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 <>
To: "" <>
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)”


Am 2012-10-11 um 22:49 schrieb yahoo-pier_andreit <>:

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.