Re: [libreoffice-users] Re: Upgrade Problem on Windows

nd. I now have about 2.5GB available on C:. I'm still interested in this issue even though there is no longer a _critical_ problem. -- Jim -Original Message- From: Urmas To: users@global.libreoffice.org Sent: Tue, 29 Apr 2014 17:52 Subject: [libreoffice-users] Re: Upgrade Problem

Re: [libreoffice-users] Upgrade Problem on Windows

Yes -- Jim -Original Message- From: Florian Reisinger To: James E Lang , users@global.libreoffice.org Cc: users@global.libreoffice.org Sent: Tue, 29 Apr 2014 1:44 Subject: Re: [libreoffice-users] Upgrade Problem on Windows Hi, Also with additional parameter "/a"? -- L

Re: [libreoffice-users] Upgrade Problem on Windows

Yes -- Jim -Original Message- From: James E Lang To: users@global.libreoffice.org, Florian Reisinger Cc: users@global.libreoffice.org Sent: Tue, 29 Apr 2014 1:45 Subject: Re: [libreoffice-users] Upgrade Problem on Windows Yes -- Jim -Original Message- From: Florian

Re: [libreoffice-users] Upgrade Problem on Windows

email. -Original Message- From: Florian Reisinger To: LO Users , James E Lang Sent: Tue, 29 Apr 2014 1:32 Subject: Re: [libreoffice-users] Upgrade Problem on Windows Hi "Msiexec“ Sorry for the typo -- Liebe Grüße, / Yours, Florian Reisinger On 29. April 2014 10:27:14 MESZ, Ja

Re: [libreoffice-users] Upgrade Problem on Windows

Okay. I guess that should have been msiexec. It yields the same problem. It requires 422MB on C: -- Jim -Original Message- From: James E Lang To: users@global.libreoffice.org Cc: users@global.libreoffice.org Sent: Tue, 29 Apr 2014 1:27 Subject: Re: [libreoffice-users] Upgrade Problem

Re: [libreoffice-users] Upgrade Problem on Windows

'msciexec' is not recognized … -- Jim -Original Message- From: Regina Henschel To: users@global.libreoffice.org Sent: Mon, 28 Apr 2014 13:14 Subject: Re: [libreoffice-users] Upgrade Problem on Windows Hi James, James E Lang schrieb: > Hi Florian. > > -Origina

Re: [libreoffice-users] Upgrade Problem on Windows

away steeply. It's that final 20% that make a machine really kinda painful. Is it possible to resize the partitions? Regards from Tom :) On 28 April 2014 17:49, Tanstaafl wrote: > On 4/27/2014 2:39 PM, James E Lang wrote: > >> Volume, Size, Available, Needed >>

Re: [libreoffice-users] Upgrade Problem on Windows

Hi Florian. -Original Message- From: Florian Reisinger To: LO Users , James E Lang , Regina Henschel Sent: Mon, 28 Apr 2014 8:23 Subject: Re: [libreoffice-users] Upgrade Problem on Windows Hi, What I can imagine is the following: Some C++ redistributables. Please try a parallel

Re: [libreoffice-users] Upgrade Problem on Windows

ffice-users] Upgrade Problem on Windows Hi James, James E Lang schrieb: > 4.0.4.2 -> 4.1.5.3 > > After performing a cleanup on the volume there is only 207MB > available on C: on a Windows XP system on which I'm working. After I > specified that LO be installed on v

Re: [libreoffice-users] List-reply issues... again

.org Sent: Mon, 28 Apr 2014 2:38 Subject: Re: [libreoffice-users] List-reply issues... again On 04/28/2014 03:35 AM, Brian Barker wrote: > At 16:05 27/04/2014 -0700, James E. Lang wrote: >> Mailing lists are a way to share comments with a group of people who >> share an interest in

Re: [libreoffice-users] List-reply issues... again

Oops. Pegasus Mail truncated my Reply-To header. We'll see what DroidMail does. -- Jim -Original Message- From: "James E. Lang" To: users@global.libreoffice.org Sent: Sun, 27 Apr 2014 16:05 Subject: Re: [libreoffice-users] List-reply issues... again Paul, One problem

Re: [libreoffice-users] List-reply issues... again

Paul, One problem is that not all mail clients explicitly support your option d (Reply to mailing list). Option c (Reply to sender) is not even explicitly supported by some mail clients. Pegasus Mail (which I am using for this response) has only a single Reply button but using it opens a Reply

[libreoffice-users] test messages -- please disregard

I am simply testing a feature of Pegasus Mail as it pertains to the configuration of this list. I will reply to this message from two different e-mail clients and that will be the end of the test. Please excuse me for cluttering the list with this message. -- Jim -- To unsubscribe e-mail

[libreoffice-users] Upgrade Problem on Windows

4.0.4.2 -> 4.1.5.3 After performing a cleanup on the volume there is only 207MB available on C: on a Windows XP system on which I'm working. After I specified that LO be installed on volume D: the installer still requires 427MB on C:. I hesitate to compress volume C:. Volume, Size, Available,

[libreoffice-users] Conditional Formatting in Calc

How can this be accomplished with LO 4.0.4.2? Cell B1 should be protected UNLESS the leftmost two characters in A1 are "0/" The sheet is protected. A1 is unprotected. B1 is normally protected. I unsuccessfully tried this conditional formatting in B1: Condition: Formula is LEFT(A1,2)="0/" Custo

Re: [libreoffice-users] Why new page style after manual page break changes all pages?

This is an argument that gains nobody anything. The quoted remarks were made in passing and should be left at that. PLEASE! Enough flame wars have been waged over this and we've lost. I surrender. -- Jim -Original Message- From: libreoffice-ml.mbou...@spamgourmet.com To: users@global.

Re: [libreoffice-users] Calc Sum cells based on color

Franco, What do you do to color the cells in the first place? I'm guessing that you use some conditional formatting formula. Just a thought but could you use that same information to derive your sums instead of trying to base it on the colors? Cell formatting is primarily (if not solely) desig

Re: [libreoffice-users] Microsoft Revisits the '80s With MS-DOS, Word for Windows Source Code,

Caution: Simply viewing this code _could_ pollute the products of the open source movement. As I understand their action, MS is not releasing this code to the Public Domain. -- Jim -Original Message- From: Kracked_P_P---webmaster To: LibreO - Users Global Sent: Thu, 03 Apr 2014 8:53

Re: [libreoffice-users] MSO for iPad, big deal or big yawn

As far as I know you must "root" the device to install Ubuntu on it. -- Jim -Original Message- From: Johnny Rosenberg To: "users@global.libreoffice.org" Sent: Thu, 03 Apr 2014 10:58 Subject: Re: [libreoffice-users] MSO for iPad, big deal or big yawn About running Apache OpenOffice or

Re: [libreoffice-users] Microsoft Revisits the '80s With MS-DOS, Word for Windows Source Code,

I'm not sure my first response was received. CAUTION: As I understand what MS has done, the code has NOT been released to the Public Domain. Viewing it could pollute products of the Open Source Software movement. Software -- Jim -Original Message- From: Kracked_P_P---webmaster To:

Re: [libreoffice-users] Re: MSO for iPad, big deal or big yawn

I'm using a mail client that doesn't differentiate between top level quotes and interleaved comments so my comments are in brackets [like this]. I mark snips like this: >8. Editorial comment: I _hate_ having to edit addressing in order to post a reply to a mailing list! :-< -Origi

Re: [libreoffice-users] Errors in LO 4.1 but not in LO 3.5

Oh dear! So let me get this straight. Old macros might not work with newer versions of LO. I realize that backward compatibility leads to "bloat" when carried to the extreme but shouldn't the older specification be deprecated but still supported through two major versions (e.g. version 3.x spe

Re: [libreoffice-users] Master Documents, Office Suites, and the Underwood

Hi, Tom and others. I am finding this discussion to be intellectually stimulating though I have no idea as to the mechanics involved in developing or using master documents. What you write about saving time is most likely very true. However I have probably never written a document with more th

Re: [libreoffice-users] Calc: Automatically sizing cells vertically to fit contents

Have you tried Alt+O, R, O which sets row height to fit the content. I think it continues to fit increased needs such as added lines as well as larger font size. On March 16, 2014 11:57:44 PM PDT, Brian Barker wrote: > At 14:39 17/03/2014 +1100, Hedley Finger wrote: > >On 17/03/2014 1:43 PM, S

Re: [libreoffice-users] Question about LibreOffice Calc 4.2.1 and MS Excel workbook

I think Calc defaults to zoom of 60% when the View mode is Page instead of Normal. On March 8, 2014 6:38:23 PM PST, Tom Williams wrote: > On 03/08/2014 06:15 PM, Brian Barker wrote: > > At 17:18 08/03/2014 -0800, Tom Williams wrote: > >> A friend of mine has LibreOffice 4.2.1 installed alongside

[libreoffice-users] Calc bug query

I have not seen the latest LO versions but the last version I tested this on failed my test. The problem is that cells that contain or are dependent on cells that contain the function call CELL("filename") do not get recalculated automatically based on performance of "Save as …" even though tha

[libreoffice-users] Re: Thank you all for your help with AndrOpenOffice!

FYI: An update with swipe and pinch gestures was released this week. On February 28, 2014 6:39:08 PM PST, Jeffrey Deutsch wrote: > Hello, > > Two months ago -- right after last Christmas -- I asked what you > thought > about AndrOpenOffice, and got some enlightening information. > > Thank you

Re: [libreoffice-users] Re: Defending ODF against OOXML in the UK

On February 26, 2014 7:37:15 AM PST, James Knott wrote: > Gordon Burgess-Parker wrote: > > On Wed, 2014-02-26 at 10:08 -0500, James Knott wrote: > > > >> https://play.google.com/store/apps/details?id=com.andropenoffice > >> > > That doesn't work on my Kindle - tried it and kept getting an error

Re: [libreoffice-users] How to Make postcards

Sir or Ma'am: The biggest problem that I've seen with creating amateur radio QSL cards is getting the printer to feed the card stock. The dimensions are typically too small for the paper tray and the thickness is too heavy for the paper path. Your task might well experience the same issues. Of

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

On February 25, 2014 1:57:49 PM PST, Alan B wrote: > On Tue, Feb 25, 2014 at 1:45 PM, Paul D. Mirowsky > wrote: > > > Please download and install > > > > http://extensions.libreoffice.org/extension-center/numbertext-1 > > > > Very nice. I've installed it. > > If I could change the extension (m

[libreoffice-users] WEEKNUM_ADD(;2)

I am not literate with regard to Excel. I understand that WEEKNUM_ADD() in Calc returns the same value as WEEKNUM() does in the non standards compliant Excel. Under what condition does that value differ from what WEEKNUM() returns in Calc? My .ods file includes calls to WEEKNUM() but the file n

Re: [libreoffice-users] Inserting a row does not change formula

I realize this thread is a little long in the tooth by now but one aspect (why?) of Mr Byrnes query is still dangling. On January 12, 2014 12:57:16 PM PST, Jim Byrnes wrote: >Running LO 3.5.7.2 on Ubuntu 12.04 > >If I have cells: > >A1 = 2 >A2 = 2 >A3 = 2 >A4 = =SUM(A1:A3) which equ

Re: [libreoffice-users] All of the messages in Nabble are suddenly going into the "AndrOpen Office" thread!

Well said, Mark. One more comment inserted below. On February 7, 2014 12:09:58 PM PST, Mark Bourne wrote: > >I don't know if it's the case here, but people do sometimes reply to an >existing email to the list and just change the subject line (presumably >to save looking up the address for the

Re: [libreoffice-users] Review of AndrOpen Office

? (Rhetoric question) In any case I do find AnOo (as you called it) to be usable if attention is paid to its quirks. -- Jim On February 7, 2014 10:53:35 AM PST, Toki wrote: >On 2/6/2014 4:12 AM, James E Lang wrote: > >>AOO1.x implements all the modules (Text Document, Spreadsheet, &

Re: [libreoffice-users] Re: low traffic lately?

Ouch! Who would-a thought my simple apology would start this firestorm? -- Jim Then, would you please consider the pros vs. cons of this list as well as all the users of this list who are seeking help then offering help. Here are more logical steps of top-posting vs. bot

[libreoffice-users] Review of AndrOpen Office (was: Re: What do you think of AndrOpenOffice?)

There is ambiguity in abbreviating AndrOpen Office and Apache OpenOffice since they are both referred to as AOO. I'll use AOO1.x to the former and the customary AOO for the latter. AOO1.x is based on v3.4 of AOO. It's the most usable OOo derivative that I've found for Android tablets or smart ph

[libreoffice-users] OOo derivatives on Android

In the FWIW category: In the past week I have discovered AndrOpen Office which is a fork of Apache OpenOffice 3.4. Though it has some significant issues, it is at present a more usable app than LibreOffice for Android. I use the spreadsheet feature (Calc) of office suites about 95% but AndrOpe

[libreoffice-users] Re: low traffic lately?

This is top posted. I apologize but it seems appropriate in this case. A blind copy (to prevent Reply All from including the address) of this is also going to the list's postmaster. I'm a 75 year youngster. Over the last few months I've taken to reading and responding to eMail via K-9 Mail on m

Re: [libreoffice-users] low traffic lately?

-- Jim Tom Davies wrote: >Hi :) >Does anyone else feel we have had very low traffic over the last few >weeks? yet many answers going unanswered? Is this a result of having to "reply all" to get the answer automatically sent to the list? I have been led to believe that "reply all" should b

Re: [libreoffice-users] Calc: Inline Formatting

I apologize for the redundancy if this has already been answered. Try this: ="my text "&text($r$2,"mm/dd/") -- Jim Dave Liesse wrote: >Two simple questions which should be available through Help, but I >haven't been able to find anything. > >1. Is there a way to format content within a

Re: [libreoffice-users] malfunzione

Note to the list admin: You need to put in a "Reply-To:" (maybe it's "Reply To:") header specifying this list so that members who politely use "Reply" will send their replies to the list. Use of "Reply All" is often considered rude netiquette and ought not to be forced on people. === Now

[libreoffice-users] Formatting Errors in Calc

LibreOffice Version: 4.1.3.2 Build ID: 410m0(Build:2) on Kubuntu 13.10 Background: I use KingSoft Office Spreadsheet for Android on my phone because regrettably LibreOffice Calc for Android is not usable. KingSoft uses and saves .xlsx files. From time to time I upload one of these files to my L

Re: [libreoffice-users] cancel lines with the (almost) the same timestamp

Brian Barker wrote: >At 09:26 20/01/2014 -0800, Hugo Borrell wrote: >>I download big raw data containing that is supposed to show minute >>per minute quotation of an index (SP500). The problem is that some >>quotations have been included twice in the same minute (at some >>seconds of distan

Re: [libreoffice-users] Re: Recalc cell("filename") [partially solved]

not done similar things given that I subscribe >to both mailing lists. > > > > >On 01/15/2014 12:56 AM, James E Lang wrote: >> Related bug report: AOO Bug 68188 >> > >-- >Andrew Pitonyak >My Macro Document: http://www.pitonyak.org/AndrewMacro.odt >Info: htt

Re: [libreoffice-users] Editing Custom Styles in Calc

Brian Barker wrote: >Perhaps explain what you tried, what you expected to happen, and what >actually happened? Otherwise, anyone can only guess. Okay, here goes in painful detail. I wanted several custom styles to highlight values in a range that could be considered to be outliers relati

[libreoffice-users] Editing Custom Styles in Calc

I use custom styles in Conditional Formatting. For example, I highlight cells that contain values that are more than 2.5 standard deviations on either side of the mean value of the data. I am unable to delete styles that I no longer need or to change their characteristics (e.g. background color

[libreoffice-users] Re: Recalc cell("filename") [partially solved]

CTL+SHIFT+F9 does work. It would be nice if Save If … were sufficient -- Jim James E Lang wrote: >After performing "Save As ..." in Calc, a cell that contains >CELL("filename") is not recalculated. Pressing F9 does not do anything >to the cell either. >

[libreoffice-users] Re: Recalc cell("filename") [partially solved]

Related bug report: AOO Bug 68188 -- Jim James E Lang wrote: >CTL+SHIFT+F9 does work. It would be nice if Save If … were sufficient > >-- >Jim > > >James E Lang wrote: >>After performing "Save As ..." in Calc, a cell that contains >>CELL("file

[libreoffice-users] Recalc cell("filename")

After performing "Save As ..." in Calc, a cell that contains CELL("filename") is not recalculated. Pressing F9 does not do anything to the cell either. Any suggestions? LO 4.1.3.2 Kubuntu 13.10 -- Jim -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www

[libreoffice-users] Calc Function

Please fill in the blank ("___") below with a function name or tell me there is no such function: SUM(range) is to SUMIF(range1,criteria,range2) as COUNT(range) is to ___(range1,criteria,range2) COUNTIF would seem to be the logical answer but I don't think it supports the third parameter and t

Re: [libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF...

This has been a most enlightening discussion. I am a big fan of open source software. That said, this discussion has shined a bright light on one of the most problematic areas of the concept. I might be totally off base here but as I view it, without a central management structure to _enforce_

[libreoffice-users] Platform Support

Are there any plans to implement Calc for Android? I would abandon Kingsoft Spreadsheet on my Android 4.1 phone in a heartbeat if Calc were available for this platform. -- Jim -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/

Re: Formats & failed marketing, was: Fwd: Cost of MS Office relative to LO, was: Fwd: [libreoffice-users] Re: moving to new version of MS Office

-->8=== >>> Le Sat, 30 Nov 2013 09:22:32 +, >>> Tom Davies a écrit : >>> Hi :) My thought is that we need to promote 1. LibreOffice first 2. other programs that can use the format as their native format 3. the format 4. the community 5. the

Re: [libreoffice-users] Database Design

thoughtful responses. -- Jim James E Lang wrote (with major snips applied): >I have no experience designing a database. > >My son delivers a variety of newspapers … -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mai

[libreoffice-users] Database Design

I have no experience designing a database. I hope this list is a satisfactory forum for my questions. My son delivers a variety of newspapers with some subscribers getting more than one publication and with each publication's deliveries varied according to the day of the week. I want to constr

Re: [libreoffice-users] Re: CALC convert text to numbers

I've been following this debate with great interest. One big question comes to mind: Why would someone use the apostrophe construct in the first place if he intended to perform arithmetic calculations using the cell content? I understand ending up with a text string rather than a number by for

Re: [libreoffice-users] Re: Engaging users: initial results of the survey

Ken Springer wrote:. > >On 11/10/13 9:11 PM, Ady wrote: >> >> There are many ways for users to communicate: LibreOffice forum, Ask >> LibreOffice, several LibreOffice mailing lists, Nabble, wiki, >> Bugzilla, and several irc channels. The problem is, IMHO, they are >> sometimes "too many" and "t

Re: [libreoffice-users] countif() problem in calc

ction. --On Wednesday, May 29, 2013 08:49:23 PM -0700 "James E. Lang" wrote: I am having a problem with a formula in Calc. The formula includes a call to function COUNTIF() which is miscounting in one case. The problem appears to be very sensitive to the data value in cell K3 as sho

[libreoffice-users] countif() problem in calc

I am having a problem with a formula in Calc. The formula includes a call to function COUNTIF() which is miscounting in one case. The problem appears to be very sensitive to the data value in cell K3 as shown below. Cell E3 contains the value 49.14 Cell F3 contains the value 54.14 Cell I3 conta

[libreoffice-users] Re: Installing multiple versions of LibreOffice

Correction: Make 1) read, "Install LibreOffice 4.0.x in a different directory than the one that contains LibreOffice 3.6.x." --On Monday, March 18, 2013 17:27 -0700 "James E. Lang" wrote: I am currently using LibreOffice 3.6.x on my Kubuntu 12.10 Linux system. I wan

[libreoffice-users] Installing multiple versions of LibreOffice

I am currently using LibreOffice 3.6.x on my Kubuntu 12.10 Linux system. I want to experiment with LibreOffice 4.0.x without putting my production spreadsheets in jeopardy. I have been told by a member of our local Linux Users Group that I need to do two things in order to accomplish this.

Re: [libreoffice-users] Permissions issue with Libreoffice3.5 on Fedora 16?

(Top posting because my response is general -- signature at end) I use Ubuntu rather than Fedora but your problem sounds to me like an issue with permissions to access some file since things work with sudo and not without sudo. I would search the computer for "RANDR" for starters. I don't know

[libreoffice-users] Sheet Protection in Calc

I need help finding the programatic technique to access a new LibreOffice Calc feature. LibreOffice Calc has a feature that is absent in OpenOffice.org relating to protection within a sheet. Try Alt+T, P, S on an unprotected sheet. You will see a box where you can check "Protect this sheet and

Re: [libreoffice-users] Conditions

--On Sunday, March 18, 2012 22:11 +0100 Jean-Francois Nifenecker wrote: You need double quotes and I guess parenthesis can help as weel, that is: (NOT Country=="") OR (Country=="Scotland") equivalent to (Country<>"") AND (Country<>"Scotland") These two are not logically equivalent. I thin

[libreoffice-users] Protection in Calc

LO 3.4.4 Kubuntu 11.10 Two issues (and the second is the big one as far as I am concerned): 1) Tools --> Protect Document --> Document (Alt+T,P,D) when the Document is unprotected does not appear to protect anything. This appears to be a long standing issue that has been noted by others -- mos

[libreoffice-users] Delayed Execution of a Formula in Calc

I am using LibreOffice 3.4.4 on Kubuntu 11.10. I think my problem may be with an attempt by LO (and most likely with OOo as well) to optimize processing by immediately recalculating only those cells that are on the currently active sheet or those on other sheets that are _known_ to cause chang

Re: [libreoffice-users] Re: Windows for SUSE?

--On Thursday, February 23, 2012 10:42 -0500 Steven Shelton wrote: On 2/23/2012 9:36 AM, Pedro wrote: "LibreOffice for Windows" from SUSE not "Windows from SUSE" :) It seems to be a Windows only version optimized for Intel CPUs and for Okay. For a minute, I thought I had missed something b

Re: [libreoffice-users] Top posting

I hesitate to add to this thread which is already bloated. However ... --On Wednesday, February 22, 2012 20:43 +0100 Stefan Weigel wrote: --->8=== Am 22.02.2012 20:19, schrieb Tom Davies: Is our main aim here to change the way people post or is it to help people move to LibreOffic

Re: [libreoffice-users] "Tips" and "Extended Tips"

--On Friday, December 16, 2011 10:51 -0800 "James E. Lang" wrote: I have been having a problem with the Tips and Extended Tips in Calc for some time now. I believe the problem started when I upgraded my Kubuntu distribution to 11.10 (just in case that helps to identify the problem).

[libreoffice-users] "Tips" and "Extended Tips"

I have been having a problem with the Tips and Extended Tips in Calc for some time now. I believe the problem started when I upgraded my Kubuntu distribution to 11.10 (just in case that helps to identify the problem). My problem is that I cannot read them since the forground color (black?) and

[libreoffice-users] OT: Error in list headers

The list headers include this line: List-Unsubscribe: Instead of "+help" it should be "+unsubscribe" -- Jim --On Monday, May 30, 2011 01:32:19 PM -0400 Richard wrote: I have tried many, many times to unsubscribe with NO SUCCESS. PLEASE give me an email, l

Re: [libreoffice-users] Re: Printing with LO 3.3.1

Just to add another data point: --On Wednesday, March 09, 2011 08:11:15 PM -0800 NoOp wrote: On 03/09/2011 08:11 AM, Colin J. Williams wrote: With OOo it was possible to print double-sided on a Brother HL 760 printer. I use a Lexmark C534dn. This is no longer possible with libreoffice.

<    1   2