fudmer rieley | 24 Jul 19:19 2016
Picon

Re: Where is everyone?

http://truscribe.com/products/

does anyone know if there is an open source product that can perform this on a linux
os.. ?  

next..  

Is there anyone on this list that can support a high volume email server on an 
amazon platform// 

Open source needs to get to cracking on the cad / cam software

bricad is excellent but it does not handle architecture very well.  

it may not take much to develop an architecture front end to bricad 
someone interested to work on this.. 

Also we need a good  math package type program  

the future is in animation.. sensory systems robotics linked to intelligent
cognitive software.. 

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> 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
billschu | 23 Jul 23:50 2016

localc 5.1.4.2 - comment and reference issues

only tested on ods format - preferred over xls,xlsx, etc

spreadsheet with page1 and page2 "spreadpages" both with "View/Freeze rows
and columns set in cell a2

###################### comment issues ############################
with comment in "show" state... cell a1
comment window does not stay on top when you scroll when the comment window
position and/or size is below row 1
suboptimal workaround, increase row 1 height - 

with comment in "hide state"
comment window position and size are gone default postion and size is used
suboptimal workaround - use the enter key to space down the comments  below
the bottom of row 1

what most(IMHO) user want is "show" state size and position maintained in
"hide" state regardless of Freeze position

############################ reference (nternal to one sheet) issues 
if you link =$page1.$A$1 to page2 cell a1 changes to the cell update
immediately but changes to comment content, size or position never to
regardless of global localc general updating setting 

On spreadsheets with only internal links the "Edit/Links" is ghosted.

it would be nice to have a hotkey to update INTERNAL links including row
height, comment window content, position and size

--
(Continue reading)

Girvin Herr | 23 Jul 03:19 2016

Re: Where is everyone?

Bruce,
Thanks for the response.
Yes, I have ask.libreoffice.org bookmarked also.  It is another 
resource.  This forum has benefited me in the past, and I prefer to stay 
with it.  As I said, I have been away for about 2 years and I was not 
sure what had happened to the forum in that time.  I have spent the last 
year off-and-on trying to sign up again through my at&t/yahoo email 
provider, but my subscription requests have been going into a black 
hole.  I never even got the subscription confirmation replies.  I 
suspected the problem was with at&t/yahoo again, similar to 2 years ago, 
so I had a friend, who was not with at&t/yahoo, test the subscription 
process and it worked for him.  That was when I had proof that the 
problem was with at&t/yahoo.  I suspect they are blacklisting this forum 
for whatever reason, but they never told me they were doing it.  I am in 
the process of shutting down my at&t/yahoo email service and, as you can 
see in the header, I am in the process of switching to FastMail.  They 
seem to be working fine.

Thanks again and take care.
Girvin

On 07/22/2016 05:36 PM, Bruce Hohl wrote:
> Girvin,
> There also exists the busier forum ask.libreoffice.org 
> <http://ask.libreoffice.org> but like you I prefer mailing lists ... 
> and this is a good mailing list where questions often receive solid 
> responses.

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> global.libreoffice.org
(Continue reading)

Girvin Herr | 22 Jul 23:04 2016

Fwd: Re: Restoration problem between sessions


Paul,
Thanks for the response.
I checked and this option is already checked by default.  So, it doesn't 
look like that is the problem.  Or are you suggesting I uncheck it and 
see if LO5 comes up automatically at the next session where now it 
doesn't come up at all?
I will try it, but I am not sure how that would affect the rest of my 
desktop.  So, it may not be a long-term solution for me.
Thanks for the suggestion.
Girvin

Hello Girvin

In Xfce, when you click on the logout button on the taskbar there is a 
checkbox "Save session for future logins"...

Would this be a way to solve your problem?

On 7/21/2016 3:37 PM, Girvin Herr wrote:
> Greetings,
>
> I am running Slackware Linux 14.1 (K3.10.17), Xfce 4, and Libreoffice 
> 5.0.6.3 (binary .rpm download from LO website).
>
> I prefer to keep several oft-used LO files open all the time. These 
> files are open when I shut down the session.  When I start the next 
> session, LO will not autoload these files and in fact will not run at 
> all.  When I then start LO5 manually from the desktop icon, these 
> files are opened.  I created a log of the Xfce output from the 
(Continue reading)

Girvin Herr | 22 Jul 22:25 2016

Where is everyone?

Greetings,

I have just re-joined this forum since dropping it 2 years ago due to 
email provider censoring issues.  Back then it was vibrant and I was 
able to get good answers to my LO problems quickly and I was able to 
help others with problems.  Now, since I resubscribed, I saw less than 
10 postings downloaded on my first day, but nothing since.  I posted a 
message yesterday, and it was echoed to me but that is it.  Is this not 
the proper place to post LO user questions?  If not, what is?

Thanks.
Girvin Herr

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> 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
Girvin Herr | 21 Jul 21:37 2016

Restoration problem between sessions

Greetings,

I am running Slackware Linux 14.1 (K3.10.17), Xfce 4, and Libreoffice 
5.0.6.3 (binary .rpm download from LO website).

I prefer to keep several oft-used LO files open all the time. These 
files are open when I shut down the session.  When I start the next 
session, LO will not autoload these files and in fact will not run at 
all.  When I then start LO5 manually from the desktop icon, these files 
are opened.  I created a log of the Xfce output from the startup, which 
included the startup of LO5 and got the following snippet:

...

LibreOffice 5.0.6.3 490fc03b25318460cfc54456516ea2519c11d1aa

Unknown option: --session=2c07016df-92b0-47a4-8398-8d806cdb3d0c

Usage: soffice [options] [documents...]

Options:
--minimized    keep startup bitmap minimized.
--invisible    no startup screen, no default document and no UI.
--norestore    suppress restart/restore after fatal errors.
--quickstart   starts the quickstart service
--nologo       don't show startup screen.
--nolockcheck  don't check for remote instances using the installation
--nodefault    don't start with an empty document
--headless     like invisible but no user interaction at all.
--help/-h/-?   show this message and exit.
(Continue reading)

John R. Sowden | 20 Jul 22:36 2016
Picon

Re: Use of variables in a cell

Thank you very much.  I've got it now.  I thought that a variable was 
placed in the range, and I had to assign a value to that variable.  
Actually is is easier than I thought (often the case). Hope others have 
seen your explanation and have benefited also.

John

On 07/20/2016 11:08 AM, Brian Barker wrote:
> At 10:23 20/07/2016 -0700, John R. Sowden wrote:
>> I think you just introduced another set of questions.
>
> I don't think so ...
>
>> Is the "&" used for macro substitution?
>
> Er, nope: it's the concatenation operator.
>
>> I assume the lowercase n is a shorthand way of defining the variable 
>> type (n=number, s=string, etc.), and not part of the formula?
>
> No: I just used "Xn" to represent the cell that you had referred to 
> but not identified - "at the top of [your] spreadsheet". In your 
> actual formula, this will read A1 or B2 or AP99 or Sheet2.F10 or 
> whatever is the identifier of the cell containing your variable number.
>
>> I went to Help with indirect(), not to much avail. I think I am not 
>> grasping your solution.
>
> Xn contains your variable number. Let's suppose this is 52. The & 
> operator concatenates the string "A1:A" with this, and the number 52 
(Continue reading)

John R. Sowden | 20 Jul 19:23 2016
Picon

Re: Use of variables in a cell

I think you just introduced another set of questions.

Is the "&" used for macro substitution?  If so, how does that fit in?

I assume the lowercase n is a shorthand way of defining the variable 
type (n=number, s=string, etc.), and not part of the formula?

I went to Help with indirect(), not to much avail.  I think I am not 
grasping your solution.  Also, how do I assign the variable value, and, 
in terms of sequential execution, where do I put the assignment so it 
will be executed before the indirect() function?

Is it executed only once? Meaning, if I jump to a cell with my mouse 
(manual), is it possible that the indirect() function will fail because 
the assignment was not reread?  (I am thinking in terms of procedural 
code here (Basic, Pascal, xBase).

John

On 07/20/2016 09:35 AM, Brian Barker wrote:
> At 08:50 20/07/2016 -0700, John R. Sowden wrote:
>> If I have a cell with following formula, can I replace a cell 
>> coordinate, such as the 52 below, with a variable that I can assign 
>> at the top of my spreadsheet?
>> =sum(a1:a52)
>
> Yes:
> =SUM(INDIRECT("A1:A"&Xn))
>
> I trust this helps.
(Continue reading)

John R. Sowden | 20 Jul 17:50 2016
Picon

Use of variables in a cell

If I have a cell with following formula, can I replace a cell 
coordinate, such as the 52 below,  with a variable that I can assign at 
the top of my spreadsheet?

=sum(a1:a52)

Thanks, John

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> 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
Paolo Debortoli | 18 Jul 18:20 2016
Picon

extracting data from uri

Hi.  I am working on a calc sheet and need to insert data from an url:  

https://finance.google.com/finance/info?client=ig&q=NASDAQ%3aAAPL     

I  guess it generates a csv output  (in the browser it is like:  
// [ { "id": "22144" ,"t" : "AAPL" ,"e" : "NASDAQ" ,"l" : "99.92" ,"l_fix" : "99.92" ,"l_cur" : "99.92" ,"s":
"0" ,"ltt":"12:13PM EDT" ,"lt" : "Jul 18, 12:13PM EDT" ,"lt_dts" : "2016-07-18T12:13:44Z" ,"c" :
"+1.14" ,"c_fix" : "1.14" ,"cp" : "1.15" ,"cp_fix" : "1.15" ,"ccol" : "chg" ,"pcls_fix" : "98.78" } ]).   I
would need to isolate the  number with 'l' label and insert it into a cell.

I also tried menu -> link external data -> url;  it opens the page, sees the table, but doesn't show it in the
dialog box (with the checkbox 'update every x seconds'    ....   bug??).

Thanks if you can help.

Paolo

--

-- 
To unsubscribe e-mail to: users+unsubscribe <at> 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
Wade Smart | 15 Jul 14:26 2016
Picon

Re: If value is not present, count it.

Its been pointed out that actually state my problem
making it difficult for people help. Valid point.

I have a spread sheet that tracks jersey inventory.

Column B = Jersey Color
Column C = Number printed on the Jersey
Column D = Jersey Size
Column E = Status of the jersey
     IN, OUT, PO, Replace, ?

Column B: E, 2:160 is the range.

=SUMPRODUCT($E$2:$E$160<>"PO",$B$2:$B$160="Red",$D$2:$D$160="L")

This I would think would show me all Large Red jerseys
that are not PO.

What I want to know is, for each size of jersey in
a certain color, how many do I have that are NOT PO.

I have gone through to make sure any line with PO
is actually "PO" and not " PO", " PO " or "PO ".

As for correctness of each entry, I have been going
back through all entries to make sure "PO" is just that
and not "PO " or " PO" or " PO ". I have found a three
like that.

As you said, it is exclusion of PO in a jersey color and
(Continue reading)


Gmane