Re: [libreoffice-users] LO printing issue, 5.3.6.1
Yes > On Sep 16, 2017, at 5:04 PM, Ken Springerwrote: > > Mac OS X 10.11.6 > > I create a document in portrait orientation. > > Print Preview is correct. > > PDF export is correct. > > Printing is not. The document displays and print as landscape. > > Create a landscape document, and printing is correct. > > Bug? > > > > > -- > Ken > Mac OS X 10.11.6 > Firefox 53.0.2 (64 bit) > Thunderbird 52.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 -- 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 printing issue, 5.3.6.1
Mac OS X 10.11.6 I create a document in portrait orientation. Print Preview is correct. PDF export is correct. Printing is not. The document displays and print as landscape. Create a landscape document, and printing is correct. Bug? -- Ken Mac OS X 10.11.6 Firefox 53.0.2 (64 bit) Thunderbird 52.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
[libreoffice-users] Re: Opening Remote Files
On 9/4/17 8:29 PM, Ken Springer wrote: OX X 10.11.6 El Capitan LO 5.3.6.1 I'm working with the first of multiple files that will be located on a Windows 8.1 computer. That computer and my Mac are both hardwired to a network. LO seems to have an issue opening the document at the beginning of a work session. Start Windows 8.1. Start OS X. Wait until the Mac has recognized and connected to 8.1. Start LO to the Start Center. The file I want is listed, but when I click on it, I get the message the file does not exist. Even though I know it does exist. If I click on Open File, I can then navigate to the W8.1 computer, and drill down to the folder where the file is and load it. Even better, I have the folder that contains the file in the Finder's Sidebar. Click on the folder, it opens and I can load the file I want. Has anyone else seen this? Rather disappointing there was no response. :-( But it seems the problem is worse than I described. The hard drive in this iMac is partitioned into two partitions. LO's Startcenter can't open a file that's on the 2nd partition, either. -- Ken Mac OS X 10.11.6 Firefox 53.0.2 (64 bit) Thunderbird 52.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] Base query - CONCAT function
On Sat, 2017-09-16 at 18:31 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > > > But shouldn't the CONCAT( ' & ', [Partnervorname] ), '' ) actually > > return a NULL due to the '' (i.e. not a space, zero length)? > > NULL: There is nothing inside, no string, no number, no data ... > Empty: Could only be for strings - nothing to see, but its a string > with > zero length. > > Base will save for default all fields without content as NULL, not as > fields, which are empty. The difference: You could concatenate empty > fields with content of other fields without problems, because it > recognizes an empty string. With NULL it won't work. > > The Help in LibreOffice and the GUI is missleading here, because Base > won't save fields as empty fields but as NULL. > > Regards > > Robert > Thanks, Robert. I had a feeling that would be the answer. Many thanks for helping me to clear that up. Your proposed syntax is certainly more economical than the COALESCE alternative. Cheers Harvey -- 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] Base query - CONCAT function
Hi Harvey, > > But shouldn't the CONCAT( ' & ', [Partnervorname] ), '' ) actually > return a NULL due to the '' (i.e. not a space, zero length)? NULL: There is nothing inside, no string, no number, no data ... Empty: Could only be for strings - nothing to see, but its a string with zero length. Base will save for default all fields without content as NULL, not as fields, which are empty. The difference: You could concatenate empty fields with content of other fields without problems, because it recognizes an empty string. With NULL it won't work. The Help in LibreOffice and the GUI is missleading here, because Base won't save fields as empty fields but as NULL. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_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] Base query - CONCAT function
On Fri, 2017-09-15 at 22:46 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > > > I have a backend Mariadb 10 which I access directly using the using > > the > > MySQL connector. > > All right. With MariaDB (and MySQL) the two pipes (||) dont work. > > But something like > SELECT CONCAT("Vorname, ' ',IFNULL("Partnervorname",' '),"Nachname") > AS > "Name" FROM "Table" > > should work. > > Regards > > Robert Hi Robert, you are right it works with CONCAT, but, isn't CONCAT inconsistent here? This seems to work as desired: CONCAT( [Vorname], IFNULL( CONCAT( ' & ', [Partnervorname] ), '' ), ' ', [Nachname] ) But shouldn't the CONCAT( ' & ', [Partnervorname] ), '' ) actually return a NULL due to the '' (i.e. not a space, zero length)? Cheers Harvey -- 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] extraneous bullets
good afternoon, things are strange. to my shock the bullets issue does not seem to effect few viewer versions. repro on lo viewer v1 lo viewer v4 however, display is similar to attachment 119855 on tdf#95238 on lo viewer v6 lo viewer v8 lo viewer v10 just sharing my observations ;) regards, krishna -- krishna [ never ever ask about my real name or identity ] ji-bu-rish: https://github.com/kr1shna-opensource/ -- 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