Virgil Arrington | 11 Feb 15:37 2016
Picon

Re: Currency calculations [was: Avery 8167 label printing]

Thanks for the tip, but back in 1989 when this was all happening, I'm 
not sure that my DOS spreadsheet even had the ability to display numbers 
as "currency". I certainly made no attempt to do so, even if it were 
possible. They were just numbers and, yes, integers, and no, the 
spreadsheet didn't get 28 divided by 7 correct.

I have learned, however, as you point out, that how numbers are 
displayed is not the same as what they are. For example, you can't 
"round" a number in a spreadsheet by simply reducing the number of 
decimal places displayed in a cell. The underlying number remains 
unrounded and further calculations with it might produce undesired 
results. When working with currency, I've developed the habit of 
probably overusing the the " <at> round" function at each step of a complex 
calculation just to ensure desired results.

Virgil

On 02/11/2016 04:16 AM, Brian Barker wrote:
> At 15:18 10/02/2016 -0500, Virgil Arrington wrote:
>> About 25 years ago, I was the treasurer of my children's preschool. I 
>> created a spreadsheet to calculate paychecks, and I found that the 
>> paycheck was consistently off by .01 (a penny). It drove me nuts. As 
>> it turned out, one part of the calculation required the division of 
>> 28 by 7, which every third grader knows is 4. Well, my spreadsheet 
>> gave an answer of 3.9999999999_. By itself, it wasn't a big problem, 
>> but later in the chain of operations, the 3.99999_ produced a result 
>> that rounded *down* to the nearest penny instead of *up*, which it 
>> would have done if the 28/7 had resulted in 4 instead of 3.9999. I 
>> complained to a computer friend of mine who tried to explain that the 
>> computer's answer was more "precise" than my mental math of 28/7=4. I 
(Continue reading)

Piet van Oostrum | 11 Feb 08:28 2016

Re: UNSUBSCRIBE

Steve Gifford wrote:

 > PLEASE UNSUBSCRIBE ME
 > 
See the bottom of each message:

To unsubscribe e-mail to: users+unsubscribe <at> global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
--

-- 
Piet van Oostrum <piet <at> vanoostrum.org>
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]

EXU | 11 Feb 00:57 2016
Picon

Simultaneous PDF Export (from a spreadsheet database -- based on validity).

Good day.

Current scenario:
*1. Database.*
I have a spreadsheet (Sheet 1) containing the information

*2. Template (quote form).*
There is a form, with a specific layout that uses:
 a- Validity > Cell Range > First Column from Sheet 1
 b- For the fields (date, description, etc.) the function
=IFERROR(VLOOKUP($B$4,'Sheet1'.A2:E89,*5*,0),0) is inserted (FYI the *5*
changes depending on the column required from Sheet 1-- date is 5)

*3. PDF Export Macro.*
The following macro (inserted in an action button) is used to export to PDF:

/sub ExportPDF
Dim oDescriptor

rem define variables
dim document   as object
dim dispatcher as object

rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
oSheets = ThisComponent.getSheets()
oSheet3 = oSheets.getByIndex(2)

rem name of the file
(Continue reading)

Larry Gusaas | 10 Feb 20:10 2016
Picon

Java broke on LO 5.1 on Macs

LibreOffice 5.1.0 doesn't find the installed Java on my Mac (MacBook Pro Retina, OS X version 
10.11.3). Had to reinstall LibreOffice 5.0.4.

-- 
_________________________________

Larry I. Gusaas
Moose Jaw, Saskatchewan Canada
Website: http://larry-gusaas.com
"An artist is never ahead of his time but most people are far behind theirs." - Edgard Varese

--

-- 
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
Marc Grober | 10 Feb 18:31 2016
Gravatar

Access to character accent menu in Writer on El Cap

A great OSX feature  is the character accent menu available in OSX (you
can set the OS so that holding down a key pops up a menu with special
characters, instead of just endlessly repeating the key).  With the roll
out of ElCap (OSX 10.11.3), Apple made repeating letters the default. 
While one can reset the default to the pop-up accent menu,  this reset
does NOT work in LO (one has to manual enter the Special Character menu).

Is this rejection of the OS setting a 'feature' of LO (5.0.0.5) or a
bug, and in either case is there a way to implement the  OS setting?

--

-- 
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
MENGUAL Jean-Philippe | 10 Feb 18:19 2016
Picon

Calc, Writer, tables

Hi,

I've just noticed that:
1. Open a Calc file
2. Copy or cut the full sheet
3. Paste it in Writer (a blank doc)

On Office (Word), the pasted table from Excel to Word is in editable
form, browseable through keyboard, etc. On LibreOffice, the Calc table
is inserted as an object. Consequently, it seems that I cannot edit it.
More boring, I can't browse it with the caret. It becomes a big a11y issue.

Is it a known thing? Should I report it as a bug, e.g. in a wishlist? Is
there a way to do differently?

Thanks for your feedback,

-- 

Jean-Philippe MENGUAL

HYPRA, progressons ensemble

Tél.: 01 84 73 06 61
Mail: contact <at> hypra.fr

Site Web: http://hypra.fr

--

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

Marion & Noel Lodge | 10 Feb 03:37 2016
Picon

How to use parameters when opening a Database

Hi,

I have an accounting system, AcctsSyst.odb, which I want to use for three
different databases.  Currently I have three Windows Shortcuts on my
desktop, each calling a different .odb.  The .odbs are simply copies of
AcctsSyst.odb, with a different database name hard coded into the
appropriate Basic macro.

I want to use AcctsSyst.odb for all three, and to indicate which database
to open using a parameter in the Windows Shortcut's Target field.
e.g.  "D:\LibreOffice\Databases\AcctsSyst.odb"  --IndiAccts.

Is this possible?  If so, how do I access the parameter, 'IndiAccts', from
the Basic macro that opens the database.  Some sample code would be a great
help.

Thanks,
--
Noel Lodge
lodgemn <at> gmail.com

--

-- 
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
charles meyer | 9 Feb 03:41 2016
Picon

Calc - Sorting - Alphabetically

Hi Folks,

I have all my data in Column A.

I wish to sort alphabetically.

I highlight all the data in every cell in column A, choose Data>Sort
but in the criteria I don't see anything for alphabetically,

How does one sort alphabetically?

Thank you!

--

-- 
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
Pat Brown | 7 Feb 19:51 2016
Picon

Cal file not recovering

I was sending a cal document to be printed but the print never went through
and LO hung. I had to close LO down. When I restarted LO I got the message
that there was a file that needed to be recovered. I instructed to start
recovery but it went into working mode and never came out. It is not a big
file and should not have taken more than a couple of minutes to recover. I
shut down and tried again a couple of times but without success. On
searching for that particular file I found two references. The file is
called "Invoices.ods". I also found "Invoices.ods.lnk" and
".~lock.Invoices.ods#". If I delete these last two will that release the
file for recovery or will I be causing trouble by doing so? Are there any
other options I can try? And if anyone says "go to backups"  I will choke.
I had just made a large number of changes to the file and had not had an
opportunity to do a backup. Hope someone has a solution. Paddy

--

-- 
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
Egbert Eissing | 7 Feb 08:48 2016
Picon

Base - hiding a push button conditionally

 p { margin-bottom: 0.1in; line-height: 120%; }I have the followingArrangement:The main form of the
document is (oForm), and there is a subform (oMangForm).On the subform, thereis a push-button, which I
wish to hide under certain conditions.I have carefullyread all the documents available to me, but I could
not find a clueon how to do that. Hereis a code snipped:
 oDoc =ThisComponent oDrawpage =oDoc.drawpage oForm =oDrawpage.forms.getByName("startMenu")
oComputerNameBox =oForm.getByName("computerName") oMangForm =oForm.getByName("mangForm")
oMangFormLbl =oMangForm.getByName("mangFormLbl") oMangFormLbl.Label= ("Management")
oMangFormSupplBtn =oMangForm.getByName("oMangFormSupplBtn")  REM
Error:com.sun.star.container.NoSuchElement oMangFormSupplBtn.setVisible(false)
My problems are onlythe last 2 lines. I would be veryhappy if someone could get me a hint on how to accomplish
this.Thanks for helpingand regards, Egbert

--

-- 
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
Ken Springer | 6 Feb 21:16 2016

Avery 8167 label printing

Printing is off the mark vertically by about an eighth of an inch 
vertically, lower on the page than correct.

Labels print fine on Avery 8160.

No adjustments of any kind to the template was made.

LO 4.4.7.2

-- 
Ken
Mac OS X 10.8.5
Firefox 44.0
Thunderbird 38.0.1
"My brain is like lightning, a quick flash
      and it's gone!"

--

-- 
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

Gmane