[libreoffice-users] How to set defaults in form controls
Hi, I can't seem to find where in Libreoffice Writer I can set defaults for the font etc. in form controls. I set my default font for new documents to Arial 11, but when I insert a form control the font there is always Liberation Sans, Regular, 12. I searched the web for quite some time, but the only "solutions" were to change it afterwards by selecting all the form controls and change it then. Where can I set the default for the font and other properties? Thanks Thomas -- 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] Re: copying down references to other cells turns text to UPPERCASE
Am 01.06.2016 um 14:08 schrieb m.a.riosv: > I can't reproduce with Version: 5.2.0.0.alpha1+ > > But as it happens from row 100 looks as an OpenCL issue, please test > disabling it: > > Menu/Tools/Options/LibreOffice/OpenCL > > The number 100 is set up in: > Menu/Tools/Options/LibreOffice calc/Formula - Custom Hi Miguel, you're spot on. If I increase the number to 200, it happens from A200 onwards. But I haven't found a way to disable OpenCL. If I un-tick the checkbox, it uses the last set value. So the workaround would be to set it to a very high number. -- 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] Re: copying down references to other cells turns text to UPPERCASE
Am 31.05.2016 um 23:23 schrieb Steve Edmonds: > I have also tried entering "cat" into Sheet1.A1:Sheet1.A120 and dragging > sheet2.A1 down so that the references increment (=Sheet1.A1 =Sheet1.A2 > =Sheet1.A3 etc.) That's what I meant with "copying down", clicking the lower right corner of cell Sheet2.A1 and dragging it down to A100 or further. -- 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] copying down references to other cells turns text to UPPERCASE
Hi list, I found an annoying bug (or is it a feature?) in Calc. When I create a new document in calc and fill column A in Sheet1 with text. Now I add Sheet2 and put "=Sheet1.A1" in cell A1 of Sheet2. Everything behaves as expected so far. If I copy down A1 in Sheet2 up to A99 everything is fine too, but if I copy it down until A100 or more everything turns UPPERCASE and I cannot change it. I'm using LO 5.1.3.2 at the moment, but I observed this behavior in earlier versions too. Am I doing something wrong or is this really a bug? Thanks Thomas -- 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] "RebootYesNo=No" in silent installation not working anymore
Hi all, I'm just trying to deploy LO 5.1.2 Win x64 in our network and found out that "RebootYesNo=No" doesn't seem to work anymore. According to https://wiki.documentfoundation.org/Deployment_and_Migration it should work, but it reboots after the installation regardless. Very annoying since this is not the only software I install in my script. Or is there another command line switch for it since 5.1? Thanks Thomas -- 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] Re: text alignment broken when re-saving RTF document
On 11/08/15 19:55, Andreas Säger wrote: > ODF is the new RTF and LibreOffice is an ODF suite. > Use the Windows Wordpad to edit RTF. I'd love to use ODF, but the software we're using uses RTF templates, so that people can use it no matter what office suite they're using. We cannot change that. The only thing we can change is using another office suite. > There are too many problems with RTF and lots of bug reports. > >> http://diaryproducts.net/for/geek/microsoft_rtf_specification_nightmare I digged a bit deeper and found out that this bug got introduced between version 4.4.3.2 and 4.4.4.1 Whatever the problems with RTF are, LO should be able to read *its own* RTF documents. You can't blame Microsoft for that. -- 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] Re: text alignment broken when re-saving RTF document
On 11/08/15 19:55, Andreas Säger wrote: > ODF is the new RTF and LibreOffice is an ODF suite. > Use the Windows Wordpad to edit RTF. I'd love to use ODF, but the software we're using uses RTF templates, so that people can use it no matter what office suite they're using. > There are too many problems with RTF and lots of bug reports. > >> http://diaryproducts.net/for/geek/microsoft_rtf_specification_nightmare I digged a bit deeper and found out that this bug got introduced between version 4.4.3.2 and 4.4.4.1 Whatever the problems with RTF are, LO should be able to read *its own* RTF documents. You can't blame Microsoft for that. -- 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] text alignment broken when re-saving RTF document
Hi list, I have problems with the text alignment in LO Writer 5.0.0.5 under Linux and Windows. When I open an RTF document and save it again (with or without making changes) all alignments are lost and everything is aligned to the left. Steps to re-produce: 1. Create new document 2. write "test" in the first line 3. align this line to center or right 4. save as RTF 5. open document again and everything is aligned as it should 6. add more text to the document and save or just "save as" without making changes 7. re-open document and all alignments are gone Is this a known bug and is there a solution to it? I can't use LO 5 like this and have to roll back all installations to 4.3.7. The problem didn't occur in this version. Thanks Thomas -- 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] How to make a document Read-Write ?
Sheafe Ewing wrote: > I have created a Text document file… sent it to a recipient who > notes it is Read-only. > > How do I make the file Read-Write in order that he be able work the file at > his end. I'm sure it has nothing to do with LO and the problem lies with the file permissions in his OS. My guess is that he uses some flavour of Linux and he opens the document from the email. I'm using Ubuntu and when I open a document from an email in Thunderbird, it save an read-only copy in /tmp and LO opens the document from there. Can you ask the recipient to save the document first and open it from this location? -- 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] LibreOffice 'deployment'
Milos Sramek wrote: > Hi, > A friend recently asked me, if it is possible to remotely install and > configure LibreOffice on numerous client machines - so that the admin > does not have to run from one computer to the next to do the job. Is > that possible for LO? I take it that you're using Windows. The Libreoffice setup has a silent install command line switch. I use the following command to "deploy" a newer version > msiexec /qn /i "libreoffice_setup.msi%" SELECT_WORD=1 SELECT_EXCEL=1 > SELECT_POWERPOINT=1 REGISTER_ALL_MSO_TYPES=1 ADDLOCAL=ALL RebootYesNo=No > REMOVE=gm_o_Onlineupdate,gm_o_jf_Palm,gm_o_jf_Pocketpc and put it into the domain login script, so that it gets executed if one particular user with the right permissions to install software logs in. I do this with Remote Desktop on multiple PC at the same time. There are also proper deployment solutions available like OPSI. HTH Thomas -- 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] MONTH() and YEAR() functions behave differently in scalc 3.5.7 and 4.x
Thomas Boehm wrote: > Brian Barker wrote: >> in your case. Your first question should be what happens if you enter >> 10/2013 into an unformatted cell: do you see a date value, perhaps 1 >> October 2013, or do you see the text string you entered? > > I see the text string entered, but the formatting says "Number - General". > >> Note that the date acceptance patterns can now be adjusted at Tools | >> Options... | Language Settings | Languages | Language of | Date >> acceptance patterns. Note also that the ISO format -MM-DD works in >> all locales, so is most reliable. > > When I add ;M/Y nothing changes. Or did you mean, that after this change > if I enter 10/2013 into the cell it should be formatted as date? Then > this doesn't work. Of course I had to replace D/M with M/Y and not just add it. Now it works and "01/10/13" appears when I enter "10/13". -- 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] Re: MONTH() and YEAR() functions behave differently in scalc 3.5.7 and 4.x
Alex Thurgood wrote: > On 07/10/2013 00:58, Thomas Boehm wrote: > Which version of 4.x ? >>From 4.1 onwards, the date/time definitions were reworked. These changes > might be what is causing the difference in behaviour. In many instances, > date/time values are now structs as opposed to string representations, > and perhaps the Calc functions in question rely on that to work correctly. I tried both, 4.0 and 4.1, hence the x. But yesterday I only tried 4.1.2.3 -- 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] MONTH() and YEAR() functions behave differently in scalc 3.5.7 and 4.x
Brian Barker wrote:
> At 21:59 06/10/2013 +0200, Thomas Boehm wrote:
>> =MONTH("10/2013") returns "10" in version 3.5.7, but returns "#VALUE!"
>> in version 4.x. The same applies to YEAR() as well. Is this a known
>> bug/feature or is there maybe something wrong in my settings?
>
> I think this is a feature.
>
> The definition of the MONTH() and YEAR() functions require their single
> argument to be a date value - that is, a numerical value which can be
> formatted as a date. I think in giving them a text argument, you are
> relying on the same interpretation rules being followed to convert your
> text into a date as happens when you type a text string as a date into a
> cell. And those rules changed in version 3.6.2: some formats that
> worked previously no longer do so. This sort of thing is very
> locale-dependent, so I won't try to be definite about what is happening
> in your case. Your first question should be what happens if you enter
> 10/2013 into an unformatted cell: do you see a date value, perhaps 1
> October 2013, or do you see the text string you entered?
I see the text string entered, but the formatting says "Number - General".
> Note that the date acceptance patterns can now be adjusted at Tools |
> Options... | Language Settings | Languages | Language of | Date
> acceptance patterns. Note also that the ISO format -MM-DD works in
> all locales, so is most reliable.
When I add ;M/Y nothing changes. Or did you mean, that after this change
if I enter 10/2013 into the cell it should be formatted as date? Then
this doesn't work.
> It occurs to me that you would never want to use a literal text value as
> in your example: 10 would be a lot easier to type than
> =MONTH("10/2013")! So you must be wanting to refer to the contents of a
> cell or some other expression, of course. In that case, you would
> presumably be best advised ether to store proper (numerical) dates in
> the first place, or else to construct them explicitly from the text
> values you have available instead of relying on the automatic
> interpretation.
Of course my formula is referring to another cell ;-) I changed the
formatting of those cells to Date MM/ and everything works now. I
"only" had to manually remove all those pesky ' from the beginning of
the expression, which appeared after I changed the formatting.
Thanks for your help
Thomas
--
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] MONTH() and YEAR() functions behave differently in scalc 3.5.7 and 4.x
Hi list,
=MONTH("10/2013") returns "10" in version 3.5.7, but returns "#VALUE!"
in version 4.x
The same applies to YEAR() as well.
Is this a known bug/feature or is there maybe something wrong in my
settings?
--
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
