Re: [libreoffice-users] Ambiguous Calc cell status show

Hi :)
I think you are on the right path.  

The programs often give you more and better options if you run it from the command-line.  The cute 
front-end deals with normal typical uses but the command-line tends to have let you access a bit 
more power.  To find out what it can do try (in this case)  

simple-scan --help

That's 2 x - symbols.  Sometimes just -h works, so 

simple-scan -h

Unfortunately it looks like simple-scan doesn't do the whole job you want.  I tried.  Then i just 
opened my package manager, synaptic, and used the search tool to look for ocr and got tons of 
results that looked good.  A few look well worth trying.  Perhaps 
cuniform
gocr
gocr-tk  (to get a front-end for gocr)
ocrad
ocropus  (apparently developed in the mid-90s and used by US Census bureau)  
tesseract-ocr  (alegedly one of the most accurate OpenSource ocr readers.  Originally developed by 
HP)
unpaper  (to prepare scanned images to look smarter and make them easier for ocrs to read) 

I did try a search for "scanner" but got loads about network scanners, ports scan and evena  couple 
of anti-virus scanners to scan Windows machines on the same network and stuff.  


Another path that might be faster to check is to just open the image with Gimp and see if there is 
a text layer so you can copy&paste the number that way.  It seems unlikely but it could lead to 
something if it does work.  Does Png allow layers like Gifs do?  

Good luck and regards from
Tom :)  


--- On Sun, 14/10/12, Viral Orpe <viral.orpe@yahoo.com> wrote:

From: Viral Orpe <viral.orpe@yahoo.com>
Subject: Re: [libreoffice-users] Ambiguous Calc cell status show
To: "users@global.libreoffice.org" <users@global.libreoffice.org>
Date: Sunday, 14 October, 2012, 14:48

Hi Dan :)

I could find Simple Scan under "Applications/ Graphics". Thanks, 

It is kind of stuck on the fact that I do not have a scanner. 

Also, couldn't find explicit mention of OCR, but I guess the menu chain 

Document -> Scan -> Text might be doing that.


Seems there is some confusion here or perhaps I am not able to grasp the idea 

/ use Simple Scan.  


I have a .png from a website that rost52 suggested I can pass through OCR 

so that I do not have to manually copy some numbers from it.
Simple Scan does not take .png (or any file) as an input.  (Right?)

I checked under Simple Scan preferences, the source choice doesn't have "file" / "browse" facility.
I have Simple Scan 3.2.1

Am I using simple scan correctly? 
Is there a way to separate the OCR part of Simple Scan application from the scanning part?! 

I mean from the menus itself, not getting down to the code!

 

Thanks for your time,
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: Dan Lewis <elderdanlewis@gmail.com>
To: users@global.libreoffice.org 
Sent: Sunday, October 14, 2012 5:27 PM
Subject: Re: [libreoffice-users] Ambiguous Calc cell status show
 
      Ubuntu has a program called Simple Scan. Very likely your Linux 
version will have a similar OCR.

--Dan

On 10/14/2012 07:00 AM, Viral Orpe wrote:
> Hi :)
>
>
> Ideally, I would like to get rid of the dependency and do all the work, the web-site's
>
> and mine, from raw data to have timely results with better control on various parameters.
>
> However, in the meanwhile I can try your idea.
>
> What are the important softwares for OCR?
> I thought they come bundled only when one purchases some scanner.
>
> My system details are given below.
>
>   
> 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: rost52 <bugquestcontri@online.de>
> To: users@global.libreoffice.org
> Sent: Sunday, October 14, 2012 2:01 PM
> Subject: Re: [libreoffice-users] Ambiguous Calc cell status show
>   
> 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.lochbuehler@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_andreit@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+help@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+help@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+help@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+help@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