Re: [libreoffice-users] Re: how to make formulas permanently case sensitive?
On 12/05/2015 21:39, Andreas Säger wrote: Am 12.05.2015 um 12:55 schrieb hw: Am 12.05.2015 um 12:45 schrieb hw: Hi, I need, of course, formulars to be case sensitive. This can be set in the options for calc. The option is not saved permanently and every time I open a spreadsheet, I need to set the option again. How can I save this option permanently so I don't need to set it over and over again? To clarify: I need the string comparisons of IF() to be case sensitive: 'if(a1 = x; ...) is, of course, different from 'if(a1 = X; ...)'. Why would anyone make them not case sensitive unless explicitly specified, and how do I specify case sensitiveness per formula? All spreadsheets had been case insensitive ever since. Use the EXACT function for case sensitive comparison. The calculation options do not apply to Excel files which is why you have to reset this option every time you load the file. The Excel file format has no place where this setting can be stored. All spreadsheets had been case insensitive ever since. - I don't understand this. The OpenFormula specification says that comparisons are case sensitive unless HOST-CASE-SENSITIVEisfalse. 6.4.7Infix Operator = Summary:Report if two values are equal Syntax:ScalarLeft =ScalarRight Returns:Logical Constraints:None Semantics:Returns TRUE if two values are equal. If the values differ in type, return FALSE. If the values are both Number, return TRUE if they are considered equal, else return FALSE. If they are both Text, return TRUE if the two values match, else return FALSE. For Text values, if the calculation settingHOST-CASE-SENSITIVEisfalse, text is compared but characters differencing only in case are considered equal. If they are both Logicals, return TRUE if they are identical, else return FALSE. Error valuescannotbe compared to a constant Error value to determine if that is the same Error value. -- 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: how to make formulas permanently case sensitive?
Am 13.05.2015 um 12:27 schrieb David Lynch: All spreadsheets had been case insensitive ever since. - I don't understand this. The OpenFormula specification says that comparisons are case sensitive unless HOST-CASE-SENSITIVEisfalse. I've never seen any spreadsheet program (Lotus 1-2-3, Excel, Gnumeric, Calc) with case sensitive string comparison. But all of them have an EXACT function to enforce case sensitivity. -- 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: Unzipped opendoc files
The functionality doesn't seem to be present in LibreOffice itself (at the very least, it's not in obvious places). But if you really want to use an SVC on the content, you could probably set things using fuse-zip or something similar. It might not work very well however, as LibreOffice enjoy having files in a certain order inside their zip (especially the mimetype at the beginning). All things considered, you might as well go with using the flat XML format, which is slightly more SVC-friendly. -- Cley Faye http://cleyfaye.net 2015-05-13 14:04 GMT+02:00 mkrbins mka...@naturalsciences.be: Oh, I'm not sure I made myself clear. What I was asking is Can soffice use a directory resulting from an unzip as if it were an odt document? Presumably all information of the document is in the directory. So given the right starting point soffice or swriter or scalc should be able to treat the directory as an odt document. so normaly I would do something like swriter thedocument.odt but I could unzip thedocument.odt as otherplace/thedocument.odt (directory name) and do swriter otherplace/thedocument.odt and just be editing an unzipped odt document Ok, it doesn't work like that but is there a way that it would? So you might think. What the f... is this guy thinking about? Well I was thinking about using a standard SVC on such a directory. Ok so LibreOffice does have a document version tracking functionality. I was just wondering if there would be a way to do it 'old-style'. Of course there would be a lot of problems working this way. (Most of all the influence of any change would not be very clear) I did not say it would be a smart way to work. I just wanted to check if it would be possible at all. :-) - Michel K. -- View this message in context: http://nabble.documentfoundation.org/Unzipped-opendoc-files-tp4148436p4148533.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 -- 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: Unzipped opendoc files
Oh, I'm not sure I made myself clear. What I was asking is Can soffice use a directory resulting from an unzip as if it were an odt document? Presumably all information of the document is in the directory. So given the right starting point soffice or swriter or scalc should be able to treat the directory as an odt document. so normaly I would do something like swriter thedocument.odt but I could unzip thedocument.odt as otherplace/thedocument.odt (directory name) and do swriter otherplace/thedocument.odt and just be editing an unzipped odt document Ok, it doesn't work like that but is there a way that it would? So you might think. What the f... is this guy thinking about? Well I was thinking about using a standard SVC on such a directory. Ok so LibreOffice does have a document version tracking functionality. I was just wondering if there would be a way to do it 'old-style'. Of course there would be a lot of problems working this way. (Most of all the influence of any change would not be very clear) I did not say it would be a smart way to work. I just wanted to check if it would be possible at all. :-) - Michel K. -- View this message in context: http://nabble.documentfoundation.org/Unzipped-opendoc-files-tp4148436p4148533.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
Re: [libreoffice-users] Re: Unzipped opendoc files
On 05/13/2015 08:04 AM, mkrbins wrote: Oh, I'm not sure I made myself clear. What I was asking is Can soffice use a directory resulting from an unzip as if it were an odt document? If I understand what you're saying, you may be able to edit it, but unless you save it elsewhere, your changes won't be saved. You can't just open a zip, change something and then expect the changes to be saved when you close the zipped file. You'd have to save the contents somewhere and then zip them. -- 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: Unzipped opendoc files
I believe the idea is to have a file structure like this: /home/foldername/Configurations2 /home/foldername/content.xml /home/foldername/layout-cache /home/foldername/manifest.rdf /home/foldername/META-INF /home/foldername/meta.xml /home/foldername/mimetype /home/foldername/Pictures /home/foldername/settings.xml /home/foldername/styles.xml /home/foldername/Thumbnails And to directly open it with libreoffice, using /home/foldername, without zipping/unzipping the odt file. -- Cley Faye http://cleyfaye.net 2015-05-13 14:23 GMT+02:00 James Knott james.kn...@rogers.com: On 05/13/2015 08:04 AM, mkrbins wrote: Oh, I'm not sure I made myself clear. What I was asking is Can soffice use a directory resulting from an unzip as if it were an odt document? If I understand what you're saying, you may be able to edit it, but unless you save it elsewhere, your changes won't be saved. You can't just open a zip, change something and then expect the changes to be saved when you close the zipped file. You'd have to save the contents somewhere and then zip them. -- 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] Re: Unzipped opendoc files
Yep that's exactly the idea. Thank you for your answers everybody. I think I know where to go now. - Michel K. -- View this message in context: http://nabble.documentfoundation.org/Unzipped-opendoc-files-tp4148436p4148540.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] Base, connect to map/grid ?
Base, can I link a database to a map/grid/spreadsheet grid – not really sure how to ak this or what is possible, doable or worth attempting so bear with me. An explanation of what I want to do. I like gardening and keep on buying plants and sticking them in around the garden, most have difficult names and I have a crap memory. At some point I'll be wandering around the garden see a plant and have no idea what it is. I'd like to create a map of my garden and record where a plant is and its name (common and Latin) etc in a database. Possibly such an application already exists (free) if it does I haven’t found it. So is it possible to connect a database to a map/grid/whatever to do what I want Any thoughts help appreciated - IGraham W764 LibreOffice 4.4.1.2 -- View this message in context: http://nabble.documentfoundation.org/Base-connect-to-map-grid-tp4148544.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] CRLF is cut in a writer mergefield
Hi all, is it possible to make visible the CRLF's from a database textfield in a mergefield at a writer document? If not, is there a workarround? Regards bernd -- 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] Impress - PowerPoint equivalent for these settings
I have a Raspberry Pi driving a kiosk where users simply dump a PowerPoint to a shared folder whenever they want to update what is shown. Unfortunately, users creating the shows are still on Microsoft Office. Things generally work out fine except that I can't control the following setting in the Impress Slide Show Settings: Type: Default/Window/Auto (with a delay setting). At the PowerPoint side, shows are saved to loop continuously, and Browse at a kiosk. When saved as ppt files, the show opens in Impress with Type=Auto at 10 seconds. When saved as pptx files, the show opens in Impress with Type=Default. This is an unattended computer so I cannot go in and set up the Impress show manually each time. Is there a way to set the show Type to Auto=0 globally? -- 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: CRLF is cut in a writer mergefield
Am 13.05.2015 um 17:09 schrieb Bernd Laskowski: Hi all, is it possible to make visible the CRLF's from a database textfield in a mergefield at a writer document? If not, is there a workarround? Regards bernd Print to file and see line feeds included. The grey boxes are just placeholders. They don't know anything about the field length until they are filled with data. -- 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