[libreoffice-users] Strange pdf printout in Calc vs. Excel

[Valter Mura]

Hi All

I noticed that if I have a Calc file with multiple sheets, even if with 
regular print area defined, if I click the "Print PDF directly" button 
while positioned in a specific sheet, the command prints out *all the 
sheets* I have in the file.


With the same situation in Excel, the printout is *only the sheet* I'm 
positioned.


Can anybody confirm this behaviour?

Thanks, ciao

--
Valter
Open Source is better!
LibreOffice: www.libreoffice.org
KDE: www.kde.org
Kubuntu: www.kubuntu.org
OpenSuse: it.opensuse.org

--
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: I need Autocorrect working in two languages in one document

[Dave Howorth]

On Thu, 13 Oct 2016 11:47:28 +0200
Ricardo  wrote:

> El 2016-10-13 09:33, Robert Großkopf escribió:
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> > 
> > Hi *,
> > 
> > I have tried this:
> > First paragraph defined with German language.
> > Second paragraph defined with Englisch language.
> > 
> > Wrote something in the first paragraph, for example the wrong word
> > "dei", and it was autocorrected to "die". Wrote also "ihs", which is
> > shown as wrong, but isn't autocorrected.
> > 
> > Did the same in the second paragraph. "dei" is shown as wrong, but
> > not autocorrected to anything. "ihs" is autocorrected th "his".
> > 
> > I don't see a problem with autocorrect for two languages in one 
> > document
> 
> Of the five tabs Autocorrect menu offers, only the first two are 
> language sensitive and your test case is from the first one.
> 
> But as stated on the original email, different languages use
> different kind of quotes (fourth tab) and that is not controlled by
> language settings. For example, on English you use "double quotes"
> but on Spanish and Italian «Latin quotes» are the right ones and you
> cannot use both *automatically* on the same document.

No, in English we use single quotes. It is Americans that use double
quotes.

> Word completion (fifth tab) is also problematic on multilingual 
> documents, like shown on the bug report I quoted.
> 
> Regards,
> Ricardo

-- 
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] Strange pdf printout in Calc vs. Excel

[Robert Großkopf]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Valter,

> 
> I noticed that if I have a Calc file with multiple sheets, even if
> with regular print area defined, if I click the "Print PDF
> directly" button while positioned in a specific sheet, the command
> prints out *all the sheets* I have in the file.

Don't know where you get "Print PDF directly".
There is a button "Export as PDF". With this button the whole document
will be exported.
Print > Print to File: Default is selected sheet for this function.
The file will be a *.pdf, too.

Regards

Robert
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJX/+huAAoJELDKYwaoS9AIRLoP/1dABqRe5qWBlse41sWjQjaM
NR18ILTxAox2GRfawAFRt8t9R3pE4HGOopUuQfy9KrK42hLi596wXQc0xozi6RYQ
qADID4qf1FeDxxRufPOtv+g9aLLaBg8I5IGYHO+0jntBVbkHqCQaC96kWYycjoC2
z17wVX/+nbw0d6chSrut9KLh6zhsruZlkGra5jQ3PuRrRUtjtbriDJGOOYq9D8P+
jmOePPre6Y4iARRfp//ccRZnqHDwDmKj1g/i1agExd7rBEkholsKvny5TLqC46Sw
NuFfzmPXo7EqXtnggal8PBsEFac9E6Ti9I78a97wc+mdQv49vp51xiZ4ZSyrmvCE
/21rISrBfA+7u/EktzljEVl495BOBx1MOVV5t3zUf66IrVy/KKA8Zeg+wrAyrxXN
CSqTUzNZoQD013v5wKFVI/Xs1nfPU0u0KU0cdxjjhk+PKnSSCjplOTXWIfonrIWh
mxFONLwWHuR3p+IpvbEOPkc9rXQmJUDUAyevEPqiPfKLCe6XWHXbAJTMgaK3VAi1
cWGlwQUTkp3n70lburjZofrgGiiSoRtBS6+GoAc0OSCr//IKm4gp4YvEnXaNSrkl
G66BYeUel6fDl2SKAt43url5UDPvzpUcumQdS/5T5tXCwZnDs/UTm/ttyMnqwVFu
3ELPxiobUaQ1VLn56vRL
=1Sr8
-END PGP SIGNATURE-

-- 
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] Document protection

[anne-ology]

   You could add a password which should lock the document;
  then when the receiver reads the document, he should be able to
copy it to his machine, make any additions & send back to you;
 then you can make the changes to the table & re-send/upload.

   I don't know the details as to how this would work;
  whenever I upload anything, I always click on 'only those with
the link' can open which keeps prying roving eyes from seeing.

   Hoping this helps to some degree,



From: Ken Springer 
Date: Mon, Oct 10, 2016 at 7:11 PM
Subject: [libreoffice-users] Document protection
To: users@global.libreoffice.org


Windows 7 Ultimate
LO 5.1.5.2

I've created a document with a simple table.  In one column, each cell
contains a fill in field.

I want to protect the entire document from changes *except* the fields.

How can I do this?  I haven't found a way up to now.

Incidentally, the help file for cell protection does not match the program.


-- 
Ken
Mac OS X 10.11.6
Firefox 48.0.1
Thunderbird 45.3.0
"My brain is like lightning, a quick flash
 and it's gone!"

-- 
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] Exporting a PDF file with fill in fields

[anne-ology]

   Click on the menu options ... scroll to 'save as' (if you wish it
saved on your machine)
  or 'send as' ->then your e-program should open ...
 if it doesn't, then open your e-program & either send the document
or the link to the document (if uploaded to one of these 'clouds' for that
purpose) to whomever.



From: Ken Springer 
Date: Mon, Oct 10, 2016 at 7:13 PM
Subject: [libreoffice-users] Exporting a PDF file with fill in fields
To: users@global.libreoffice.org


I've just posted a message about document protection.

After I've got the document protection the way I wish, how do I export that
document as a PDF and retain the ability to have the fill in fields?


-- 
Ken
Mac OS X 10.11.6
Firefox 48.0.1
Thunderbird 45.3.0
"My brain is like lightning, a quick flash
 and it's gone!"

-- 
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 change Writer form letter database connection

[Gary Dale]

On 12/10/16 11:00 AM, Paul D. Mirowsky wrote:

Are the field names identical from original to newer data?

Are you creating new/updated queries?

I'm always switching to new single source databases from boilerplate 
Writer and haven't had a problem. I have not tried multiple sources 
though.


Also beware that while the fields may update to the new data, record> has to be applied manually.  (Seems to be true in most 
versions of LibreOffice).


I'm using a Base database (pasted the data in from a spreadsheet so I 
could run queries that were apparently too complex for simple 
conditional text). The field names haven't changed. If they did, then I 
would expect that I'd have to update the merge document.


When I View | Field Names (ctrl-F9), I not only see the database name 
for both the old database (in the fields that I haven't updated 
manually) and the new database (in the fields that I did re-insert to 
this year's database) but also the name of the query that was used.


This is absurd. The form letter should just contain the name of the 
fields and let the user select which database and/or query they wants to 
use. As it stands, I am apparently required to not only stick with the 
same database but also keep the same query name.


Even the menu item (Field Names) seems to be poorly thought out. 
Toggling it switches the view from just the Field Names to the full 
database, query, Field Names. In both cases I see Field Names. It 
probably should be named "Query Path" - although as I have stated, the 
document shouldn't even use that information.


--
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: Apostrophe prepended to MM/DD/YYYY

[Doug McNutt]

What I have learned:

Most important: Brian is very helpful. Thank you.

Dates are really floating point numbers and the unit is one day. 
Somewhere there must be a way of setting the zero point. 1900, 1904, 
1970 are common. My startup worksheet came from an old, 2001, Apple 
version of Excel and, though I have seen some time values in cy 2020, 
almost all are based on 1904 and show 2016 as the year. Time values 
appear to be rounded so that differences of less than a second get lost 
while sorting. They might be using a 32 bit float.


The format used by US Bank for it's delivery of data as *.csv files 
offers lines like this:


"8/30/2016","DEBIT","DEBIT PURCHASE -VISA OOMAINC 
xxx-xxx-CA","Download from usbank.com. OOMAINC xxx-xxx-CA","-4.2300"


All entries include quote marks and I can't tell if they ever escape 
quotes that are required inside of regions of text. The DEBIT entry is 
often a CREDIT instead. The "-" minus sign is redundant and just means a 
debit.


Getting the download requires use of a browser. I don't think 
Libre_Office has the required security and I don't have time to search 
that way but Firefox will save the bytes in a Linux file where there are 
no provisions for formatting. The calc module will open the file and 
senses the .CSV well enough to read into a spreadsheet format. It 
recognizes the MM/DD/ format and converts the times to the internal 
format used by calc. It also handles the extra zeros in the US$ format. 
There is some white space in front of the xxx items and the xxx's are my 
replacements of decimal digits. I think calc is ignoring them - fine.


I find it convenient to introduce the downloaded information using a 
sheet in the workbook that handles everything else. with the downloaded 
spreadsheet open and the destination open in another screen I can copy a 
bunch of data into columns starting with J.


There are a bunch of details such as identifying column K to see if it 
is a check number and changing a format for that. No big deal and the 
Excel page is adequate except


Copying those MM/DD/ dates into column A and B, where they are 
needed when the new data is entered into the big spreadsheet which 
handles a year of data, can be a pain. The format data for columns A and 
B must be set BEFORE the data is moved over and they don't seem to 
remember that. What works is to fill the destination columns with the 
formula =VALUE(Jx). Somehow that causes calc to recognize the MM/DD/ 
format and convert the integers to an appropriate floating point 
date/time value. If you just use =Jx you get an apostrophe in front of 
the MM/DD item. That's an Excel concept that tells the software to leave 
the data alone. It's useful for specifying long numbers of more that 14 
digits that are found for the likes of part numbers or encoding keys.


The "Format / Number Format / Date" option under the Apple-like menu bar 
is interesting and will let you specify a date format for empty cells 
but it varies between showing a floating point number like 41146 and the 
equivalent 08/26/16. If you don't see what you want try it again.  You 
can add fractional parts to the first format like 41147.25 which moves 
it to 08/27/16 which is limited to the day part. Formatting it as time 
results in "AM".


On this Linux box I like to work with a shell which leads me to a simple 
command to open my spreadsheet. I also noticed the availability of an 
error file. This is a small part of the result. It's mostly warnings but 
those items 34, 36, and 38 are repeated well over 25000(10) times before 
I trimmed them down. I also have zero experience with Java. The machine 
uses Ubuntu and it's current.


Wed Oct 12 14:28:18 EDT 2016
Opening Finance_16.ods with libreoffice --calc
javaldx: Could not find a Java Runtime Environment!
Warning: failed to read path from javaldx
(soffice:27204): Gdk-WARNING **: gdk_window_set_icon_list: icons too large
(soffice:27204): Gdk-WARNING **: gdk_window_set_icon_list: icons too large
(soffice:27204): Gdk-WARNING **: gdk_window_set_icon_list: icons too large
** (soffice:27204): WARNING **: Unknown event notification 38
(soffice:27204): Gdk-WARNING **: gdk_window_set_icon_list: icons too large
** (soffice:27204): WARNING **: Unknown event notification 36
** (soffice:27204): WARNING **: Unknown event notification 34



--
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] Strange pdf printout in Calc vs. Excel

[Bruce Hohl]

@Valter
There is actually an enhancement request related to PDF export in Calc:
https://bugs.documentfoundation.org/show_bug.cgi?id=54052

I agree the default of printing the entire workbook is generally unwelcome.

On Thu, Oct 13, 2016 at 4:02 PM, Robert Großkopf  wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi Valter,
>
> >
> > I noticed that if I have a Calc file with multiple sheets, even if
> > with regular print area defined, if I click the "Print PDF
> > directly" button while positioned in a specific sheet, the command
> > prints out *all the sheets* I have in the file.
>
> Don't know where you get "Print PDF directly".
> There is a button "Export as PDF". With this button the whole document
> will be exported.
> Print > Print to File: Default is selected sheet for this function.
> The file will be a *.pdf, too.
>
> Regards
>
> Robert
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v2
>
> iQIcBAEBAgAGBQJX/+huAAoJELDKYwaoS9AIRLoP/1dABqRe5qWBlse41sWjQjaM
> NR18ILTxAox2GRfawAFRt8t9R3pE4HGOopUuQfy9KrK42hLi596wXQc0xozi6RYQ
> qADID4qf1FeDxxRufPOtv+g9aLLaBg8I5IGYHO+0jntBVbkHqCQaC96kWYycjoC2
> z17wVX/+nbw0d6chSrut9KLh6zhsruZlkGra5jQ3PuRrRUtjtbriDJGOOYq9D8P+
> jmOePPre6Y4iARRfp//ccRZnqHDwDmKj1g/i1agExd7rBEkholsKvny5TLqC46Sw
> NuFfzmPXo7EqXtnggal8PBsEFac9E6Ti9I78a97wc+mdQv49vp51xiZ4ZSyrmvCE
> /21rISrBfA+7u/EktzljEVl495BOBx1MOVV5t3zUf66IrVy/KKA8Zeg+wrAyrxXN
> CSqTUzNZoQD013v5wKFVI/Xs1nfPU0u0KU0cdxjjhk+PKnSSCjplOTXWIfonrIWh
> mxFONLwWHuR3p+IpvbEOPkc9rXQmJUDUAyevEPqiPfKLCe6XWHXbAJTMgaK3VAi1
> cWGlwQUTkp3n70lburjZofrgGiiSoRtBS6+GoAc0OSCr//IKm4gp4YvEnXaNSrkl
> G66BYeUel6fDl2SKAt43url5UDPvzpUcumQdS/5T5tXCwZnDs/UTm/ttyMnqwVFu
> 3ELPxiobUaQ1VLn56vRL
> =1Sr8
> -END PGP SIGNATURE-
>
> --
> 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] Re: I need Autocorrect working in two languages in one document

[Robert Großkopf]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi *,

I have tried this:
First paragraph defined with German language.
Second paragraph defined with Englisch language.

Wrote something in the first paragraph, for example the wrong word
"dei", and it was autocorrected to "die". Wrote also "ihs", which is
shown as wrong, but isn't autocorrected.

Did the same in the second paragraph. "dei" is shown as wrong, but not
autocorrected to anything. "ihs" is autocorrected th "his".

I don't see a problem with autocorrect for two languages in one document
.

Regards

Robert
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJX/zjhAAoJELDKYwaoS9AIElAQAJ2KxMuacY4hSbQszUzUXjjG
70BMUCYmAqEQqKnZ3IQRpi6M1E4jtHHDkaLL/T2QVsRZOZ+CyeZLFrThCV+co0uU
WUbIUr7wbSbNgUahymBzLzNbQ4euPg8rbs3TWNyfSya387pkCWBp4J0dVzpc9zQp
VBQYPtlg/fpktgvgttvZSbLpmcsjlYlUy3u4LJ2BKVeLTRsrSzxZ3bGKMdFg2Qcr
4rb63iKpM9LIXHUQdAZT7iGqAy336Ct52AcZn9WbAKiemayO/r/t/qTwQ0XMMNzz
Ym71Hwil9vwKySR1Q67pVMK0ptWMAqrF3rzAe5iwTOyw74XoHEpS2g2we6zLa2Ux
ZvBg1iYc7eWfrHvEzK7DKwoLc/FWMHlibxM/f3YExCbGsWCWG6az9/fFBmjWoOQv
ma43YiuVLSHsUwSejb002gsnqSX/cIZrdx3K9DY+CaFysznAhMH9H/r7ulPzznka
4Lq4AFJCAKGOqRI4y2vN1eubWUycFtS1oEur1J5YId2FQWRrez/UsvzAXwUWjmVi
ZQMK+iw9wQA+dNMVYcxM3ufFpMhKYiHzOZ1vtOgQSX/3XnYz/6wGs3J7Pt0fS8D4
RJKALq0sGGhXdgmU/9sAiL6AFH19WEyg9OD8GQXrgPYHCpEoMk8F/zjIi2F5R/3u
PnBmqWx0D6zVnR2j3NI6
=dU1B
-END PGP SIGNATURE-

-- 
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: I need Autocorrect working in two languages in one document

[Ricardo]

El 2016-10-13 09:33, Robert Großkopf escribió:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi *,

I have tried this:
First paragraph defined with German language.
Second paragraph defined with Englisch language.

Wrote something in the first paragraph, for example the wrong word
"dei", and it was autocorrected to "die". Wrote also "ihs", which is
shown as wrong, but isn't autocorrected.

Did the same in the second paragraph. "dei" is shown as wrong, but not
autocorrected to anything. "ihs" is autocorrected th "his".

I don't see a problem with autocorrect for two languages in one 
document


Of the five tabs Autocorrect menu offers, only the first two are 
language sensitive and your test case is from the first one.


But as stated on the original email, different languages use different 
kind of quotes (fourth tab) and that is not controlled by language 
settings. For example, on English you use "double quotes" but on Spanish 
and Italian «Latin quotes» are the right ones and you cannot use both 
*automatically* on the same document.


Word completion (fifth tab) is also problematic on multilingual 
documents, like shown on the bug report I quoted.


Regards,
Ricardo




.

Regards

Robert
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJX/zjhAAoJELDKYwaoS9AIElAQAJ2KxMuacY4hSbQszUzUXjjG
70BMUCYmAqEQqKnZ3IQRpi6M1E4jtHHDkaLL/T2QVsRZOZ+CyeZLFrThCV+co0uU
WUbIUr7wbSbNgUahymBzLzNbQ4euPg8rbs3TWNyfSya387pkCWBp4J0dVzpc9zQp
VBQYPtlg/fpktgvgttvZSbLpmcsjlYlUy3u4LJ2BKVeLTRsrSzxZ3bGKMdFg2Qcr
4rb63iKpM9LIXHUQdAZT7iGqAy336Ct52AcZn9WbAKiemayO/r/t/qTwQ0XMMNzz
Ym71Hwil9vwKySR1Q67pVMK0ptWMAqrF3rzAe5iwTOyw74XoHEpS2g2we6zLa2Ux
ZvBg1iYc7eWfrHvEzK7DKwoLc/FWMHlibxM/f3YExCbGsWCWG6az9/fFBmjWoOQv
ma43YiuVLSHsUwSejb002gsnqSX/cIZrdx3K9DY+CaFysznAhMH9H/r7ulPzznka
4Lq4AFJCAKGOqRI4y2vN1eubWUycFtS1oEur1J5YId2FQWRrez/UsvzAXwUWjmVi
ZQMK+iw9wQA+dNMVYcxM3ufFpMhKYiHzOZ1vtOgQSX/3XnYz/6wGs3J7Pt0fS8D4
RJKALq0sGGhXdgmU/9sAiL6AFH19WEyg9OD8GQXrgPYHCpEoMk8F/zjIi2F5R/3u
PnBmqWx0D6zVnR2j3NI6
=dU1B
-END PGP SIGNATURE-


--
Il mio blog in italiano: https://ilpinguinoscrittore.wordpress.com/
Mi blog en español: https://elpinguinotolkiano.wordpress.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