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

[Tom Williams]

On 03/08/2014 06:47 PM, James E Lang wrote:
> I think Calc defaults to zoom of 60% when the View mode is Page instead of 
> Normal.

Thanks!  I'll look into this too!

Peace...

Tom

>
> 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 MS
>> Office
 2010 Starter Edition on his Windows 7 system.  He received an Excel
 spreadsheet via email which he can open just fine in both Excel and
 Calc.   The problem is when he opens the file in Calc, it opens
>> with
 the page zoom set to 60%.  When he opens the file in Excel, it
>> opens
 with page zoom set to 100%.  Because of this, he didn't think he
 could edit the file in Calc since he couldn't read the info.  He
 wasn't aware of the page zoom capability of either application.  :)
>>> Experimentation suggests that the zoom factor in use when the
>> document
>>> file is saved is stored in the document, with the effect that it can
>>> be reopened with the same appearance.  This is the case whether the
>>> document is saved as .xls, .xlsx, or .ods.  Calc appears to respect
>>> the saved zoom factor in each case, but Microsoft Office 2010,
>> whilst
>>> it respects the zoom saved in .xls and .xlsx files, ignores that in
>>> .ods files - even when saved by Microsoft Office itself.
>>>
 Any ideas as to why Calc would open the spreadsheet with a page
>> zoom
 of 60%?
>>> Presumably it was being displayed at a zoom factor of 60% and was
>>> saved as an .ods file.
>>>
>>> I trust this helps.
>>>
>>> Brian Barker
>>>
>>>
>> Thanks for the information.  I'll do some experimentation with the
>> particular file in question and see what happens.
>>
>> Peace...
>>
>> Tom
>>
>> -- 
>> /When we dance, you have a way with me,
>> Stay with me... Sway with me.../
>>
>> -- 
>> To unsubscribe e-mail to: users+unsubscr...@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
>


-- 
/When we dance, you have a way with me,
Stay with me... Sway with me.../

-- 
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] Re: Default Date Format in Libreoffice Calc

[Ralph Navarro]

Changing the text attribute language for the date field in a header or footer 
does NOT change the date format.  If I highlight the date field in the 
header, select text attribute, change the language from English to 
Portuguese, then goto the menu->File->Page Preview, the date still shows 
03/08/2014 when Portuguese uses the European date styles of day-month-year!




-- 
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] LO Base Error: DB Created By Newer Version

[Mark LaPierre]

Hey Y'all,

I'm following directions in GS40-GettingStartedLO Chapter 8.  I created
a new database, and then created the Fuel table per the instructions.

I saved the table and the database, then closed the database.

When I open the database, and click on the Tables icon I get this error:

The connection to the data source "NAME OF DB" could not be established.
The connection could not be established.  The database was created by a
newer version of LibreOffice.

When I click the [More] button on the bottom of the error box I get two
errors listed.

The first says, "The connection to the data source "NAME OF DB" could
not be established."

The second says:
SQL STATUS: HY000

"The connection could not be established.  The database was created by a
newer version of LibreOffice."

No it wasn't!  It was created just a minute ago on the same machine, buy
the same user, with the same version of LO.

I tried erasing and then reinstalling LO and building a whole new
database.  Same result.

I'm using:

LO Base, Version 4.0.4.2 (Build ID: 4.0.4.2-9.el6)
JRE, Sun Microsystems Inc. 1.6.0_30 with accessibility support

CentOS release 6.5 (Final)

Linux mushroom.patch 2.6.32-431.5.1.el6.i686 #1 SMP Tue Feb 11 21:56:33
UTC 2014 i686 i686 i386 GNU/Linux

22:37:28 up 5 days,  1:46,  2 users,  load average: 1.33, 1.17, 1.11

Now the money question.  How do I fix this?

-- 
_
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/


-- 
To unsubscribe e-mail to: users+unsubscr...@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

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

[James E Lang]

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 MS
> Office
> >> 2010 Starter Edition on his Windows 7 system.  He received an Excel
> >> spreadsheet via email which he can open just fine in both Excel and
> >> Calc.   The problem is when he opens the file in Calc, it opens
> with
> >> the page zoom set to 60%.  When he opens the file in Excel, it
> opens
> >> with page zoom set to 100%.  Because of this, he didn't think he
> >> could edit the file in Calc since he couldn't read the info.  He
> >> wasn't aware of the page zoom capability of either application.  :)
> >
> > Experimentation suggests that the zoom factor in use when the
> document
> > file is saved is stored in the document, with the effect that it can
> > be reopened with the same appearance.  This is the case whether the
> > document is saved as .xls, .xlsx, or .ods.  Calc appears to respect
> > the saved zoom factor in each case, but Microsoft Office 2010,
> whilst
> > it respects the zoom saved in .xls and .xlsx files, ignores that in
> > .ods files - even when saved by Microsoft Office itself.
> >
> >> Any ideas as to why Calc would open the spreadsheet with a page
> zoom
> >> of 60%?
> >
> > Presumably it was being displayed at a zoom factor of 60% and was
> > saved as an .ods file.
> >
> > I trust this helps.
> >
> > Brian Barker
> >
> >
> Thanks for the information.  I'll do some experimentation with the
> particular file in question and see what happens.
> 
> Peace...
> 
> Tom
> 
> -- 
> /When we dance, you have a way with me,
> Stay with me... Sway with me.../
> 
> -- 
> To unsubscribe e-mail to: users+unsubscr...@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


-- 
Jim


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Auto-Monthly Donation?

[C. Reis]

Hello Tom,

Tank you for the prompt reply, and my apologies for the delay in 
mine. I will take you advice and talk to the marketing team.


Thank you,
-Cephas

On 03/02/2014 05:57 AM, Tom Davies wrote:

Hi :)
That option i not yet available.  I'm fairly sure it's just because
no-one has even thought about it before.  I've certainly not seen
anyone suggest it in all the discussions i saw about the donations
page.  Perhaps just suggest it to the marketing mailing list and see
if they like the idea.
Regards from
Tom :)



On 1 March 2014 23:27, C. Reis  wrote:

Hello Libre Support,

 I really like Libre Office. I use it on my Windows, Linux and OS X
Boxen. I wish to contribute, but I can't seem to find an option that allows
me to make a donation in a set monthly amount. I guess I'm looking for
something like how WikiPedia is setup (i.e. I can choose to donate a one
time gift or a set monthly amount). I see the options for the one-time
donation, but I don't see any options for a monthly one. Am I missing
something, or is that option not available?

Thank you,
-Cephas

--
To unsubscribe e-mail to: users+unsubscr...@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




--
To unsubscribe e-mail to: users+unsubscr...@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

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

[Tom Williams]

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 MS Office
>> 2010 Starter Edition on his Windows 7 system.  He received an Excel
>> spreadsheet via email which he can open just fine in both Excel and
>> Calc.   The problem is when he opens the file in Calc, it opens with
>> the page zoom set to 60%.  When he opens the file in Excel, it opens
>> with page zoom set to 100%.  Because of this, he didn't think he
>> could edit the file in Calc since he couldn't read the info.  He
>> wasn't aware of the page zoom capability of either application.  :)
>
> Experimentation suggests that the zoom factor in use when the document
> file is saved is stored in the document, with the effect that it can
> be reopened with the same appearance.  This is the case whether the
> document is saved as .xls, .xlsx, or .ods.  Calc appears to respect
> the saved zoom factor in each case, but Microsoft Office 2010, whilst
> it respects the zoom saved in .xls and .xlsx files, ignores that in
> .ods files - even when saved by Microsoft Office itself.
>
>> Any ideas as to why Calc would open the spreadsheet with a page zoom
>> of 60%?
>
> Presumably it was being displayed at a zoom factor of 60% and was
> saved as an .ods file.
>
> I trust this helps.
>
> Brian Barker
>
>
Thanks for the information.  I'll do some experimentation with the
particular file in question and see what happens.

Peace...

Tom

-- 
/When we dance, you have a way with me,
Stay with me... Sway with me.../

-- 
To unsubscribe e-mail to: users+unsubscr...@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

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

[Brian Barker]

At 17:18 08/03/2014 -0800, Tom Williams wrote:
A friend of mine has LibreOffice 4.2.1 installed alongside MS Office 
2010 Starter Edition on his Windows 7 system.  He received an Excel 
spreadsheet via email which he can open just fine in both Excel and 
Calc.   The problem is when he opens the file in Calc, it opens with 
the page zoom set to 60%.  When he opens the file in Excel, it opens 
with page zoom set to 100%.  Because of this, he didn't think he 
could edit the file in Calc since he couldn't read the info.  He 
wasn't aware of the page zoom capability of either application.  :)


Experimentation suggests that the zoom factor in use when the 
document file is saved is stored in the document, with the effect 
that it can be reopened with the same appearance.  This is the case 
whether the document is saved as .xls, .xlsx, or .ods.  Calc appears 
to respect the saved zoom factor in each case, but Microsoft Office 
2010, whilst it respects the zoom saved in .xls and .xlsx files, 
ignores that in .ods files - even when saved by Microsoft Office itself.



Any ideas as to why Calc would open the spreadsheet with a page zoom of 60%?


Presumably it was being displayed at a zoom factor of 60% and was 
saved as an .ods file.


I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@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

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

[Tom Williams]

Hi!  A friend of mine has LibreOffice 4.2.1 installed alongside MS
Office 2010 Starter Edition on his Windows 7 system.  He received an
Excel spreadsheet via email which he can open just fine in both Excel
and Calc.   The problem is when he opens the file in Calc, it opens with
the page zoom set to 60%.  When he opens the file in Excel, it opens
with page zoom set to 100%.  Because of this, he didn't think he could
edit the file in Calc since he couldn't read the info.  He wasn't aware
of the page zoom capability of either application.  :)

Any ideas as to why Calc would open the spreadsheet with a page zoom of 60%?

Thanks in advance!

Peace...

Tom

-- 
/When we dance, you have a way with me,
Stay with me... Sway with me.../

-- 
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] Re: Default Date Format in Libreoffice Calc

[m.a.riosv]

Sorry  Ralph  I confuse the application.

For calc editing the header select the field and the button for change Font,
there you can select the language.

 



--
View this message in context: 
http://nabble.documentfoundation.org/Default-Date-Format-in-Libreoffice-Calc-tp4069171p4100583.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] Re: Default Date Format in Libreoffice Calc

[Ralph Navarro]

Nothing happens when I double click the date field that I added in the 
"Headers and Footers".


-- 
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] Re: Default Date Format in Libreoffice Calc

[m.a.riosv]

Hi Ralph,
double click the field, selecting additional format you can choose the
language for date field.

 



--
View this message in context: 
http://nabble.documentfoundation.org/Default-Date-Format-in-Libreoffice-Calc-tp4069171p4100577.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] Re: Default Date Format in Libreoffice Calc

[Ralph Navarro]

Is the date format for LibreOffice headers and footers locked into the 
originator's locale?  What if you wanted to write a letter or spreadsheet to 
someone in another country and wanted to make the date format in the headers 
and footers match what they use?  

Is it possible to change the date format used in the headers and footers 
without having to reset the originator's system locale?


-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] Careful with Impress in 4.2.1.1: Presentation files may crash 4.1.x

[Tom Davies]

Hi :)
Which format are you saving files in?
Regards from
Tom :)

On 8 March 2014 00:37, Stephan Petersen  wrote:
>
> Hi guys,
>
> it's an unfortunate tradition with Impress that every new version
> contain major screw-ups and showstoppers. I just had a case where a
> presentation that was started with 4.1 (all Win 7 64bit), then edited on
> a another computer with 4.2.1.1, crashes 4.1 on the original computer
> when you try to load it, and only updating LO on the original computer
> to 4.2.1.1 seems to help. Unfortunately I can't provide a sample file at
> this point, but be careful when you upgrade to 4.2.1.1 if you rely on
> Impress files to work on previous versions too.
>
> All the best,
>
> Stephan
>
> --
> To unsubscribe e-mail to: users+unsubscr...@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
>

-- 
To unsubscribe e-mail to: users+unsubscr...@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

Re: [libreoffice-users] What happened to the release notes for 4.2.1?

[Charles-H. Schulz]

Le Sat, 08 Mar 2014 07:09:06 -0500,
William Drago  a écrit :

> All,
> 
> The LibreOffice website looks different and some information 
> is missing that was there last week. In particular I'm 
> looking for the 4.2.1 release notes which used to be here:
> 
> http://www.libreoffice.org/download/release-notes/
> 
> I just noticed that the 4.1.5 release notes are gone too!
> 
> What's going on here?

As you rightly noticed, the website "looks" different.  We have a new
website. What I'm a bit surprized is that when it comes to the release
notes I had added them myself to the staging site. I'll find them back.

Best,

Charles.


> 
> -Bill
> 
> 
> On 3/7/2014 7:42 PM, Stephan Petersen wrote:
> > Hi guys,
> >
> > does anyone know how to set the "default" number of slides per page
> > when printing handouts?
> >
> > LO unfortunately contains a bug (which goes way back and remains
> > unfixed) that causes it to forget what you were printing (notes,
> > handouts, ...) between print jobs. And with the latest version it
> > even got worse. Now, if you want to print handouts, you not only
> > have to select "handouts" every time, but now you also have to pick
> > the number of slides per page again, unless you want the "default",
> > which seems to be 6 (for whatever reason).
> >
> > Does anyone know a workaround for this nuisance?
> >
> > Thanks and all the best,
> >
> > Stephan
> >
> 
> 



-- 
Charles-H. Schulz 
Co-founder, The Document Foundation,
Kurfürstendamm 188, 10707 Berlin
Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts
Legal details: http://www.documentfoundation.org/imprint
Mobile Number: +33 (0)6 98 65 54 24.


-- 
To unsubscribe e-mail to: users+unsubscr...@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

[libreoffice-users] What happened to the release notes for 4.2.1?

[William Drago]

All,

The LibreOffice website looks different and some information 
is missing that was there last week. In particular I'm 
looking for the 4.2.1 release notes which used to be here:


http://www.libreoffice.org/download/release-notes/

I just noticed that the 4.1.5 release notes are gone too!

What's going on here?

-Bill


On 3/7/2014 7:42 PM, Stephan Petersen wrote:

Hi guys,

does anyone know how to set the "default" number of slides per page when
printing handouts?

LO unfortunately contains a bug (which goes way back and remains
unfixed) that causes it to forget what you were printing (notes,
handouts, ...) between print jobs. And with the latest version it even
got worse. Now, if you want to print handouts, you not only have to
select "handouts" every time, but now you also have to pick the number
of slides per page again, unless you want the "default", which seems to
be 6 (for whatever reason).

Does anyone know a workaround for this nuisance?

Thanks and all the best,

Stephan




--
To unsubscribe e-mail to: users+unsubscr...@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