headers
jnrigg | 18 May 2013 09:38
Picon

rounding off number results in Base

I have LibreOffice 4.0.3.3 on a Windows 7 computer.

I have an older database created originally with OpenOffice. The database is
a household inventory including item description, brand name, serial number,
date an item was purchased and its exact cost (among other fields).

I have just noticed that in LibreOffice Base the program is rounding all
costs to $.00). I cannot find a setting that is causing this unwanted
rounding. When I look at the format of any cell that is involved, one item
says that it will accept two digits past the decimal marker (but nothing
mentions rounding off).

I did not change any settings between when I used OpenOffice Base (where it
displayed costs correctly) and when I changed over to LibreOffice Base.

#1 - is this the right forum to ask this question?

#2 - is anybody else having a similar problem?

#3 - is there a setting that I have overlooked that will solve this unwanted
rounding of costs?

Thanks for any answers.

jnrigg

--
View this message in context: http://nabble.documentfoundation.org/rounding-off-number-results-in-Base-tp4056773.html
Sent from the Users mailing list archive at Nabble.com.
(Continue reading)

Permalink | Reply | 1 comment |
headers
Anish Pandey | 18 May 2013 19:17
Picon

Please add this email Id for global subscription list

-- 
Regards,
Anish

--

-- 
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
Permalink | Reply | 0 comments |
headers
Bob Power | 17 May 2013 14:13
Picon
Favicon

problem with this website's security certificate

Hi,
 
Just installed LibreOffice 3.6.6
 
All links to help / submit feedback etc from the app and attempts to access help via links on the LibreOffice
website eg to https://help.libreoffice.org/Writer/Welcome_to_the_Writer_Help
 
yield a warning page indicating an issue with the site's security certificate.
 
I'm using XP and IE 8.
 
 
Bob.

--

-- 
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
Permalink | Reply | 2 comments |
headers
CVAlkan | 17 May 2013 00:29
Picon

Uninstall LibreOffice 4.0.2

Hi:

I uninstalled my 3.6 LibreOffice a few weeks ago when I discovered that the
Ubuntu Software Center had an "official" version of the new 4.0.2. I'm using
a 64 bit version of Ubuntu 12.04 LTS by the way.

I've had a slew of problems with that release and don't have the time to
fool with it, so I uninstalled all of the LibreOffice stuff - again using
the Ubuntu Software Center - in order to try the separately downloaded 4.0.3
version from the Libre Office site.

Everything went well for the first part (the stuff in
LibreOffice_4.0.3_Linux_x86-64_deb.tar.gz). When I attempted the second part
(in the desktop-integration), I got the following message:

~/Downloads/LibreOffice_4/LibreOffice_4.0.3.3_Linux_x86-64_deb/DEBS/desktop-integration$
sudo dpkg -i *.deb
dpkg: regarding libreoffice4.0-debian-menus_4.0.3-3_all.deb containing
libreoffice-debian-menus:
 libreoffice-core conflicts with libreoffice-unbundled
  libreoffice-debian-menus provides libreoffice-unbundled and is to be
installed.
dpkg: error processing libreoffice4.0-debian-menus_4.0.3-3_all.deb
(--install):
 conflicting packages - not installing libreoffice-debian-menus
Errors were encountered while processing:
 libreoffice4.0-debian-menus_4.0.3-3_all.deb

I tried opening libreoffice4.0-debian-menus_4.0.3-3_all.deb in the Ubuntu
Software Center, but got the message "Conflicts with the installed package
(Continue reading)

Permalink | Reply | 6 comments |
headers
marta333 | 16 May 2013 13:55
Picon

inquiry from hungary

Kérem, mondják meg, hogy lehet beállitani a 12-es alapállapotu betüméretet
14es alapállapotra?

l want to know how can l set up the base letter size 12 to base letter
size 14
so that l should not set up the letter size whenver l start a new
document!

Thanks.

--

-- 
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
Permalink | Reply | 1 comment |
headers
Mihamina Rakotomandimby | 16 May 2013 09:11
Gravatar

computer & network pictures

Hi all,

My collegues asked me to draw a network & server topology.
They would like more "sexy" pictucres than rectangles and circles:

Would you have a Drawing template to have nice "computer & network 
pictures"?

Example:
http://www.fr3d.org/blog/wp-content/uploads/2006/10/network-current.png

-- 
RMA.

--

-- 
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
Permalink | Reply | 4 comments |
headers
Brian Barker | 16 May 2013 05:56

Re: LibreOffice Portable Writer changes my custom style?

At 01:03 16/05/2013 +0800, Huxiao Ke wrote:
>I have create a style for paragraph: English font is Times New 
>Roman, font size is 12 pt. And it appears that the current style is 
>my custom style, but when I type some English words, it change to 
>font cajcd-fntaa, font size 13.6 pt. What wrong?

It's difficult to tell without more information.  But note that 
character formatting and character style formatting can each override 
the paragraph style you have applied.  Try this: select the relevant 
text and then go to Format | Default Formatting (or Ctrl+M).  This 
will remove local formatting and should leave you seeing the effects 
of your paragraph style.

Note also that if you type immediately after some text with local 
formatting, that formatting is replicated in the new text.  Local 
formatting can also be remembered even if you delete all the previous text.

I trust this helps.

Brian Barker
Permalink | Reply | 0 comments |
headers
Carl Paulsen | 15 May 2013 22:16
Picon

"Case" function equivalent in Calc

Anyone know if there is an equivalent to the Filemaker Pro "Case" 
function?  It's kinda like the "IF" function but is simpler to 
concatenate multiple conditions.  It basically says If something is true 
then do what is specified, if the next thing is, then do that, if the 
next thing is true, do that, etc.

Here's what I need to do.  Take 4 columns and concatenate with a 
semi-colon between the values, but not string together two semi-colons 
consecutively.  Like:

Phone     Email     Mail -> Phone;Email;Mail
Phone                  Mail -> Phone;Mail
                            Mail -> Mail
               Email    Mail -> Email;Mail

So semi-colons only occur if there's a value present and not at all if 
there's only one value present.
I hope that makes sense and displays correctly.

Carl
-- 

Carl Paulsen

--

-- 
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
(Continue reading)

Permalink | Reply | 10 comments |
headers
Alan Stern | 15 May 2013 21:52
Picon
Favicon

How to unprotect readonly parts of a document?

I'm having trouble with LibreOffice 3.6.  A file I was given contains 
regions that are readonly, and I can't figure out how to unprotect them 
in order to edit them.

The usual advice in the archives is to use the Format -> Sections menu 
option.  That doesn't work here; the Sections line in the Format menu 
is grayed out.  Other advice is to save the file in .odt format and 
then open the result.  That doesn't work either.

Attached to this email is a very short document (in .odt format)
exhibiting the problem.  It's just one line of text saying:

	Normal (9) Normal again.

The "(9)" region shows up in gray and can't be edited.  Can anybody 
help?

Thanks,

Alan Stern
Permalink | Reply | 13 comments |
headers
胡小柯 | 15 May 2013 19:03
Picon

LibreOffice Portable Writer changes my custom style?

hi,
I have create a style for paragraph: English font is Times New Roman,
font size is 12 pt. And it appears that the current style is my custom
style, but when I type some English words, it change to font
cajcd-fntaa, font size 13.6 pt. What wrong?

I'm using LibreOffice Portable 4.0.3.3 on Windows 7.

--

-- 
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
Permalink | Reply | 0 comments |
headers
Steven Friedrich | 15 May 2013 14:24
Picon

I'm looking for a place where I can ask questions about programming Base applications, using LibreBasic and the API.

I'm looking for a place where I can ask questions about programming Base
applications, using LibreBasic and the API.  Is this the right place?

To save a little time, let me explain my question.

I have a Base Form that uses a ListBox based on a SQL query.  When a record
is updated, I want the ListBox to requery.

In Microsoft Access, I just said Requery and I didn't even need to specify
the control.

How do I get a Form to requery in LibreOffice?
Permalink | Reply | 6 comments |

Gmane