Re: [libreoffice-users] lines and movement with arrow keys
Actually, you DID understand my question. And I discovered, after submitting the question, that the tab spaces DID underline and I ended up using that solution in this case. But I still wanted to understand how to move the line appropriately since I do at times have need of lines where underlining won't work. I've been using LO for MANY years and early on (perhaps it was before the split with OpenOffice) tab spaces didn't underline. I stupidly just assumed it still worked that way. Egg on my face. But I really appreciate the support from this group! Carl On 3/10/22 12:21 AM, John Kaufmann wrote: Carl, On 2022-03-09 17:00, Carl Paulsen wrote: I have inserted a line into a text document and have a few questions. ... I have done this in the past using tab spaces with a right justified tab, but LO won't underline tab spaces. ... At the conclusion of her elegant reply to your question, Regina advised, It would be good, if you describe the purpose of such line. There might exist a totally different solution for your goal. In particular, when you say that, "I have [made a line] using tab spaces with a right justified tab, but LO won't underline tab spaces", I wonder what you mean, since LO's Right Tab setting includes the underline as one of the options for Fill Character (fourth choice). So I'm surely not understanding your question and/or approach. Could please clarify what you are doing? Kind regards, John -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] lines and movement with arrow keys
Wow, thank you Regina. I will look into all of this, but it sounds like it addresses my concerns. Carl On 3/9/22 5:26 PM, Regina Henschel wrote: Hi Carl, Carl Paulsen schrieb am 09.03.2022 um 23:00: I have inserted a line into a text document and have a few questions. First, I need to make sure it is horizontal. Press the Shift-key while creating the line. Then it is horizontal. Or use Ctrl + Click on icon. That inserts a default line in the middle of the window. That one is horizontal too. Is there a way to ensure it is perfectly horizontal and won't print with the offsets for diagonal placement? I am unable to see if it is perfect. Use item "Position and Size" from the context menu of the line. That dialog has a tab "Rotation", where you can verify that the rotation angle is 0° and correct it if necessary. I have done this in the past using tab spaces with a right justified tab, but LO won't underline tab spaces. You will not get a line but a sequence of underscore characters. If it does not work for you, than perhaps the fill character is not set for that tab stop? You find the setting in the page "Tabs" of the paragraph properties dialog. Second, I need to move the line up slightly. If I select the line and tap the arrow keys, it jumps an entire text line or more (it looks greater than the font size for that line, e.g. 12 pts). The smallest movement with arrow keys is achieved, when you press the Alt-key while using the arrow keys. You get movement by pixel then. If you use a high zoom in addition, the movement is really tiny. For an exact position use the above mentioned dialog "Position and Size" It's as if it is snapping to a grid. Such might be. Is option "Snap to grid" enabled? You find the setting in menu Tools > Options > Writer > Grid, in the upper part. Clear the checkbox. I want to be able to move the line in very small increments. It would be good, if you describe the purpose of such line. There might exist a totally different solution for your goal. Kind regards, Regina -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] lines and movement with arrow keys
I have inserted a line into a text document and have a few questions. First, I need to make sure it is horizontal. Is there a way to ensure it is perfectly horizontal and won't print with the offsets for diagonal placement? I am unable to see if it is perfect. I have done this in the past using tab spaces with a right justified tab, but LO won't underline tab spaces. Second, I need to move the line up slightly. If I select the line and tap the arrow keys, it jumps an entire text line or more (it looks greater than the font size for that line, e.g. 12 pts). It's as if it is snapping to a grid. I want to be able to move the line in very small increments. Thank you! -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Tabs in selection of text
Steve, I think you may have hit the nail on the head. I'll look into upgrading and see if that changes anything. I think the issue may well have been that I was selecting "paragraphs" with different formatting (my quotes aren't to draw attention but rather to indicate I don't mean only book-like paragraphs) and trying to apply tabs to those. If I repeatedly use a specific format, I'd definitely consider Styles. But there seem to be a lot of complicated considerations for using Styles (the nesting/heirarchy topics I mentioned in my other reply). Anyway, thank you. Carl On 4/8/19 3:53 PM, Steve Edmonds wrote: Hi. I am on 6.07 but your issue is dredging up some memories where I think I noticed the same situation. With a paragraph as a block of text terminating in a line break (rather than the older paragraph in a book interpretation), I think I noticed that when I selected multiple paragraphs with different tab settings that I couldn't edit tab settings in the ruler and there was no TAB tab in the paragraph format dialogue. This was before 6.07 which is not showing the issue, may have been 6.05 or 5 series. In some cases I set the tabs one paragraph at a time, in others I just set the default style for the block of text and then re-formatted characteristics, including tabs. If there are a lot of paragraphs to format the same way, I would suggest creating a style and then you can easily apply the same formatting repeatedly. Steve On 09/04/2019 00:34, Carl Paulsen wrote: LO 6.0.5.2 on Mac Sierra (10.12.6) In some cases I can click into a line and set tabs normally. In the document where I had the problem I believe it was a bulleted list or indented text (hanging indent I think) where I was having the problem. I opened the document today and quickly tried it again and can't find the section I was having problems in. But I'm pretty sure I removed all formatting and started over in that section, at which point it worked. Wish I could reproduce it, as it was quite frustrating. My guess is it was something to do with whatever formatting was applied in that section. I don't yet use Styles so any formatting would have been set manually, and that would have been minimal. If I encounter it again I'll be sure to post again, and try to post a sample document. On 4/8/19 7:19 AM, Dave Howorth wrote: On Mon, 8 Apr 2019 14:32:05 +1200 Steve Edmonds wrote: Hi. What version of LO do you have. Just as a test, can you click into just 1 line and then add a tab stop to the ruler. Steve Also what OS? In addition, can you post an example of the text/document that you cannot format tabs for somewhere? Perhaps it is a data-dependent problem, since tab stops work as you expect for other people including me. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Tabs in selection of text
Thanks Dan, I guess what is unintuitive is the CSS-like approach to Styles. I find CSS to be very difficult when, as you say, you have a complex page and need to nest various styles and keep track of hierarchies. When using LO for text docs, I'm simply wanting to produce a text document with other elements scattered around. I want a simple interface that gives me decent control over presentation but doesn't require in-depth studying to learn how to use it. I want to format a document or section, then occasionally apply a set of tabs (or other formats) within a subset that applies only to that section. And I'd rather not have to build a style just for tabs to a bulleted list when I may only use that specific style once ever. I do a lot of document specific formatting and I don't want a massive list of styles to wade through every time I want tabs at specific locations. What would be even worse would be to have to repeat all the other styles components for that section in my new tabs style. (Sounds like that may not be necessary if that's what you mean by nesting.) I will eventually learn about Styles and no-doubt start using them for big-picture formatting. For often-repeated styling I can see the value of Styles. But I don't see using them for every one-off stylistic change I make in a document, and if that means I have to remove styles for a sub-section in order to add or change something for just that section, I suspect I'll end up highly frustrated with LO. I get that I may be an unusual case and no one develops for that oddball. But I can't believe I'm alone. Back in the early 2000s I'd hoped OO (and now it's offspring) would be a viable alternative to the big bully in the room, but for a number of reasons (not just Styles) I just don't see that happening. And at least in my circles, it's use has dropped off significantly. Carl On 4/8/19 4:44 PM, Dan Lewis wrote: On 4/3/19 8:37 PM, Carl Paulsen wrote: I have a number of "paragraphs" of text (job listing section of a resume) for which I'd like to add tab stops. I select the lines and click the tab stop I want, then click in the ruler, but nothing happens. I see no menu item to format tabs, though I did stumble into one dialog box with Tabs that required manual setting and it was unclear just where those tabs would be applied. In any case, I can't find that any more. In the help document (https://help.libreoffice.org/Common/Inserting_and_Editing_Tab_Stops) it says for changing one or more paragraphs: "Select the paragraphs, then click inside the ruler." That is most definitely not working. Finally, if I clear all formatting, I get the default tab stops and could re-format the entire section that way. But that's a bit of work given all the formatting I'd lose. What do I do to quickly and simply edit tab stops, and why is it so difficult in LO? FYI I find the Styles aspect of LibreOffice to be entirely unintuitive and I've never been able to work with them. I realize that should be a goal but it's not possible in my current timeline. Thank you! I missed this when this thread was started. Your 'FYI' statement is probably the real reason for all of your problems. LibreOffice is designed to use styles for text creation and/or editing. Manual formatting can create so many more problems than using styles. Besides they are harder to solve. The 'Getting Started Guide' has at least one chapter on styles as does the 'Writer Guide'. When I first began working on the documentation for OpenOffice.org (early 2000's) and later LibreOffice, I used this chapters to learn how to use styles. I have never regretted. I would like to know what is 'unintuitive' with styles. I am thinking it might be that you think in terms of lines of type verses groups of paragraphs. You also may have some problems with the concept of nesting. Each paragraph has specific set of characteristics that applies to every character of the paragraph; it ends with a paragraph break. Character styles are used to give specific characteristics to a continuous set of characters within the paragraph. Perhaps it might be unintuitive for you to think that each member of a list can also be a separate paragraph. Yet this might be the best way to give you document the formatting you want it to have. Dan -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Tabs in selection of text
LO 6.0.5.2 on Mac Sierra (10.12.6) In some cases I can click into a line and set tabs normally. In the document where I had the problem I believe it was a bulleted list or indented text (hanging indent I think) where I was having the problem. I opened the document today and quickly tried it again and can't find the section I was having problems in. But I'm pretty sure I removed all formatting and started over in that section, at which point it worked. Wish I could reproduce it, as it was quite frustrating. My guess is it was something to do with whatever formatting was applied in that section. I don't yet use Styles so any formatting would have been set manually, and that would have been minimal. If I encounter it again I'll be sure to post again, and try to post a sample document. On 4/8/19 7:19 AM, Dave Howorth wrote: On Mon, 8 Apr 2019 14:32:05 +1200 Steve Edmonds wrote: Hi. What version of LO do you have. Just as a test, can you click into just 1 line and then add a tab stop to the ruler. Steve Also what OS? In addition, can you post an example of the text/document that you cannot format tabs for somewhere? Perhaps it is a data-dependent problem, since tab stops work as you expect for other people including me. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Tabs in selection of text
On 4/7/19 12:55 PM, Brian Barker wrote: At 20:37 03/04/2019 -0400, Carl Paulsen wrote: I have a number of "paragraphs" of text (job listing section of a resume) for which I'd like to add tab stops. Are these true paragraphs? I'm not sure why you have given the word scare quotes. If they are not true paragraphs, what you with tab stops may not behave as you expect. U. What's the definition of a true paragraph, in particular as distinct from, say, a line in a bulleted list, and why does that matter? I simply want to take lines of text and apply some tab stops to it (the full set of text prior to the next carriage return, whether a paragraph or lines of bulleted text or whatever). These will be left justified tab stops. Simple enough I thought. I select the lines and click the tab stop I want, then click in the ruler, but nothing happens. "Lines" are not really a word processing concept, as text reflows automatically as you edit it. Tab stops are applied to paragraphs. Are you clicking in the *horizontal* ruler, above the text window? Incidentally, are you simply missing how tab stops work? They do nothing by themselves: you need also to insert tab *characters* (or other formatting) into your text to control how the tab stops take effect. I select the lines of text to which I want to apply the tab stops. I click on the tab stop box in the upper left of the document to select which type of tab I want, then click in the horizontal ruler where I want that tab to go. Nothing happens. No tab stop. I most definitely MUST be missing how tab stops work, hence why I posted. But in every other program I've used it works similarly to how I describe. I see no menu item to format tabs, though I did stumble into one dialog box with Tabs that required manual setting and it was unclear just where those tabs would be applied. Tabs are a paragraph property as well as a paragraph style property: o For paragraph formatting, go to Format | Paragraph... | Tabs (or right-click | Paragraph... | Tabs). o For paragraph style formatting, go to Format | Styles and Formatting... | right-click style | Modify... | Tabs (or right-click | Edit Paragraph Style... | Tabs). That's what's odd. In the lines of text I want to apply the tabs, there is no Tab option in Format | Paragraph. Again, hence my question. I do wish I could just set tabs in the ruler as at times I want to apply the tabs, look at the result, and make adjustments. Requiring manual tab setting makes that process much more cumbersome. In the help document (https://help.libreoffice.org/Common/Inserting_and_Editing_Tab_Stops) it says for changing one or more paragraphs: "Select the paragraphs, then click inside the ruler." That is most definitely not working. So what exactly happens when you try? Do you not see a tab stop in the ruler? Exactly. Carl -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Tabs in selection of text
I have a number of "paragraphs" of text (job listing section of a resume) for which I'd like to add tab stops. I select the lines and click the tab stop I want, then click in the ruler, but nothing happens. I see no menu item to format tabs, though I did stumble into one dialog box with Tabs that required manual setting and it was unclear just where those tabs would be applied. In any case, I can't find that any more. In the help document (https://help.libreoffice.org/Common/Inserting_and_Editing_Tab_Stops) it says for changing one or more paragraphs: "Select the paragraphs, then click inside the ruler." That is most definitely not working. Finally, if I clear all formatting, I get the default tab stops and could re-format the entire section that way. But that's a bit of work given all the formatting I'd lose. What do I do to quickly and simply edit tab stops, and why is it so difficult in LO? FYI I find the Styles aspect of LibreOffice to be entirely unintuitive and I've never been able to work with them. I realize that should be a goal but it's not possible in my current timeline. Thank you! -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Auto recovery problem
Thanks for this suggestion. I'll try it next time I notice the problem (which could be soon since I'm not convinced I've fixed it). Carl On 2/4/19 8:09 PM, Girvin Herr wrote: Carl, I have experienced this endless auto-recovery on startup problem before. Whenever I got it, I "reset" my user profile and it stopped doing it. Offhand, I don't remember the exact steps to do that, but a search of this forum should turn up the procedure or maybe someone out there who knows it can give it to you. I have developed the process of occasionally saving the good profile in a directory somewhere so I can just copy it back to resolve such a problem and still keep my settings. HTH. Girvin Herr On 2/4/19 4:13 PM, Carl Paulsen wrote: Windows 10. I think the LO version is either 6.1.4 or the previous one. Note that earlier in the day I was struggling with the same problems and saw that LO was telling me there was a new release. So in desperation I upgraded, which I think was to 6.1.4. That computer is down for the night but I can check again tomorrow. In any case that didn't fix it. Note that I eventually got the system to work...sometimes. I had de-registered the databases for my other issue, cleared the auto-recovery, started working with new files and got them to work sometimes. An example is a label document, where I saved the labels as a LO Writer document with the merge fields in it, and merged to a full sheet. That document continues to open with the auto-recover for itself, whether I discard the recovery point or not. When it opens it seems to work fine. With another document, a merge letter, I saved it with merge fields in place. That one appears to open without the auto-recovery, though this one opened with merge data in the place of the fields. And in this case I at some point I exchanged databases so I could build a merged file with a second data set. What seems like is happening is the documents get saved and closed, and then there's some kind of flag in the file that didn't get reset by the save, which marks it as damaged/needing recovery. So it triggers the auto-recovery system even when it's not needed. Carl On 2/4/19 6:06 PM, Dan Lewis wrote: Two things are needed to help you: your version of LibreOffice, and your operating system. Dan On 2/4/19 4:43 PM, Carl Paulsen wrote: I'm trying to create a mail merge document for a letter. I'm adding fields directly to retain formatting control and NOT have to deal with a text block which is how the wizard inserts addresses. I've had some success after a LONG time trying to figure out how to do this. Documentation is a bit lacking on this approach. The real problem is happening when I try to close and then reopen the document. The file appears to close fine but when I try to reopen it, LibreOffice seems to think the file is damaged. I can recover and the file opens fine, but same thing happens when I try to reopen again. I can also "discard" the auto-recovery which should fix the auto-recover so it doesn't come up again, but in fact it DOES. Even when discarding recovery points, the program continues to think there's a problem with the file and re-opens the auto recovery. I can't find any way to deal with this problem. BTW, it seems that I finally figured out how to generate the merged letters, so I assume the file is basically OK. But I still get the auto-recovery screen. I'd love to get this to stop. It's a hassle, slows me down, and doesn't show LO at it's best when I'm showing friends and clients. Carl -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Mailing labels from mail merge
I was contacted off list to discuss this not long after I was able to get the system to work. See my reply below. In short, I did eventually get it to work, but I have no idea why. And the whole experience seemed a bit buggy. First, I was able to build a merge letter with the wizard, once using an address block and then, after some struggling, I figured out how to add the merge fields directly and NOT using the wizard address block. (Note that system is not at all helpful when starting with a pre-existing letter - it shifted blocks of text around and basically ruined the letter formatting.) But then I could not get that system to actually merge the data into letters. Somehow after closing and reopening that file and de-registering and then re-registering the spreadsheet, the commands for merging to document or printing showed up. But even then I was still not able to flip through the records to see how they would appear in the preview. I was able to merge the document to a file, though, and then print that. Then after similar stumbling around, opening and closing files, de-registering and re-registering databases, I was able to get the merge fields to show up for the labels. I've now printed the labels. But again, I have no idea what fixed the problem, and am not at all confident I can do it successfully in the future. Mail merges are one of the most important aspects of an office suite like this for me. I really wish it could be made more simple and reliable. Carl On 2/4/19 6:53 PM, Carl Paulsen wrote: Hi Wayne, This is off list so I should probably post this to the support list, but after a while of fiddling around, removing the databases I'd registered (Tools | Options | Base | Databases), closing LO, and then re-opening LO and re-registering them with the mail merge wizard, I was eventually able to get the spreadsheet to show in the labels picklist. I think it may be a slight bug, but it eventually let me build the labels. Hope something like that will work for you. Try de-registering the DBs, closing, restarting, re-registering, and see what happens. You've probably done that, but maybe it'll work? BTW, I'm on LO 6.1.4 I think, Windows 10, Intel processor (don't recall what and I'm off that computer now). Carl On 2/4/19 4:59 PM, stinson wrote: Carl, I'm having the same problem...not resolved. Platform: AMD Phenom(tm) II X2 555 Processor × 2 Ubuntu 16.04 LTS LibreOffice Version: 5.1.6.2 Build ID: 1:5.1.6~rc2-0ubuntu1~xenial4 CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; Locale: en-US (en_US.UTF-8); Calc: group I've created a mailing DB - named columns (tables) - saved it - registered it ...but when attempting to print mailing labels only the DB name shows in the label window - no table names are made available to format the label. If I resolve this issue will post my solution Wayne On 2/4/19 4:37 PM, Carl Paulsen wrote: I'm trying to build a set of "Avery 5160" labels to match the letters I'm printing via mail merge, using the same spreadsheet data source. When I select Mailing Labels as the new document type, I am presented with a drop-down list of databases. I've registered the spreadsheet during the letter creation (though it has seemingly created the database multiple times, as it shows me 4 or 5 options with the same name) but when I select it in the labels dialog, it shows no tables and no fields. Help! How do I get the "registered" databases to show me the fields and data? The mail merge process seems to be pretty cumbersome. Aside from this problem, labels aren't created the same way Letters are, and I had to search and try things for hours to figure out how to insert address, salutation, and other fields manually (I don't like the address block approach of the wizard). The system seems to think my merge documents are damaged, launching the recovery system every time I open them (see my other post), and discarding the auto-recovery entries doesn't help. This really shouldn't be so hard to do. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Auto recovery problem
Windows 10. I think the LO version is either 6.1.4 or the previous one. Note that earlier in the day I was struggling with the same problems and saw that LO was telling me there was a new release. So in desperation I upgraded, which I think was to 6.1.4. That computer is down for the night but I can check again tomorrow. In any case that didn't fix it. Note that I eventually got the system to work...sometimes. I had de-registered the databases for my other issue, cleared the auto-recovery, started working with new files and got them to work sometimes. An example is a label document, where I saved the labels as a LO Writer document with the merge fields in it, and merged to a full sheet. That document continues to open with the auto-recover for itself, whether I discard the recovery point or not. When it opens it seems to work fine. With another document, a merge letter, I saved it with merge fields in place. That one appears to open without the auto-recovery, though this one opened with merge data in the place of the fields. And in this case I at some point I exchanged databases so I could build a merged file with a second data set. What seems like is happening is the documents get saved and closed, and then there's some kind of flag in the file that didn't get reset by the save, which marks it as damaged/needing recovery. So it triggers the auto-recovery system even when it's not needed. Carl On 2/4/19 6:06 PM, Dan Lewis wrote: Two things are needed to help you: your version of LibreOffice, and your operating system. Dan On 2/4/19 4:43 PM, Carl Paulsen wrote: I'm trying to create a mail merge document for a letter. I'm adding fields directly to retain formatting control and NOT have to deal with a text block which is how the wizard inserts addresses. I've had some success after a LONG time trying to figure out how to do this. Documentation is a bit lacking on this approach. The real problem is happening when I try to close and then reopen the document. The file appears to close fine but when I try to reopen it, LibreOffice seems to think the file is damaged. I can recover and the file opens fine, but same thing happens when I try to reopen again. I can also "discard" the auto-recovery which should fix the auto-recover so it doesn't come up again, but in fact it DOES. Even when discarding recovery points, the program continues to think there's a problem with the file and re-opens the auto recovery. I can't find any way to deal with this problem. BTW, it seems that I finally figured out how to generate the merged letters, so I assume the file is basically OK. But I still get the auto-recovery screen. I'd love to get this to stop. It's a hassle, slows me down, and doesn't show LO at it's best when I'm showing friends and clients. Carl -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Auto recovery problem
I'm trying to create a mail merge document for a letter. I'm adding fields directly to retain formatting control and NOT have to deal with a text block which is how the wizard inserts addresses. I've had some success after a LONG time trying to figure out how to do this. Documentation is a bit lacking on this approach. The real problem is happening when I try to close and then reopen the document. The file appears to close fine but when I try to reopen it, LibreOffice seems to think the file is damaged. I can recover and the file opens fine, but same thing happens when I try to reopen again. I can also "discard" the auto-recovery which should fix the auto-recover so it doesn't come up again, but in fact it DOES. Even when discarding recovery points, the program continues to think there's a problem with the file and re-opens the auto recovery. I can't find any way to deal with this problem. BTW, it seems that I finally figured out how to generate the merged letters, so I assume the file is basically OK. But I still get the auto-recovery screen. I'd love to get this to stop. It's a hassle, slows me down, and doesn't show LO at it's best when I'm showing friends and clients. Carl -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Mailing labels from mail merge
I'm trying to build a set of "Avery 5160" labels to match the letters I'm printing via mail merge, using the same spreadsheet data source. When I select Mailing Labels as the new document type, I am presented with a drop-down list of databases. I've registered the spreadsheet during the letter creation (though it has seemingly created the database multiple times, as it shows me 4 or 5 options with the same name) but when I select it in the labels dialog, it shows no tables and no fields. Help! How do I get the "registered" databases to show me the fields and data? The mail merge process seems to be pretty cumbersome. Aside from this problem, labels aren't created the same way Letters are, and I had to search and try things for hours to figure out how to insert address, salutation, and other fields manually (I don't like the address block approach of the wizard). The system seems to think my merge documents are damaged, launching the recovery system every time I open them (see my other post), and discarding the auto-recovery entries doesn't help. This really shouldn't be so hard to do. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Calc SLOW with filtering large data set
I realized this morning that the version I installed was the "fresh" release and not the "still" release. I did that because it was at the top of the download page for the installer and was the only one that showed on my browser screen (I didn't think to scroll down because convention seems to be to present the current safe version at the top and provide access to potentially unstable versions via more obscure links). Seems to me it would be wise to hide the "fresh" version and present the "still" version at the top of the list. I am downloading the v.5 "still" release and will test that on the new computer. I'm expecting it to work faster. I also noticed that the 6.0.1 release is missing the memory management option under the Tools|Options menu. I'd thought perhaps I could speed up the filtering of the long file with memory management but there was no option for memory management that I could find. I don't know if that's intentional or a bug, but I thought I should mention it. Again, that is in v.6.0.1. Carl On 2/19/18 11:07 PM, Carl Paulsen wrote: OK, a little more info. I just ended up trying the spreadsheet on the older machine running windows 7 and LibreOffice 5 and the filtering was nearly instantaneous. Odd because Excel (2007) on that same machine is very slow. So why would Calc run so slow when filtering using LO 6 on a Windows 10 machine but so fast when running LO 5 on a Windows 7 machine? And is there any connection to Excel being so slow on both machines? Thx On 2/19/18 10:49 PM, Carl Paulsen wrote: I work with large spreadsheets and have used both Excel and Calc in the past. I have a large file with 10 or so sheets, many of which are large and one has just over 35,000 records. In this sheet there is a field that is boolean (0 or -1). When I filter on this field in Excel it takes several minutes to complete. When filtering in Calc it takes 10-15 minutes or more. I'm using Excel on an older and slower i5 windows 7 machine and Libreoffice on a newer i5 (8th gen) with windows 10. I may try to switch machines to see what happens, but I'm pretty busy and taking the time to do that is tricky. Also, I've tried using Excel 360 (trial) on the newer windows 10 machine and it loads 30 seconds or so faster than the older machine running excel, much faster than Libreoffice. What might cause this slow filtering? I'd love to use Calc exclusively, but occasional problems like this keep scaring me away from fully embracing Libreoffice. Thanks for any insights or ideas about how to speed it up. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc SLOW with filtering large data set
OK, a little more info. I just ended up trying the spreadsheet on the older machine running windows 7 and LibreOffice 5 and the filtering was nearly instantaneous. Odd because Excel (2007) on that same machine is very slow. So why would Calc run so slow when filtering using LO 6 on a Windows 10 machine but so fast when running LO 5 on a Windows 7 machine? And is there any connection to Excel being so slow on both machines? Thx On 2/19/18 10:49 PM, Carl Paulsen wrote: I work with large spreadsheets and have used both Excel and Calc in the past. I have a large file with 10 or so sheets, many of which are large and one has just over 35,000 records. In this sheet there is a field that is boolean (0 or -1). When I filter on this field in Excel it takes several minutes to complete. When filtering in Calc it takes 10-15 minutes or more. I'm using Excel on an older and slower i5 windows 7 machine and Libreoffice on a newer i5 (8th gen) with windows 10. I may try to switch machines to see what happens, but I'm pretty busy and taking the time to do that is tricky. Also, I've tried using Excel 360 (trial) on the newer windows 10 machine and it loads 30 seconds or so faster than the older machine running excel, much faster than Libreoffice. What might cause this slow filtering? I'd love to use Calc exclusively, but occasional problems like this keep scaring me away from fully embracing Libreoffice. Thanks for any insights or ideas about how to speed it up. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Calc SLOW with filtering large data set
I work with large spreadsheets and have used both Excel and Calc in the past. I have a large file with 10 or so sheets, many of which are large and one has just over 35,000 records. In this sheet there is a field that is boolean (0 or -1). When I filter on this field in Excel it takes several minutes to complete. When filtering in Calc it takes 10-15 minutes or more. I'm using Excel on an older and slower i5 windows 7 machine and Libreoffice on a newer i5 (8th gen) with windows 10. I may try to switch machines to see what happens, but I'm pretty busy and taking the time to do that is tricky. Also, I've tried using Excel 360 (trial) on the newer windows 10 machine and it loads 30 seconds or so faster than the older machine running excel, much faster than Libreoffice. What might cause this slow filtering? I'd love to use Calc exclusively, but occasional problems like this keep scaring me away from fully embracing Libreoffice. Thanks for any insights or ideas about how to speed it up. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Excel file .xls not opening properly
Thanks, Bill. After trying a few things, I discovered that this file doesn't open in Windows using M$ Office either, so there's something wrong with it. I had moved 3 files from Windows to my Mac to work on them, and that's where I noticed the problem. The other two files had opened fine on the Windows machine but I guess I hadn't checked this third one. My hint (inspired by your reply) was that TextEdit on a Mac thought the file was empty except for two blank lines. That program can usually open any file, so there was clearly something odd going on. Carl On 3/10/15 5:09 AM, William Drago wrote: Just because a file has a .xls extension does not mean it's actually a spreadsheet file. I'd open the file in a text editor to make sure it's not an HTML file. Also, if you think it's being treated as a .doc file, then I'd rename it .doc and then try opening it. -Bill On 3/9/2015 2:08 PM, cpaulsen10 wrote: LibreOffice is trying to open a recent file with the extension .xls as if it were a .doc file. When opened directly (by saving the file to the hard drive then double clicking it) I get an error that says this page uses frames but your browser doesn't support them and I get only text-style menus and tools. I'm NOT trying to open this in a browser and there's no browser involved when trying to open it. This file was originally generated by Salesforce, which often saves it as if it were an html/web file. But with a save-as operation in MS Excel, the file saves correctly as a spreadsheet file (.xls). I'm using MS Office 2007, so it's not a new file type, and I've had no problems in the past. Any idea what is happening? I've tried opening a blank spreadsheet and inserting from a file, but no luck. Nothing happens when I do that. Thanks, Carl -- 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] Calc formula ...
Wow, excellent suggestions Brian. Your ideas are always spot on. Thanks. Carl On 3/10/15 4:08 AM, Brian Barker wrote: At 19:20 10/03/2015 +1300, David Love wrote: I have a three column spreadsheet. Column A. Date - The dates are consecutive Column B. Production - The Production has a daily target of 10,000 units and each production period is of seven days. Column C. a formula every seventh cell. Is it possible to construct a formula which will show in the seventh cell of column C the average for the number of days of production i.e. if day 1 reaches a production of 10,000 units I want this figure entered into the seventh cell in column C. Hold on! How do you know this is going to be the average for the week? Do your workers celebrate reaching the daily target and take the rest of the week off? Surely they need to attempt the same daily target on each of the next six days? Or do you mean that 1 is the *weekly* target? If so, what happens when it is reached? Does production automatically stop to prevent its being exceeded? Or could some weeks exceed 1 - even by accident? If days 1+2+3+4 total, say, 42,500 I want the seventh cell in column C to show the average of 10,265. In other words I want the average shown for the actual days of production each seven day period. So 1 isn't a weekly limit. In that case, what is the significance of the 1? If four days exceed 1, as here, it's not a daily limit either: at least one of these days must have exceeded 1. I'm beginning to suspect that it has no significance for the calculation (so you didn't need to tell us): it may be of interest only to the workers' supervisor in interpreting the results. You can find the average of non-negative values (i.e. non-zero values in your case, assuming production cannot be negative) by putting in, say, C7: =AVERAGEIF(B1:B7;0) If you copy this and paste it into every seventh row of column C, you will have what you need. But that leaves you with the rather messy requirement to paste separately into every seventh row - a process very prone to error. Instead, in C7 try: =IF(MOD(ROW();7)=0;AVERAGEIF(B1:B7;0);) ROW() returns the current row number. The MOD() function returns the remainder on dividing by 7. If this is zero - as it will be for row 7 and every seventh row thereafter - the required average is shown; otherwise the null string ensures that there is no display in the cell. You can copy or fill this down column C without the same risk of error as the previous suggestion. Note that comparing the result of the MOD() function with zero will show results in rows 7, 14, 21, and so on. You will have to change the 0 to 1 to show results instead in rows 8, 15, 22, and so on - and similarly for other possibilities. Once you have found the appropriate value, you can fill the formula containing it down the column. Is it possible for there to be no production at all in a particular week? The above formula, in evaluating the average of no values, attempts to divide by zero and displays #DIV/0! . You could test for this and avoid it in various ways. If days with no production have empty cells in column B, =IF(AND(COUNT(B1:B7)0;MOD(ROW();7)=0);AVERAGEIF(B1:B7;0);) would suffice. If they have (or may have) explicit zero values, try: =IF(AND(COUNTIF(B1:B7;0)0;MOD(ROW();7)=0);AVERAGEIF(B1:B7;0);) I trust this helps. Brian Barker -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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] Your message to LibreOffice awaits moderator approval
That's a pretty ironic message! On 6/27/14 12:20 AM, Thomas Taylor wrote: On Thu, 26 Jun 2014 03:21:02 -0700 libreoffice-ow...@lists.freedesktop.org wrote: Your mail to 'LibreOffice' with the subject Delivery reports about your e-mail Is being held until the list moderator can review it for approval. The reason it is being held: The message headers matched a filter rule Either the message will get posted to the list, or you will receive notification of the moderator's decision. If you would like to cancel this posting, please visit the following URL: http://lists.freedesktop.org/mailman/confirm/libreoffice/2bda60b63da22656939eec470ed36b22e6552623 This message is NOT useful. Whom is it for and why was it sent to the entire list? Tom - moderator -- Carl Paulsen -- 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] Calc worksheet stalls when opening
Tom, This was indeed a helpful post (beyond just this thread). I didn't know it worked that way and didn't realize it could get corrupted. Nice to know! Carl On 3/13/14 9:17 AM, Tom Davies wrote: Hi :) Ok, so it's probably something in the upgrade or in the User Profile. Easiest one to check is the User Profile so please rename it https://wiki.documentfoundation.org/UserProfile -- Carl Paulsen -- 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] vlookup not working
Thanks, Brian. I finally got a chance to look at this, and it appears it was, in fact, formatted to text (though I can't figure out how that would have happened b/c I didn't do anything before setting up the formula). When I set it to General, it worked. I appreciate your help! Carl On 3/7/14 3:11 AM, Brian Barker wrote: At 18:27 06/03/2014 -0500, Carl Paulsen wrote: I have a spreadsheet that won't calculate a vlookup. The formula displays as the formula, not the result. I can think of two possibilities: o You have Calc configured to display formulae, not results. Go to Tools | Options... | LibreOffice Calc | View | Display. Is Formulas ticked? Remove the tick. o The cell into which you typed the formula was formatted as Text before you did so. So what you have is a text string which happens to look like a formula, not a formula. After you have changed the formatting, you will need to retype or re-paste an entry and then fill it down the column again to correct this. What's more, the relative reference to A2, which should change as the location of the lookup changes, doesn't change, so it always references A2. That suggests the second possibility. I trust this helps. Brian Barker -- Carl Paulsen -- 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] vlookup not working
I have a spreadsheet that won't calculate a vlookup. The formula displays as the formula, not the result. In the formula dialog box, it displays an answer for the lookup (I don't know if the answer is correct) and if I click into the formula, it displays the cell references as I'd expect. It just doesn't want to actually display the result. Formula is: =VLOOKUP(A2;Contacts.$B$1:$C$2183;2;0) The vlookup uses static lookup array (hence the $ symbols). I first tried this in Excel on another computer and had the same problem. Tried forcing the calculation and setting the file to auto-calculate, but no joy. Then opened it in Calc, saved as ODS, then tried again and I'm getting the same problem. What's more, the relative reference to A2, which should change as the location of the lookup changes, doesn't change, so it always references A2. Any wisdom is greatly appreciated. -- Carl Paulsen -- 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: Reply-To?
I still see no Smart Reply but in the email window itself there is the Reply Lists button, which I will be trying to use. I see no option for any toolbar, menu item or anything else resembling what you are talking about (I also see no images in the bug post you link to). Makes me wonder if we're even using the same software! Maybe there's a difference between my Mac version and whatever you are using? Carl On 3/4/14 11:48 AM, Tanstaafl wrote: On 3/4/2014 10:37 AM, Tanstaafl tansta...@libertytrek.org wrote: On 3/3/2014 9:12 PM, Carl Paulsen carlpaul...@comcast.net wrote: Tanstaafl, where is the smart reply button? I'm running T-Bird 24.3.0 (latest update for me) and see no such button. I have either Reply or Reply to List, but no smart button and no preference or option for such a button that I can find. I'm on a Mac. Sure would be helpful. It is only available in the EMail Header Toolbar (either in the Preview Pane or in individual email windows). By this I meant that there is NOT a 'Smart Reply' button available for the Main/General Menu Toolbar. If you'd like to see one, please feel free to vote for my feature request: https://bugzilla.mozilla.org/show_bug.cgi?id=868961 -- Carl Paulsen -- 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: Reply-To?
OK, thanks, this helps. I hadn't understood that the only way to ADD the button was to right-click. Sometimes it's helpful to be explicit. Not everyone knows all the details of every software. So I had the Reply Lists (or Smart Reply?) button on individual email windows all along (whether showing all headers or not). But I can also CTRL-Click on the header above the email windows (e.g. in the main window) and get the same button. This button shows regardless of the state of the headers or other settings. If I use that button to reply to an individual email, the To field is left blank, but if I click it on a list email, it uses the list reply address. Not quite as useful as I expected, but it does kinda help. Now I can click on an email that isn't open and still reply to the list (if it's a list email). I still have to remember to use the reply lists button, but that shouldn't be too hard to learn (I'm not THAT old of a dog...). Thanks again. Carl On 3/4/14 2:31 PM, John Mary Linge wrote: On 3/4/14, 1:51 PM, Carl Paulsen wrote: I still see no Smart Reply but in the email window itself there is the Reply Lists button, which I will be trying to use. I see no option for any toolbar, menu item or anything else resembling what you are talking about (I also see no images in the bug post you link to). Makes me wonder if we're even using the same software! Maybe there's a difference between my Mac version and whatever you are using? I am using Thunderbird on the Mac. If you right-click the message header, you will see a customize button. Clicking it will give you a number of items to add to the toolbar and will allow you to remove items from the toolbar. Since I have Smart Reply present, the corresponding button shows Reply List when I am viewing this list. The Reply List button disappears when I am not viewing a mailing list. John -- Carl Paulsen -- 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: Reply-To?
Tanstaafl, where is the smart reply button? I'm running T-Bird 24.3.0 (latest update for me) and see no such button. I have either Reply or Reply to List, but no smart button and no preference or option for such a button that I can find. I'm on a Mac. Sure would be helpful. Carl On 3/3/14 4:54 PM, Tanstaafl wrote: I'm not Jim, but probably know far more than he does about Thunderbird. On 3/3/2014 3:14 PM, yahoo-pier_andreit pier_andr...@yahoo.it wrote: dear jim, I'm using thunderbird, and I have the same problem, if I press ctrlR the reply is to the sender non to the list, and I would like to reply to the list not to the sender, so I have to use reply to list, It seems you are very skilled about, how can I set thunderbird to reply to the list when I pressR??? You can't - that is the whole point about keyboard shortcuts - they specifically invoke a specific command. Computers cannot (yet) read minds. What you can do is tell the computer what you want to do - in this case, to use the keyboard shortcut to Reply List, do: CTRL-SHIFT-L Or, you could use the 'Smart Reply' button, which automatically switches to 'Reply List' for messages that List Headers. -- Carl Paulsen -- 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] Calc: help with VLOOKUP
Take a look at the Help entry for vlookup. That entry begins with the first 3 lines: Vertical search with reference to adjacent cells to the right. This function checks if a specific value _is contained in the first column of an array_. The function then returns the value in the same row of the column named by Index. Underlining added. In other words, it looks for values in the first column of the named array, then returns the value in the same row in whatever column you tell it to (the Index column). I'm sure it could be stated more clearly and more specifically in the details of the Help entry, but it's there. A few hints for vlookups: I find I usually want to add hard references for the array so that it always looks at the intended rows of the array. To do that, you need to add $ before each cell reference in the array. So if the array of the function is A1:C100, I enter it as $A$1:$C$100. This forces vlookup to always look at those cells regardless of what row the calculation is happening on. Without this fixed reference, as the vlookup moves to new cells (e.g. down a column) the array will also shift down. So for example, if the looked up value is in cell D1 and the vlookup formula is in E1, the above array will be searched. But if you then copy that function down column E, each cell you move down will shift the Array down as a relative reference. That is, on line E2, the vlookup will look at D2, then search for that value in the array A2:C101 (not the originally intended A1:C100). On row 201, the vlookup in E201 will look at the value in D201 and search for it in the array A201:C300. If the values you want to search through are only in A1:C100, then your lookup won't find a match...ever. The $ hard references prevent this. Finally, be mindful of the implications of the sort order variable in the function. If it is 1 or TRUE, the array must be sorted ascending, and the function returns the nearest value below or before the looked up value. If you want to force it to return only exact matches and/or don't want to or can't sort the array, be sure to set sort order to 0 or FALSE. HTH, Carl On 2/14/14 3:55 PM, Pikov Andropov wrote: Dave Liesse has written on 2/10/2014 4:00 PM: The first problem I see is that your lookup value -- in this case the ID number -- has to be the first column in the lookup array. When I moved the ID number to the first column, my VLOOKUP worked! Where does it say that that is a requirement? -- Carl Paulsen Dover, NH 03820 -- 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] Calc: help with VLOOKUP
: A. Name B. Price (ignorable as far as this example is concerned) C. ID number Sheet 2 has three columns as follows: A. Item Code B. Item description C. Minimum bid (ignorable as far as this example is concerned) The operator will be given a piece of paper with an Item code, an ID number and a price. I would like him to be able to look up an Item code in Sheet 2 and then, in that row, enter the ID number (column D?). A VLOOKUP formula would paste the Name into an available column (E?) and the operator would enter the price into the next column (F?). Where do I type the =VLOOKUP formula? Can I save the sheet with the formula so I can set this strategy up ahead of time? How do I get the formula to apply properly to every row? What should the initial formula look like? Thank you. -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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] Calc: help with VLOOKUP
Hmmm. Formatting leaves a little to be desired. Let's see: 1st sheet: Database looks like this: Sheet 1: ID Name Price ID 1Shirt 6 1 2Pants 5 2 3Hat3 3 4Gloves 2 4 Sheet 2: Code Description Min. Bid 3 ;lkajsdfk ;aljsdf 2 3 ;lkjdf 2 4 ;akldjf ;laksf ;alskdfj1 2 oisel 3 1;lakjsdf 4 1 woe 4 4 ldklw 1 Sheet 2 would look like: CodeDescriptionMin. Bid Item Name 3 ;lkajsdfk ;aljsdf 2 Hat 3;lkjdf 2 Hat 4;akldjf ;laksf ;alskdfj 1 Gloves 2 oisel 3 Pants 1 ;lakjsdf4 Shirt 1 woe 4 Shirt 4 ldklw 1 Gloves Final sheet: CodeDescriptionMin. BidItem Name 3 ;lkajsdfk ;aljsdf 2 Hat 3;lkjdf 2 Hat 4;akldjf ;laksf ;alskdfj 1 Gloves 2 oisel 3Pants 1 ;lakjsdf4 Shirt 1 woe 4 Shirt 4 ldklw 1 Gloves 3 Hat 4 Gloves 4 Gloves 4 Gloves 1 Shirt #N/A #N/A #N/A HTH clarify. Again, I can post this if it helps. Carl On 2/10/14 10:07 PM, Carl Paulsen wrote: OK, the item that you want to look up to return the price or name needs to be in both spreadsheets (otherwise you won't find a match!). IF (big IF here) the ID# and item code are the same for each item, then this could be done as follows: Database looks like this: Sheet 1: ID Name Price ID 1 Shirt 6 1 2 Pants 5 2 3 Hat 3 3 4 Gloves 2 4 Sheet 2: Code Description Min. Bid 3 ;lkajsdfk ;aljsdf 2 3 ;lkjdf 2 4 ;akldjf ;laksf ;alskdfj 1 2 oisel 3 1 ;lakjsdf 4 1 woe 4 4 ldklw 1 (Gibberish was intentional. I didn't want to bother with actual descriptions.) In this case, take the code you're given (3 in the first line, sheet 2) and look up the value in sheet 1 (in this case it would be Hat). To do this: Sheet 2, add the following column in D: =VLOOKUP(A2,Sheet1.$A$1:$D$5,2,0) copy and paste this formula as far down the sheet as you need to. Note the dollar symbol is needed to create a static reference to the array that you are looking at for the lookup. Otherwise it starts at the row you're looking at and goes down from there, meaning eventually you'll almost certainly NOT find a match. The lookup value (A2 in the first cell of D2) will change for each row the formula is pasted into. Final sheet 2 would look like this: Code Description Min. Bid Item Name 3 ;lkajsdfk ;aljsdf 2 Hat 3 ;lkjdf 2 Hat 4 ;akldjf ;laksf ;alskdfj 1 Gloves 2 oisel 3 Pants 1 ;lakjsdf 4 Shirt 1 woe 4 Shirt 4 ldklw 1 Gloves In Column D, you would see the item name returned, but the actual contents of that column would be the formula above, with the first part after the vlookup (A2) changing with each row from A2 to A3, A4, A5, A6, A7 and A8. What this does is looks up whatever is in A1 and returns the name based on what it matches for ID in sheet 1. Read carefully and I think you'll eventually get it. It can be confusing, but it makes sense if you're careful to follow the logic. Now, after the 7 lines of sample data above, I copied and pasted the vlookup formula into the rest of Column D (as far as you think you need to go). That's the setup. After that, when a number (from 1-4 for the item ID in sheet 1) is typed into column A, an item name is returned in Column D. I typed a bunch of numbers into Column A to illustrate below. See: Code Description Min. Bid Item Name 3 ;lkajsdfk ;aljsdf 2 Hat 3 ;lkjdf 2 Hat 4 ;akldjf ;laksf ;alskdfj 1 Gloves 2 oisel 3 Pants 1 ;lakjsdf 4 Shirt 1 woe 4 Shirt 4 ldklw 1 Gloves 3 Hat 4 Gloves 4 -- Carl Paulsen Dover, NH 03820 -- 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
[libreoffice-users] MS Office woes
Just a rant here from someone who is reasonably sophisticated at both LO/OO and MS Office. I've had to use MS Office for work lately, and I've run into a TON of frustrations. Biggest recent frustrations: 1. The auto-fill and other aides in MSO make it much HARDER to construct formula fields in Excel. And if I get a formula wrong, it won't let me leave it in the cell for later troubleshooting (with a #NA value as LO/OO does). I have to either fix it or erase it. But what if I can't fix it before I have to move on to other things? 2. The smart text select system, which tries to anticipate what you want to select, forces me to select the period of the previous sentence when trying to move a sentence to a new location. I used to be able to de-select the period by selecting the text from the end to the beginning, then moving the cursor back off of the period toward the sentence I want to move. Not working right now. 3. Biggest frustration (and I've heard talk of this but not experienced it until last few days) - I've been saving a ton of small spreadsheets as CSV to move into a database that requires CSV file types. But if I have to open them to re-edit, about half of them say they are the wrong file type (extension is .csv, but Excel thinks they are SYLK). They open fine, but Excel, which moments before had saved the file as CSV, now thinks it's SYLK. HTF does excel NOT know its own file type? Rant done. Just thought I'd share specific frustrations with LO users. To be fair, there are a few minor things I've appreciated in MSO, but the frustrations are legion. -- Carl Paulsen Dover, NH 03820 -- 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] MS Office woes
On 2/7/14 4:24 PM, anne-ology wrote: Can you go into the properties to turn off the auto-fills? - that's always been my solution. True enough. But my point is it's set up to work oddly. 1. The auto-fill and other aides in MSO make it much HARDER to construct formula fields in Excel. [if you're able to turn off those 'auto's then you should be able to work as you desire] Actually, it's more than the auto-fill. The biggest problem is that if the formula doesn't meet MSO's standards, you can't leave it in place to work on later. I've had formulas which took me days to work out, and if I can't leave them in place even when faulty, then I have to re-create them each time. When they are so terribly long, with many layers of nested functions, losing them is a disaster. Yet Excel prevents you from saving them unless they work. BAH! 2. The smart text select system, [I'm not sure I understand but if you're attempting to copy, or move, then paste elsewhere, then there must be a 'bug' in the system ;-) ] It's a bit specific, and not a bug (it has behaved this way for many releases and is, I think, intended as a function, though it acts more like a bug to me). Yes, it's copy and move. Take this paragraph text and copy to MSO. Then highlight one sentence from before the first letter to the last. It will highlight not just the sentence intended, but also the proceeding period. At least that's how it works with my two-spaces between sentence style (which is the original standard for all typing, which MSO has chosen to dictate is no longer necessary, but which really does help to define sentence and paragraph structure IMHO). 3. Biggest frustration (and I've heard talk of this but not experienced it until last few days) - I've been saving a ton of small spreadsheets as CSV to move into a database that requires CSV file types. But if I have to open them to re-edit, about half of them say they are the wrong file type (extension is .csv, but Excel thinks they are SYLK). They open fine, but Excel, which moments before had saved the file as CSV, now thinks it's SYLK. HTF does excel NOT know its own file type? [haven't a clue here] Yes, and that's the point. Excel apparently hasn't a clue either. Take a spreadsheet file, save as CSV (the Excel version, not the plain text or Mac version), then open again with Excel. Roughly 50% of the times Excel fails to open these. I don't have a clue what's going on, but it seems like Excel should understand the format that it just saved the file to, so that it can re-open it. Especially for something as simple as a CSV file. Note too that I tried to open another CSV file today, slightly different situation, and Excel chose to ignore the CSV format and open it as if it were one column/field of data, ignoring the commas and quotes delineating the different fields. Rant done. Just thought I'd share specific frustrations with LO users. To be fair, there are a few minor things I've appreciated in MSO, but the frustrations are legion. Dover, NH 03820 [very pretty area - especially in the colourful fall] Indeed! SNOWY and cold now though (which is good if you're willing to get out in it as I am). -- Carl Paulsen Dover, NH 03820 -- 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] MS Office woes
OK, to this and other recent posts, please note that my intent wasn't to open a rant-fest. I have found myself wondering about the claims about file structure being a problem even for MSO itself. My original post was intended to provide one example of a case where Excel saved a specific file but then couldn't re-open it without throwing a warning (unusual enough that some users might well panic about it). That plus a few other specific issues I've encountered that make me like LO/OO even more than I did before. While I've read about the issue of the OpenXML standard issues, I hadn't experienced it yet, nor have I read of specific cases where someone had that experience (and I don't mean second hand or less). If anyone wants to add to this, may I humbly suggest you provide specific examples of issues _you've_ had (not that you've read or heard about). E.g., I saved a file as CSV, and within 5 minutes tried to reopen it but Excel failed to do so. It gave me the following error: That provides a specific situation that others can test. The more specific the better. But to say the open XML standard changes so that Excel can't open it just doesn't translate to the general user, even if it IS true. Again, specific examples help. Carl On 2/7/14 10:47 PM, null wrote: Hello, I thought I should add to the rant: If you think Microsoft Excel not being able to import formats it exports is bad, consider Microsoft's disastrous OpenXML standards. Notice I said standards, not standard. .docx, .pptx, and other files with x at the end are stored in the Microsoft OpenXML format. There are three different standards--for the same file type! Depending on the operating system and Microsoft Office version, a different XML standard is used. This can cause a .docx file, for example, not to render correctly in Microsoft Word 2013 if it were saved using 2010; even the operating system is a factor in which XML standard is used. So, sometimes, Microsoft Office can't open Microsoft Office files. Not to mention the extra features that don't work, no one uses, and takes up valuable disk space, such as PDF Reflow. When will Microsoft realize that you can't reflow a PDF? The implementation for each OpenXML standard is nearly 6,000 pages long! So, it really doesn't do what Microsoft said it would do; they made the system so complex to try to force more people to using Microsoft Office, and now their products can't read files. Regards, xmlhttprequest.o...@gmail.com -- Carl Paulsen Dover, NH 03820 -- 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] MS Office woes
I suppose you're right. With some work I could have found a workaround, and I appreciate your idea. My issue is much more about the way MSO is set up by default, and changes to that are not especially apparent. But your point is well taken. Carl On 2/7/14 11:26 PM, marianne-x wrote: On 2/7/2014 9:10 PM, Carl Paulsen wrote: The biggest problem is that if the formula doesn't meet MSO's standards, you can't leave it in place to work on later. I've had formulas which took me days to work out, and if I can't leave them in place even when faulty, then I have to re-create them each time. When they are so terribly long, with many layers of nested functions, losing them is a disaster. Yet Excel prevents you from saving them unless they work. BAH! I have no experience with M$O specifically, and have no interest in making excuses for its failings, but with those s.sheets that I do use, all you have to do in this situation is put a quote at the start of the formula, thereby making it text. The formula should then be preserved as text, and can be saved as such, until you want to work on it again; removing the quote makes it back into formula. Isn't that a reasonable work-around for their unreasonable default action? -- Carl Paulsen Dover, NH 03820 -- 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] Need help with a calculation for an auction
Let's not forget the Pivot Table option, though I know that wasn't the option you were thinking of. On 2/6/14 5:17 PM, Paul wrote: I seem to recall your question, and I think you're looking for Subtotals under the Data menu. 1. Sort by name 2. Subtotals on the Data menu Paul On Thu, 06 Feb 2014 17:04:15 -0500 Pikov Andropov piko...@gmail.com wrote: I thought I had posted this earlier today but as it hasn't shown up, I must have hit the wrong button! Someone had an elegant solution to this problem but I've lost it. I have a spreadsheet with the following columns: Name, Amount, Item #, Description. It's for an auction. When the auction is over and all data has been entered, the cashier needs to tally the amount each person owes. My wife came up with this: 1. Sort on Name 2. Manually insert an empty row after each name group. 3. For each person, swipe from the top entry in Amount to that person's last entry. 4. Click SIGMA The total for that person will appear in the Amount column in the heretofore empty row under that person's name group. The solution I lost did all the calculations at once. Sound familiar? Thanks. -- 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
Fwd: Re: [libreoffice-users] Calc question
Dang, I hate the new list behavior of replying to the sender instead of the list. Can't that be changed back? My reply below, sent only to Alan B by mistake. Original Message Subject:Re: [libreoffice-users] Calc question Date: Fri, 24 Jan 2014 07:50:14 -0500 From: Carl Paulsen carlpaul...@comcast.net Reply-To: cpaul...@alumni.middlebury.edu To: Alan B abo...@gmail.com Isn't this the role of the pivot table? That could provide a total for both number (of purchases) and total of price if set up correctly. Maybe I'm missing something here though. Carl On 1/23/14 9:58 PM, Alan B wrote: On Thu, Jan 23, 2014 at 9:28 PM, Pikov Andropovpiko...@gmail.com wrote: Next to each buyer will be a price. How do I total the amount of a buyer's purchase on the fly, so-to-speak? Have labels at the top of each column such as Buyer and Price. Once you're ready to get your totals by buyer 1) sort by buyer as you intend 2) select the entire data range including the column labels 3) from the menu select Data | Subtotals... 4) in the Subtotals dialog box make sure the Group by option is Buyer 5) tick the Price check box in the Calculate subtotals for list 6) confirm Sum is the selected function in the Use function list 7) click the OK button You'll be back to your spreadsheet with subtotals for each Buyer inserted. Plus to the left of the row numbers you'll see outline features that allow hiding and showing the various subtotaled rows. -Alan -- Carl Paulsen Dover, NH 03820 -- 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: Fwd: Re: [libreoffice-users] Calc question
You might have a look at this video here: http://www.youtube.com/watch?v=Qo0GoudZ01M No association with the user. Note that he uses the term Data Pilot instead of Pivot Table, but they are essentially the same thing. Earlier versions of LibreOffice used Data Pilot as the term for Pivot Table. Carl On 1/24/14 11:53 AM, Pikov Andropov wrote: What's a pivot table? Pointers to introductory tutorials will be appreciated. Thanks. Original Message Subject:Re: [libreoffice-users] Calc question Date: Fri, 24 Jan 2014 07:50:14 -0500 From: Carl Paulsen carlpaul...@comcast.net Reply-To: cpaul...@alumni.middlebury.edu To: Alan B abo...@gmail.com Isn't this the role of the pivot table? That could provide a total for both number (of purchases) and total of price if set up correctly. Maybe I'm missing something here though. Carl -- Carl Paulsen Dover, NH 03820 -- 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] Help needed with LibreOffice Calc 4.1.3.2
Hi Tom, You can try View-Value Highlighting for the email column. That works on my Mac running LO 4.1.4. But it still leaves the gray cell background fill. As for gridlines, I don't know if that can be done. Carl As for the gridlines, On 1/20/14 9:29 PM, Tom Williams wrote: Hi! This is my first time posting to the mailing list. :) A client of mine is in need of editing some Excel spreadsheets on her shiny new Windows 8 system. I installed LibreOffice 4.1.3 and it mostly works but she's not able to do some of the things she used to do with MS Excel 2000. Primarily, she wants to be able to change the color of hyperlinks of email addresses. In MS Excel 2000, she could simply select the column of email addresses and change the color to black or any other color and the color of the links changes. In Calc, we select the column of email address and change the text color to black and the hyperlinks remain blue. I did some web searching and found I needed to edit the hyperlink style, but that appears to be only for cells that use the HYPERLINK formula (if that's what it's called) and not on cells that have email addresses listed that aren't using HYPERLINK syntax. I have a test Excel spreadsheet (generated with MS Excel 2000) I can send, if necessary. Any ideas on how I can get the color of the email address links to change color? She would like to preserve the links, in the spreadsheet, as she'll occasionally click them to send messages from Mozilla Thunderbird. Also, is it possible to adjust the thickness of grid lines shown in a spreadsheet, if we enable display of grid lines? Thanks in advance! Peace... Tom -- Carl Paulsen Dover, NH 03820 -- 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: Connection to SQL database
Thanks yet again, Alex. A couple of things. First I don't have access to the server from which the file originated. So I've set up both MySQL/Server and XAMP on my Windows machine hoping to get one to work for me. I've used PHPMyAdmin before so I thought that would be best, but I can't get it to start. Unfortunately, I can't get Workbench to work either, in part b/c I don't understand it. I'm trying to load the database there (actually, working on the World sample database first), but can't seem to figure that out. Do I simply load the database, import it, reverse engineer it to create a schema, create a new schema or database and import into it, etc. etc.? Create a server connection? But don't I have to create the connection first? When I try that I get a failed to connect 10061 error. As you can see, it's a bit opaque to me. BTW, I tried your command at the command prompt but get a response about the command not being interpretable or something like that. But I just read that I maybe need to start the server and get to a mysql prompt??? Basically, I'm at a huge disadvantage b/c I don't understand ANY of the terms or tools. I'm watching a ton of videos and reading a ton of material. But being someone who has done a lot of teaching/tutoring, I have to say no one out there seems to know how to assume a user knows nothing but is still capable of learning. Too much is assumed in all the materials I find. Thankfully, I'm bright enough to plow my way through this and figure it out, but it will take a LONG time. Plus, my Workbench looks nothing like what is shown in the materials I've seen. In short, I'm trying b. because I can't do the programming without learning yet another tool and don't want to continue chasing after possible tools that end up not working. But at this point, I haven't been able to get the SQL server to load/clone the database (see my confusion above). I appreciate the link you sent re: importing. If I can get PHPMyAdmin to start I think I can do this. In XAMP all I get is a control panel that lets me start Apache and MySQL but there's no PHPMyAdmin option available and no apparent way to launch it from the start button. I'm reinstalling now in case I screwed up the first installation. I hope that works. Cheers, Carl On 1/17/14 5:55 AM, Alex Thurgood wrote: Le 16/01/2014 14:45, Carl Paulsen a écrit : Hi Carl, Let's start at the source... You have access to a file containing DDL (data definition language) and DML (data manipulation language). This file has the extension .sql. Essentially, this file is a kind of dump from the mysql/mariadb database. The dump includes instructions about the database name or schema, the tables in the database, and the field types, as well as the corresponding statements that would allow you to insert that data into a corresponding mysql database server hosted elsewhere. First things first : - can you gain query access to the mysql/mariadb server from which the sql file originates ? If you can, then you should be able to export your data directly in CSV format, by querying the database and using the SELECT...INTO OUTFILE command, or an equivalent GUI function from an appropriate program (e.g. phpmyadmin, MySQL Query Browser, MySQL Navigator, Navicat, etc, etc) - if you do not have query access to the source of the data, then you are effectively reliant on the SQL file that you have been given. This means that you have several other ways of dealing with the data contained therein : (a) as it is a text file, you could use a script of your own making or if lucky, trawl for one on the net, to extract the data and output that to a CSV, Excel or other text-based file type of your choice - various languages are capable of this, Ruby, Python, Perl, PHP, etc, or you could probably even use bash/sed/awk ; (b) host the data on a locally accessible mysql server - to do that you would need to install mysql server and client programs. If console commands are not your thing, then you could use LO Base to connect, via one of the connector methods (extension, jdbc or odbc), to the mysql hosted database. The advantage of (b) is that you can do most of the work via the LO Base UI, once the connection to the mysql database has been set up and the data imported. Another advantage of solution (b) is that you can tailor your output via the GUI tools of LO Base, so that it meets the requirements of your Salesforce input. The advantage of (a) is that it operates directly on the content of your SQL file without having to go through the rigmarole of setting up a mysql server, but at the expense of having to learn how to manipulate text data. Note that solution (a) works well for data that is just text or numbers, but not so well for binary encoded data (although I imagine that solutions to handle this are also available). This means that you need to know what kind of data you are going to have to manage
Re: [libreoffice-users] Re: Connection to SQL database
Update: Thanks everyone for your help. I finally figured out how to access phpMyAdmin and then figured out how to import the data file properly. I then encountered lots of errors trying to export it but ultimately figured out a workaround. All seems to be fine now with a 13MB file, but next I've been given a 250MB file to open then export! In any case, it ended up being easier to just work within MySQL and phpMyAdmin for this purpose, but I'll try to use Base to connect over the weekend just to learn it. Anyway, thanks again, especially to Alex and Jay. Carl On 1/17/14 1:19 PM, Carl Paulsen wrote: Thanks yet again, Alex. A couple of things. First I don't have access to the server from which the file originated. So I've set up both MySQL/Server and XAMP on my Windows machine hoping to get one to work for me. I've used PHPMyAdmin before so I thought that would be best, but I can't get it to start. Unfortunately, I can't get Workbench to work either, in part b/c I don't understand it. I'm trying to load the database there (actually, working on the World sample database first), but can't seem to figure that out. Do I simply load the database, import it, reverse engineer it to create a schema, create a new schema or database and import into it, etc. etc.? Create a server connection? But don't I have to create the connection first? When I try that I get a failed to connect 10061 error. As you can see, it's a bit opaque to me. BTW, I tried your command at the command prompt but get a response about the command not being interpretable or something like that. But I just read that I maybe need to start the server and get to a mysql prompt??? -- Carl Paulsen Dover, NH 03820 -- 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: Connection to SQL database
snapshot to rescue data from a sinking Cloud then none of that is a worry and the single export routes are perfect So it's really route 1 that i'm curious about and really in a yes/no way rather than in any detail. Carl doesn't seem to be thinking along those lines so this is a bit of a tangent that will probably crop up again in a future thread and be more relevant then. Regards from Tom :) -- Carl Paulsen Dover, NH 03820 -- 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] Connection to SQL database
I have a project for which I need to extract data that is in a .sql file (presumably a SQL database). I've done very little with SQL so I need some guidance on doing this. One route would be to open it with Base or Access (I now finally have access to MSAccess on a Windows machine but would prefer Base), but I don't understand the basics of doing this. So...can someone point me to a tutorial on how to do this, step-by-step and from the very beginning? For instance, do I need to set up a SQL server and if so, how? (I've tried installing XAMP with MySQL on the Windows machine but haven't gotten it to connect to the file yet.) Can I access a .sql file directly or via other methods? I'd like to eventually learn how to use SQL but I'm also on a pretty limited timeframe on accessing this data. Or does someone want to outline the steps here for me to research on my own? Thanks very much, Carl -- Carl Paulsen Dover, NH 03820 -- 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] Connection to SQL database
Thanks, Jay, that is VERY helpful and clarifies a lot. I wondered if I needed the server setup but lots of things I read yesterday suggested I did need that. I do understand that things like Base and Access are just GUIs, but I guess I really just don't understand what a database is and, in particular, what SQL is. I know there needs to be raw data and a file/table structure and I assume a way to interact with it, but I'm still missing a lot. Is there a basic online reference to help me understand what a SQL database is and what MySQL and the rest are relative to that? Thx, Carl On 1/15/14 12:11 PM, Jay Lozier wrote: Carl Backend is a database term that refers to the database itself such as MySQL, JET (MS Access), SQL Server, etc. Most non DBA's refer to the GUI tools (BASE, Access) as the database when in fact they are used to connect various backends. Base and Access both can connect to the variety of backends not just the default they are shipped with. I do not think you need XAMP just the database connector and database. XAMP refers to X = OS, A = Apache server, M = MySQL, and P = Perl/Python/PHP. It is normally used by developers and the reason for the Apache server is to provide test for web connectivity. PHP is a very common server scripting language used by many websites. For Windows is sometimes called WAMP, Mac - MAMP, and Linux - LAMP. I use MySQL for database development and do not use LAMP (Linux user) at all because I only need the database. Jay On 01/15/2014 11:55 AM, Carl Paulsen wrote: OK, thanks everyone. My system: Mac: OS 10.6.8 and LO 4.0.4.2 (I was thinking of upgrading to LO 4.1.4) PC: Win7 and OOo 3.2 (I could install any version of LO on the PC) I'm pretty far over my head here based on how little I understand of the replies, but I'm sure I can do it if I persist. Here's what I think I'm hearing so far: 1. Lots of talk about the backend. I thought the file I had was the data itself which I'd hoped I could somehow directly access, but even if it were the data, it sounds like at best I'd have to serve that file/data using MySQL or something like that and a server like XAMP, then connect via Base. Right? In which case I might be able to extract the data directly from the server? 2. Ryan may be right, I think what I have is a so-called backup from a commercial fundraising database used by a non-profit I'm working with. Perhaps it's just scripts that connect to a hosted database? How do I execute my .sql file on a MySQL server (which I've set up on my Win7 machine)? I am assuming I can get XAMP to serve up MySQL on the Win7 machine... Ryan, can I contact you off-list if I figure out how to set up the MySQL server? 3. I assume I'll need a password/login credentials, but can get them if I need them. I'm sure the data is in schema of some sort. 4. Thanks for the reference Fernand. Cheers, Carl -- Carl Paulsen Dover, NH 03820 -- 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] Connection to SQL database
Thanks again, Jay. Because of my long-time familiarity with Filemaker, Access, Salesforce (and Base soon I hope), I'm well aware of the structure of a relational database. And I'm pretty sophisticated user and even developer so long as the backend is hidden from me (LOL). Now I have this file I need to open and examine, and then move into separate tables/csv files to eventually move into Salesforce. The file came from a proprietary online database system (I'm not sure what) as a backup. And you are correct, the structure is almost certainly similar to what you outline (e.g. name/contact table, donations table, perhaps a volunteer actions table, etc. all with various keys to connect). But...I don't know just what tables are there, what field/columns are there, whether there's any consistency in data entry, and the like. All of this needs to be mapped into appropriate fields in the Salesforce system. I need to see the data and edit it (adding fields, splitting data up, etc.) in order to plan and prepare for the move, and then extract it into a csv file (the only file type that Salesforce will accept as a source). Thanks to Alex's suggestion, I've learned that the file contains table structure info (table name, column names and types, Key field assignments, etc.) with the actual data for each table included (comma separated I think). I suspect the file is sufficient to construct a SQL database that will contain all of the organization's data, either in MySQL or in Base or Access. But I need to figure out how to do that in such a way that I can assess what data is there and export into a csv file. Thanks again. Any more help is always appreciated. Carl On 1/15/14 2:43 PM, Jay Lozier wrote: Carl SQL is the query language used by relational databases and there is ANSI/ISO standard specification for the SQL. So, in principle, any relational database should understand vanilla SQL. Generally, this is true. HSQL (Base backend), Jet (Access), Oracle, MySQL/MariaDB, PostgreSQL, and SQL Server are all relational databases and they all use SQL as their query language. The only warning is all the database providers have added extensions to the SQL language. The GUIs used by Base and Access tend to hide the SQL query from the user. Some of the other tools such as PgAdmin (PostgreSQL) or MySQL Workbench generally require you to write the SQL query in an editor. But these tools allow to use a GUI to access most of the database functions. The database is program for storing and accessing data that has some sort of structure. In a relational database, the data is organized in tables that consist of rows (specific data) and columns (data types). To keep the data manageable, the data is usually broken up across a series of related tables with defined relations between the tables defined (the data in a specific row in Table A is related to the data in specific row in Table B). In relational database each column has specific data type (number, string, date, etc.). Your raw data, say for a donor, would consist of name, address, contact information, pledge amount, payments, etc. You would probably split the data into two or more tables. One table would have the donor name, address, and contact information. Another table might have a record of contacts including type, date, result. A third table might have a detail record of payments/donations with date and amounts. To relate each table, each table would likely have a primary key assigned for each entry with appropriate foreign keys (keys that refer to an entry in another table) included as well as the data specific to the table. A query would use these keys to get the data and combine it into a result set. The data design is based on the principle of entry data only once into the database (called normalization). So you would only have one table with the donor's name entered while the other tables that would refer to the entry would was the entry's primary key to refer to it. Often integers are used as primary keys because they are easy to deal with and increment nicely. The only requirement for a primary key is that is unique to the table. If you are using MySQL or MariaDB (MariaDB is a MySQL fork) a pretty good book specific to that family is MariaDB: A Crash Course by Ben Forta. It covers basic SQL, basic database design, etc. Jay On 01/15/2014 01:34 PM, Carl Paulsen wrote: Thanks, Jay, that is VERY helpful and clarifies a lot. I wondered if I needed the server setup but lots of things I read yesterday suggested I did need that. I do understand that things like Base and Access are just GUIs, but I guess I really just don't understand what a database is and, in particular, what SQL is. I know there needs to be raw data and a file/table structure and I assume a way to interact with it, but I'm still missing a lot. Is there a basic online reference to help me understand what a SQL
Re: [libreoffice-users] Re: Connection to SQL database
Sent to just Alex T by mistake: On 1/15/14 1:41 PM, Carl Paulsen wrote: OK, this is VERY helpful. I decided to try reading the file in a text editor and that was instructive! The file is about 13MB, and from a quick read through, the vast majority seems to be actual data in a kind of comma-delimited form. First part seems to be instructions for setting up the tables including keys and fields/columns, etc. I don't pretend to understand a lot of it, but I think I get the basics. So... Given it has instructions for table setup and raw data in it, how do I open it in LO? Or would I be better off moving to MySQL or something else and trying that? Is there usually info in the file about which db engine produced the file, or is there any other way to determine that? Maybe I'll just see if I can open it directly in LO and hope for the best. If you have other thoughts, though, I'd be grateful to hear them. Cheers again, Carl On 1/15/14 12:57 PM, Alex Thurgood wrote: Le 15/01/2014 16:51, Carl Paulsen a écrit : Hi Carl, An SQL file does not necessarily need to contain data, it could contain just a set of instructions for the database engine to execute. The SQL file is not a database as such, it is a generally text file containing instructions that a SQL db engine will understand and optionally data enclosed within INSERT statements. If your SQL file contains both data and instructions, it would be a good idea to know how it was produced, i.e. from which db engine the output came, as SQL dialects between different vendors, db engines etc, can differ according to their specific implementations of the SQL standards. The file itself should be loadable into any text editor, providing that it can handle the size of the file ! That can give you a better idea of what's inside. For example, it is all very well having just insert statements with associated data in a SQL file, but if the tables and db haven't been set up in advance, you won't be able to get very far with it. Some of those SQL statements might be directly executable from an empty LO Base file in the Tools SQL window, e.g. table creation statements, key definition statements, constraints, etc, but again that would depend on whether these statements were supported by the version of hsqldb that comes with a default embedded ODB database file. Alex -- Carl Paulsen Dover, NH 03820 -- 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: Connection to SQL database
Below is an excerpt from the file referring to the donations_money table. Obviously there are some ID fields, donation info fields (Amount, Date, etc.), a primary key field, etc. Immediately after the table, there's the dump of all the data in that table. I've only included one or two records from the dump, but there are many hundreds or even thousands of records. There are quite a few tables in the file, many of which we don't need (past logins under the old system, for example). Any wisdom on how to convert this data into CSV files? I thought I'd need to either open it with MySQL or connect to it via Base. If I could convert it to CSV, I can do any cleanup and prep work in Calc or some other tool I'm more familiar with. Thanks again, everyone! Excerpt: -- Table structure for table `donation_money` -- DROP TABLE IF EXISTS `donation_money`; CREATE TABLE `donation_money` ( `dm_id` mediumint(9) NOT NULL auto_increment, `dm_resource_id` mediumint(9) default NULL, `dm_promise_id` mediumint(9) default '0', `dm_date` date default NULL, `dm_amount` float(10,2) default NULL, `dm_receipt_number` varchar(15) default NULL, `dm_donation_code` varchar(15) default NULL, `dm_appeal_code` varchar(15) default 'NONE', `dm_payment_code` enum('CHE','CRD','CAS','ACH','STK','PAY','INK','OTH') default NULL, `dm_mem_hon` enum('NUL','MEM','HON') default NULL, `dm_mem_hon_who` varchar(40) default NULL, `dm_foundation_code` varchar(15) default 'NONE', `dm_in_kind_desc` varchar(60) default NULL, `dm_comment` varchar(255) default NULL, `dm_send_thank_you` tinyint(1) default '1', `dm_in_thank_you_set` tinyint(1) default '0', `dm_from_distribution_id` mediumint(9) default '0', `dm_user_field1` varchar(50) default NULL, `dm_created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `dm_created_by` varchar(15) default NULL, `dm_modified` timestamp NOT NULL default '-00-00 00:00:00', `dm_modified_by` varchar(15) default NULL, PRIMARY KEY (`dm_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `donation_money` -- /*!4 ALTER TABLE `donation_money` DISABLE KEYS */; LOCK TABLES `donation_money` WRITE; INSERT INTO `donation_money` (`dm_id`, `dm_resource_id`, `dm_promise_id`, `dm_date`, `dm_amount`, `dm_receipt_number`, `dm_donation_code`, `dm_appeal_code`, `dm_payment_code`, `dm_mem_hon`, `dm_mem_hon_who`, `dm_foundation_code`, `dm_in_kind_desc`, `dm_comment`, `dm_send_thank_you`, `dm_in_thank_you_set`, `dm_from_distribution_id`, `dm_user_field1`, `dm_created`, `dm_created_by`, `dm_modified`, `dm_modified_by`) VALUES (1,467,NULL,'2008-05-12',60.00,'03718C','MEMBERSHIP0','NONE','CRD','NUL','','NONE','','',1,1,NULL,NULL,'2008-05-14 15:39:14','jessi','2008-08-07 17:17:40','george'),(2,467,NULL,'2007-06-11',35.00,'04379C','MEMBERSHIP0','NONE','CRD','NUL','','NONE','','', -- Carl Paulsen Dover, NH 03820 -- 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] Auto save didn't work?
I'm using LO 4.0.4.2 on a Mac running 10.6.8 My son was working on a Writer doc for school, had made some big changes without saving, then the laptop ran out of juice and crashed. Autosave was set to 15 minutes but the majority of his changes had been made well over 15 minutes before the crash. When we rebooted I assured him his changes would be saved, but upon opening and recovering the files, we were back where we started as if it hadn't saved since we'd opened the file (it had been created the day before). That was probably 45 minutes to an hour of work. He learned an important lesson but... Can anyone hazard a guess at why LO would have failed to autosave? It's never failed to autosave before, and autosave has saved my keester on several occasions. But now I'm wondering if it's entirely reliable (not that autosave excuses me from manually saving my documents). -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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] Counting Instances
+1 That's how I'd do it. On 12/29/13 5:51 PM, Regina Henschel wrote: Hi Keith, Keith Bates schrieb: Hi everyone, I've used Libre Office for years, but I am an absolute newbie as far as Calc is concerned for anything but the very basics. :) Here is my problem. My church has to report to the copyright licence holders the names of the songs it uses and the number of times each song is used in a given time period. The software we use for projecting the words for songs (OpenLP) will produce the name of each song used in each service. It will generate a CSV Obviously it is easy enough to import that into a spreadsheet. How can I then count the number of times each song is used? I could sort the table by song title and then count them manually, but I am guessing there would be some sort of function that automates the counting. Thanks for any help on this. Import the csv data into the spreadsheet. Define a data range for this data including the field names. Generate a pivot table from it this way: - drag the field name of the song title to the Row Fields - drag the same field name to the Data Fields. - Double click the field name button in the Data Fields area and change the function from sum to count. OK Using a pivot table has the advantage, that you do not need to know beforehand, which song titles are contained in the list. Kind regards Regina -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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] Multi-test IF statement in Calc
I'm trying to build an IF statement that tests if a condition exists in two columns, and assigns the number 1 if it does, and 0 if not. The columns being checked are vLookups which return #NA if an ID is not found in another table. I'm trying to search for cases where an ID# IS returned in two columns meaning the record shows up in both tables. I can't figure out the syntax for this. I've tried IF(AND(A1#NA; B1#NA),1,0) on both the vlookup formula columns and on columns that are pasted without formulas. No luck yet. Can someone chime in on this? Many thanks in advance. -- Carl Paulsen Dover, NH 03820 -- 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] Grouping objects in Draw
I have 3 objects I'd like to combine in Draw (one background image, another image over a portion of the background and one text block also over the background). I'd like to somehow combine them into one object (used to be done by grouping them) that I can then copy and paste elsewhere and re-size as needed without having to separately resize each object. I can't seem to make this happen. I can't seem to select each object so as to group them. I was able to select the background object (which extends beyond the edges of the other two objects) and selected Modify-Group, and they all seemed to become a part of some kind of group. I can then copy and paste that group, but I can't re-size the group as a whole. I essentially want to group each object into one so that it gets treated as if it were one object, not three. Can anyone help? Thanks, -- Carl Paulsen Dover, NH 03820 -- 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] Mail merge manual field entry
Thanks, Tom. I've been away for a while. These links are handy, but on a quick look don't answer my questions. But...I'll keep looking. Carl On 8/17/13 6:27 AM, Tom Davies wrote: Hi :) I am not certain how to do this but it 'should' be fairly easy. it probably isn't but it should be. I am not sure if it makes a difference but do you happen to know the name of the back-end used by Salesforce? Is it MySql? There are some tutorials on using Base which might (or might not) help http://www.spoken-tutorial.org/list_videos?view=1foss=LibreOffice-Suite-Baselanguage=English also a handbook https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook and an FAQ https://wiki.documentfoundation.org/Faq/Base Hopefully someone on this list can either help directly or pinpoint more specific links found through the above or from elsewhere. Good luck and regards from Tom :) From: Carl Paulsen carlpaul...@comcast.net To: users@global.libreoffice.org users@global.libreoffice.org Sent: Monday, 12 August 2013, 23:22 Subject: Re: [libreoffice-users] Mail merge manual field entry A related question, which may help me figure out what I need, is how does one manually work through a mail merge? I only see the wizard, but what if I've already created a document and just want to change a few fields? I don't want to have to enter a wizard and work through the entire thing just to edit that document. That function might also allow me to hand-enter field names for this merge document. Carl On 8/12/13 4:12 PM, Carl Paulsen wrote: Hi all, I need to create a mail merge that will, I hope, be used with Salesforce for mail merge communications. I need to create a document with manually entered merge fields where the source database has not (and probably can not - at least with my current skills) be registered with LibreOffice. Salesforce is a web-based database service that has strict limits on connections outside of web browsers. In short, what I'd like to do is create mailing labels, type in the merge fields as they need to be typed (to work with Salesforce), then save and upload the document. I can't find any way to do this. Is there a way? Also, Salesforce provides some templates for the merges and I can see what I need to do, but the fields they provide in their templates are not relevant to what I need, and I can't replace their merge fields with the ones I do need. Thanks. -- Carl Paulsen Dover, NH 03820 -- 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 -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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: Mail merge manual field entry
Thank you Alex. I'll give your ideas some thought. The key issue for me is that I can manually enter placeholders for fields as text that Salesforce can interpret for the merge on their platform (well, I think I can but haven't been able to test it yet). What I can't do is enter any LO commands that trigger a next record or next page that Salesforce can interpret. All that said, I still don't really understand how LO handles mail merges and it seems to be tailored to those who want to generate merges with a Calc spreadsheet (even that should be simpler IMHO) or a Base dB or a connected dB for someone who knows a little more. Carl On 8/19/13 4:38 AM, Alex Thurgood wrote: Le 12/08/2013 22:12, Carl Paulsen a écrit : Hi Carl, 1) Create a Writer document template with the size of the label you require or use one of the pre-supplied label formats provided with LO. 2) In order to be able to include Database Field Names, you will need to (a) be able to either connect directly from LO to the database server (using the GUI and a registered datasource or a macro to setup the database context) OR (b) insert placeholders or user-defined fields which will then have to be mapped to the data you can retrieve from your web interfaced database. 3) Alternatively, use some third party software to manipulate the corresponding ODF document directly (python, java tools, php, perl, etc). IMO, this may probably be easier in the long run if you don't require your users to manipulate file creation, ie., if everything is setup by an admin and doesn't require further user intervention other than launching a script. Alex -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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] More mail merge help needed
Thanks, Paul. I've been away for a bit. There is a LO connector for SF, but AFAIK that connector won't make a merge document work within the broader Force.com platform. But this may be worth looking into further. I'm still stuck on creating the document with next record and next page fields to make it actually function as a merge document. Carl On 8/15/13 10:29 AM, Paul D. Mirowsky wrote: I am not an expert, but I do have a question. Does Salesforce have a database connector that will allow you to use LibreOffice Base as an intermediary to your Writer document? Paul On 8/14/2013 1:35 PM, Carl Paulsen wrote: I'm trying to create mail merge documents that contain merge fields for a document that can't connect directly to the data source. That source (Salesforce) can read the documents if the field names are correctly entered. I can type the field names in manually, but I can't figure out how to generate a label merge document that will work. The mail merge wizard doesn't seemingly allow users to generate label merges (options are letter and email). And I can't find a way to generate a merge document manually without using the wizard. I see no menu items for mail merge steps (I can find the insert field tool, but that's it - no tool to allow me to switch between merge fields and merged data without going into the wizard). I've tried starting with New-Labels, then choosing the correct label type and clicking New Document (I can't connect to the database, so can't enter the merge fields in the dialog). I can then type in merge fields as Salesforce wants to see them, but I can't figure out how to make it a merge document with the next record and next page items. In Insert-Fields there is a Next Record option but it's only available when there's a database connected. Finally, I've been through a lot of documentation so if there's a good mail merge document online, that might be enough. -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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] More mail merge help needed
Yes, that's the way I was working at this. But I realize there may be other approaches. Still, it made me wonder about hand-generating mail merge documents even without Salesforce, which is also something I'd like to understand how to do. I occasionally get questions about spreadsheets, text documents, mail merges and the like, and where possible I extol the virtues of LO (I personally don't use MSO but may end up needing to if I can't figure out the mail merge/Salesforce issue). So any learning I can do on mail merges will help me be more convincing. I also act as a consultant to non-profits for Salesforce and simple mail merges are a key concern. Salesforce has it's own weaknesses in that realm, but it's what I/we are stuck with. I'm working on learning all I can about it so I can speak with authority on more than just MSO. Thanks, Carl On 8/22/13 10:21 PM, Steve Edmonds wrote: Hi. Are you wanting to upload this document as a template for a SF extended mail merge. Do you need this document in .doc format (seems so from my quick look at SF instructions). Steve On 2013-08-23 13:48, Carl Paulsen wrote: Thanks, Paul. I've been away for a bit. There is a LO connector for SF, but AFAIK that connector won't make a merge document work within the broader Force.com platform. But this may be worth looking into further. I'm still stuck on creating the document with next record and next page fields to make it actually function as a merge document. Carl On 8/15/13 10:29 AM, Paul D. Mirowsky wrote: I am not an expert, but I do have a question. Does Salesforce have a database connector that will allow you to use LibreOffice Base as an intermediary to your Writer document? Paul On 8/14/2013 1:35 PM, Carl Paulsen wrote: I'm trying to create mail merge documents that contain merge fields for a document that can't connect directly to the data source. That source (Salesforce) can read the documents if the field names are correctly entered. I can type the field names in manually, but I can't figure out how to generate a label merge document that will work. The mail merge wizard doesn't seemingly allow users to generate label merges (options are letter and email). And I can't find a way to generate a merge document manually without using the wizard. I see no menu items for mail merge steps (I can find the insert field tool, but that's it - no tool to allow me to switch between merge fields and merged data without going into the wizard). I've tried starting with New-Labels, then choosing the correct label type and clicking New Document (I can't connect to the database, so can't enter the merge fields in the dialog). I can then type in merge fields as Salesforce wants to see them, but I can't figure out how to make it a merge document with the next record and next page items. In Insert-Fields there is a Next Record option but it's only available when there's a database connected. Finally, I've been through a lot of documentation so if there's a good mail merge document online, that might be enough. -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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] More mail merge help needed
I'm trying to create mail merge documents that contain merge fields for a document that can't connect directly to the data source. That source (Salesforce) can read the documents if the field names are correctly entered. I can type the field names in manually, but I can't figure out how to generate a label merge document that will work. The mail merge wizard doesn't seemingly allow users to generate label merges (options are letter and email). And I can't find a way to generate a merge document manually without using the wizard. I see no menu items for mail merge steps (I can find the insert field tool, but that's it - no tool to allow me to switch between merge fields and merged data without going into the wizard). I've tried starting with New-Labels, then choosing the correct label type and clicking New Document (I can't connect to the database, so can't enter the merge fields in the dialog). I can then type in merge fields as Salesforce wants to see them, but I can't figure out how to make it a merge document with the next record and next page items. In Insert-Fields there is a Next Record option but it's only available when there's a database connected. Finally, I've been through a lot of documentation so if there's a good mail merge document online, that might be enough. -- Carl Paulsen Dover, NH 03820 -- 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] Mail merge manual field entry
Hi all, I need to create a mail merge that will, I hope, be used with Salesforce for mail merge communications. I need to create a document with manually entered merge fields where the source database has not (and probably can not - at least with my current skills) be registered with LibreOffice. Salesforce is a web-based database service that has strict limits on connections outside of web browsers. In short, what I'd like to do is create mailing labels, type in the merge fields as they need to be typed (to work with Salesforce), then save and upload the document. I can't find any way to do this. Is there a way? Also, Salesforce provides some templates for the merges and I can see what I need to do, but the fields they provide in their templates are not relevant to what I need, and I can't replace their merge fields with the ones I do need. Thanks. -- Carl Paulsen Dover, NH 03820 -- 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] Mail merge manual field entry
A related question, which may help me figure out what I need, is how does one manually work through a mail merge? I only see the wizard, but what if I've already created a document and just want to change a few fields? I don't want to have to enter a wizard and work through the entire thing just to edit that document. That function might also allow me to hand-enter field names for this merge document. Carl On 8/12/13 4:12 PM, Carl Paulsen wrote: Hi all, I need to create a mail merge that will, I hope, be used with Salesforce for mail merge communications. I need to create a document with manually entered merge fields where the source database has not (and probably can not - at least with my current skills) be registered with LibreOffice. Salesforce is a web-based database service that has strict limits on connections outside of web browsers. In short, what I'd like to do is create mailing labels, type in the merge fields as they need to be typed (to work with Salesforce), then save and upload the document. I can't find any way to do this. Is there a way? Also, Salesforce provides some templates for the merges and I can see what I need to do, but the fields they provide in their templates are not relevant to what I need, and I can't replace their merge fields with the ones I do need. Thanks. -- Carl Paulsen Dover, NH 03820 -- 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] Error in Calc custom formats between closing and opening a file
-- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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: Re: [libreoffice-users] Re: Info from 3 cells merged into 1 - was [libreoffice-users] Error in Calc custom formats between closing and opening a file -
Arrgghhh. This was supposed to be a reply to the Re: Info from 3 cells merged into 1 thread. Sorry! On 7/9/13 8:31 PM, Carl Paulsen wrote: I sent the following, but apparently not to the list: Well, if all you need is to manually copy and paste, then copy the cells, move to the other spreadsheet, then select the starting cell, select Edit-Paste Special, then uncheck the Formulas option (you may first need to uncheck the Paste All box first). This will paste the data and not the formula. Carl On 7/9/13 8:11 PM, Paul wrote: Hi Regina, Terribly sorry about the delay in following up on your suggestions. I didn't mean to just disappear like that. It's been a bit hectic here, and I haven't had time to try with LibreOffice 4.1 beta yet, but I've tried a couple of other things. Firstly, I tried formatting the cell as a plain number, with ' / hour' after the default format, so the complete format is #,###.00 / hour This got changed over the save to #,###.00 / hour Again, the space was removed in front of the quotes, and added behind. Other than that, the hour wasn't mangled, I'm assuming that the mangling is only because of interpreting it as currency symbols. When I removed the extra space behind the quotes, but left it without a space in front, it preserved that over saves, i.e. the following worked fine over saves #,###.00 / hour This is still rejected when I change to currency format. Next, I looked at my locale settings. Under Tools|Options|Language Settings|Languages I have the following: Language of User interface: Default - English (USA) Locale setting: Default - English (South Africa) Decimal separator key: checked : Same as locale setting (.) Default currency: Default - ZAR Date acceptance patterns: Y/M/D;M/D Default languages for documents Western: English (South Africa) Asian: greyed out : Default - Chinese (simplified) CTL: greyed out : Default - Hindi For the current document only: not checked Enhanced language support Show UI elements for East Asian writings: not checked Show UI elements for Bi-Directional writing: not checked Ignore system input language: not checked I tried changing the default locale setting to English (USA), which also changed the currency and date settings. When I added ' / hour' it again moved the space from in front of the quotes to inside the quotes over saves. But now this doesn't mangle anything, I'm guessing because it's using a dollar sign instead of an R as the currency symbol. Changing the symbol to R by changing the format code from [$$-409] to [$R-409] works if the locale is English (USA). When the locale is Default - English (South Africa), changing the currency symbol by changing [$R-1C09] to [$$-1C09] doesn't help matters. I also noticed that with a space either in front of the quotes or moved inside the quotes to give a double space before the slash, two spaces are shown before the slash in the actual cell. So the only way to get only one space between the number and the slash in the cell is to have only one space, either in front of the qoutes or inside the quotes, but not both. It feels like there are two bugs, the first is that over saves LO doesn't preserve the space before the quotes, and moves it inside the quotes, irrespective of locale, and the second is that when there is no space before the quotes, the letters inside the quotes get interpreted as control codes instead of as literal text, and this interpretation depends on locale. There was also some strange behavior when entering just a plain number format, not currency. If I tried to enter a new number format by adding spaces inside the quotes, without a space in front of the quotes, say by setting the format to '#,###.00 / hour' and then adding spaces to make it '#,###.00 / hour', the moment it became a new format (one I hadn't used before), the preview changed to just displaying the number, without any formatting, and if I clicked OK, this carried over to the cell and reset the format to '#,##0 ;(#,##0)'. If, however, I didn't click OK when the preview reset, and instead added a space before the quotes, the preview suddenly became correct, and I could then remove the space in front of the quotes and it would stay correct. Once I pressed OK this format would get saved, and I could use it again without it getting messed up. Likewise if I added a format with, say, 5 spaces in the quotes and no space before the quotes, in this way, then went to cell formatting again and removed a space to four spaces, this didn't get messed up. But if I removed another space, to 3 spaces, which is a format I had previously used, then added a space, the format would get messed up again. It seems that there is some format interpretation going on behind the scenes when a space is added that is not going on when a space is removed. I think someone needs to have a careful look at how this section of the code is operating
Re: [libreoffice-users] Info from 3 cells merged into 1
And then, in the interest of being complete, you of course need to copy and paste that formula to all relevant rows... Carl On 7/8/13 1:46 PM, Steve Edmonds wrote: Hi. In the cell D1 where you want the result, you use =CONCATENATE(A1,B1,C1). Steve On 2013-07-09 05:31, Marino / WellnessWebshop.se wrote: Hi! I woud like to know if following is possible: I am about to create an importfile for my products in a webshop. Here I must have the name of all images and its path and file extansion. The path is always the same, but the name of the image is individual for each product. My idea is to have one column with name of the path, lets say column “A” includes the name of the path “data/” and column “B” has the name of the image “12345” and column “C” has the name for the file extansion “.jpg” or “.png”. So far all is ok. But now I would like to have these 3 facts together, so column “D” would include facts from column “A”+”B”+”C”, so in column “D” I can see “data/12345.jpg”. Is there a way to make this happen? - Thanks in advance! Best regards, Marino Assarsson -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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] To the moderators
FWIW, I did not see Sharon's message come through the email version (just checked my inbox and trash and didn't find a message with that subject). But...I seem not to get all messages. I recently missed at least some of a thread on AppleWorks file conversion, but I got some of them. Carl On 5/29/13 1:32 PM, V Stuart Foote wrote: Sharon, =-=-= From: Sharon Kimble [skimbl...@gmail.com] Sent: Wednesday, May 29, 2013 12:20 PM To: users@global.libreoffice.org Subject: [libreoffice-users] To the moderators At 1253 today I sent a email to the list under the heading of ' auto-spell checking not working on a fresh install.' asking for help with Libreoffice 4.0.3.3. This appears to have been removed from the main mailing list with no reason given. Why please? It was a genuine request for help with an ongoing problem that I have. I look forward to your reply. Sharon Kimble =-=-= Not sure what you think has happened but we saw your post come through opening a new thread, and it is resident in the TDF Nabble based mail archive, here: http://nabble.documentfoundation.org/auto-spell-checking-not-working-on-a-fresh-install-td4058444.html A problem with your Usenet reader configuration? Stuart -- 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: appleworks tests
I didn't see the earlier posts so not sure what exactly the question was, but I have AppleWorks 6 and it can save to .rtf which can then be opened in LO. My version also uses MacLinkPlus (a library of file converters) to save to M$Word format. Note that I haven't installed MacLinkPlus separately so wonder if it's packaged with AppleWorks 6. Can't any docs be saved that way and re-opened in LO or just about anything else? With a quick test on an AW text document fomatted to print envelopes, the conversion worked quite well, keeping page settings intact. -- Carl Paulsen On 5/24/13 3:33 AM, Tom Davies wrote: Hi :) Errr, having said all that i couldn't open any of the test files sent off-list (at least not in Ubuntu even after changing from utf8 to Apple encoding) so i think it probably IS important to clear some space and install the light-weight Abiword for word-processing. If you really need a spreadsheet program (on holiday??) then Gnumeric is the spreadsheet program that goes with it. However, how many long documents are you likely to write on holiday? It might still be worth sticking with what you have and then copypaste those letters and things into LibreOffice when you get back. Regards from Tom :) From: Tom Davies tomdavie...@yahoo.co.uk To: McBride dc...@xtra.co.nz; users@global.libreoffice.org users@global.libreoffice.org Sent: Friday, 24 May 2013, 8:25 Subject: Re: appleworks tests Hi :) If you need to clear a bit of space then try the standard 1. Empty the trash can in your emailing system. With more than 1 account you might need to do each one separately 2. In your web-browser (safari?) empty all the temp files, caches, password stores, cookies err anything like that if you can find out how to easily 3. Uninstall any programs/games you don't enjoy or use anymore 4. Empty your OSes temp files and stuff if you can find out how to easily 5. Empty the rubbish bin You might be amazed how often people have several Gigabytes of stuff in their trash cans and are completely unaware that the stuff in there is still easy to recover. In your case it probably wont create enough room to install LibreOffice and even if it does it's still better to leave that until after your holiday so that you have room for a photo or 2. If you are really keen to move away from those older word-processors then you might like to use AbiWord temporarily. It's very light but still quite powerful although their Mac version is a little old now https://www.macupdate.com/app/mac/11511/abiword http://www.abisource.com/download/ http://abiword.en.softonic.com/mac I found it awkward because last time i used it i could not get it to use MS formats by default. Nowadays using ODF is less problematic because so many more people can read/write it. So, Abiword is probably a lot easier now as it's default formats are the ones LibreOffice uses by default too. However, i think i would keep using the word-processors you are using at the moment and leave all this until you get back. Regards from Tom :) From: McBride dc...@xtra.co.nz To: laurent alonso alonso.laur...@gmail.com Cc: Tom Davies tomdavie...@yahoo.co.uk; Alexander Thurgood alex.thurg...@gmail.com Sent: Thursday, 23 May 2013, 23:39 Subject: appleworks tests Thanks to all for looking into my issue so carefully. Actually I don't have libre office, my enquiry was to make sure I can one way or other convert my appleworks. Got an old Mac OS x 10.5.8 and was going to get an airbook or so to go overseas, but if i can't convert my files, it won't be a holiday anymore... I'll have to change it one day though..I can't just download libreoffice for testing as I don't have much more space on my old Mac... Here are some tests if you like: Thanks. Turquoisegrece On May 24, 2013, at 2:09 AM, laurent alonso wrote: Hello, a quick answer as I just see your emails ... Le 22 mai 2013 à 10:25, McBride a écrit : My question was Can libre office read pages/appleworks/ clarissworks? Thanks. Turquoisegrece In fact, in some near future, a filter for Appleworks/Clarisworks text (word processing) files might be included in LibreOffice based on libmwaw ( http://sourceforge.net/p/libmwaw/wiki/Home/ ), see for instance http://docs.libreoffice.org/ . It will not be perfect but it may retrieve the text, most graphics, tables, text-boxes, basic layout, ... . For Pages and for other kinds of Appleworks/Clarisworks documents (spreadsheet, database, ...), I do not know. Note: if you have a Mac with OSX = 10.6, you can find in http://sourceforge.net/projects/libmwaw/files/ a compiled version of libmwaw and mwaw2odt with a crude AppleScript interface: mwawOSX.zip, it takes a supported format file ( and so Appleworks/ClarisWorks files ) and converts it in a .odt files ... Let me know if you try it and find some bugs... -- Amicalement
[libreoffice-users] Save As behavior
I'm working with a large, multi-sheet spreadsheet from which I need to generate numerous .csv files for use with another application, and when I save that way, the document is converted to .csv and the .ods file is closed (well, the .ods is no longer open...). But...while the .csv file is still open, it has multiple sheets in which I can work. If I work in more than one sheet and then save and close (without choosing to Save As), I lose all info except the current sheet. This has happened to me on more than one occasion. I know I can Save As again to .ods format, but why would it let me work in a .csv file as if it were a multi-sheet .ods file? I know this is how Excel works too, but I think it's wrong. What I'd like to see happen is to have the .ods file remain open and a SINGLE SHEET .csv file (what I just saved) open as well. That way I would have both files in which to work, I couldn't make a mistake with edits to the file AND I'd save many minutes throughout the day not having to re-open .ods files. I easily waste 1/2 hour to an hour a day working on this file because of this behavior. I wonder if there is a setting that controls what happens when I use Save As - anyone know of this? At some point I may post a feature request, but wonder if others would like to see such behavior or know why it wouldn't work. Thanks. -- Carl Paulsen -- 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] Save As behavior
Thanks, Tom. I'm rapidly moving data into and out of Salesforce, which ONLY handles .csv files. Of course, I try to Save As an .ods file, but even that doesn't prevent me from making mistakes. The fact that multiple tabs are available makes it easy to make mistakes when moving frequently between .ods and .csv file types. An example would be after having saved to .csv, I realize there are more data transformations I need to make. Some of them rely on other sheets where lookup data resides. It's easy to make a mistake and continue to work in the .csv, then save. If I do so and close the file, I may have saved the wrong sheet, or may lose changes made in other sheets, etc. Especially when I have to work feverishly on this data for 5-8 hours a day (for 2 weeks now!). At the very least, I'd be happy if LO saved the .csv to the HD in the background and left the .ods file open to work on. I seem to recall Excel used to work that way many years ago. For a while I worked as if the .csv were .ods, then throughout the day, occasionally saved as .ods. So long as the file remained open, there wasn't a problem. But too many times I either crashed or forgot which file was open and made a mistake resulting in too much lost data. I do think this issue cold be handled better, and would be ideal if the user could choose how LO worked with Save As. But again, maybe there's a reason I don't know about that forces it to work the way it does. -- Carl Paulsen On 5/22/13 2:54 PM, Tom Davies wrote: Hi :) Csv is not an ISO standard and does sometimes get implemented slightly differently in some apps. The standard approach is for a Csv to be a single sheet per file. When working on a document LO works as though it is native format NOT whichever format you happen to keep saving it in. So when you are working on spreadsheets LO treats them as Ods NOT csv. Generally even when using other formats it is best to keep saving a copy in Ods and treat that as your original. Then use Save As .. when you need a different format. Ideally the other apps might be able to read Ods too. Many can and often use it as their default format too and would be happier with that than Csv. They might only use Csv because they assume other people might not be able to read Ods. Regards from Tom :) *From:* Carl Paulsen carlpaul...@comcast.net *To:* users@global.libreoffice.org users@global.libreoffice.org *Sent:* Wednesday, 22 May 2013, 19:24 *Subject:* [libreoffice-users] Save As behavior I'm working with a large, multi-sheet spreadsheet from which I need to generate numerous .csv files for use with another application, and when I save that way, the document is converted to .csv and the .ods file is closed (well, the .ods is no longer open...). But...while the .csv file is still open, it has multiple sheets in which I can work. If I work in more than one sheet and then save and close (without choosing to Save As), I lose all info except the current sheet. This has happened to me on more than one occasion. I know I can Save As again to .ods format, but why would it let me work in a .csv file as if it were a multi-sheet .ods file? I know this is how Excel works too, but I think it's wrong. What I'd like to see happen is to have the .ods file remain open and a SINGLE SHEET .csv file (what I just saved) open as well. That way I would have both files in which to work, I couldn't make a mistake with edits to the file AND I'd save many minutes throughout the day not having to re-open .ods files. I easily waste 1/2 hour to an hour a day working on this file because of this behavior. I wonder if there is a setting that controls what happens when I use Save As - anyone know of this? At some point I may post a feature request, but wonder if others would like to see such behavior or know why it wouldn't work. Thanks. -- Carl Paulsen -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org mailto: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: [Solved] Re: [libreoffice-users] Case function equivalent in Calc
Hi Tom. Well, not quite. In my particular case this formula worked. But with some off-list input from smarter brains than mine, I realize it wouldn't work under many situations. It turns out the formula would need to change a bit, otherwise what I did would leave a trailing semi-colon where column X is blank. In fact, it's a tricky situation b/c a semi-colon is needed after U3 if U3 has a value AND any of the others has a value, otherwise not. Then, if V3 has a value and any of the other later cells has a value, there should be another semi-colon. Etc. etc. In the last case, a semi-colon should follow W3 only if there's a value in X3. I've tried a bunch of formulas and the closest I've come is the following: =A13IF(NOT(ISBLANK(A13))AND(NOT(ISBLANK(B13)))OR(NOT(ISBLANK(C13)))OR(NOT(ISBLANK(D13))),;,)B13IF(NOT(ISBLANK(B13))AND(NOT(ISBLANK(C13)))OR(NOT(ISBLANK(D13))),;,)C13IF(NOT(ISBLANK(C13))AND(NOT(ISBLANK(D13))),;,)D13 But that clearly doesn't work. Note I'm working in a test sheet and am using different cells. This formula leaves leading semi-colons under a number of situations and double semi-colons under others. I'm not entirely sure CASE would work any better here though. Anyone want to help out, great. But it's a pretty specialized situation, so I understand if not. Carl On 5/16/13 3:02 AM, Tom Davies wrote: Hi :) WoooHooo!! Nicely done! :) Is this whole thread solved now? COngrats of so! Regards from Tom :) *From:* Carl Paulsen carlpaul...@comcast.net *To:* users@global.libreoffice.org *Sent:* Thursday, 16 May 2013, 1:44 *Subject:* Re: [libreoffice-users] Case function equivalent in Calc At long last I got this to work. Syntax is ISBLANK and not ISEMPTY - aaa. My Filemaker days are getting in my way. Replace all isempty below with ISBLANK and it works perfectly now. Carl On 5/15/13 6:38 PM, Carl Paulsen wrote: So in the absence of a Case function, here's what I've done so far as a calculated solution. Note that the data I want to concatenate is in cells U3, V3, W3, and X3. In Y3, I put the following: =U3 IF(NOT(isempty(U3)),;,) V3 IF(NOT(isempty(V3)),;,) W3 IF(NOT(isempty(W3)),;,) X3 The idea is that I put together U3, a semicolon if U3 isn't empty (and nothing if it is), V3 and a semicolon if V3 isn't empty, W3 and a semicolon if W3 isn't empty, and X3. If any of the cells is empty, nothing will be added until the next cell that has data. Unfortunately, I'm getting a #NAME? error. I'm assuming some kind of syntax error. Any words of wisdom? Thanks a ton all. Carl On 5/15/13 5:13 PM, Dan Lewis wrote: On 05/15/2013 04:16 PM, Carl Paulsen wrote: Anyone know if there is an equivalent to the Filemaker Pro Case function? It's kinda like the IF function but is simpler to concatenate multiple conditions. It basically says If something is true then do what is specified, if the next thing is, then do that, if the next thing is true, do that, etc. Here's what I need to do. Take 4 columns and concatenate with a semi-colon between the values, but not string together two semi-colons consecutively. Like: PhoneEmailMail - Phone;Email;Mail Phone Mail - Phone;Mail Mail - Mail EmailMail - Email;Mail So semi-colons only occur if there's a value present and not at all if there's only one value present. I hope that makes sense and displays correctly. Carl I just checked the available functions in Calc. The Case function does not appear among them. Case When is available in Base database queries though. --Dan -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org mailto: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 -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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: [Solved] Re: [libreoffice-users] Case function equivalent in Calc
That wouldn't change anything. The existing semi-colon would be treated as just text in the field contents, so it would show up where it is in the field as well as the formula one. If you already have semi-colons in the fields at the end of the text, then they wouldn't be needed in my case. But I didn't have them and didn't want to add them. On 5/16/13 3:28 PM, mcmurchy1917-libreoff...@yahoo.co.uk wrote: Just a quick question. What happens if any of the fields already contains a semi-colon? Iain On Thursday 16 May 2013 10:23:23 Carl Paulsen wrote: Hi Tom. Well, not quite. In my particular case this formula worked. But with some off-list input from smarter brains than mine, I realize it wouldn't work under many situations. It turns out the formula would need to change a bit, otherwise what I did would leave a trailing semi-colon where column X is blank. In fact, it's a tricky situation b/c a semi-colon is needed after U3 if U3 has a value AND any of the others has a value, otherwise not. Then, if V3 has a value and any of the other later cells has a value, there should be another semi-colon. Etc. etc. In the last case, a semi-colon should follow W3 only if there's a value in X3. I've tried a bunch of formulas and the closest I've come is the following: =A13IF(NOT(ISBLANK(A13))AND(NOT(ISBLANK(B13)))OR(NOT(ISBLANK(C13)))OR(NOT(I SBLANK(D13))),;,)B13IF(NOT(ISBLANK(B13))AND(NOT(ISBLANK(C13)))OR(NOT(I SBLANK(D13))),;,)C13IF(NOT(ISBLANK(C13))AND(NOT(ISBLANK(D13))),;,) D13 But that clearly doesn't work. Note I'm working in a test sheet and am using different cells. This formula leaves leading semi-colons under a number of situations and double semi-colons under others. I'm not entirely sure CASE would work any better here though. Anyone want to help out, great. But it's a pretty specialized situation, so I understand if not. Carl On 5/16/13 3:02 AM, Tom Davies wrote: Hi :) WoooHooo!! Nicely done! :) Is this whole thread solved now? COngrats of so! Regards from Tom :) -- -- *From:* Carl Paulsen carlpaul...@comcast.net *To:* users@global.libreoffice.org *Sent:* Thursday, 16 May 2013, 1:44 *Subject:* Re: [libreoffice-users] Case function equivalent in Calc At long last I got this to work. Syntax is ISBLANK and not ISEMPTY - aaa. My Filemaker days are getting in my way. Replace all isempty below with ISBLANK and it works perfectly now. Carl On 5/15/13 6:38 PM, Carl Paulsen wrote: So in the absence of a Case function, here's what I've done so far as a calculated solution. Note that the data I want to concatenate is in cells U3, V3, W3, and X3. In Y3, I put the following: =U3 IF(NOT(isempty(U3)),;,) V3 IF(NOT(isempty(V3)),;,) W3 IF(NOT(isempty(W3)),;,) X3 The idea is that I put together U3, a semicolon if U3 isn't empty (and nothing if it is), V3 and a semicolon if V3 isn't empty, W3 and a semicolon if W3 isn't empty, and X3. If any of the cells is empty, nothing will be added until the next cell that has data. Unfortunately, I'm getting a #NAME? error. I'm assuming some kind of syntax error. Any words of wisdom? Thanks a ton all. Carl On 5/15/13 5:13 PM, Dan Lewis wrote: On 05/15/2013 04:16 PM, Carl Paulsen wrote: Anyone know if there is an equivalent to the Filemaker Pro Case function? It's kinda like the IF function but is simpler to concatenate multiple conditions. It basically says If something is true then do what is specified, if the next thing is, then do that, if the next thing is true, do that, etc. Here's what I need to do. Take 4 columns and concatenate with a semi-colon between the values, but not string together two semi-colons consecutively. Like: PhoneEmailMail - Phone;Email;Mail Phone Mail - Phone;Mail Mail - Mail EmailMail - Email;Mail So semi-colons only occur if there's a value present and not at all if there's only one value present. I hope that makes sense and displays correctly. Carl I just checked the available functions in Calc. The Case function does not appear among them. Case When is available in Base database queries though. --Dan -- Carl Paulsen -- 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
[libreoffice-users] Case function equivalent in Calc
Anyone know if there is an equivalent to the Filemaker Pro Case function? It's kinda like the IF function but is simpler to concatenate multiple conditions. It basically says If something is true then do what is specified, if the next thing is, then do that, if the next thing is true, do that, etc. Here's what I need to do. Take 4 columns and concatenate with a semi-colon between the values, but not string together two semi-colons consecutively. Like: Phone Email Mail - Phone;Email;Mail Phone Mail - Phone;Mail Mail - Mail EmailMail - Email;Mail So semi-colons only occur if there's a value present and not at all if there's only one value present. I hope that makes sense and displays correctly. Carl -- Carl Paulsen -- 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] Case function equivalent in Calc
Another way to state this is I'd like a Columns to Text function, but where I can specify semi-colon as the separator and it won't place two separators together consecutively. Thanks again, Carl On 5/15/13 4:16 PM, Carl Paulsen wrote: Anyone know if there is an equivalent to the Filemaker Pro Case function? It's kinda like the IF function but is simpler to concatenate multiple conditions. It basically says If something is true then do what is specified, if the next thing is, then do that, if the next thing is true, do that, etc. Here's what I need to do. Take 4 columns and concatenate with a semi-colon between the values, but not string together two semi-colons consecutively. Like: Phone Email Mail - Phone;Email;Mail Phone Mail - Phone;Mail Mail - Mail EmailMail - Email;Mail So semi-colons only occur if there's a value present and not at all if there's only one value present. I hope that makes sense and displays correctly. Carl -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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] Case function equivalent in Calc
So in the absence of a Case function, here's what I've done so far as a calculated solution. Note that the data I want to concatenate is in cells U3, V3, W3, and X3. In Y3, I put the following: =U3 IF(NOT(isempty(U3)),;,) V3 IF(NOT(isempty(V3)),;,) W3 IF(NOT(isempty(W3)),;,) X3 The idea is that I put together U3, a semicolon if U3 isn't empty (and nothing if it is), V3 and a semicolon if V3 isn't empty, W3 and a semicolon if W3 isn't empty, and X3. If any of the cells is empty, nothing will be added until the next cell that has data. Unfortunately, I'm getting a #NAME? error. I'm assuming some kind of syntax error. Any words of wisdom? Thanks a ton all. Carl On 5/15/13 5:13 PM, Dan Lewis wrote: On 05/15/2013 04:16 PM, Carl Paulsen wrote: Anyone know if there is an equivalent to the Filemaker Pro Case function? It's kinda like the IF function but is simpler to concatenate multiple conditions. It basically says If something is true then do what is specified, if the next thing is, then do that, if the next thing is true, do that, etc. Here's what I need to do. Take 4 columns and concatenate with a semi-colon between the values, but not string together two semi-colons consecutively. Like: Phone Email Mail - Phone;Email;Mail Phone Mail - Phone;Mail Mail - Mail EmailMail - Email;Mail So semi-colons only occur if there's a value present and not at all if there's only one value present. I hope that makes sense and displays correctly. Carl I just checked the available functions in Calc. The Case function does not appear among them. Case When is available in Base database queries though. --Dan -- 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] Case function equivalent in Calc
At long last I got this to work. Syntax is ISBLANK and not ISEMPTY - aaa. My Filemaker days are getting in my way. Replace all isempty below with ISBLANK and it works perfectly now. Carl On 5/15/13 6:38 PM, Carl Paulsen wrote: So in the absence of a Case function, here's what I've done so far as a calculated solution. Note that the data I want to concatenate is in cells U3, V3, W3, and X3. In Y3, I put the following: =U3 IF(NOT(isempty(U3)),;,) V3 IF(NOT(isempty(V3)),;,) W3 IF(NOT(isempty(W3)),;,) X3 The idea is that I put together U3, a semicolon if U3 isn't empty (and nothing if it is), V3 and a semicolon if V3 isn't empty, W3 and a semicolon if W3 isn't empty, and X3. If any of the cells is empty, nothing will be added until the next cell that has data. Unfortunately, I'm getting a #NAME? error. I'm assuming some kind of syntax error. Any words of wisdom? Thanks a ton all. Carl On 5/15/13 5:13 PM, Dan Lewis wrote: On 05/15/2013 04:16 PM, Carl Paulsen wrote: Anyone know if there is an equivalent to the Filemaker Pro Case function? It's kinda like the IF function but is simpler to concatenate multiple conditions. It basically says If something is true then do what is specified, if the next thing is, then do that, if the next thing is true, do that, etc. Here's what I need to do. Take 4 columns and concatenate with a semi-colon between the values, but not string together two semi-colons consecutively. Like: Phone Email Mail - Phone;Email;Mail Phone Mail - Phone;Mail Mail - Mail EmailMail - Email;Mail So semi-colons only occur if there's a value present and not at all if there's only one value present. I hope that makes sense and displays correctly. Carl I just checked the available functions in Calc. The Case function does not appear among them. Case When is available in Base database queries though. --Dan -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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] Sort problems
LO 4.0.3.3 I've had some problems with sorting that may have cost me 6 hours of work. Wondering what's going on. Biggest problem is that when sorting and choosing to expand selection it sometimes only expands to some of the columns of data. Why would this happen? I noticed this after a while of working on a large data file, and earlier sorts may have only sorted a portion of the sheet, meaning I have to check and possibly re-create all of my work. Much less problematic, recently I'm sorting a sheet and it sorts not only the column of data but also the columns themselves. Since I'm using vlookup a bunch, with static references (to work properly in my case), this re-sorting will screw up the entire file. I can't afford the time to recreate the vlookups each time I sort. I didn't have latter this problem under 3.x.x Carl -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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] Trouble opening Excel file fixed in 4.0.3
I was having trouble opening an excel file (.xls) in LO 3 but before posting to the list, I upgraded to LO 4.0.3 and tried again. This time no trouble opening the file. Just thought I'd post my experience. I can't comment as to the reasons why, but it worked, so if you're having trouble, you might try this. -- Carl Paulsen -- 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] Table of Contents woes
Thanks, Tom. It does seem like there's more than one style applied, but I don't know how to check that. Is there a way to display hidden characters (would that show styles?) or other way I could see what's going on? The napalm approach would be to remove all styles for the document and then re-apply them. Maybe I'll try that on a portion of a copy. Does anyone know what the Heading 1a style is for? Is it possible I created it a year ago when I started this document? I don't recall doing that. I'll take a look at the styles section of the manual as it's about time I really learned how to use them. A PITA to learn but I can see it's the best way to go. Here's a little more info: Heading 1a is level 1 in this documnt (not indented even thought this section header IS in fact indented) Heading 1a is linked with Contents 2 (which is supposed to be level 2 I think) So two questions. First, could this be part of the trouble? Second, I was considering upgrading to LO 4, and in case my styles got scrogged, is there a way to upgrade while removing any styles I may have created? I'm sure I can re-apply the Draft style watermark which is the only custom style I intentionally use. Thanks, Carl On 5/10/13 2:16 AM, Tom Davies wrote: Hi :) Have you been able to manually edit it? It does look as though something is very wrong. It looks like 2 styles have been applied to each heading. First as a sub-heading and then as a main heading. Sometimes the fastest way to fix something is an inelegant approach such as mine rather than trouble-shooting down to the exact cause. If it was all the sub-headings that you wanted to get rid of then it's fairly easy to set the ToC to only show main headings but that would not help this case. There is some documentation on Styles in Chapter 3 of the Getting Started Guide https://wiki.documentfoundation.org/Documentation/Publications#Getting_Started_with_LibreOffice Hopefully someone else can give a better answer (or even better if i missed a better answer) Apols and regards from Tom :) *From:* Carl Paulsen carlpaul...@comcast.net *To:* users@global.libreoffice.org users@global.libreoffice.org *Sent:* Thursday, 9 May 2013, 19:21 *Subject:* [libreoffice-users] Table of Contents woes LibreOffice 3.5.6.2 Build ID: e0fbe70-dcba98b-297ab39-994e618-0f858f0 On an Intel Mac on 10.6.8 I have a draft document in which I've used heading styles for sections. I now want to create a Table of Contents (ToC), but I'm having trouble getting it to work right. I'm using the styles almost as they came with the software (I added one style for a Draft watermark that I'm also using in this document). The problem is that sections to which I've applied the Heading 1a style end up with 2 or 3 entries in the ToC, at different levels. So, for example, I have one Heading 1 section, Fundraising History, followed by a subsection called Annual Fund set to Heading 1a. There are other subsections with Heading 1a applied, then other sections with Heading 1 applied. The ToC reads: Fundraising History Annual Fund Annual Fund Auction Auction Etc. The ToC should read: Fundraising History Annual Fund Auction Etc. ToC screen grab (I've inserted a screen-shot image here but not sure it'll get through to the group.) Any idea what's going on and how I can fix it? Thanks so much. -- Carl Paulsen Dover, NH -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org mailto: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 -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- 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] Table of Contents woes
LibreOffice 3.5.6.2 Build ID: e0fbe70-dcba98b-297ab39-994e618-0f858f0 On an Intel Mac on 10.6.8 I have a draft document in which I've used heading styles for sections. I now want to create a Table of Contents (ToC), but I'm having trouble getting it to work right. I'm using the styles almost as they came with the software (I added one style for a Draft watermark that I'm also using in this document). The problem is that sections to which I've applied the Heading 1a style end up with 2 or 3 entries in the ToC, at different levels. So, for example, I have one Heading 1 section, Fundraising History, followed by a subsection called Annual Fund set to Heading 1a. There are other subsections with Heading 1a applied, then other sections with Heading 1 applied. The ToC reads: Fundraising History Annual Fund Annual Fund Auction Auction Etc. The ToC should read: Fundraising History Annual Fund Auction Etc. ToC screen grab (I've inserted a screen-shot image here but not sure it'll get through to the group.) Any idea what's going on and how I can fix it? Thanks so much. -- Carl Paulsen Dover, NH -- 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] VLOOKUP for Numbers
I too hadn't realized the value of the last parameter being 1 (meaning it takes the next number below). I had trouble getting the formula to work until I realized I had pasted the array from the email and some of the numbers were formatted as text, others not, so I was getting almost all #N/A. Then I fixed it and it works. Thanks Brian. Excellent little exercise for me to learn more about VLOOKUP. Carl On 3/26/13 12:48 AM, Brian Barker wrote: At 21:17 25/03/2013 -0700, Jason C. Wells wrote: OK. Take two. Since VLOOKUP for numbers with an inequality is not meaningful, ... It will do what you require, I think. ... what I precisely hope to do is this. I hope that the preformatted columns survive the mailer software. Give the following columns: A B C D --- --- --- --- 1.1 eqn 3 0.10 1.3 6 0.12 1.5 10 0.15 1.7 18 0.18 2 30 0.21 2.2 50 0.25 2.7 80 0.30 3.2 120 0.35 3.7 180 0.40 4.3 4.8 5.3 6.4 7.4 8.4 Compare cells in column A such that: 0 A1 = C1 C1 A1 = C2 C2 A1 = C3 ... I'm hoping you mean: 0 A1 = C1 C1 A1 = C2 C2 A1 = C3 is true. Then return the value of D for the appropriate row. Repeat for all values of A. When done, the length of column B will be equal to the length of column A. B will contain values of column D. Both C and A will always be sorted. (Although it would be nice to be able to do this with A being random numbers.) It seems like I need an array equation, but the array A is not equal in size to the array in C. Simple string matching of VLOOKUP is inadequate to the task at hand. You are still talking of strings with respect to VLOOKUP(), but it will cope with your numbers too! And it will do your job ... You have missed the important value zero from your column C, so please insert it in C1, moving the other values down. *Do not* move the values in column D, so that the first value, 0.10, is now against zero in column C, 0.12 is against 3, and so on. (It seems that you don't need the maximum value 180 now in C10, in fact.) In B1, enter: =VLOOKUP(A1;C$1:D$9;2) and fill down column B. Voilà! This even works with column A values not being sorted, as you have asked. All that is required is that column C should be sorted - and that is no problem, of course. I trust this helps. Brian Barker -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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
Fwd: Re: [libreoffice-users] VLOOKUP for Numbers
Oops, sent this to the original sender, not the list: Please clarify: I haven't had any luck figuring out a method to compare each element of a list of numbers to each element of a differently sized list of numbers. What I want would bo something very much like VLOOKUP, but instead of matching strings, it would compare a number using an inequality and then return a value from another column along the row where a match was found. This is confusing. You say you're looking for an inequality, then return a match from another column along the row where the match was found. Are you looking for matches or not? Do you mean return a value along the row where a match WASN'T found (how would you identify the row where a match isn't found, since that could be all of the rows in the search column)? Or are you saying if VLOOKUP finds some mathematical derivation of the value in the source column (say, the square root), then return the value of the row of THAT match? What VLOOKUP does is return a value from another column where there IS a match. VLOOKUP works on strings or numbers. Where there IS a match with a matching column, it returns the value from the same row of a separate column in the lookup array. If there's no match, it returns a blank or N/A. If what you want is to identify the places where a match ISN'T found, couldn't you then use an IF statement to test if vlookup returns a value and then return a blank where there's a match and a value (say, 1) if the vlookup doesn't find a value? Note that vlookup works on different sized lists - the column with numbers that you want to look for in another column doesn't need to be the same length as the matching column. Also, keep in mind that you'll usually need to reference the array list absolutely (use $ before column name and row number). So if you're matching numbers in column A that is 100 numbers long, the lookup array from B1 to C50 would need to be specified as $B$1:$C$50. Otherwise the array range gets adjusted for each row down the search column. If you want a value from another column returned where there ISN'T a match, you'll have to specify how the spreadsheet would identify that value. A small spreadsheet might help if you show us what you'd LIKE to see returned. But make sure it's pretty small so we can see any patterns easily. -- Carl Paulsen Dover, NH -- For unsubscribe instructions e-mail to: users+h...@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] Help! Sheets tab not showing in Calc
LibreOffice 3.5.6.2 Mac OS 10.6.8 I have a spreadsheet with 4 sheets. File has been taking a long time to save (10 seconds or so for a 650kb file). Auto-filter is currently on for at least one sheet. This morning I closed the file because after saving, the display of the grid was wrong. Auto-filter pop-up arrows and column headings were mixed up and wouldn't revert to the proper display. After closing with a save, when I re-opened, the last sheet I worked on opens, file says there are 4 sheets, but I can't access the sheet tabs to navigate to the other tabs. I've opened Calc options/prefs and made sure it was set to display sheet tabs in the window. No luck. I've spent 8-10 hours on this file with some complicated vlookups, formulas, etc. (most of which have been converted to data by now), and I need to complete it today or tomorrow and am a bit panicked. Can't think of anything else that would cause this, nor how to access the other sheets. Help please! Thanks! Carl -- For unsubscribe instructions e-mail to: users+h...@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
Solved: Re: [libreoffice-users] Help! Sheets tab not showing in Calc
OK, after working on this more, I found 2 things. First, I was able to switch between the sheets using the Navigator (I double-clicked where it showed the number of sheets on bottom left of file window). Then I noticed that the scroll bar had been expanded to the entire width of the window, hiding the sheet tabs. I simply clicked the left edge of the bottom scroll bar and dragged to the right to uncover the tabs. Not sure how that happened, but it's working now. Whew! Thanks, Carl On 3/13/13 1:07 PM, Carl Paulsen wrote: LibreOffice 3.5.6.2 Mac OS 10.6.8 I have a spreadsheet with 4 sheets. File has been taking a long time to save (10 seconds or so for a 650kb file). Auto-filter is currently on for at least one sheet. This morning I closed the file because after saving, the display of the grid was wrong. Auto-filter pop-up arrows and column headings were mixed up and wouldn't revert to the proper display. After closing with a save, when I re-opened, the last sheet I worked on opens, file says there are 4 sheets, but I can't access the sheet tabs to navigate to the other tabs. I've opened Calc options/prefs and made sure it was set to display sheet tabs in the window. No luck. I've spent 8-10 hours on this file with some complicated vlookups, formulas, etc. (most of which have been converted to data by now), and I need to complete it today or tomorrow and am a bit panicked. Can't think of anything else that would cause this, nor how to access the other sheets. Help please! Thanks! Carl -- For unsubscribe instructions e-mail to: users+h...@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] Problem loading and saving XLS files
Thanks, Tom. I'm on a Mac so those memory settings are under LibreOffice-Preferences-Memory. I set per object memory to 18MB and then 20MB based on the 15MB file size and left the others. I don't care if it's slow for testing purposes. I run 4GB ram and typically have over 1GB available, so no problem there...at least in theory. Changing the memory didn't affect the file opening. Still truncating at 7,600+ records. Note there are no images in the files. They are straight text and numeric data with up to 25,000 records and 17 fields/columns. The only formatting is that the first row is boldface. When I save the .csv file (the one that contains all records) as a .xls, the files size is 3-4MB, much more like what I expect. I will certainly inquire with Salesforce to see what they do for file generation, though I don't expect much of a response. Re: gnumeric, I don't see a build for Mac OS and I always have LOTS of trouble building from source code. I may try it eventually, though, so thanks. It certainly sounds interesting. Carl On 2/26/13 6:44 AM, Tom Davies wrote: Hi :) I'm just wondering if Gnumeric might be better at opening the file? Calc 'should' be able to handle it easily so there is something weird there. The file-size drop sounds like the old bug about images dropping out but we haven't seen that happen for around a year afaik. Is it definitely an Xls and not an XlsX? XlsX and Odt can be opened as though they were Zip files which allows you to poke around inside a lot more. On the other hand Xls is usually a lot more stable than XlsX. 15Mb is pretty large for a normal file unless it does have images embedded inside. Could you just open LibreOffice itself, without opening the Xls, and go to Tools - Options - Memory and bump up those figures a LOT. Particularly the Memory per object to maybe around 15Mb, or something huge like that. I'm assuming your Ram is over 1Gb and could handle it quite easily. Perhaps drop the number of undo steps it remembers to maybe 50. Mine seems excessive at 100. I don't know why the file-size keeps changing. It's something that would worry me so i would save as an Odt to make sure i got a stable copy and then possibly start exploring the Xls to see why it's so unstable. Csv holds no formatting information so it's bound to be a lot smaller than an Xls or Odt. It also strips out any images and macros and stuff. Regards from Tom :) From: Jay Lozier jsloz...@gmail.com To: users@global.libreoffice.org Sent: Tuesday, 26 February 2013, 4:19 Subject: Re: [libreoffice-users] Problem loading and saving XLS files On 02/25/2013 06:19 PM, Carl Paulsen wrote: I'm using LO 3.5.6.2 on a Mac OS 10.6.8 I'm working on a critical project analyzing data from Salesforce (I'll call it SF) for non-profit SF users. When I export xls files from SF, if those files are greater than something like 7,000 records (a dozen or so fields), the file gets truncated by LO. The files (some with 21,000+ records) open fine in MS Excel (on a PC at least - I don't own Excel on my Mac). If I export from SF as .csv files, these open fine in LO and I can manipulate them fine. Saving is also OK and I seem to be able to export to .xls, which then opens fine in LO with all 21000 records. Any idea why the SF export of .xls file type won't open properly in LO? What could cause this problem? Could this be a bug in LO? I realize there could be oddities in the SF export function, but given it opens fine in Excel (on a PC at least) Note I can see something going on with the file size. The .xls direct from SF is 15MB. After opening this file and then saving it, the file size is 3-6MB (and it has only about 7000 records). The .csv file that's exported from SF is about 2-3MB, but when I save the .csv file as .xls, the file is still only 3-4MB but it's complete (all 21000 records). Carl The problem is not the number of records since importing the csv file does not truncate. Most spreadsheets do have an upper limit for the number of records and for Excel and Calc I believe it is much larger than 21K. Can you import the csv file and then save as an xls file and then reopen the xls file without data loss? -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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 -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http
[libreoffice-users] Problem loading and saving XLS files
I'm using LO 3.5.6.2 on a Mac OS 10.6.8 I'm working on a critical project analyzing data from Salesforce (I'll call it SF) for non-profit SF users. When I export xls files from SF, if those files are greater than something like 7,000 records (a dozen or so fields), the file gets truncated by LO. The files (some with 21,000+ records) open fine in MS Excel (on a PC at least - I don't own Excel on my Mac). If I export from SF as .csv files, these open fine in LO and I can manipulate them fine. Saving is also OK and I seem to be able to export to .xls, which then opens fine in LO with all 21000 records. Any idea why the SF export of .xls file type won't open properly in LO? What could cause this problem? Could this be a bug in LO? I realize there could be oddities in the SF export function, but given it opens fine in Excel (on a PC at least) Note I can see something going on with the file size. The .xls direct from SF is 15MB. After opening this file and then saving it, the file size is 3-6MB (and it has only about 7000 records). The .csv file that's exported from SF is about 2-3MB, but when I save the .csv file as .xls, the file is still only 3-4MB but it's complete (all 21000 records). -- Carl Paulsen Dover, NH 03820 -- For unsubscribe instructions e-mail to: users+h...@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] crash recovery odd behavior
LO crashed ( I think I ran out of battery on my laptop) with 3 documents open. When re-opening some time later, 3 documents failed recovery. I had probably trashed the files b/c I didn't need them any more, but not sure. In any case, these 3 files keep coming up as having been improperly closed every time I open LO. They of course fail each time. I've looked for a setting to clear out the list of files that crashed, but can't find it. Is this by design? If so, can I somehow clear out the file list so it opens normally? Thanks, Carl -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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] crash recovery odd behavior
OK, 3 people suggested cancel. I tried that , then restarted LO and, lo and behold, it bypassed the recovery routine. I'm assuming it will work this way even after rebooting, so I think my question has been solved. Thank you so much everyone. Carl On 1/10/13 7:13 PM, webmaster-Kracked_P_P wrote: I have not had the problem with 3.6.4, but when I did, Cancel sometimes worked and sometimes did not. On 01/10/2013 07:03 PM, Tom Davies wrote: Hi :) Have you tried the Cancel button when you get that recovery dialogue pop-up box? Cancel usually clears them. I often find that documents it worries might have been corrupted are actually completely fine. Regards from Tom :) From: Kieran Peckett crazyske...@gmail.com To: cpaul...@alumni.middlebury.edu Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Thursday, 10 January 2013, 21:55 Subject: Re: [libreoffice-users] crash recovery odd behavior On 10/01/2013, Carl Paulsen carlpaul...@comcast.net wrote: LO crashed ( I think I ran out of battery on my laptop) with 3 documents open. When re-opening some time later, 3 documents failed recovery. I had probably trashed the files b/c I didn't need them any more, but not sure. In any case, these 3 files keep coming up as having been improperly closed every time I open LO. They of course fail each time. I've looked for a setting to clear out the list of files that crashed, but can't find it. Is this by design? If so, can I somehow clear out the file list so it opens normally? Thanks, Carl -- Carl Paulsen -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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] Formulas in Calc not showing results
OK, having now rebooted, LO seems to be displaying the results of the formulas again. That's a relief, and no doubt it's the reboot that solved the issue. Wish I understood why such things happen, but in any case, thanks for pushing me in that direction. As for: Also with Mac i think updates and even installing stuff seldom demands a reboot? Correct. In some cases with OS updates, reboot is required, but not usually. Mac may also have a way to re-open all the last work after a shutdown, but I haven't looked into it yet (Safari browser does this, so maybe Apple thought about it for the entire OS). I do hope to look into Linux and the like one day... Cheers, Carl With Ubuntu there is some setting that allows you to make the start-up procedure open up everything that you had open when you shut-down. There might be something similar on Mac but i don't know of good places to find out. There must be forums or soemthing worth asking. Apols and regards from Tom :) From: Carl Paulsen carlpaul...@comcast.net To: users@global.libreoffice.org Sent: Thursday, 13 December 2012, 12:25 Subject: Re: [libreoffice-users] Formulas in Calc not showing results It's not the downtime but rather all the work that's open that I have to keep track of, decide how to save and then close. It's hard to explain but given I work 3-4 different jobs at once and am working on new tools that I don't know very well yet, I'm always reluctant to reboot. Obviously I'll have to change that. And I too can shut down processes individually on my Mac, but I don't always know what ones apply to what programs. Sounds easier than it is... I'm still wondering why it's happening, and why LO is now opening the CSV files (no re-start or re-boot yet). In the latter case, obviously re-starting or re-booting didn't matter. This is all a lot more complicated that just re-booting. Cheers, Carl On 12/13/12 1:39 AM, Tom Davies wrote: Hi :) Lol, +1 Even on GnuLinux distros (mainly Ubuntu ime tbh) it's a good plan to do a reboot to ensure that services that are normally on haven't been stopped temporarily without you really being aware of it. Of course in GnuLinux you could restart individual processes in order to avoid any down-time at all but on a desktop or mobile machine a couple of minutes of downtime is unlikely to matter much. Regards from Tom :) From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Wednesday, 12 December 2012, 22:21 Subject: Re: [libreoffice-users] Formulas in Calc not showing results At 16:35 12/12/2012 -0500, Carl Paulsen wrote: Restart the software or reboot the computer sometimes helps these odd glitches. You mean that you didn't try this before asking your question?! Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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 -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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 -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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] Formulas in Calc not showing results
It's not the downtime but rather all the work that's open that I have to keep track of, decide how to save and then close. It's hard to explain but given I work 3-4 different jobs at once and am working on new tools that I don't know very well yet, I'm always reluctant to reboot. Obviously I'll have to change that. And I too can shut down processes individually on my Mac, but I don't always know what ones apply to what programs. Sounds easier than it is... I'm still wondering why it's happening, and why LO is now opening the CSV files (no re-start or re-boot yet). In the latter case, obviously re-starting or re-booting didn't matter. This is all a lot more complicated that just re-booting. Cheers, Carl On 12/13/12 1:39 AM, Tom Davies wrote: Hi :) Lol, +1 Even on GnuLinux distros (mainly Ubuntu ime tbh) it's a good plan to do a reboot to ensure that services that are normally on haven't been stopped temporarily without you really being aware of it. Of course in GnuLinux you could restart individual processes in order to avoid any down-time at all but on a desktop or mobile machine a couple of minutes of downtime is unlikely to matter much. Regards from Tom :) From: Brian Barker b.m.bar...@btinternet.com To: users@global.libreoffice.org Sent: Wednesday, 12 December 2012, 22:21 Subject: Re: [libreoffice-users] Formulas in Calc not showing results At 16:35 12/12/2012 -0500, Carl Paulsen wrote: Restart the software or reboot the computer sometimes helps these odd glitches. You mean that you didn't try this before asking your question?! Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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 -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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] Formulas in Calc not showing results
LO = 3.5.6.2 for Mac OS 10.6 AutoCalculate is on I'm trying to build a simple text concatenation (forumula is =CONCATENATE(Dear ,Q2), though I also tried it as =Dear Q2). The formula only shows as the text of the formula, not the result of the formula. Using the formula builder, it shows the correct result (in this case, Dear Kate and Marc. It's just that the result doesn't show in the cell. My Tools menu doesn't contain Options as a choice (not even grayed out), so can't adjust that. Finally, when I export to csv, where I should be able to see the formula results if they are being created, I can't even open the resulting csv file with LO (or anything else I have on hand). Any suggestions? Thanks! -- For unsubscribe instructions e-mail to: users+h...@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] Formulas in Calc not showing results
Thanks, Brian, So I finally was able to open the CSV file after re-saving it a few times. Not sure what that's about... The CSV file has the proper values saved instead of the formulas, so it appears it's just a display issue. I'll try to dig further to see what might be going on. Restart the software or reboot the computer sometimes helps these odd glitches. Carl On 12/12/12 3:45 PM, Brian Barker wrote: At 12:10 12/12/2012 -0500, Carl Paulsen wrote: I'm trying to build a simple text concatenation (formula is =CONCATENATE(Dear ,Q2), though I also tried it as =Dear Q2). The formula only shows as the text of the formula, not the result of the formula. Another possible cause of this is formatting the cell as Text before you enter the formula. I trust this helps. Brian Barker -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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: OpenOffice to be dumped in Freiburg ?
Thanks, Regina. I know there are other ways to contribute, but I don't necessarily know what they are. Templates is one way, but the real issue I see is going from MSO to LO/OO. We can't control the other end. So is there a simple list of SPECIFIC ways users can contribute (templates is a good example) that is easily found? I've seen some general lists of how to contribute, but I haven't searched much for more specifics. In any case it should probably be front and center on the website (again, not the develop, donate $$, etc. generic list, but more specifics). Carl On 11/19/12 8:09 AM, Regina Henschel wrote: Hi, Carl Paulsen schrieb: In practical use, I would NOT say LO (or OOo) has a high file compatibility with MS Office. Virtually every file I receive from MS Office users has some kind of problem (bullet lists almost NEVER convert correctly, at least from MSO to LO). I'm only an occasional Office suite user so I put up with it (plus I'm on a Mac), but I've never been able to convince others to use LO for this reason alone. And I mostly work with non-profits who, for several reasons, should be avid LO users. I also realize MSO, with it's market share, stands only to gain from keeping it's formatting a moving target. With that in mind, I just can't imagine how a project like LO could hope to keep up and make inroads. Wish I could help with making it work better, but I know nothing about contributing to development. You do not need to be a developer to help. One idea for interoperability I heard on LibOCon, is to make templates, that can be converted nicely. So if you have access to MSO, then examine, what kind of things are dangerous for converting and what kind of things convert without problems. Make a Wiki site with your observations and create good templates based on this rationale. Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@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: OpenOffice to be dumped in Freiburg ?
Thanks, all. My resources are such that it'd be hard for me to contribute much, but it's helpful to know there are small ways I could pitch in. I will see if I can make room to contribute in some way. And the specific suggestions are indeed helpful. Carl On 11/19/12 11:31 AM, Joel Madero wrote: I was one of the one who sent a direct email to you (should have kept it on list, my apologies) about contributing. QA is actively trying to grow and requires very little (if any) programming skills. If you'd like to help out with QA (triaging mostly right now), let us know and we'll help you get started. Devs can't start fixing problems until they are appropriately prioritized so there may be hundreds of bugs about interoperability with MSO but Devs can't look at it until our small team of QA'ers get to them and verify the bugs and then prioritize. Regards, Joel On Mon, Nov 19, 2012 at 8:28 AM, Marc Paré m...@marcpare.com wrote: Hi Carl, Le 2012-11-19 08:34, Carl Paulsen a écrit : Thanks, Regina. I know there are other ways to contribute, but I don't necessarily know what they are. Templates is one way, but the real issue I see is going from MSO to LO/OO. We can't control the other end. So is there a simple list of SPECIFIC ways users can contribute (templates is a good example) that is easily found? I've seen some general lists of how to contribute, but I haven't searched much for more specifics. In any case it should probably be front and center on the website (again, not the develop, donate $$, etc. generic list, but more specifics). Carl Our contributions are team driven. Usually, if an individual is seriously interested in contributing: * she/he will go to the Get Involved section of our website[1] * read through the different categories for contribution * choose/join an area of interest * announce her/himself to the list * state their particular interest in that section * members will then direct them to their project needs If unsure of where you would best fit: * the user or the discuss mailing lists are where you could leave questions with regards to contributing * someone from the project will ask you about your interests, after which, guide you to the right contributor-section that suits you best * once you have joined the team and announced yourself, the team members will help guide you to their project needs. Feel free to let us know in what way you could help out the project, and, we will help you find the right section. You will find that we will gladly accept your help in whatever section you decide to join. Hope this helps. Cheers, Marc Marketing Team Member http://www.libreoffice.org/**get-involved/http://www.libreoffice.org/get-involved/ -- Marc Paré m...@marcpare.com http://www.parEntreprise.com parEntreprise.com Supports OpenDocument Formats (ODF) parEntreprise.com Supports http://www.LibreOffice.org -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@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: OpenOffice to be dumped in Freiburg ?
Here, here. But what about gov'ts mandating simply that the format structure be open (without mandating a specific one be used)? That's not political IMHO. Carl On 11/19/12 3:15 PM, M Henri Day wrote: 2012/11/19 VA cuyfa...@hotmail.com At the risk of getting political, the last thing I want is my government dictating to me what kind of file format to use on my documents. Virgil At the risk of getting political, the last thing I want is a multi-national corporation, responsible to no one save a few major shareholders and/or top executives, which, due to its domination of the market, can effectively render it manditory for me to use its proprietary file format Regulation of markets, so that they remain as free and accessible as possible, is one of the principle tasks of government Henri -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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: OpenOffice to be dumped in Freiburg ?
Without trying to defend MS, it can only dominate markets that customers allow it to dominate. Nobody is forced to purchase MS products. They do so because, for whatever reason, they perceive that MS serves their needs. One of those needs is file compatibility with others, which by its nature, allows MS sales to feed on themselves. The more people buy MS products, the more people need to buy MS products to communicate with all the others who went before. But, of course, the only reason file compatibility is an issue - the only reason MS can behave as it does - is that it is an effective monopoly. Last time I checked monopolies are anti-competitive, and there are LAWS in the US to curb them. So I agree, there is a role for gov't to step in. Good luck waiting for that though. Break the monopoly for a few years by being hyper-vigilant about code development and marketing and you might actually break the monopoly for good. Furthermore, if enough people forced gov't to accept standardized document types (e.g. ODT or even PDFs!), the monopoly would weaken. Carl -- For unsubscribe instructions e-mail to: users+h...@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: OpenOffice to be dumped in Freiburg ?
In practical use, I would NOT say LO (or OOo) has a high file compatibility with MS Office. Virtually every file I receive from MS Office users has some kind of problem (bullet lists almost NEVER convert correctly, at least from MSO to LO). I'm only an occasional Office suite user so I put up with it (plus I'm on a Mac), but I've never been able to convince others to use LO for this reason alone. And I mostly work with non-profits who, for several reasons, should be avid LO users. I also realize MSO, with it's market share, stands only to gain from keeping it's formatting a moving target. With that in mind, I just can't imagine how a project like LO could hope to keep up and make inroads. Wish I could help with making it work better, but I know nothing about contributing to development. Carl On 11/18/12 7:48 PM, rost52 wrote: I only can use Virgil's word I hate to say it but Virgil is right. File compatibility is very important in our daily business world where we need to exchange editable files within our company and also with external partners. Whenever I need to exchange files with MSO formats, I additionally attach a pdf-file or ask for pdf-file as reference. This is a reduction of productivity - I am willing to take I, but how many others? Although I am aware that it is not an easy task and requires dev work, LibO must achieve more than a high compatibility with MSO formats. I keep fingers crossed. On 2012-11-19 07:37, VA wrote: I hate to say it, but I think in business MS compatibility is THE paramount concern. When I was working for a large business, I used LibO only for documents I knew I didn't have to share with others. For anything that had to be used by others, I used MS Office. I realize that LibO is highly compatible with MS Office, but highly often isn't enough. In my experience there were enough incompatibilities that it just wasn't worth the hassle of trying to clean up documents sent back and forth between the two office suites. File format compatibility is far more important than similar user interfaces or command structures. I would say file compatibility is the primary reason companies keep buying MS Office. Virgil -Original Message- From: Pedro Sent: Sunday, November 18, 2012 5:25 PM To: users@global.libreoffice.org Subject: [libreoffice-users] Re: OpenOffice to be dumped in Freiburg ? NoOp wrote Which part of that do you not understand? This part apache.incubator.ooo.user You are correct that I didn't notice the second option (apologies for that). I wrongly assumed it was another ooo link But redirecting a LibreOffice issue to an ooo forum doesn't make any sense. And this is a LibreOffice issue. So much so that TDF's Director bothered to answer (unfortunately in German) http://blog.documentfoundation.org/2012/11/16/open-letter-to-the-city-of-freiburg/ There are some translations in the comments. -- View this message in context: http://nabble.documentfoundation.org/OpenOffice-to-be-dumped-in-Freiburg-tp4019224p4019398.html Sent from the Users mailing list archive at Nabble.com. -- Carl Paulsen 8 Hamilton Street Dover, NH 03820 (603) 749-2310 -- For unsubscribe instructions e-mail to: users+h...@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