Re: [libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA
El 29/08/13 10:38, Michele contabilmenteAG escribió: Dear Marlosv thanks for the reply. Enclosed is sending the file from these problems. I look forward to technical comments from the thing. (I have not yet thrown from my building, but customers may feel happy to push me from the brink, if he does not finish the job :-) ) -- Please : Some Notes details for the use of the file: It is a complete accounting double entry for businesses. The worksheets are to be observed: PROSPETTO CODICI (which contains 2 PivotTable): one for a CODICI DARE and one for CODICI AVERE The origin of the data is in the worksheet PRIMA NOTA. activity 1) If you update the PivotTable CODICI AVERE (red numbers), updating the Codes field disappears and the pivot table does not work. Task 2) If you ask in the Pivot table detail of a code (double click on an amount in AVERE column or DARE column) opens a worksheet regularly with details. If you make the task 1) or 2) in the worksheet named BILANCIO CE columns C (visible column) and F (hidden column) where the functions are written in the cells GETPIVOTDATA refer to 2 Pivot Tables do not contain more results GETPIVOTDATA = function no longer works. Even rewriting the Pivot Tables and rewriting the GETPIVOTDATA function in those cells (the cells before deleting), the function from the results that more has to give. And then the balance is no longer results Oh My God What a disaster! Best Regards. Michele Ras Hi Michele. 1) Seems the row field is missing, WHY? I don't know, maybe a bug. Edit the PT add the field Cod. R/D to row fields and PT works again. 2) Calc have been a deep rework on the core for 4.1, seems that the second form of GETPIVOTDATA, what you are using doesn't work, but the first form works for me: in cell BILANCIOCEE.C10: =GETPIVOTDATA(DARE;'PROSPETTO CODICI'.$A$3;'PROSPETTO CODICI'.$A$3;$A10). Saluti. Miguel Ángel. -- 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] extension or program for book printing?
El 12/11/12 15:16, webmaster-Kracked_P_P escribió: Since there was the thread about the Book Preview, I was wondering if there is either an extension out there or a external program that would print the pages of the document in the correct order for Book Printing. When you have a landscape double sided sheet with two pages printed on each side [letter or tabloid sized paper], you need to arrange the pages in a set order for the pages to print out on the correct sheet and suchfor the colation and folding of the sheets into a book format. I use to do a lot of multi-sheet newsletters printed onto tabloid paper. I ended up making a template in PageMaker that had the pages listed in the placement for printing and not for the standard document printing. I had a template for each page count version of the newsletter, such as 2 or 3 tabloid sheets. I would like to find an extension or external package that would print out the pages in the proper order for the placement on the sheets instead of doing it manually. Since I use both Windows and Linux, I could use a package for either OS. Anyone know of a package or extension that would do the work? LibreOffice help: Printing a Brochure You can print a Writer document as a brochure or a booklet. That is, Writer prints two pages on each side of the paper, so that when you fold the paper, you can read the document as a book. When you create a document that you want to print as a brochure, use portrait orientation for the pages. Writer applies the brochure layout when you print the document. To Print a Brochure 1. Choose File - Print. 2. In the Print dialog, click Properties. 3. In the properties dialog for your printer, set the paper orientation to landscape. If your printer prints duplex, and because brochures always print in landscape mode, you should use the duplex - short edge setting in your printer setup dialog. 4. Return to Print dialog, and click the Page Layout tab page. 5. Select Brochure. 6. For a printer that automatically prints on both sides of a page, specify to include All pages. 7. Click OK. If you print a document in portrait on a landscape page, two opposing sides in a brochure will be printed next to each other. If you have a printer with double-sided printing capability, you can create an entire brochure from your document without having to collate the pages later. If you have a printer that only has single-sided printing capability, you can achieve this effect by first printing the front pages with the Front sides / right pages /odd pages option marked, then re-inserting the entire paper stack in your printer and printing all the back pages with the Back pages / left pages / even pages option marked. If LibreOffice prints the pages in the wrong order, open the Options tab page, select Print in reverse page order, and then print the document again. I hope this is what you are looking for. -- 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: Writer: AutoCorrect language resets and sticks to English after Japanese script is inserted
El 07/11/12 1:28, Minix escribió: Thank you. I have reproduced your exact same steps, but with Brazilian Portuguese instead of German. The document language switches back to English as soon as I start typing again. Likewise, the default language in ToolsOptionsLanguage SettingsLanguagesDefault languages for documents also switches back to English/Japanese when this happens. Whenever I set the language back to Portuguese, newly typed text is treated as English. I can, for example, select all the text in Portuguese and set it to be treated as Portuguese, but any new or modified text gets treated as English. On Tue, Nov 6, 2012 at 12:41 PM, Dr. R. O Stapf reinh...@stapf-online.comwrote: I am not sure if my test matches your situation: I have LibO: - User interface English - Asian language: Japanese - German dictionary installed - Normally I am using English and Japanese Test: - Opened a new writer document, started typing in German. - The spellchecker showed errors; red wavy lines under words. - Changed to German (Tools/Language/For all text / German) - Spellchecker removed red wavy lines under words. - Switch over to Japanese writing (半角／全角key) and wrote a Japanese sentence (Kanji, hiragana, katakana) without any problems. No wavy red lines under the Japanese words. - Switched back from Japanese (半角／全角key again) and continued writing German. No wavy red lines under the German words. Thus writer recognized German correctly. - copied Japanese text into clipboard and pasted at the end of the German text (no switching to Japanese writing) - Continued writing German and all is okay. I am using LibO 3.5.7 on XP / SP3 Hope it gives you a hint. On 2012-11-06 23:05, Minix wrote: Good afternoon. I'm sorry for insisting, but it's been 13 days and I haven't had a single response, nor were able to fix the issue. At the very least, is anyone here affected by this problem? Thank you. On Wed, Oct 24, 2012 at 11:11 PM, Minix b...@2dbonsai.com wrote: Good evening. I'm running LibreOffice 3.6.2.2 on Windows 7. My default language in LibreOffice is set to Brazilian Portuguese. When I'm typing a text in Portuguese and insert Japanese text, the AutoCorrect changes the language to the following text to English. The text that has already been typed as Portuguese remains unaffected. I am able to set the text manually back to Portuguese, but as soon as Japanese text is typed, the roman script that comes afterward is treated again as English. Is this a known problem? Do anyone know a solution or workaround that doesn't require manually changing the language every time? Thank you. - Raphael Campos -- 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 Hi Raphael, Have you tried resetting the user profile. Often solves strange problems. wiki.documentfoundation.org/UserProfile I guess the font language is right in the paragraph and character styles. Miguel Ángel. -- 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] Delete a Registered Database
El 29/10/12 2:14, webofht-libreoffice...@yahoo.com.hk escribió: Hello, In LibreOffice 3.5 Writer, how should I delete a registered database? Edit → Exchange Database... → Browse... → (Choose an ODF Spreadsheet file) → Define → Close Data Sources (or F4) → Right-click the left panel → Registered databases → (Choose a file) → Delete → OK (Restart LibreOffice) → Data Sources (or F4) → (The “registered database” is _not_ deleted.) Any ideas? C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Menu/Tools/Options/Database/LibreOffice Base or F4, right-click the base to delete the registration. This only delete the registration in LibreOffice. The .odb file with their data remains in the OS file system. -- 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] Calc - Multiple font effects in a single cell
El 19/10/12 10:00, david_lynch escribió: I want to have a cell in Calc with multiple font effects, which characters get which font depends on the values in other cells. An example: A1 abcdefg A2 3 A3 5 I want to be able to program Calc so that characters A2 to A3 (3 to 5) of A1 are strikeout, so A1 looks like abcdefg with cde in strikeout. I know I can get this effect be editing A1 manually, but that not possible with the large number of cells I want to edit in this manner. Can anyone tell me a way to do this, please? I'm willing to program this in basic if it's the only way. David Lynch Maybe the function MID() is what you are looking for? =MID(abcdefg;A2;A3-A2+1) Menu/Help/LibreOffice help (F1) - Index tab - search term: MID. MID Returns a text string of a text. The parameters specify the starting position and the number of characters. Syntax MID(Text; Start; Number) Text is the text containing the characters to extract. Start is the position of the first character in the text to extract. Number specifies the number of characters in the part of the text. Example =MID(office;2;2) returns ff. -- 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] Libre Writer - Opening plain text documents to desired font
El 19/10/12 18:27, Tom Davies escribió: Hi :) Ahhh, thanks Dan. That makes more sense. Sorry Charles, ignore me. Regards from Tom :) From: Dan Lewis elderdanle...@gmail.com To: users@global.libreoffice.org Sent: Friday, 19 October 2012, 17:08 Subject: Re: [libreoffice-users] Libre Writer - Opening plain text documents to desired font If you have plain text, use Control+A to highlight the entire text. Then clicking the Default Paragraph style will change to your desired font. The key to what is happening is the type of style being applied: paragraph. If you place the cursor in a single line paragraph, clicking Default will only change one line. If a paragraph has several lines, doing this will change several lines. Stop and think about your question. If Writer were to do what you wanted, it would do this for all text files. That means you might later create a text document with several custom styles in it. Opening this document in Writer would remove all these styles. This is not a good idea. However, there is a better way to do this using copy and paste special. Open the text in a simple text editor (Notepad, Gedit, etc.) Open Writer with an Untitled document. Click your Default style so that it is applied to the first paragraph (empty paragraph in this case. Copy the text. Paste special (Control+Shift+V). Select Unformatted text. All the text will be pasted with your default font. --Dan On 10/19/2012 11:37 AM, charles meyer wrote: Hi Tom, Have you figured out if Libre Writer can open plain text files automatically to your chosen font? When I place the cursor anywhere in the body of the text of a plain text file and then choose Default in the style window it only changes that line of text to my chosen Default style, not the whole file of text. What version of Libre are you using? Thank you, Charles. On 10/19/12, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) I think you don't even have to select all your text. Just have the cursor somewhere in the text and click on the box besides the fonts box on the toolbar and reselect default (or whatever) i think that should be enough to reassert your fonts and sizes rather than copying the ones used in your text-editor. My text editor doesn't use Courier so i get Arial or something when i try to copypaste from it. Regards from Tom :) From: charles meyer reachmepl...@gmail.com To: users@global.libreoffice.org Sent: Friday, 19 October 2012, 15:44 Subject: [libreoffice-users] Libre Writer - Opening plain text documents to desired font Hi Folks, I'm new to Libre Office but I read how you can create your own default font style and size so a blank document will open to that default style and size. I'm trying to set Libre Writer so that when I open a saved plain text (.txt) file it opens to my created default style and size. Right now it opens to Preformatted Text - Courier New 10 point. I've visited Styles and Formatting and right clicked on Preformatted Text and chosen Modify and changes the font to Bookman Old 12 point and clicked Apply, then OK. I then reopened Preformatted Text style and it indeed displays my chosen font and size. However, still when I open a saved plain text file it opens to Preformatted Text but with Courier New 10 point - not the Bookman Old 12 point I chose and saved. Would anyone know if you can open saved plain documents to a desired font style and size or are you always stuck with Courier New 10 point whenever you open a plain text file? I know I can highlight all the text in the opened plain text file and chosoe the Default style and it will change back to my desired font and style but is there any way of ensuring any plain text files will open to a desired font stye? Thank you so much, Charles. -- 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 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/r 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 Menu/Insert/File set the style in use where the file text is inserted. So creating a new writer file and inserting the file, must assign the default format. -- 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:
Re: [libreoffice-users] Fw: Help request on CALC charts' features
El 09/10/12 19:52, Viral Orpe escribió: Hi :) Thanks for your time and replies. I could stop fighting calc to show me the chart as a single worksheet! I was charting the stock market data (available in daily doses to be bunched neatly in weekly, monthly, quarterly, yearly batches) in candlestick form. Both Excel and Calc do not allow any other lines on the candlestick charts (moving averages, e.g.). It robs the ease of analysis (and make me dependent on some websites that offer it - currently for free :) but I never liked the dependence) I read somewhere* what Shakespeare wrote of vaulting ambition :) Since, I have no spur to prick my intent, as of today I can't start vaulting onto tweaking CALC source code to add a new chart type. But, it would be fun and a taste + test of the Linux promise of free(dom)! Hope I reach the promised land one day. Any pointers are welcome. again, thanks for your time, regards, Viral Orpe p.s. *Vaulting Ambition :) http://www.shakespeare-online.com/plays/macbeth/soliloquies/blow.html (spur: I know just C, data structures, and presently am learning shell scripting. Nothing about Linux kernel/ internals and have never written software in a professional team) snip Have you tried to overlap several charts with different types?. I think this is possible if you set for each, the background of the the graphics area, as 100% transparent. Even more, you can use the result of the cells below the chart as part of it. Miguel Ángel. -- 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] using \t in regular expression replace
El 08/10/12 9:03, Cor Nouws escribió: Hi all, Brian Barker wrote (07-10-12 16:01) At 11:08 07/10/2012 +0200, Johnny Rosenberg wrote: The problem I encountered was that the paragraph breaks was replaced with the characters \t, not the [tab] (tab) character, no matter if Regular expressions were ticked or not. I got the same result when trying to replace with \x09: The paragraph breaks were replaced with the characters \x09, not the [tab] character. But maybe that's only me, I am not the OP, so feel free to ignore this. Weirdly that's true: if you search for $ on its own, you can replace the paragraph breaks with something else. The problem is then only that \t in the Replace with box is interpreted as text instead of a regular expression. (Surely that's wrong?) But you've found the solution. (I spotted this part but didn't latch on to its significance.) AH yes, that was the only thing that I did not write in my original post. Sorry for that. With Regular expressions ticked, first search for $ and replace with a character or string that does not occur in your document - perhaps a hash mark? Then repeat the search (still with Regular expressions ticked), this time searching for # and replacing with \t. Of course I used this workaround. But I wondered if I did something wrong, or missed some special trick to replace $ with a tab in one run. Sorry for previous distraction. I trust this helps. No problem of course. Thanks to you all for the replies. I think this is worth a bug report/request for enhancement. Cheers, http://extensions.libreoffice.org/extension-center/alternative-dialog-find-replace-for-writer -- 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: calc
El 12/09/12 16:26, Andreas Säger escribió: Am 12.09.2012 15:35, a a wrote: Hey, When i am creating a diagram i can change the numeric values of the y-axel, but when i try the same procedure for the x-axel, the template with options stay grey and imposible to change. How can i do to make this grey area black again so i can change the numeric values? /Magnus östlund Change the chart type to x/y-scatter chart. Ignore Tom Davies. He is the most verbose ignorant on this list. Hi Andreas, please forgive us, I believe, we all learn from you, and we are grateful for that, but IMHO we do not need to be encouraged with these adjectives. Regards. Miguel Ángel. -- 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] Re: 3.6 Calc Problem / ~lock
Mensaje original Asunto: Re: [libreoffice-users] Re: 3.6 Calc Problem / ~lock Fecha: Wed, 29 Aug 2012 18:23:17 -0500 De: anne-ology lagin...@gmail.com A: Tom tomdavie...@yahoo.co.uk CC: Steve steve.edmo...@ptglobal.com, users@global.libreoffice.org Thanks for your response - unfortunately, it does NOT go away; sometimes, I've found several of these ~lock files ;-( I've only seen this issue when the file is not closed properly. For example remove the memory stick with files opened. A program crash. Or maybe do not have rights to delete in that directory. -- 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] workspace
El 25/08/12 10:40, Jean-Baptiste Faure escribió: Hi, Le 25/08/2012 08:52, Jean Elchinger a écrit : Hello, A friend of mine is asking if it is possible to save the workspace environnement in LibreOffice like you have in MS Office. There is the file extension xlw for this. I never used this features so I don't know myself. What kind of data are stored in this file ? Best regards. JBF There is an extesion: http://extensions.services.openoffice.org/en/project/Last_Session_Multi Last Session Multi by turtle47 This tool enables to store and reload up to 10 different document sessions. -- 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: Calc 3.6.0 takes a lot of time editing any cell o a file
El 11/08/12 11:04, Juan Antonio escribió: This problem doesn't occur in all files but in one file with calculations. The option 'Autocalculate' is activated. There are simple calculations and conditional formatting. There are not large matrix formulas. This is in all cells, including empty cells, with any change. For example, if I enter a word in an empty cell, Calc stops and, if I click the mouse anywhere it hangs. After some minutes it becames ready again. With Calc 3.5 and previous this problem didn't exist with the same file. -- View this message in context: http://nabble.documentfoundation.org/Calc-3-6-0-takes-a-lot-of-time-editing-any-cell-of-a-file-tp4000339p4000582.html Sent from the Users mailing list archive at Nabble.com. Take a look to this bug: https://bugs.freedesktop.org/show_bug.cgi?id=49764 -- 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] White lines
El 10/08/12 16:03, carlamar...@xmsnet.nl escribió: It is in the text and I think they put two paragraph marks at the end of each paragraph. In MSO I can remove those bij finding ^p^p and replacing it by ^p. Carla -Oorspronkelijk bericht- Van: Norman [mailto:nor...@amuletter.net] Verzonden: vrijdag 10 augustus 2012 10:10 Aan: users@global.libreoffice.org Onderwerp: Re: [libreoffice-users] White lines What do you mean by 'white lines'? Is this underlining within the text? Are these lines borders? Is it acutally in the text, or is possibly a 'picture' within the text? On Aug 10, 2012 08:37 carlamar...@xmsnet.nl wrote: I am still looking for a way to erase white lines in the text of a document. Who can help me? Carla -- I am using the free version of SPAMfighter. SPAMfighter has removed 12781 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len Do you have a slow PC? Try Free scan http://www.spamfighter.com/SLOW-PCfighter?cid=sigen -- 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 Take a look to this extension: http://extensions.libreoffice.org/extension-center/alternative-dialog-find-replace-for-writer. I think can help to do what you need. Miguel Ángel. * Inglés - detectado * Inglés * Español * Gallego * Italiano * Inglés * Español * Gallego * Italiano javascript:void(0); -- 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: Calc 3.6.0 takes a lot of time editing any cell o a file
El 10/08/12 17:41, Juan Antonio escribió: This problem occurs in both Windows XP and 7 -- View this message in context: http://nabble.documentfoundation.org/Calc-3-6-0-takes-a-lot-of-time-editing-any-cell-of-a-file-tp4000339p4000481.html Sent from the Users mailing list archive at Nabble.com. Have you intensive calculations?, Try modifying Menu/Tools/Cell contents/Autocalculate. Is this in all cells or only cell with conditional formatting? Are there large matrix formulas? -- 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] Other SQL question as it affects Base
El 30/07/12 2:08, Dan escribió: Mark Stanton wrote: Keys are intended for the internal workings of the database, they are not meant to be used like this. What you want is the WHERE clause, or occasionally the HAVING clause, matching or excluding rows based on their data. Keys are NOT data and should not be used as such. Regards Mark Stanton One small step for mankind... I have a table, Reading, that contains three fields: ID, Date, and Meter. Date is the date the meter is read, and Meter is the meter reading. I want to know how much electricity (KWH used) I have used each month. The query below will provide that information: SELECT Ending.Date, Ending.Meter -Beginning.Meter AS KWH Used FROM Power. Reading AS Beginning LEFT JOIN Power. Reading AS Ending ON Ending.ID =1 + Beginning.ID Perhaps you are right about keys being intended for the internal workings of the database. While I don't have an example of one key being the multiple of the other key, it is possible. It just might not have any practical applications. --Dan I have used a sentence like next with Firebird, but I don't know if your database lets to use SELECT like a field. SELECT R_End.Date, (SELECT R_Beg.Date FROM Reading AS R_Beg WHERE R_Beg.Date = (SELECT DISTINCT MAX(R_Look.Date) FROM Reading AS R_Look WHERE (R_Look.Date R_End.Date))) AS Beginning_Date R_End.Meter, (R_End.Meter - (SELECT R_Beg.Meter FROM Reading AS R_Beg WHERE R_Beg.Date = (SELECT DISTINCT MAX(R_Look.Date) FROM Reading AS R_Look WHERE (R_Look.Date R_End.Date AS KwH_used FROM Reading as R_End (SELECT DISTINCT MAX(R_Look.Date) FROM Reading AS R_Look WHERE (R_Look.Date R_End.Date)) Search the maximum date before the actual row date, which lets to get the previous values to the actual row date. Miguel Ángel. * Inglés - detectado * Inglés * Español * Gallego * Italiano * Inglés * Español * Gallego * Italiano javascript:void(0); -- 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] pdf creation issue on a single file?
El 29/07/12 18:12, Hylton Conacher (ZR1HPC) escribió: Hi Miguel, On 28/07/12 18:07, MiguelAngel wrote: El 28/07/12 15:42, Hylton Conacher (ZR1HPC) escribió: Hi, I have an rainfall.ods document that has 24 tabs. Two of the tabs contain figures and the balance contain graphs of the figures. I recently experienced a problem, it would seem after my last tab addition, that prevents me from creating a PDF file of the selected sheets(12). The PDF export works fine on other files regarding `Export as PDF', why not on this file? I was using LibreOffice 3.3 and have since updated to LibreOffice 3.4.5 OOO340m1 (Build:1505). Unfortunately the newer version is unable to `Export as PDF' on the selected TABS either!! What could be wrong? There are no special characters in the sheet names bar possibly a space. I will gladly send this file to anyone who can assist as I need to create and post to a public user mailing list a PDF at the end of the month. Help is much appreciated Hylton Thank you for commenting on the OP's initial problem, and not a Linux Windows word flame-war that bears no relation to the subject line, despite some valid suggestions being valid. Verify you have not marked in the same tab the option: Embed OpenDocument file. How could I check this via the GUI? I recreated the last graph and made sure there were no 'embeds' of any kind. Could non-standard fonts i.e. not Arial, also play a part? Further to this, issue it would seem that only the last created graph is being exported( but this is NOT the last selected Tab) as when I view the exported PDF, only a single page shows, instead of approx 12. Hylton Hi Hylton, sure I have not explained with the required detail. The option is in: Menu/File/Export as PDF/[General] - General - Embed OpenDocument file. If this option is enable the only chance is to export the complete document. This option embed the ods document in the pdf file, and if you later open this pdf in LibreOffice the ods document is open. IMO a very interesting option to share a document, an accurate view plus an edit file option. About other non related things with your question, you are right, IMHO people would be better answer what it is asked, and if they like to comment about other things start their own thread. Too much blah blah blah, with few helping answers. Miguel Ángel. * Inglés - detectado * Inglés * Español * Gallego * Italiano * Inglés * Español * Gallego * Italiano javascript:void(0); -- 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] pdf creation issue on a single file?
El 28/07/12 15:42, Hylton Conacher (ZR1HPC) escribió: Hi, I have an rainfall.ods document that has 24 tabs. Two of the tabs contain figures and the balance contain graphs of the figures. I recently experienced a problem, it would seem after my last tab addition, that prevents me from creating a PDF file of the selected sheets(12). The PDF export works fine on other files regarding `Export as PDF', why not on this file? I was using LibreOffice 3.3 and have since updated to LibreOffice 3.4.5 OOO340m1 (Build:1505). Unfortunately the newer version is unable to `Export as PDF' on the selected TABS either!! What could be wrong? There are no special characters in the sheet names bar possibly a space. I will gladly send this file to anyone who can assist as I need to create and post to a public user mailing list a PDF at the end of the month. Help is much appreciated Hylton Verify you have not marked in the same tab the option: Embed OpenDocument file. Miguel Ángel. -- 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] LibO 3.6.0.2 - Calc: date notation
El 23/07/12 16:51, Dan escribió: Guy Voets wrote: Hi folks, A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past). - In LibO 3.5.5, I used to give in dates as 20-7 and they were shown as 20 Jul 12. - In LibO 3.6.0.2, if I enter 20-7, 20-7 is shown in the cell. If I enter 20-7-12, the date is inverted into 12 Jul 2020. So instead of entering 20-7, I now need to enter 12-7-20 to get the desired notation 20 Jul 12. Is this a new feature, or a bug? I just downloaded LO 3.6.2 and installed it. Then I opened Calc. I also entered 20-7 in a cell and got 20-7. It seems that Calc considered that to be text because the window to the right of the = was showing '20-7. Then I right clicked a column and formatted it using Dutch (Netherlands) as the local. I also selected 31 dec 99 from the format list. Then when I entered 20-7 I got 20 jul 2012. 14-7 gave me 14 jul 2012. It may be a new feature in that you have to format cells, rows, or columns for the type of formatting you want in them. --Dan And maybe is refined to be interpreted as date using the system separator, the same separator as in the date cell format. In my Spanish Winx64Ult: / If I enter: 20/7 I get: 20/07/12 If I enter: 20-7 I get: 20-7 (text) Miguel Ángel * Inglés - detectado * Inglés * Español * Gallego * Italiano * Inglés * Español * Gallego * Italiano javascript:void(0); -- 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] Searching for ”empty” cell (LibreOffice BASIC macro)
El 20/07/12 21:33, Johnny Rosenberg escribió: 2012/7/20 Johnny Rosenberg gurus.knu...@gmail.com: 2012/7/20 Fernand Vanrie s...@pmgroup.be: Op 20/07/2012 13:31, Johnny Rosenberg schreef: 2012/7/20 Fernand Vanries...@pmgroup.be: Johnny, I suppose you have to run the check 2 Times, first SearchType = 0 here we find if there is a formula use . What do you mean? Use . as the search string? Regular expressions set to what? True? yep looking for not empty you need regular expressions I did some brutal experimenting and after hundreds of swearwords (the damned crap freeze all the time) I actually found something. Have a look at this descriptor: With SearchDescriptor .SearchByRow=False .SearchRegularExpression=True .SearchString=^[^.]$ .SearchType=1 ' Search values. End With First it didn't work as I expected, but it found another cell in another column. That cell has a semi complicated formula with nested IF's and in this case it returns F2+STYLE(Hide). F2 in this case is an empty cell, so now I changed the formula in the cell I wanted to find, by just replacing the two quotes () with F2, and now it finds the cell! So is not good enough for making a cell empty, but I can reference to a cell that actually is empty! So what I need to do now, is to change all the formulas in one column, and the search descriptor above will work, as it seems! At least I'll try that. Ok, I'd just better give up, I guess. LibreOffice seems to be way too slow for the things I do (I am surprised that I seem to be the only one who actually do something with spreadsheets, except simple tables of a few rows and columns, doing close to nothing, more or less). Many years ago I did similar things in Excel. It crashed now and then, but it was fast, at least. Things that took maybe one second to execute in Excel seems to take hours in LibreOffice these days. I don't know exactly how long they take, since I can never wait for more than a couple of minutes before I restart it. It's very frustrating, when testing new stuff. Simple developing a spreadsheet (something that you shouldn't do, obviously) takes days instead of minutes. I am not sure where things go slow. My current spreadsheet isn't particularly big. There are currently about 2000 rows in 5 columns containing formulas and there is one column with about 3300 rows of formulas. Not that complicated formulas, mostly nested IF's. One of the 2000 row columns use a custom formula (written in LibreOffice BASIC), not very complicated: It reads the values from two cells and returns a string value depending on the input values. A few IF's, that's all. I also use conditional formatting in all of the cells, approximately 3300+6×2000=15300 cells. It's not like millions of cells or something. What is likely the most time consuming part in this case? My own cell formula in a couple of hundred cells? The conditional formatted cells? All those longer formulas with nested IF's? Anyway, back to the subject… The thing I wrote about that regular expression above was not quite accurate. I am not sure what to think any more, it all feels like a mess, kind of. It seems like cells containing a number also is found with the search descriptor above. I am not sure why this is considered a proper behaviour, but maybe it is. Well, I am not sure what more to say, feel quite confused, to say the least… What are you other guys using a spreadsheet for? It seems like whatever I try to do, it all turns out as an extremely slow confusing mess. Sorry for being such a jerk. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ then SearchType 1 on the found area Area? You mean what's found when setting ”search all”? no you can define the erea (cells) you want to searched so when you found that 1 cell has a formula, you need to check only this cell on a value the SearchString has a different meaning , depending on the .SearchType = 1 then the SearchString is the is the result of the formula or the value content Okay, that's not very well designed… at least not in my opinion. = 0 then the SearchString is the formula string Meaning what if a cell contains only a value? hope it helps I don't know, will do some tests later, but it certainly feels confusing at the moment, because when I use the Search/Replace dialogue, it doesn't work like that at all. Selecting ”Values” in the dialogue give me the result I want, it finds the first cell with an empty value (in this case a cell with a formula that returns that empty value – ). So one question that comes to my mind is why the LibreOffice Basic Search doesn't work the same way as the dialogue. Maybe it's just fun to confuse the users… As I said, I will do some more tests and come back here later. Thanks for replying. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Fernand Just can't figure it out. I have
Re: [libreoffice-users] CALC - How to count blank cells?
El 09/07/12 3:31, Simon Cropper escribió: On 09/07/12 11:01, Michael Reich wrote: On 7/4/12 11:00 AM, users+h...@global.libreoffice.org wrote: Subject: Re: [libreoffice-users] CALC - How to count blank cells? From: MiguelAngel mari...@miguelangel.mobi Date: 7/4/12 3:44 AM To: users@global.libreoffice.org El 04/07/12 5:16, dave wagner escribió: I have a small range of cells (less than 100) in which I need to count the cells that are blank. What is the best way to do this? I was trying something like =COUNTIF(C11:C103,(CELL(Type,b))).But that just did not work. Thanks to all who helps me with this simple problem. =SUMPRODUCT(ISBLANK(C11:C103)) Miguel Ángel. In a related (I think) question, what formula could be used to identify the last row in a spreadsheet with data in it? It's a similar situation as the OP, in which new data is inserted as a new row at the bottom of the sheet. I want another worksheet to be able to pick up certain fields from the last row of data, but haven't been able to figure out how to locate which row is last (with data). A1=a A2=b A3=c A4=d What I'm looking for is a formula that would tell me, in the above data, that row 4 is the last one with data. Thanks for any help! I know that this is not what you asked for exactly, but coupled with CELL() or COUNTBLANK() function, might allow you to establish the row number in your situation. The following allows me to get the last value of the column (F) in sheet1 (used in my case in a summary table that lists the final value in a column that lists the running balance of my bank account)... =OFFSET($'sheet1'.$F$6,COUNTA($'sheet1'.$F$6:$'sheet1'.$F$9633)-1,0) Assumes the range $F$6: to $F$9633 has continuous data - essentially it returns the number of rows/cells with data, so will not work if your array or range has blanks (unless the number is static or can be predicted). So in your example... COUNTA(A1:A1000) will return 4, knowing that you start from A1 allows you to extrapolate that the last row is A4. =SUMPRODUCT(MAX(NOT(iSBLANK(c11:c999))*ROW(c11:c999))) give the number of the last row with data in the range. Miguel Ángel. -- 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] CALC - How to count blank cells?
El 04/07/12 5:16, dave wagner escribió: I have a small range of cells (less than 100) in which I need to count the cells that are blank. What is the best way to do this? I was trying something like =COUNTIF(C11:C103,(CELL(Type,b))).But that just did not work. Thanks to all who helps me with this simple problem. =SUMPRODUCT(ISBLANK(C11:C103)) Miguel Ángel. -- 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] Issue with vertical alignment in table row spanning across two pages (Writer)
El 06/06/12 23:51, Sébastien Vigneau escribió: I have a table with multiple rows and two columns. One specific row of this table contains several lines of text in the first column and only one line of text in the second column, set to align to the bottom of the cell. This row spans across two pages, because of the content in the first column. The text in the second column does not align to the bottom of the cell, as would have been expected, but instead to the bottom of the part of the cell that is on the first page. How can I have this text align the actual bottom of the cell? Thank you for your help! Sébastien Maybe can help the option to not break the row between pages, in: Menu/Table/Table propierties - Text flow - - Allow row to break accross pages and columns. Miguel Ángel. -- 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] Issue with border of table row spanning two pages (Writer)
El 06/06/12 23:53, Sébastien Vigneau escribió: I have a table row spanning across two pages, set to have a visible horizontal border at the top and at the bottom. However, the border also appears at the bottom of the part of the row on the first page, and at the top of the part of the row on the second page. How could I remove this additional borders and only keep those at the top of the row, on the first page, and at the bottom of the row, on the second page? Thank you for your help! Sébastien A workaround: Define one row as repeating heading in: Menu/Table/Table properties - Text flow - Repeat heading. Set the first row without borders and 0 as height. Set the top border in the second row. Miguel Ángel. -- 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: Problem when exporting exporting from CALC to a fixed length csv
El 30/05/12 21:15, berritorre escribió: Thanks for your response. I have tried CSVed before. Actually, I don't really want to work with the csv files. Actually doesn't even need to be a csv file. Any ASCII text file probably does. It just has to have the correct format. So my client sends me a data map where he specifies the exact width for each column. E.g. Variable 1: Positions 1-4 Variable 2: Positions 5-6 Variable 3: Positions 7-10 My software generates csv files with ; as delimiter which works perfect for importing in Calc or Excel. But then I have to follow my clients requests and the document has to have exactly the required format. So what I do is I add a row at the top with the max. number of characters for this specific variable, e.g. if it would be variable 1 from the example above, the first line would look like this: 1234. This is how I guarantee the length. I found a software that is generating .sdf files from csv files (called Convert). But actually I would like to do it directly from a spreadsheet software, to avoid another software. Libreoffice almost does it right. It just takes the visible width of the column as the width to export and not the max. characters in a column. When I adapt the column width manually to the minium which still allows to see all characters Libreoffice exports correctly!! So I would just need to find a way to avoid this little visible space on the left of the cell. Excel adapts the columns correctly and doesn't add space to the left, but minimizes the column to exactly the width necessary to show all characters, but then Excel doesn't allow to export fixed field csv files. -- View this message in context: http://nabble.documentfoundation.org/Problem-when-exporting-exporting-from-CALC-to-a-fixed-length-csv-tp3986825p3986844.html Sent from the Users mailing list archive at Nabble.com. When saving as CSV there is an option to edit filter settings, one is fixed column with. (Click the option and follow saving). In the help. Fixed column width: Exports all data fields with a fixed width. The width of a data field in the exported text file is set to the current width of the corresponding column. Values are exported in the format as currently seen in the cell. If a value is longer than the fixed column width, it will be exported as a ### string. If a text string is longer than the fixed column width, it will be truncated at the end. The alignment Left, Centered, and Right will be simulated by inserted blanks. Miguel Ángel. -- 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: Calc: Search Replace Within A Column
El 26/05/12 12:41, Brian Barker escribió: At 17:14 25/05/2012 +0200, MiguelAngel wrote: Maybe the mistake is in search for 0.000, it can't be found, because a 0.000 is always saved as 0, nonsignificant zeroes to the right/left of decimal point are never saved. Computers store numbers in a fixed-length format - however-many bytes. So there are always the same number of binary digits stored - which equates to a different but similarly (approximately) fixed number of decimal digits stored (unless you choose multiple precision, of course). So surely what you may think of as nonsignificant zeroes are not never but *always* stored? Brian Barker I think not a fixed format, but a fixed length with eight bytes used to store the number in memory, as result fourteen significant numbers. In any case the user can't find 0. or 000.00, we can search for 0. In content.xml file one of the files in .ods file, we can see the saved values in office:value tag and the representation of the value in text:p tag. - table:table table:name=Sheet1 table:style-name=ta1 table:table-column table:style-name=co2 table:default-cell-style-name=Default / - table:table-row table:style-name=ro2 - table:table-cell table:style-name=ce1 office:value-type=float office:value=0 text:p000,000/text:p /table:table-cell /table:table-row - table:table-row table:style-name=ro2 - table:table-cell office:value-type=float office:value=12345 text:p12345/text:p /table:table-cell /table:table-row - table:table-row table:style-name=ro2 - table:table-cell office:value-type=float office:value=0.12345 text:p0,12/text:p /table:table-cell /table:table-row - table:table-row table:style-name=ro2 - table:table-cell office:value-type=float office:value=123.123 text:p123,12/text:p /table:table-cell /table:table-row - table:table-row table:style-name=ro2 - table:table-cell table:style-name=ce2 office:value-type=float office:value=1.23456578901234E+015 text:p1,23E+015/text:p /table:table-cell /table:table-row - table:table-row table:style-name=ro2 - table:table-cell table:style-name=ce3 office:value-type=float office:value=1.23456578901234E+015 text:p1234565789012340/text:p /table:table-cell /table:table-row /table:table Miguel Ángel. * Inglés - detectado * Inglés * Español * Gallego * Italiano * Inglés * Español * Gallego * Italiano javascript:void(0); -- 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: Calc: Search Replace Within A Column
El 25/05/12 16:52, Rich Shepard escribió: On Fri, 25 May 2012, Mirosław Zalewski wrote: Sorry we could not solve your problem, then. That's OK. awk, sed, grep, cut, and sort do the job very quickly. :-) Thanks to all for the suggesions, Rich Maybe the mistake is in search for 0.000, it can't be found, because a 0.000 is always saved as 0, nonsignificant zeroes to the right/left of decimal point are never saved. Miguel Ángel * Inglés - detectado * Inglés * Español * Gallego * Italiano * Inglés * Español * Gallego * Italiano javascript:void(0); -- 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: No QuickStarter? (Linux)
El 21/05/12 2:41, TomW escribió: On 2012-05-20 17:53, Marc Paré wrote: Le 2012-05-20 09:41, minhsien0330 a écrit : Dear all: I tried soffice --quickstart, but Libreoffice still not showed the quickstarter. Any suggestion? Thanks~ I looked for it on my MageiaLinux and it doesn't look like it is there. Maybe a dev could chime in and let us know why the QuickStart is not on the Linux version of LibreOffice? Cheers, Marc Hello: On Windows one must do a custom install to include the Quickstarter. TomW There is an option to activate it: Menu/Tools/Options/LibreOffice/Memory - LibreOffice Quickstarter. Miguel Ángel. -- 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 with using Zotero
El 18/05/12 16:48, RustyRiley escribió: I'm living Downunder so I haven't had a response to a query I put to the Zotero forums about a problem I was having with trying to insert citations into a LO 3.5.3 document -- Z would freeze -- problem occurred with both standalone and Ff versions of Z -- managed to resolve problem but not in a way I would recommend if some other way could be found as stated I had LO 3.5.3 installed, using Ff 12, and latest versions of Z and LO/OO wp integration with JRE 7 -- error messages would pop up from Z suggesting some problem with Java -- so uninstalled LO, uninstalled JRE and went back to using LO 3.4.6 and JRE 1.6 -- works sweetly, but now of course I don't have latest version of LO any suggestions? Rusty -- View this message in context: http://nabble.documentfoundation.org/Problem-with-using-Zotero-tp3984571.html Sent from the Users mailing list archive at Nabble.com. You can try, LO 3.5.3 with already installed JRE 1.6 to avoid the problem between Zotero and Java 1.7. Miguel Ángel. -- 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] Built-in Help vs. User Guides
El 04/05/12 13:46, Nino Novak escribió: On Friday 04 May 2012, 09:02:06 Alexander Thurgood wrote: Le 04/05/12 04:21, Tom Davies a écrit : Let's face it, the built-in help system sucks But OTOH, built-in Help is *very* helpful in certain situations IMHO. So, if one is looking for the exact syntax of a regex or if one wants to learn about how to use a calc function, it is first choice. So it has two aspects, the helpful one and the - how you put it - sucking one. So what we have to do is, * looking where we can improve the bad aspects * trying to keep up the valuable aspects * make people aware of *both* sides and help them adjusting their expectations to the reality: that will maximize their benefit. Generalizations like the help is bad, rather look into User Guides are less helpfull. User Guides have their uniqe role in helping people to understand certain principles / concepts, as they offer much more space for detailed redundant descriptions. However they are secondary products often produced by mere users and thus there are two major gaps within them: the time gap, i.e. they follow development with a certain delay and, the accuracy gap, i.e. they can miss certain aspects or details or functions, just because they have been simply overseen or forgotten by the original writer of the guide. Therefore, I'd rather have us teaching people the difference between the possibilities of getting help than playing them off against each other and thus confusing people. (And, yes, there are the bad aspects, too. They need improvement, of course.) Regards, Nino +1 For many users seem easier to ask in the net than read the built-in help, when often the answers are there, even with samples. And in this program like in others, IMHO, the first is at least a quick read of the built-in help to get a panoramic view, so you can have a basic acknowledgement over can be done and how. But the sign of these times is that everyone wants things done for yesterday for free and effortless. Miguel Ángel -- 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] Printint to PocketMod layout
El 23/04/12 16:03, webmaster-Kracked_P_P escribió: On 04/23/2012 09:36 AM, Nino Novak wrote: Am Montag, 23. April 2012, 05:21:35 schrieb BKh: Is there any way to print a document into the PocketMod booklet layout? If you happen to use Linux, you can use psutils (psnup and psbook) to print such nice booklets. According to Google, there seems to be also a Windows version, but I did not try it. If it can be done with LibreOffice, I don't know. But you can export to pdf and than print with Acrobat Reader (at least I think it's possible). Regards, Nino What is a PocketMod booklet ? What are the page dimensions? Are you asking about a package/extension that will print out multiple sheets that have two pages on each side of a duplexed sheet of paper, and printing the document where the pages will have the proper placement if you printed out the document, staples it, and fold it over? How many pages or page faces are you printing? 10, 20, 30? I just printed a 34 page document to the CUPs-PDF driver [instead of export to PDF]. I checked the brochure option and it printed out the pages in the proper order for printing a stack and folding it after you place a staple in it. It seemed to print out the pages in the correct order. SO, if you want 4 face pages per sheet, 2 pages per side of the sheet, then you the brochure option in Page Layout. It works for me. Did you try with Menu/File/Print/Print layout [tab] - brochure?. Miguel Ángel -- 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: Printint to PocketMod layout
El 23/04/12 22:29, BKh escribió: May I ask what you are you doing that needs this type of printed document? I never saw that type of printed document before, so it would be nice to know what you are using it for. I am using it to create booklets like the ones that appear on this site: http://www.how-to-pray-the-rosary-everyday.com/rosary-booklets.html Although the ones I am making are for Buddhist practice, not Catholic. It is actually very popular with people who are using an analog form of the GTD(Getting Things Done) method. And if you are into DIY publishing, they are rather nifty. As I stated earlier, the printing half of the pages at a time, is the only easy way to do what you need without some type of external package or extension. Thank you. I realize that I could do exactly what I want if I used desk top publishing software. But it seems so close to being possible in LibreOffice, I thought I would ask. Since the PocketMod layout seems to be a specific Patent Pending style of booklet. The possible rarity of that format and the Patent Pending issue might make it very hard to support the decision to create an extension or external package filter. It's hard to imagine that it will be possible to patent a way of folding a piece of paper into a booklet. Thanks again to everyone who offered suggestions. . On 04/23/2012 02:35 PM, BKh wrote: Hello everyone, Print as Brochure. For example getting a DIN A6 booklet write with page size DIN A6 and print with setting Brochure on DIN A5 paper sheets. I think booklet is only useful for doing two pages side by side. I realize there are many ways to do booklet printing, for booklets of various sizes. But I am interested in this very specific method mentioned in the original post that uses a single side of paper, 8 pages and no fastener. It's true that the website I linked to has software to make this conversion from a PDF, but it's not as flexible as I want and it seemed like it would be possible in LibreOffice. Thank you all very sincerely for all the suggestions. You have given me some things to consider. Best wishes, BKh On 4/23/2012 1:11 PM, Regina Henschel [via Document Foundation Mail Archive] wrote: Hi Bkh, BKh schrieb: Is there any way to print a document into the PocketMod booklet layout? Here is more information on pocketmod... http://www.pocketmod.com And folding instructions that show the layout needed: http://www.pocketmod.com/howto/ The layout photo above would probably be more clear if B and F (standing for back and front) were Numbered 1 and 8 respectively. But you get the idea. Print as Brochure. For example getting a DIN A6 booklet write with page size DIN A6 and print with setting Brochure on DIN A5 paper sheets. Kind regards Regina -- For unsubscribe instructions e-mail to: [hidden email] /user/SendEmail.jtp?type=nodenode=3933549i=0 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 If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Printint-to-PocketMod-layout-tp3932314p3933549.html To unsubscribe from Printint to PocketMod layout, click here http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=3932314code=YmtocGFsaUBnbWFpbC5jb218MzkzMjMxNHwxMzQ1NTM2NjA2. NAML http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml Do a try, playing with: Menu/File/Print/General - Pages: 1,2,3,4,7,8,5,6 Menu/File/Print/Pages Layout - Pages per sheet: custom pages: 42 - Order: left to right, then down Miguel Ángel -- 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] calc compliance with openformula
El 21/04/12 18:19, Jean-Francois Nifenecker escribió: Le 21/04/2012 17:48, Jay Lozier a écrit : I think the above syntax was developed for Lotus 123 in the early 80's(?) and everyone else implemented the rules/syntax to be compatible with Lotus. By the mid 80's this syntax was standard for all spreadsheets. The only real change from Lotus is that (using 1) is in Lotus formulas were enter +SUM(A1:A10) while the IMHO the more logical =SUM(A1:A10) was introduced later by the mid 80's. Thanks for the historical backgroud, Jay. Interesting to know. I'm sorry but +SUM(A1:A10) doesn't work in 123, there is always needed @ to introduce functions in 123: @SUM(A1:A10). Miguel Ángel * Inglés - detectado * Inglés * Español * Gallego * Italiano * Inglés * Español * Gallego * Italiano javascript:void(0); -- 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: Problems importing an OO database into LO
El 20/04/12 1:18, Andreas Säger escribió: Am 19.04.2012 20:45, Pertti Rönnberg wrote: LibO-folks, From this long and very interesting thread and some other discussions on this mailing list too, together with my own recent experiences, there is only one main conclusion to draw: There is no real future forLibO's Base module, perhaps not for the whole LibO suite. From a non-expert user's perspective there are in fact two versions of LibO-Base A a Light-LibO-Base = a package consisting of LibO-Base as a front-end GUI and an embedded db-engine HSQKDBv1.8. This package is (could be) suitable for up to medium complex databases and be used by 'ordinary' people (like me) who does not have own skills in programming or developing or in SQL or other languages (PHP, HTML, etc.) -- who plainly want to create a database following instructions mechanically B an Advanced-LibO-Base = the LibO-Base module to be used as a front-end GUI connected to an external db-engine and that can be used by people with own knowledge in programming anddb-theories and SQL and who have a good knowledge of the whole LibO's build-up,preferable in the linux environment I can hardly see any difference between A and B. The embedded HSQLDB behaves exactly like an external DB. When you open the embedded database document you actually _install_ an external HSQLDB and connect the office suite to that _external_ database in cached mode (single user on local machine) until you close the database document which re-packages the external database. IMHO, nobody needs to know anything about macro programming in order to build useful database applications with Base. The vast majority of Base macros are due to bad database design, save one or two clicks or they are made to impress the boss. There are plenty of macros for generic tasks. All the most desperately wanted macros have been written already (clone records, refresh this and that, open forms and reports, open text as hyperlink). What I would describe as Base light is the ability to use spreadsheets, csv files, dBase files, LDAP and popular mail client address books as read-only data sources for office documents, mostly mail merge. This is the most important feature and the concept is superior to MS Office if there is a computer knowledgable administrator able to work with templates, spreadsheets, plain text and some SQL in a creative manner. For the end user who writes a serial letter the type of data source makes no difference at all. It is always used in the same (slightly clumsy) way, no matter if the addresses come from Oracle server or plain text file. The Light-LibO-Base will fail because it is like a car without a gear box: you can open it and start it but not use it as intended Øthe installing procedure of Lib-O causes problems because of unclear instructions Øthe LibO-Base module as a program is half done;even basic features does not work Base is not a stand-alone program and all the _basic_ features do work well. The database backend is a mature database program, most of the rest belongs to the Writer component. There is just too much dysfunctional junk on top of the basic database functionality which does not add any additional functionality. Everything that the wizards are supposed to do can be done without the wizard. Today's users are do not accept any _basic_ features in a highly sophisticated office suite, no matter how well the basic features use to work. Instead they complain about the dysfunctional rubbish. Øthere is no documentation explicit for LibO-Base -- and will obviouslynot be; There is excellent documentation for OOo Base which is identical to LibO Base. Main problem with documentation is that today's computer users overestimate their skills and do not understand the difference between end user applications and development tools. This type of office suite suggest that each component should be as easy to use as the text processor. Users have to rely on OpenO documentation why there is no logical reason to install LibO (ordinary new users does not know about any differences between LibO and OO -- and do not know why to seek) Øthe LibreOffice Help is a disaster -- a user new to LibO does not get any (direct) help LibO documentation on Base is plain wrong and misleading. Simply point to the existing OOo docs or copy and paste that stuff. Øthe embedded HSQLv1.8 is out-of-date and causes frustration and waste of time because the lack of easy to get and sufficient support There are not many users who suffer from the limited capabilities of HSQL1.8. A high risk of total data loss is the main reason why one must not use the embedded database. Getting an embedded database out of the jail is easy enough. Øthe reports is a important part of the data output; there is no Report Builder explicit for LibO-Base or one that works properly Calc is a very good sorrogate for a report engine even if you are not very familiar with spreadsheets. It supports
Re: [libreoffice-users] Recovery and Updates
El 13/04/12 2:17, rexrino escribió: On 04/12/2012 07:42 PM, Onyeibo Oku wrote: Hi everyone, I've switched to digest mode and, so far, it is just what I need. I started a thread earlier about an anomaly in Libreoffice 3.5.1. I have not seen any response to it neither have I spotted the initial mail in any digest I have received so far. I'll repeat again: 1. Libreoffice is trying to recover files that do not exist. This happens at every start-up. The files in question are not corrupt. They were deleted and are no longer needed. I'd like to stop this behaviour. Any clues? I suspect Libreoffice maintains a list/record of recently failed loading attempts and continues to try entries on that list at each start-up ... if this is true, where does LibO maintain such? 2. I have just downloaded 3.5.2. I did notice something strange on a page linked from the download page (release notes under 'Handy Resources'). The release info has the following statement: This is the third release from the 3.5 branch of Libreoffice. It contains many exciting new features, and is the recommended version for private users and small enterprises. This is not informative! What changed between 3.5.1 and 3.5.2? The idea of release notes is to inform users of changes ... or perhaps that is reserved for main releases in the order 3.3, 3.4, 3.5 ...etc. If so, there should be a change-log or report somewhere. We cant keep downloading things without knowing what to expect. Regards Onyeibo not sure if it will help but you might try writing a doc and checking the .libreoffice directory to see how it changes (config files, backup, etc). Did you check the settings in the Tools/Options section? I'm using slackware 13.37 without the kde lib's and it flies. I have the qt lib installed but nothing kde. I'm using the xfe GUI. John. And the changes between releases are here: http://wiki.documentfoundation.org/Releases Miguel ángel. -- 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: Calc: cell protection + cut paste
El 13/04/12 22:36, miakoiv escribió:
-Original Message-
From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org]
Sent: Thursday, April 12, 2012 11:15
To: 'users@global.libreoffice.org'
Subject: RE: [libreoffice-users] Re: Calc: cell protection + cut paste
I spoke too soon. Absolute references don't solve this problem, because
even those are updated when moves happen, such as the cut and paste in the
demonstration example. There actually needs to be a way to block cutting
and other operations that relocate cells if formulas are to be protected
from movement of their operands.
It looks like a bigger issue might be whether it is possible to prevent
editing operations (cut especially but also row-column insertions and
deletions) in a sheet with protections turned on. All while still
allowing data entry into unprotected cells.
Yes, absolute references don't solve it.
And I really do agree that there should be a way to control how these
editing operations affect protected cells.
One of the core fuctions of a speadsheet program (in my opinion) in that
somebody skills can make a calculation sheet and other people can use it to
fill needed data and do the calculations and get the needed data.
In excel you build your own UI to enter data and with VB you can do a lot of
things. But in my opinion that's just overkill for most of the cases.
Somebody said that it's an expected (and maybe even wanted?) behaviour, but
I just can't understand it.
I wish I could do the coding needed, but unfortunately I'm not skilled
enough.
I think that with a small improvement LibreOffice could be a lot better tool
without too complicated things (like Excels UI + VB)
I hope somebody, who could do something about this, finds this interesting
and needed. :)
Mikko
--
View this message in context:
http://nabble.documentfoundation.org/Calc-cell-protection-cut-paste-tp3903414p3908930.html
Sent from the Users mailing list archive at Nabble.com.
A workaround is INDIRECT() function to avoid that cut/paste change the
references:
C1: =INDIRECT(A2)+INDIRECT(B1)
other options can be used like OFFSET() or INDEX(), and I don't know
how, maybe is easy to disable the cut option.
To avoid delete/insert rows/columns use an array formula:
An array formula in A1 like = {IV1:IV100} doesn't let delete/insert rows
in the range of the array formula, the same for columns with a column array.
Miguel Ángel
--
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: Calc: cell protection + cut paste
El 12/04/12 6:28, miakoiv escribió: miakoiv wrote (11-04-12 20:32) If a protected cell reads data from non protected cell and the user decides to cut + paste the information, the orginal formula in the protected cell will be modified. I don't get this. When data, that is used in a formula is changed, removed, the result of the formula will change, not the formula. Example: A1: 1 B1: 2 C1: =A1+B1 (result: 3) A2: 2 B2: 1 C2: =A2+B2 (result: 3) Now you protect cells C1 and C2. Now this is an important spreadsheet to customer and their employees fill the data to cells A1, A2, B1, B2. And it's of course important that the calculations are correct. Now the customer enters data to A1 which was supposed to go to A2. He/She cuts the data from A1 and pastes the data to cell A2. This is the result: (he/she wanted to enter 1 to A2, but entered it to A1 and then cut + pasted it to A2. Then he/she entered number 2 to A1) A1: 2 B1: 2 C1: =A2+B1 (result: 3) A2: 1 B2: 1 C2: =A2+B2 (result: 2) So the formula in C1 is now A2+B1 which is different than A1+B1 so it changed. And since the cell is protected, you can't change it back to correct one unless you cut + paste again. But if the formulas are also hidden, then it's totally impossible to fix it anymore. I've heard some comments like This is expected and wanted behaviour in all spreadsheet applications., but then I would like to ask what's the point of protection when you can't protect the formulas from even the simpliest user errors? I know that this happens in Excel too, but there you are able to prevent user from using cut+paste (and if googled, you'll notice that people use this quite much just for this reeason). If this is a wanted behaviour, it should atleast give a warning to the user. Are you sure you want to cut + paste data? It will modify protected formulas and you won't be able to fix those anymore and you will get wrong results afterwards? So are you sure? :-) Miakoiv -- View this message in context: http://nabble.documentfoundation.org/Calc-cell-protection-cut-paste-tp3903414p3904507.html Sent from the Users mailing list archive at Nabble.com. A workaround is INDIRECT() function to avoid the cut/paste: C1: =INDIRECT(A2)+INDIRECT(B1) This need edit C1 to change the reference to cells, because as you can see the references are texts and don't change with cut/paste A2 and B1. Miguel Ángel. -- 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: PLEASE ban this spammer! - NO
El 10/04/12 10:47, Tom Davies escribió: Hi :) Thanks :) It is great to see all the support from people on the users list but i don't think any of the big cheeses hang out on this list. They mostly seem to be on only the Marketing List. Thanks Don, Marc, Stuart and all the off-list supporters too. Many regards from Tom :) --- On Tue, 10/4/12, Marc Groberm...@interak.com wrote: From: Marc Groberm...@interak.com Subject: Re: [libreoffice-users] Re: PLEASE ban this spammer! - NO To: users@global.libreoffice.org Date: Tuesday, 10 April, 2012, 7:29 This requires a top-posted Amen, lol On 4/9/12 8:13 PM, Don Myers wrote: On 04/09/2012 09:42 PM, V Stuart Foote wrote: Humm, Andreas That is UNFAIR! Why do you consider Tom's posts on MariaDB as Spam? There is nothing indiscriminate about his postings. He's very clear about what he is posting and why. While they could be trimmed down a bit they are applicable as an alternative to a great number of LibreOffice users using an external DBMS. If you don't find his contributions applicable to your situation--don't read them. But, they're not SPAM! Grow up! Stuart -- View this message in context: http://nabble.documentfoundation.org/Base-Fw-MariaDB-Announce-MariaDB-5-3-6-now-available-tp3896535p3898493.html Sent from the Users mailing list archive at Nabble.com. Well said, Stuart! Not always is easy to catch the humor of Andreas, I guess a sarcastic critique. Fortunately the world is plural, and most of us can have our own thoughts, we don't need to be and think the same. I truly appreciate the contribution from both, and both are needed here. What the life would be without any disagreement?. We can left this no question and go ahead. Miguel Ángel. -- 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: Conditional Formatting columns
El 09/04/12 21:20, IGraham escribió: Seems my initial post was to ambiguous, contained info that wasn't needed and was unclear as to what i wanted etc etc (so I've been told) so I've uploaded a demo file that might make things a little clearer http://nabble.documentfoundation.org/file/n3897740/column_test.ods column_test.ods - IGraham W764 LibreOffice 3.5.2.2 -- View this message in context: http://nabble.documentfoundation.org/Conditional-Formatting-columns-tp3896993p3897740.html Sent from the Users mailing list archive at Nabble.com. I think the correct formula is: COLUMN()-COLUMN($'DH April'.$E$10)$'DH April'.$N$8 changed the = to Miguel Ángel. -- 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] Page breaks never get really deleted, bug shows when saving as docx.
El 05/04/12 22:21, Joachim Otahal (privat) escribió: Tom Davies schrieb: Hi :) Again a bug-report seems like a good plan. DocX is apparently not properly supported in MS Office and there are differences between the way it is implemented in MSO 2007 and MSO 2010. This sort of problem is one of the reasons that people here recommend keeping an original in Odt format and only save a copy in some other format when you need to share the document with someone else that can't or won't install LibreOffice or OpenOffice or any of the other office suites or programs that do support the OpenDocument Format. People are quite happy to install all sorts of extra programs to read Pdfs but then suddenly object to installing something to read Odfs. This will change as the format is becoming more popular. Regards from Tom :) Well, it is not really my choice. I do have mixed environments, at work it is MS-office and some LO. At home it is LO only. Since the work environment has a higer priority any documents which are related to work have to be .doc or .docx. But: In this case it looks like an .odt bug too, the page break gets saved even after it was deleted, I saw it in the source of the document. I just have to extract it to make a usable bug report. It simply does not show up if you repoen the .odt document. Jou I can't reproduce it in LibreOffice 3.5.2RC2 Win7x64. Maybe something in default template or in the user profile. Miguel Ángel -- 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: [Calc] Bug in Search/replace with regexp
El 21/03/12 15:23, Ninj escribió: Indeed, the replacement seems to take place after re-reading the cell content but from the beginning. It starts at the 3rd char, like it should (after =T3) but from the beginning, not the next position in string (after finding the first match). I'll file a bug indeed, thank you for the links! Best regards -- View this message in context: http://nabble.documentfoundation.org/Calc-Bug-in-Search-replace-with-regexp-tp3844337p3845725.html Sent from the Users mailing list archive at Nabble.com. Are you sure it isn't working as designed? Maybe you are interested in get the next position in your specific case, but for others is good from the beginning. I'm not an specialist in regular expressions, but perhaps other expression can get what you want. Miguel Ángel. -- 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: saving as docx crashes libreoffice 3.5.1 on windows 7
El 20/03/12 15:52, Tom Davies escribió: Hi :) Yes, doc is much better than docX for greater compatibility between the different Office Suites. MS's implementation fo docX are not quite the standard they pushed through as an ISO standard. Regards from Tom :) --- On Tue, 20/3/12, RustyRileyrusswilso...@yahoo.com.au wrote: From: RustyRileyrusswilso...@yahoo.com.au Subject: [libreoffice-users] Re: saving as docx crashes libreoffice 3.5.1 on windows 7 To: users@global.libreoffice.org Date: Tuesday, 20 March, 2012, 14:20 so the better solution might be to save it as a .doc file? From: darwinev0lved [via Document Foundation Mail Archive]ml-node+s969070n384247...@n3.nabble.com To: RustyRileyrusswilso...@yahoo.com.au Sent: Wednesday, 21 March 2012 3:07 AM Subject: Re: saving as docx crashes libreoffice 3.5.1 on windows 7 Great minds ... so that's what I did, created a new template. http://dl.dropbox.com/u/8251533/New.Standard.Template.12.ott this still crashed LO 3.5.1 on win7 when trying to save it as docx - but doesn't crash when trying to save it on LO 3.4.4 on Ubuntu 11.10 Not sure if that counts as progress or not ... On 20 March 2012 14:00, Guy Voets [via Document Foundation Mail Archive][hidden email] wrote: 2012/3/20 darwinev0lved[hidden email] If anybody wants to try the template to see if they can save it as a docx, it's here: http://dl.dropbox.com/u/8251533/New.Standard.Template.11.ott -- View this message in context: http://nabble.documentfoundation.org/saving-as-docx-crashes-libreoffice-3-5-1-on-windows-7-tp3842244p3842381.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [hidden email] 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 Hi there, I can confirm it crashes on my iMac (OS Lion 7.3) too when I try to save it as docx. Normally, I have no problem saving as docx in 3.5.1, so I suppose something sticky in your template. probably easier to make a new template than to find out why the old one crashes, but it shouldn't happen, should it? -- Guy using LibO 3.5 3.5.1 on a iMac Intel DualCore Lion -- please reply only to [hidden email] -- Dodoes can't afford to have headaches -- For unsubscribe instructions e-mail to: [hidden email] 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 If you reply to this email, your message will be added to the discussion below:http://nabble.documentfoundation.org/saving-as-docx-crashes-libreoffice-3-5-1-on-windows-7-tp3842244p3842449.html To unsubscribe from saving as docx crashes libreoffice 3.5.1 on windows 7, click here. NAML If you reply to this email, your message will be added to the discussion below:http://nabble.documentfoundation.org/saving-as-docx-crashes-libreoffice-3-5-1-on-windows-7-tp3842244p3842471.html To unsubscribe from saving as docx crashes libreoffice 3.5.1 on windows 7, click here. NAML -- View this message in context: http://nabble.documentfoundation.org/saving-as-docx-crashes-libreoffice-3-5-1-on-windows-7-tp3842244p3842508.html Sent from the Users mailing list archive at Nabble.com. The Chapter field seems to be the problem, removing it doesn't crash. LibreOffice 3.5.1 Win7Ult. Miguel Ángel. -- 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: saving as docx crashes libreoffice 3.5.1 on windows 7
El 20/03/12 15:52, Tom Davies escribió: Hi :) Yes, doc is much better than docX for greater compatibility between the different Office Suites. MS's implementation fo docX are not quite the standard they pushed through as an ISO standard. Regards from Tom :) --- On Tue, 20/3/12, RustyRileyrusswilso...@yahoo.com.au wrote: From: RustyRileyrusswilso...@yahoo.com.au Subject: [libreoffice-users] Re: saving as docx crashes libreoffice 3.5.1 on windows 7 To: users@global.libreoffice.org Date: Tuesday, 20 March, 2012, 14:20 so the better solution might be to save it as a .doc file? From: darwinev0lved [via Document Foundation Mail Archive]ml-node+s969070n384247...@n3.nabble.com To: RustyRileyrusswilso...@yahoo.com.au Sent: Wednesday, 21 March 2012 3:07 AM Subject: Re: saving as docx crashes libreoffice 3.5.1 on windows 7 Great minds ... so that's what I did, created a new template. http://dl.dropbox.com/u/8251533/New.Standard.Template.12.ott this still crashed LO 3.5.1 on win7 when trying to save it as docx - but doesn't crash when trying to save it on LO 3.4.4 on Ubuntu 11.10 Not sure if that counts as progress or not ... On 20 March 2012 14:00, Guy Voets [via Document Foundation Mail Archive][hidden email] wrote: 2012/3/20 darwinev0lved[hidden email] If anybody wants to try the template to see if they can save it as a docx, it's here: http://dl.dropbox.com/u/8251533/New.Standard.Template.11.ott -- View this message in context: http://nabble.documentfoundation.org/saving-as-docx-crashes-libreoffice-3-5-1-on-windows-7-tp3842244p3842381.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [hidden email] 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 Hi there, I can confirm it crashes on my iMac (OS Lion 7.3) too when I try to save it as docx. Normally, I have no problem saving as docx in 3.5.1, so I suppose something sticky in your template. probably easier to make a new template than to find out why the old one crashes, but it shouldn't happen, should it? -- Guy using LibO 3.5 3.5.1 on a iMac Intel DualCore Lion -- please reply only to [hidden email] -- Dodoes can't afford to have headaches -- For unsubscribe instructions e-mail to: [hidden email] 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 If you reply to this email, your message will be added to the discussion below:http://nabble.documentfoundation.org/saving-as-docx-crashes-libreoffice-3-5-1-on-windows-7-tp3842244p3842449.html To unsubscribe from saving as docx crashes libreoffice 3.5.1 on windows 7, click here. NAML If you reply to this email, your message will be added to the discussion below:http://nabble.documentfoundation.org/saving-as-docx-crashes-libreoffice-3-5-1-on-windows-7-tp3842244p3842471.html To unsubscribe from saving as docx crashes libreoffice 3.5.1 on windows 7, click here. NAML -- View this message in context: http://nabble.documentfoundation.org/saving-as-docx-crashes-libreoffice-3-5-1-on-windows-7-tp3842244p3842508.html Sent from the Users mailing list archive at Nabble.com. The Chapter field seems to be the problem, removing it doesn't crash. LibreOffice 3.5.1 Win7Ult. Miguel Ángel. -- 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: Calc enhancement request:Label ranges
El 12/03/12 9:35, mleikvol escribió: mariosv wrote Introduce: A2: 1 A3: 2 A4: 3 Create a label range: Menu/Insert/Names/Define/Adds: Name: SumRange Range: $Sheet1.$A$2:$A2 $A$2 is an absolute reference. $A2 is a relative reference. Introduce: B2: =SUM(SumRange) result 1 Copy B2 to B3: B3: =SUM(SumRange) result 3 Copy B3 to B4: B4: =SUM(SumRange) result 6 Introduce: B3: =SUM(SumRange) result 3 Introduce: B4: =SUM(SumRange) result 6 Can this help? /First a typo correction in my original post: C2==Arow will resolve to a1 should say C2==Arow will resolve to Arow Also, my example was a bit confusing since I used the word row when I should have used col / Thanks, but I'm afraid this doesnt do what I need. Your example doesnt use labels, just a named range. Maybe a lot of users isnt aware of this function? Here is a short description how label's work. Define the label range: Mark range A1:B1 Menu/Insert/Names/Labels: (make sure radiobutton contains column labels is selected) Accept the current range by pushing Add, then OK Set these cells: A1:=colA,B1=colB *(note these cells contain pure text)* A2:=1,B2:=0.1,C2:==colA A3:=10,B3=0.01,C3:==colB *(note the = in front of the label name of C2 and C3)* C2 will now show the value 1 and C3 will show 0.01 *I need to be able to point the labels to the column above:* C2 should show colA (or #REF! if it's out of range) and C3 should show 0.1 (the row above) ..and I would like this to be possible with the suggested enhancement. -- View this message in context: http://nabble.documentfoundation.org/Calc-enhancement-request-Label-ranges-tp3809978p3818694.html Sent from the Users mailing list archive at Nabble.com. Thanks for the information, I have used labels, but I don like so much because there isn't possible to set like an absolute address. To register your request for enhancement: https://bugs.freedesktop.org/ But seems difficult that a so special request will be attended, maybe if you get support from other users. I think better try will named ranges or named formulas. Miguel Ángel. -- 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] Calc enhancement request:Label ranges
El 08/03/12 16:34, mleikvol escribió: Background: Im doing a state machine simulation with libreoffice where I would like to reference the row above the with a label, to get to the previous state (row above). Now I have to do that with cell reference. Please dont suggest to use functions like offset. The number of label references in each cell can be large, and doing a offset lookup on every access would end up extremely dirty. This enhancement would save me many hours of manual lookup work. Current limitation: The current (-3.5.0) label range limits you to have a lookup to the same row (or col I guess) as the referencing cell. Action: I suggest to remove current for data range and replace it with these two parameters -Label valid range -start offset cell Example: Defined label range: column labels=$A$1:$A$2, for data range=$A$2:$B$3 A1=Arow,B1=Brow A2=a2,B2=b2 A3=a3,B3=b3 C2==Arow will always resolve to a2 C3==Brow will always resolve to b3 Goal: Defined label range: column labels=$A$1:$A$2, label valid range=$A$2:$B$3, start offset=$A$1 C2==Arow will resolve to a1 C3==Brow will resolve to b2 Challenge: Can this be done without loosing backward compatibilty for the sheets not using the new feature? PS:I'm willing to conditionally donate if this gets implemented :) -- View this message in context: http://nabble.documentfoundation.org/Calc-enhancement-request-Label-ranges-tp3809978p3809978.html Sent from the Users mailing list archive at Nabble.com. Introduce: A2: 1 A3: 2 A4: 3 Create a label range: Menu/Insert/Names/Define/Adds: Name: SumRange Range: $Sheet1.$A$2:$A2 $A$2 is an absolute reference. $A2 is a relative reference. Introduce: B2: =SUM(SumRange) result 1 Copy B2 to B3: B3: =SUM(SumRange) result 3 Copy B3 to B4: B4: =SUM(SumRange) result 6 Introduce: B3: =SUM(SumRange) result 3 Introduce: B4: =SUM(SumRange) result 6 Can this help? Miguel Ángel. -- 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] Writer too slow to be usable- part 2.
El 09/03/12 22:07, Tom Davies escribió: Hi :) This link might help you post a bug-report about it https://wiki.documentfoundation.org/BugReport or this one might be easier https://www.libreoffice.org/get-help/bug/ Thanks for testing it. :) Regards from Tom :) --- On Fri, 9/3/12, Sergio Coccisergio.co...@alice.it wrote: From: Sergio Coccisergio.co...@alice.it Subject: [libreoffice-users] Writer too slow to be usable- part 2. To: Lista Users Libre Officeusers@global.libreoffice.org Date: Friday, 9 March, 2012, 21:03 _*I saw Tom Davies info about ver. 3.5.1; so I downloaded the RC 2 of it and tested its speed. The problem has not yet been fixed - Please, may who has this part in charge take a look at it comparing, if possible, the Suse/Intel corresponding, but faster code? Sergio Cocci *_ ---* My previous message * When I take a text from Internet (a manual,a user guide, etc.) I like to get it nicely formatted before reading it (yes, I am quite *pernickety)*, so I usually maka these settings(I will translate the italian menu options, so they may not correspond exactly to the English ones): Format - Paragraph - Paragraph tab - First line= 0,5 cm After paragraph = 0.2 cm Alignment tab -: Justified Often the end of paragraph is marked only by char. 0x0A (LF), instead of the pair 0x0D0A (CR-LF); this makes also the last paragraph line to get right justified, even when it is only made by two words, that are placed one leftside and the other rightside. With the previous versions I fixed these last lines while reading the text, but the LO 3.5, with texts of 10 - 15 pages takes a huge time to accomplish these steps 1. get the End key; 2. jump to EOL; 3. get the ENTER key; 4. left alignment; 5. skip to new line - CR-LF; 6. get the Del key; 7. deletion of the old mew line - LF. I think steps 5 and 7 make the full following text to be managed - even if out of screen, since as nearer ve are to the EOT, as shorter are times. I uninstalled the standard edition and installed *the Suse/Intel version* to try it. *Result: IT WORKS FINE!!!* Sergio Cocci Reggello (Florence, Italy) -- 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 Verify your setup in: Menu/Tools/Option/LibreOffice/Memory Miguel Ángel. -- 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: Calc macro to open tab delimited data file?
El 07/03/12 22:41, fork escribió: Johnny Rosenberggurus.knugumat gmail.com writes: 2012/3/7 Andreas Sägervilleroyat t-online.de: Again, it is technically and logically impossible to write a program without knowing anything about the input. A Tab delimited text file – what more could we want to know? Some text ↹ More text ↹ More text again ↹ Text again, perhaps ↵ Another row with text, ↹ and ↵ and so on. yeah, exactly. Oh, let me add with a newline after Another row with text. (Or perhaps: a tab delimited file with text in columns. Or maybe: a text file, with columns separated by tabs and records separated by newlines. Or: A CSV file, except with tabs instead of commas... I am a little bit surprised at the level of drama my original specification elicited ...) The macros could automatically detect how many rows and columns there are, shouldn't be too difficult. I'd give it a try if I had some time left. Sorry that I don't at the moment. If you have time at some point, could you point me at the functions you would think of first to do this? I tried to record a macro but all I got was an empty Main function. Kind regards Likewise! (so refreshing...) Sorry, have you taken a look on internet to find something about. http://user.services.openoffice.org/en/forum/viewtopic.php?f=20t=40585p=186925hilit=macro+import+text+file#p186925 Miguel Ángel -- 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: page break problem
El 05/03/12 17:08, Tecknomage escribió: This is for users of LibreOffice: *SEE* https://issues.apache.org/ooo/show_bug.cgi?id=116837 This Bug Report which has the document listed below. The Calc spreadsheet include was made with OpenOffice 3.2 with 3 Manual Row-Breaks and DOES print correctly in OpenOffice 3.2, but does NOT print correctly in LibreOffice (/nor OpenOffice 3.3/). *There should NOT be a difference on how Manual Row-Breaks are handled.* Users should NOT have to modify Calc spreadsheets between verisons of LibreOffice nor OpenOffice. The incorrect behavior of *Manual Row-Breaks *in OO 3.3+ ALSO appears in LibreOffice. - According to a Newsgroup post there is a new RC release of LibreOffice 3.5.? PLEASE, can testers test the Spreadsheet that does NOT print Manual Breaks in 3.3bug-report, and check print results against PDF Print - Spreadsheet with 3 Manual Row breaks CORRECTLY Printed above. I am trying to assess IF the bug got corrected or NOT. -- View this message in context: http://nabble.documentfoundation.org/page-break-problem-tp2763737p3801083.html Sent from the Users mailing list archive at Nabble.com. Page break only work with: Menu/Format/Page/Sheet - Scaling mode, Reduce/enlarge printout selected. I don't like it, but is how it works. Miguel Ángel. -- 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] Top posting
I think nobody needs this improductive discussion. There too much places in the project where put the efforts. What is the freedom? You like top, do it. You like bottom, do it. You don't like top, don't read messages with top. You don't like bottom, don't read messages with bottom. You like the freedom. Do what you like. Let others to do what they like. Miguel Ángel. -- 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] Spreadsheet -- General searching guidance...
El 12/02/12 0:37, Barry Smith escribió: I have always been fascinated by statistics. I'm trying to understand the math behind powerball statistics, but my spreadsheet experience is having trouble meeting the bill. I'm trying to duplicate the statistics that I saw on http://www.simplypowerball.com/?q=node/33 , most simply the GMO column number of games since last hit. So far, I imported the current powerball winning numbers text file from http://www.powerball.com/powerball/winnums-text.txt After import, the sheet '20120208' contains draws including 20120208 and has 8 cols from the original data-- A DrawDate, B WB1, C WB2, D WB3, E WB4, F WB5, G PB, H PP, and I added a column I Draw DOW, which is simply a DOW number from the draw date in Col A. The value is either 4 for Wed, and 7 for Saturday. Plan to use that info later somehow. Next, I added another sheet which will scan the draws from first sheet, and report back the same stats from the SimplyPowerball webpage. The first task is getting the GMO column working. In order to do that, I need to understand how to lookup data in an array, report the row, and then to subtract a constant. Since the last draw is in row 2, I think I need to subtract 1. Yet I digress. From sheet 'Pre-2008 WB' I'm trying to figure out how to scan array '20120208'.B3:'20120208'.F1491 row-by-row, and find the first row with a number that I'm looking for (which is in 'Pre-2008' in column A, which contains the sequential list of white balls 1 thru 55). I keep getting an error 502... which doesn't tell me what part of my function is invalid. I have tried LOOKUP function, MATCH function, and currently I am trying the HLOOKUP function. The current cell has the formula [=HLOOKUP(N(A2),'20120208'.B3:'20120208'.F1491,0)] . A2 contains the number 1, so I'm attempting to just find that a 1 has ever been drawn at the moment. Ideally, the formula should contain a ROW function (I think), and subtract 2... to show me before 2/8, when was a 1 drawn as a whiteball. I have thrown a copy of my current spreadsheet onto the web on my GoogleDoc account. the file link is http://bit.ly/wjJtXu . I will continue to fiddle with the formula, but if someone would be so kind as to teach me a little about how to find the row of the last time that a number was drawn... I would be grateful... because the error from Libre office doesn't really point me in a direction to fix the error. :) Thank you, May be this is what you are looking for: =MATCH(N(A2),'20120208'!B$2:B$1491,0) Miguel Ángel. -- 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] Spreadsheet -- General searching guidance...
El 12/02/12 16:04, Barry Smith escribió:
Thank you for your help, Miguel.
=MATCH(N(A2),'20120208'!B$2:B$1491,0)
That is part of the problem. That says within the WB1 column, that
there is a match on the 122 row, but the actual row is 123... so MATCH
gives a row relative to the top of the vector. That is even better than
I was hoping for (I was thinking that I'd have to subtract a scalar
because the matrix started in Row 2 (or 3, since I'm trying to create
the stats before the draw on 2/8).
So, I dupe the MATCH function for each WB column, and can I then use MIN
to find the first occurrence...
Something like
=MIN( MATCH(N(A2),'20120208'!B$2:B$1491,0),
MATCH(N(A2),'20120208'!C$2:C$1491,0),
MATCH(N(A2),'20120208'!D$2:D$1491,0),
MATCH(N(A2),'20120208'!E$2:E$1491,0),
MATCH(N(A2),'20120208'!F$2:F$1491,0) )
That would give me the lowest row in the matrix where N(A2) is found...
I think.
Thank you for your help, Miguel.
Paz, (escribo español también)
For you can use a matrix fomula:
=ArrayFormula(MIN(IF('20120208'!B$2:H$1490=$A2;ROW('20120208'!B$2:H$1490);99)))
This is how is view in google docs,
To enter in LibreOffice, intruduce the formula:
=MIN(IF('20120208'.B$2:H$1490=$A2;ROW('20120208'.B$2:H$1490);99))
and finish with Crtl+Shift+Enter
Take care of sheet separator, if you use Libo or google docs.
Miguel Ángel.
--
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] Calc and gradient conditional formatting
El 12/02/12 16:52, Jay Lozier escribió: On 02/11/2012 08:03 PM, 451farenheit wrote: Hi there! I have been looking for a while and I do not find any related topic finally. What I want is to do a conditional format between a group of data, where the background of the cells in calc depends on the values inside the group. For example a list of numbers from 0 to 10 where 10 is totally red on the background and 0 is white. Then, a gradient of white to red should be seen between the values in between 1,2,3, and so on. Open FormatConditional Formatting. A dialog box will open allowing you specify the criteria and formatting for that criteria. AFAIK only 3 can be applied. Is that possible with calc? Any link for it? Many thanks in advance! -- View this message in context: http://nabble.documentfoundation.org/Calc-and-gradient-conditional-formatting-tp3736391p3736391.html Sent from the Users mailing list archive at Nabble.com. Now is possible in LibreOffice 3.5RC3, more than 10 conditions I don't know the limit. But also it is possible in other version using the STYLE() function inside the formula condition of conditional format. First define the styles needed. In this sample Background _1, Background_2 ... Background_10 with the different background colors. In the Conditional Formatting select Formula is = and the formula: STYLE(Background_A1) A1 is supposed to have the value to select the appropriated style. Miguel Ángel. -- 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: Unable to connect to Access DB
El 06/02/12 22:25, drew escribió: On Mon, 2012-02-06 at 21:07 +, Tom Davies wrote: Hi :) I am not sure how that link is supposed to help Donald with his question? Access uses something called Jet and something called MDAC? How can Donald find out which version of Jet is being used in their Access? Would finding out even be relevant to Donald's question, or would it only help with that unhelpful page? Hi Tom The page lists the downloads for the data drivers needed to connect to an Access database - from anything other then Access, Base included, on a Windows OS. They don't ship with Windows and therefore the user needs to go get them. Once installed the questioner should be able to connect following the instructions in the help file. --- On Mon, 6/2/12, Andreas Sägerville...@t-online.de wrote: From: Andreas Sägerville...@t-online.de Subject: [libreoffice-users] Re: Unable to connect to Access DB To: users@global.libreoffice.org Date: Monday, 6 February, 2012, 20:49 Am 06.02.2012 21:16, Donald Craig wrote: Running LibreOffice 3.4.5 on Windows 7 Home Premium laptop. Downloaded LO last week and all is fine so far with Write and Calc. But when I try to connect to an Access DB. I get an 'unable to connect, maybe necessary data provider is not installed'. What data provider would I need and where can I download it? TIA Donald Craig. http://msdn.microsoft.com/en-us/data/aa937730.aspx If I not in a mistake, the problem is derivated because is a regressión in 3.4 version and the SDBC drivers to connect with diferent MS access version, weren't shipped with LibreOffice 3.4. I reported a bug about this regression. This is solved in 3.5, which in other side seems to will be a very good version. Miguel Ángel. * Inglés - detectado * Inglés * Español * Gallego * Italiano * Inglés * Español * Gallego * Italiano javascript:void(0); -- 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] LWP documents
El 30/01/12 23:11, Gregory Forster escribió: On 1/28/2012 1:10 AM, Jay Lozier wrote: On 01/26/2012 06:30 PM, Gregory Forster wrote: How do I open LotusWord Pro documents? When I click on the document in Windows Explorer, I get a blank screen. When I enter LibreOffice and open the document, I get a blank screen. In LibreOffice, I File/Open, change the file selection to Lotus WordPro document (*.lwp), select the file and still get a blank screen. Greg Can you post the file on nabble? A brief check indicates that *.lwp files should open in LO/OOo. I wasn't quite sure how to navigate nabble. I'm not talking of one file, I'm talking of hundreds and hundreds of Lotus WordPro documents. My client's 3rd Lotus WordPro installation floppy disk corrupted, so he cannot install his Lotus WordPro. However, he wants to be able to access his Lotus WordPro documents. I understood by the advertising on the LibreOffice web site that LibreOffice could read Lotus WordPro documents, that it was a new feature for 3.4.5 It was also posted as a new feature for3.3 I was just at the LibreOffice web site and since my posting of this question, now the ability to read Lotus WordPro documents is no longer there for 3.4.5, as well as being able to read other types of documents. However, under the new features of 3.3 IS the ability to read Lotus WordPro documents. So I downloaded the provided sample. LibreOffice read that sample fine, but still won't read true LWP documents. I used 3.3 and downloaded and installed 3.4.5 Greg I think the first versions of Lotus Symphony could read Lotus 123 y Wordpro. You can try downloading from this link: http://www-03.ibm.com/software/lotus/symphony/home.nsf/home Select Get Lotus Symphony 1.3. The last version don't read Lotus files. Miguel Ángel. * Inglés - detectado * Inglés * Español * Inglés * Español javascript:void(0); -- 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] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ
El 28/01/12 14:50, Tom Davies escribió: Hi :) It 'should' be reasonably easy to update, delete or add new records to an address book using Base. Is it possible to use a different connector to your data? Regards from Tom :) --- On Sat, 28/1/12, sonicghostbusters_so...@hotmail.com wrote: From: sonicghostbusters_so...@hotmail.com Subject: [libreoffice-users] create mailmerge with spreadsheet librecalc without using libre base ! pls help how to do it TQ To: users@global.libreoffice.org Date: Saturday, 28 January, 2012, 3:39 HI, i'm facing a problem which doing mail-merge without using BASE to registered to the data source. i did successfully do it with base but now i do not wan to using base to registered the data from spreadsheet table librecalc because i wan to edit the spreadsheet data table easily for me to remove or del or update new data... May i know is there any solutions? TQ i have try using file - wizard - address data source - other external data source - no SDBC driver found Once you have registered in Base as spredsheet, you can do the modifications directly in the spreadsheet without using base. Only the registration in base is needed. Maybe this extension (FastMailMerge)is what you need: http://extensions.services.openoffice.org/en/project/FMM Miguel Ángel * Inglés - detectado * Inglés * Español * Inglés * Español javascript:void(0); -- 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] Automatically increasing next value by 2 in cells
El 15/01/12 10:15, csanyipal escribió: Hi, I have a Spreadsheet in which I must fill many cells with numbers so so every next cell contain a number that is bigger then the previous number by two. However, these cells aren't neither side by side nor one underneath another and are in pair (see the uploaded example file). Moreover I have divers for these cells, so every kind of these cells must increasing it's number by two separately from other kind of cells. In the example ods file uploaded here one can see for example that that the cell by '5c' cell in the first instance has value '1' and to the right of this cell there is another '5c' cell that has value '2'. In the raws bellow somewhere are another pair of '5c' cells by which these values are increased by 2: the first is '3' and the second is '4'. And there are other kind of cells, like '5a', '5b', '6a', '6b', '6c', etc. too that must be increased in the next instance by 2. How can I achieve that that the value of these cells get increased automatically by 2? http://nabble.documentfoundation.org/file/n3660431/AutomaticallyIncreasingCellsValues.ods AutomaticallyIncreasingCellsValues.ods - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Automatically-increasing-next-value-by-2-in-cells-tp3660431p3660431.html Sent from the Users mailing list archive at Nabble.com. If I understood your request, one solution is in cell D7: =COUNTIF($B$3:C7;B7)+COUNTIF(D$3:$V6;B7) and copy from this the cell to others without changes. Miguel Ángel. * Inglés - detectado * Inglés * Español * Inglés * Español javascript:void(0); -- 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: re: So what's with LibO 3.5?
El 15/01/12 0:06, Pedro escribió: Cor Nouws wrote Where no reference to the bugs fixed is left. Maybe a pointer to a wiki page with those notes is relevant for that www.page ? I really don't understand TDF's goals or methods Those Release Notes don't say anything about the changes since the previous version... You can just copy them and replace 3.4.4 with 3.4.5 and they are ready to be re-used. I'm puzzled. -- View this message in context: http://nabble.documentfoundation.org/So-what-s-with-LibO-3-5-tp3650042p3659807.html Sent from the Users mailing list archive at Nabble.com. In: http://wiki.documentfoundation.org/Releases/3.5.0/Beta2 Reported Bugs A list of annoying bugs still contained in this version is available from Bugzilla, the full list of reported bugs is here. List of fixed bugs Bugs fixed against Beta1 core 'Back' is misleading, use 'Revert' instead fdo#39452 .. ... Miguel Ángel -- 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] Calc handles fonts wrong
El 13/01/12 11:02, Thomas Blasejewicz escribió: Good evening OS: Windows XP, LO 3.4.4 I have noted this quite a while ago. Working on a sheet with 3 different languages (Japanese - English - German). The setting for the ENTIRE sheet specifies one font for western languages, a different font for Japanese. Yet, when I copy text from some other application (mostly Japanese) Calc renders the font differently - even though the little window indicating the font says otherwise - and I CANNOT change the font in that particular cell. This even happens, when I first copy the relevant text into a text editor and then from there into calc. Is there a way to fix this, because it is really annoying. Thank you. Thomas Have you set? Menu/Tools/Options/Language Settings/Languages - Enabled for Asian languages. Miguel Ángel. -- 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] Best JRE for LibreOffice on a 64-bit system: 32 or 64 bit ?
El 11/01/12 15:17, Fabian Rodriguez escribió: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, This may sound obvious but I am not certain of the answer and wanted to double-check here. When installting LibreOffice for Windows for use on a 64-bit system, is it best to install the 32-bit or the 64-bit JRE ? Thanks for any information on this. Fabian -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: PGP/Mime available upon request Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk8NmgIACgkQfUcTXFrypNXLWQCgr2fZ1P3jMWEkqx6s7/MM8Cid /z4An3qMCIyyKSDUSd9jjQbg032PVhIc =GQ17 -END PGP SIGNATURE- As I know, LibreOffice in Windows it's compiled only for 32-bits. Only 32-bit JRE works in LibreOffice for windows. Miguel Ángel. -- 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] CALC - current row/column highlight
El 07/01/12 8:16, alex sato escribió: Hi! I have a question about the CALC. There is a way to make highlighted the row and/or the column of the current cell to make easier to input data in a cell which is far from another cell used as reference? I know that selecting the row/column do it, but I mean a way which keep the row/column of the current cell highlighted even moving to another cell using cursor keys or clicking with mouse. Sorry for my bad english, I apologize if I said something offensive. Thanks in Advance Alex Mitsio Sato Hi Alex, in the Spanish OOo forum, there is a thread with a macro to highlight all cells in column/row of selected cell. http://user.services.openoffice.org/es/forum/viewtopic.php?f=21t=5546p=20201hilit=fila+seleccionada#p20201 Miguel Ángel. -- 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] linking a calc chart into a writer document
El 05/01/12 1:12, Tom Davies escribió: Hi :) In Writer Insert - Object - Chart seems to do something and then right-click on the chart and have a look at data-range or something. In the Draw guide there is a chapter about working with Objects and maybe that might help? http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Draw_Guide Someone else asked a similar question to this a few weeks ago and i don't think we were able to help him much either :( Apols and regards from Tom :) --- On Wed, 4/1/12, David Edwardsdav...@somniumtech.com wrote: From: David Edwardsdav...@somniumtech.com Subject: Re: [libreoffice-users] linking a calc chart into a writer document To: oo...@nouenoff.nl, users@global.libreoffice.org Date: Wednesday, 4 January, 2012, 23:56 Hi Cor, Thanks for the info. I've still not managed to work out how to do this! I had used OLE linking succesfully to insert other spreadsheets into writer and they work fine (but doesn't OLE obsolete DDE?). When I've selected the chart and paste special there is no DDE link option. Thus I've tried anchoring the chart to a cell and copying that cell. Paste special does then have a DDE option, but it just pastes a link to the empty cell and doesn't include the chart. I wonder if using DDE linking to link the actual cells into writer, generate the table locally in writer would work - though I'd need a method to hide the actual cells in writer. Is there a method to do this? Thanks in advance! To insert: - Menu/Insert/Ole Object - Create from file, mark Link to file. Select the file. To update: - Menu/Edit/Link - update. Or another way: - Menu/Insert/Ole Object - Create new. - Open the new object (double click), and paste the area from the spreadsheet including the data and the graph. - Paste. - Copy the data in original spreadsheet. - Paste special - link. The graph is from inserted object. The data are linked to the original spreadsheet. Miguel Ángel. -- 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: Calc Question Regarding Sheets and Formulas
El 02/01/12 22:23, Mark Phillips escribió: My apologies, gmail decided to send the message before I was finished..I will try it again. A row has Jan 3, Jan 8, Jan 12, in each of three columns. These string are really formatted dates. I have three sheets with names Jan 3, Jan 8, Jan 12. I want to write a formula (vlookup) that has a reference 'Jan 3'.a1:g14, but I want the Jan 3 sheet name to be taken from the cell that has Jan 3 in it. I can then copy the formula across the spreadsheet in the row under the dates and refer to each succeeding sheet. I hope this makes sense! Thanks, Mark On Mon, Jan 2, 2012 at 2:18 PM, Mark Phillipsm...@phillipsmarketing.bizwrote: Is there a way to have a text string in a cell and use that text string in a formula for the sheet name?e For example, I have this row 1: row 2 One method is use INDIRECT(TEXT(ceelwithdate;MMM D).A1:g14) to compose the address. Miguel Ángel. -- 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:
El 01/01/12 1:50, Scott Jones escribió: Happy New Year to all! Hi :) Happy New Year all! Regards from Tom :) -- 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 And if it were possible, begin to go to a better world. Miguel Ángel -- 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] Slow Insert Row
El 16/12/11 5:48, . escribió: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 When I insert a row in small sheet it takes about 7 seconds before the row is inserted. This isn't typical for my machine. On another much older machine of mine the Insert Row process is instant. I'm running Ubuntu 11.04 Any ideas? (No, I don't have a huge pile of programs that're open) -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJO6s2MAAoJEPBpZNn4grcjxRgIAJoOTZ7NimTnykV1CGSA5Hwi QmoEbsnN8t2TK0JIGmA6/2uj1vfdJxDuk2+iTt2bQ+EZQ5ay9hS7erAVq189qdNC kVhmw/e27AezdYJoMU8Pf4BZbKuLqCEMkdbbFiR6B1Re8a7sdi00bjNopD4id+lZ 4m6syBWreTPK1SoyUXVnrWXlsQoHgyVjxCVWOo3AVlbSA2tYHc+p/7tEGQliyeIA 6K0MU2I65fdKJ9R8rVFeAUghLDcyr6KZJ1kiuIal8PsSsCV5gO9RGcE5XMPI50jP WstB2NzQnM297fS11UyTEDDEyJw15JofAciQJDhfGjPjl000ga4SgQs/M+Pogu4= =XsTN -END PGP SIGNATURE- Verify the settings in: Menu/Tools/Options/LibreOffice/Memory. Miguel Ángel. -- 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: Cell reference that updates all sheets?
El 15/12/11 19:21, Pedro escribió: . wrote How do I do it? I've tried the Absolute reference method ($A$1) but that won't allow for the addition of new rows in an additional sheet. Absolute references won't work because they are updated as you insert rows. One solution is to use INDIRECT to always point at the same cells. http://db.tt/mdp3mBMz Probably there are more elegant ways of doing this :) -- View this message in context: http://nabble.documentfoundation.org/Cell-reference-that-updates-all-sheets-tp3589103p3589460.html Sent from the Users mailing list archive at Nabble.com. A very good option is use an array. In Sheet2.a1 =Sheet1.a1:a15 and use Mays+Crtl+Enter to get an array. If you insert a row in for example Sheet1.a8 then the array in Sheet2 is expanded to retain the same size, even better if you have formulae in the array rows in Sheet2, they are also copied in the new row. To edit an array you must select the array not a cell in the array, use Ctrl+/ for this. The help in the wiki about arrays: http://help.libreoffice.org/Calc/Array_Functions Miguel Ángel * Inglés - detectado * Inglés * Español * Inglés * Español javascript:void(0); -- 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] Base can't open databases
El 15/12/11 21:28, Michael Bogaerts escribió: I think that java isn't starting ... for some reason LO doesn't load java; and thus it's DB driver isn't loaded either? (i say this because normally i get a small java icon in my systray whenever java is loaded and this isn't happening anymore) Also; when i go to options - java; it takes like 8-10 seconds before the java screen responds ... and then it lists both versions of java 1.6u29 ... (i've got 1.6 1.7 installed, both x86 and x64). I have the 32 bit version selected though, as i know that LibO is a 32bit app and won't talk with the 64bit java ... I think i'll just install OO.O 's base to open my ODB files for the time being... Met vriendelijke groeten, Michael Bogaerts Zaakvoerder ~ F1/Help PC-Herstellingen -- E-Mail (Privé): i...@bogy.be mailto:i...@bogy.be *Problemen* met de *PC?* Mail dan naar: *Info@F1Help*.be mailto:i...@f1help.be?Subject=F1_Computerprobleem Informatie-website: http://F1Help.be (/F1/Help PC-Herstellingen/) Persoonlijke BLOG-site: http://dcnet.be/praten (/BoGy's Visie op het Leven/) De bij ons als Mark Stanton geidentificeerde tegenpartij wist exact op 15/12/2011 9:59 uur het volgende uit de vingers te tokkelen: Hi Alex, Hmm, I wouldn't say cut down, it is actually rather good, I understand that it *is* good. As I understand it the cut-down-ness contributes to the good-ness, or at least that was part of the design goal. Mark Stanton One small step for mankind... __ Alle inkomende en uitgaande mail van mail.bogy.be wordt gescand op spyware, spam enzomeer. Indien u toch problemen via deze mailserver zou ondervinden, stuur dan de originele mail door naar i...@bogy.be All incoming and outgoing mail from mail.bogy.be is scanned against spyware, spam, etc. If you would have any inconvenience from our services then do not hesitate to send the original mail to i...@bogy.be Serverconfig: A64 3700+, 1.5GB Ram, +1 TB HD, WXP Pro, Mercury/32. De inhoud van deze mail is enkel bestemd voor de ontvanger; indien u deze mail verkeerdelijk hebt ontvangen, gelieve de verzender hiervan op de hoogte te brengen en de inhoud niet verder te verspreiden. The contents of this mail is solely intended for the individual whom it is addressed. If you received this mail in error, then please inform the sender and do not spread the contents of this mail any further. __ You need select a 1.6_29 32 bits, Libo doesn't with Java 64 or Java 1.7 Miguel Ángel. -- 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] Change cell border sizes- quickly?
El 14/12/11 5:18, Dave Barton escribió: Original Message From: .pe...@aleksandrsolzhenitsyn.net To: users@global.libreoffice.org Date: Tue, 13 Dec 2011 22:26:01 -0500 I upgraded from Oo 3.2 (I think that was the version) to the following version of LibreOffice; LibreOffice 3.4.3 OOO340m1 (Build:302) A spreadsheet I work on had the cell borders set at 1 pt. in Oo. Now with LibreOffice all of the cell borders on the sheet are .25 pt. A change was made to the cell border sizes and I didn't do it. How do I quickly change ALL of the cell borders in the many sheets I'm working on? I have literally 1,000's of cells to fix IF I have to change each cell one at a time. Man, do I need some help! Thanks. I don't know if it's possible to fix multiple sheets at one time, but for individual sheets follow this procedure: o Keyboard Ctrl + A to select/highlight all cells on the sheet. o Right click anywhere in the highlighted area and select Format Cells o In the dialog select the Borders tab and make the adjustment. Recommend you check out the Calc User Guide: http://www.libreoffice.org/get-help/documentation/ Dave With F11, select Default format, and change there the border. If there is another style non vinculated with default, change it also. Miguel Ángel -- 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] Identifying the correct row in Spreadsheet formulas
El 10/12/11 10:28, Ian Whitfield escribió: Thanks to Brian and the others who have now put me right and shown me the right way to start a new Thread!!! Regarding the 'Signature' I was going along with what I found in the 'TDF/LibreOffice Mailing List Netiquette'... /Signature/ /Always 'sign' your message with your name and your preferred e-mail address. This is especially important because some e-mail and newsreader software do not always convey the originator's full e-mail address. While you may certainly include your regular mail address in your postings, you may wish to give this out only in personal replies, when necessary. / /Use a short signature, including only the essential information. Four lines are usually enough to include name, email, telephone number and other nicknames, and - if necessary - corporate affiliation. Please avoid lengthy legal disclaimers, which are useless in principle and even more useless - and disturbing - when posting to a mailing list. / If this is in fact wrong I would suggest that it be changed on the WebSite!! So - OK - I will go back to just signing my name and occasionally adding my City!! Thanks all - On the main question I'm still looking for a positive answer. So far VLOOKUP is NOT what I want am about to look at HLOOKUP and MATCH. Just thinking I wonder if =A+'Z4' would work to give me 'A12 if I put the value 12 into Z4. Will try... NO - That doesn't work!! I tried various combinations. The one I thought would work was 'A+(VALUE(Z4))' but no luck. Is my syntax out?? Ian Whitfield Pretoria./ / Maybe =INDIRECT(AVALUE(Z4)) Miguel Ángel. * Español - detectado * Inglés * Español * Inglés * Español javascript:void(0); # -- 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] Stuck with 3.3 forever?
El 03/12/11 18:57, Johnny Rosenberg escribió: 2011/12/3 Tom Daviestomdavie...@yahoo.co.uk: Hi :) Are the empty cells somehow defined as text-cells? Do they contain a space or a ' mark or formatted to be text? Depends on the situation, but I found that entering = into a cell causes different results from 3.3.4 vs 3.4.4. So why do that? you might ask. Well, the formulas in a column looks something like =IF(SomeCase;;IF(AnotherCase;SomeResult;SomeResult+TheCellAbove)), so here and there, there will be cells that are equal to =, and in some cases those cells will be used for calculation with the same formula. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Regards from Tom :) --- On Sat, 3/12/11, Johnny Rosenberggurus.knu...@gmail.com wrote: From: Johnny Rosenberggurus.knu...@gmail.com Subject: [libreoffice-users] Stuck with 3.3 forever? To: LibreOffice Användareusers@global.libreoffice.org Date: Saturday, 3 December, 2011, 17:10 I installed Ubuntu 11.10 from scratch today on my Eee-PC and found that the installed version of LibreOffice was 3.4.4 (my old install had 3.3.4, which I installed from the deb files at the LibreOffice download page). One of the differences I noticed between 3.4.4 and 3.3.4 is that 3.4.4 can't calculate with empty cells, which I find horrible and very surprising. For instance, I have this formula in one cell (E10), copied to a couple of thousands of cells in the same column: =IF(OR(DAY(A11)DAY(A10);C10=);;IF(OR(B10=Lunch;B10=Läkarbesök);E9;C10+E9)) Depending on the value in other cells, the result can be a time or an empty string (). In this case, E9 is an empty string, so E10 becomes ”#VALUE!”, and in fact every cell below E10 is also ”#VALUE!” because of this. Seems like the developers decided that it shouldn't be possible to use empty cells for calculation, and I just can't help myself wondering why. This is a very common task in my case, and if an empty cell is not defined as 0, it will mean that most of my formulas will be very much longer and way more complicated than they need to be with 3.3. That is, more complicated, harder to edit and very much slower. Is this really the best way to go? Why is handling an empty cell as 0 in calculations such a bad idea? Am I stuck with 3.3 like forever ow or is this going to change any time soon? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- 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 -- 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 In 3.4 only text which can be explicitly interpreted as number, is treated as number, and an space or an empty string is not a number. You can use the N(e9) to avoid this. =IF(OR(DAY(A11)DAY(A10);n(C10));;IF(OR(B10=Lunch;B10=Läkarbesök);E9;C10+N(E9))) I think this avoid misleading with text as numbers. Miguel Ángel. * Inglés - detectado * Afrikaans * Albanés * Árabe * Bielorruso * Búlgaro * Catalán * Chino * Chino (Simplificado) * Chino (Tradicional) * Croata * Checo * Danés * Neerlandés * Inglés * Estonio * Filipino * Finés * Francés * Gallego * Alemán * Griego * Griego * Haitiano * Hindi * Húngaro * Islandés * Indonesio * Irlandés * Italiano * Japonés * Coreano * Letón * Lituano * Macedonio * Malayo * Maltés * Noruego * Persa * Polaco * Portugués * Portugués de Portugal * Rumano * Ruso * Serbio * Eslovaco * Esloveno * Español * Swahili * Sueco * Tailandés * Turco * Ucraniano * Vietnamita * Galés * Yídish * Afrikaans * Albanés * Árabe * Bielorruso * Búlgaro * Catalán * Chino * Chino (Simplificado) * Chino (Tradicional) * Croata * Checo * Danés * Neerlandés * Inglés * Estonio * Filipino * Finés * Francés * Gallego * Alemán * Griego * Griego * Haitiano * Hindi * Húngaro * Islandés * Indonesio * Irlandés * Italiano * Japonés * Coreano * Letón * Lituano * Macedonio * Malayo * Maltés * Noruego * Persa * Polaco * Portugués * Portugués de Portugal * Rumano * Ruso * Serbio * Eslovaco * Esloveno * Español * Swahili * Sueco * Tailandés * Turco * Ucraniano * Vietnamita * Galés * Yídish javascript:void(0); -- 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:
Re: [libreoffice-users] Re: Stuck with 3.3 forever?
El 03/12/11 22:54, Pedro escribi:David S. Crampton wrotePer my mini-sermon (earlier today) on debugging and preferring strict type-based behavior, I would prefer A5 to also display #VALUE.Obviously! If it behaves differently it's simply inconsistent. It the user wants to change that he just has to do =A2+VALUE(A4) If there is a voting somewhere you can count +1 on the strict (coherent, consistent) behavior.Also mine.But interpret text as number is only with direct reference, not for example in the middle of a SUM().Miguelngel.. -- 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: Stuck with 3.3 forever?
El 03/12/11 22:54, Pedro escribió: David S. Crampton wrote Per my mini-sermon (earlier today) on debugging and preferring strict type-based behavior, I would prefer A5 to also display #VALUE. Obviously! If it behaves differently it's simply inconsistent. It the user wants to change that he just has to do =A2+VALUE(A4) If there is a voting somewhere you can count +1 on the strict (coherent, consistent) behavior. Also mine. But interpret text as number is only with direct reference, not for example in the middle of a SUM(). Miguel Ángel. . -- 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: Replacing graphic images in documents
El 30/11/11 0:04, Cor Nouws escribió: Pedro wrote (29-11-11 23:51) Using LO 3.4.4 under Windows XP I can simply open the image in any image viewer (or even LO Draw) and then Copy the image, select the precisely formatted image in LO Writer and simply Paste. This will replace the previous image and apply the size and position to the pasted image. Doesn't it work this way in Ubuntu? It does, Interesting solution - thanks :-) Mind that for me it only works if I use paste special as Bitmap. Cheers, May tryin with this extension: http://extensions.services.openoffice.org/en/project/ChangePicture -- 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] Cannot get LibreOffice to install
El 11/11/11 22:41, Doug escribió: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Greetings I have been trying to get LO 3.4.4, 3.4.3 or 3.3.4 to install on Windows 7 SP 1 for the past day or so. I have downloaded all the mentioned version with the help files and checked their MD5 sums (all are good). I have attempted to install with and without Admin privileges and still each version dies at trying to start the Report Builder. Between each install I use the Windows uninstaller to wipe out each version before I attempt to re-install a different version. Is this a bug or just something in Win 7 sp1 that refuses to let me run software I want? - -- Doug Roberts d...@sasktel.net - - There's nothing that kills the fun of an MMORPG as quickly as all your friends leaving the game... -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.17 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJOvZalAAoJEBapq94wYxTQgD4H/1k+novSdve2PeoY7Riy57PP g6bILCM2mGhNcZVeW5nAcG0FZMb9ynuFpsJ0FEAQRtJNcIR6YSTq0OJUJmFOEu7+ xYrRsSuISoB8IdVgYdJkI5HJkC6lFIheKKZYWm8AuWDAIuFWk3xlgWFyblq4SR5h aMrkR6cLtL9W8lhflNWfvfdxea6JYuvNGENL2yXJ4HX/F0kDjYAZnVBinWBZBVoQ 3dOGbgUMmq0qQwSbR3KzVFtRaeVF6Bke6jk9ddOWSliVEeAT45SlbMubPqh4joBZ mnkvnh4iKVmNKDTnchqZDU5dC76h1FzAt0rvsuOUhG44AmSNxVvY/fpAh6iFbt4= =P6FZ -END PGP SIGNATURE- Have you set a Java environment in Menu/Tools/Options/LibreOffice/Java?. -- 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: LO Conflicts with OOo
El 31/10/11 10:55, Stephan Zietsman escribió: Harold Fuchs wrote: The conflict I reported was between a non-portable OOo installed to the C: drive on the machine and a portable LO installed on a USB key. I don't think they'd be using the same folder for user settings. As far as I know, the portable version uses the profile on the USB key (as you mention). It seems to be located here: Z:\PortableApps\LibreOfficePortable\Data\settings (where Z:\ is the USB key's drive letter). Please check your attribution. I believe it was Regina Henschel who said you could use different user settings. From your post, it seems like No. Regards Stephan As I can see, the problem is only with portable version, may be something is eliminated to reduce the pack size. Miguel Ángel -- 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] LO auto save
El 26/10/11 21:48, Tom Davies escribi:Hi :) Yes, or use Steve's answer to set it at a reasonably longer time-interval (jic you do get carried away and forget). Hmmm, longest is 60mins apparently. It is a good idea to have the back-up thing ticked jic but i think that is unticked by default while the autosave is ticked. Regards from Tom :) --- On Wed, 26/10/11, Steve Edmondssteve.edmonds@ptglobal.comwrote:From: Steve Edmondssteve.edmonds@ptglobal.comSubject: Re: [libreoffice-users] LO auto save To:users@global.libreoffice.orgDate: Wednesday, 26 October, 2011, 20:39 Hi. In optionsload/savegeneral. this is under my Tools menu item. I turn off (untick) the backup and auto recovery options. steve On 27/10/11 08:29, Murray White wrote:I just downloaded and install LO today and am tryingout some things. One thing I wonder is if there is any way to turn off the auto save? I prefer to use Ctrl + S at my own choosing or to return to auto save if I find I prefer that option.MW-- For unsubscribe instructions e-mail to:users+help@global.libreoffice.orgProblems?http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/Posting guidelines + more:http://wiki.documentfoundation.org/NetiquetteList archive:http://listarchives.libreoffice.org/global/users/All messages sent to this list will be publicly archived and cannot be deletedThis automatic auto-recovery save is not the same as Ctrl-S, this option not overwrite your file, only save information to recovery if there is a crash.For me indeed a good option that you'll appreciate when you'll need it.Miguelngel. -- 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] [Writer] Modify hyphenation pattern for some words
El 16/10/11 13:03, Mirosław Zalewski escribió: Hi I'm using LO with automatic hyphenation. Most of times it is pretty great, but sometimes it fails miserably. Especially for words that have hyphen in them. Eg. surname Kozyr-Kowalski may be brake as: Kozy- r-Kowalski. It is unacceptable for me. Is there a way to tell LO Writer to brake words only in specific place? Or to prevent hyphenation for some words (I will hyphen them manually, if I have to)? If it matters, I am using LibreOffice from Debian testing repository; version 3.4.3 on amd64. Thanks in advance. PS. I have asked that question on LibreOffice Forum, but after week of no reply, I am posting it here as well. Have you had a look in the Text_Flow tab of Paragraph Style (Menu/Format/Paragraph or F11). There are several options obout hyphenation. -- 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] Calc row limits error
El 12/10/11 19:56, AdmFubar escribi:Calc seems to have a bug on row limits. I was attempting to load a 974 row .csv file, and Calc stopped adding lines at 714. :( Anyone else have this problem? is there a setting to adjust somewhere? using LibreOffice 3.4.3 Thanks -- View this message in context:http://nabble.documentfoundation.org/Calc-row-limits-error-tp3416403p3416403.htmlSent from the Users mailing list archive at Nabble.com.Have you verify the correct structure of the CSV file in the lines where load fails.You can see it with a simple text editor. -- 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 installing on Windows 7, with workaround
El 06/10/11 14:12, Gordon Burgess-Parker escribió: On 05/10/2011 21:21, Op Ed wrote: Now my office computer has been upgraded to Windows 7 Pro If this computer is owned by the company you work for (as you imply) than a) have you got the permission of the IT dept to actually install LO in the first place, and b) the only way is to right-click on the executable and Run as Administrator for which you will need the local admin password - again you need to see the IT dept... Or install the portable version. http://www.libreoffice.org/download/portable/ It don't need admin rights, can be instaled on USB, but also on hard disk. -- 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] toolbars automatic appearance behaviour
El 05/10/11 23:45, e-letter escribió: On 05/10/2011, Sigrid Carrera sigrid.carr...@googlemail.com wrote: Hi, On Wed, 5 Oct 2011 17:01:22 +0100 e-letter inp...@gmail.com wrote: Readers, When opening a document and a particular object becomes visible (e.g. a table) a floating toolbar appears (e.g. table toolbar). How to configure LO to stop this behaviour? next time the unwanted toolbar appears, just close it (with the x button on the top right corner). If you ever need the toolbar again, you can activate it again by using View Toolbars. This is already known; this request is to configure LO so that unwanted toolbars _never_ appear unless they have been requested via the options in the menu bar. It is an example of unwanted design. The analogy is with the noscript extension for firefox; if the web page reader does _not_ want ecmascript code to run, (s)he can configure the web browser to prevent any ecmascript being activated _by default_ and code only runs when specifically wanted. This feature of automatically displaying a table toolbar when a table becomes visible is an annoyance and provides no benefit, especially frustrating as there is no function to control this behaviour; it was expected to find such a function in the menu bar option 'tools'|'auto correct options'. Everyone has an opinion, is an Unwanted design for you. If you want, you can make an extension, or even a code modification, to change the behavour. -- 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] Default file save format to MSOffice (doc, xls, ppt) etc..
El 03/10/11 11:38, e-letter escribi:On 02/10/2011, Jean-Baptiste Faurejbf.faure@orange.frwrote:I think other formats than ODF should be considered only as export formats, like pdf is. Work in ODF, save in ODF and, if you have to send your file, choose an export format accordingly to the usage of the file. If receiver of the document does not need to modify the file, pdf is the right format. If he needs to modify the document and is not able to work with ODF (nobody is perfect), then you should export your document to doc (MS-Office 97/2000/XP). But your ODF version should always be your reference version.By coincedence, was thinking about this whilst looking at the menu bar 'file'. There are 'save as' and 'export' options. Wouldn't be better from a design perspective to use the 'save as' option only for odf formats, and the option 'export' for non-odf (pdf, png, html, etc.) formats?JBF -- Seuls des formats ouverts peuvent assurer la prennitde vos documents. -- For unsubscribe instructions e-mail to:users+help@global.libreoffice.orgProblems?http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/Posting guidelines + more:http://wiki.documentfoundation.org/NetiquetteList archive:http://listarchives.libreoffice.org/global/users/All messages sent to this list will be publicly archived and cannot be deleted+1This canmake a difference,not much,but a step. -- 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] equal width columns
El 04/10/11 1:27, James escribió: I want the columns to each be the same width (the width of the selected columns divided by the number of selected columns). I found this: Space Columns Equally Adjusts the width of the selected columns to match the width of the widest column in the selection. The total width of the table cannot exceed the width of the page but it is not what I want. I can merge all the cells into one column and then split the one column into equal parts or I can manually set the column widths but each of those methods has drawbacks. Clicking on upper-left corner, all cells and rows are selected, right-click on a column head and set column width. Mriosv -- 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] merging documents
Menu/File/New/Master Document, I think is the option that you are looking for.Regards.Miguelngel.El 28/09/11 18:19, Tom Davies escribi:Hi :) Is it possible to merge 2 different documents, both odt, so that the 1st is the title page and the 2 is the contents?The 1st page has photos.I'm trying to get about 6 documents together for the End-of-Year Report at work. Regards from Tom :) -- 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] LibreOffice / OpenOffice Calc very slow with Excel File
With the navigator [F5] you can see that there are a lot of drawing objects. Regards Miguel Ángel El 25/09/11 18:31, Vinod Nadiadwala escribió: Hi, there I am using LibreOffice 3.4.3 on Windows 7, i am moving my ogranization office suite to LibreOffice from ms-office, but having some issues with large excel files, most of the excel files works very very slow with libreoffice, i have searched google but unable to find the solutions, you can download sample file from the following URL which i have uploaded to my organization website. http://www.bhushitech.com/downloads/sample.xls (File Size: Around 8 MB ) This is lowest size which i have, if i open this file in excel it works well, but when i try to open it with LibreOffice Calc application it works very slow, i have also tried it with OpenOffice 3.3 but still the issue is same. I have also tried converting it to the .ODS using fileconverter.com, file size dramatically reduced (Around 300kb only) but still it takes around 15 min to open the file, and after opening if i move cursor it take lot of time to move from one screen to another screen. (MY PC Configuration is enough good, so the configuration is not an issue, as i have also tried it on IBM X3400 SERVER's with 16 GB Memory) Vinu -- 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] Boarders in calc
El 24/09/11 22:43, Rasmus Hjbjerg escribi:Hi LibreOffice team I really like LibreOffice, but i think that Calc can be made better. If you put double underline in boarders. I use double underline all the time, and i really miss that feature. Please include it in the next update, if possible. -- 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] Contribute to 'Copy only visible cells' extension project
Thanks for the answer Gustavo, but copy only the visible cells is the normal behavour in Libo and OOo, in 3.3 and 3.4. Regards El 21/09/11 2:21, Gustavo Pacheco escribió: Hi Miguel! The purpose of the extension is just copy the non hidden rows or columns. In other words, suppose two ways to copy a cell range with hidden columns or rows: with the simple Copy command or with the Edit 'Copy only visible cells' command provided by the extension. In the simple Copy case, If you need to copy the cell range to other sheet, you select the range, go to Edit Copy command, go to the destination sheet and Paste the cell range. The result is: all cells of the original range are copied, including the hidden columns or rows. With the 'Copy only visible cells' extension, you can use the Edit Copy only visible cells command instead of Edit Copy command on the range. Then, go to the destination sheet and Paste the cell range. The result is: only the visible cells are copied, not including the hidden columns or rows. Please, do the tests and check if your results are the same. If you have an unexpected result, send me an e-mail with details of your tests! Thanks, Gustavo Pacheco. 2011/9/20 MiguelAngel mari...@miguelangel.mobi I'm sorry, but in Libo 3.3 or OOo 3.3, only non hidden rows and columns are copied.I think the problem is paste on the non hidden cells.Miguelngel.El 21/09/11 0:39, Gustavo Pacheco escribi:Hi people! I would invite you to collaborate with the development of Copy only visible cells extension. In many cases, Copy only visible cells provides an alternative to the 'Select Visible Cells' command in Microsoft Excel. Its useful to use with subtotals or ranges with hidden columns or rows. At moment, the extension supports only English, Portuguese, French, German, Italian and Spanish languages. My goal is to add more languages with the help of the community. If you want to contribute, just send me a private email (to: gbpacheco AT gmail.com) with a translation of the phrase Copy only visible cells, your language, your country and your name (for the credits). Its simple and you can help other people who speak your language. You can try 'Copy only visible cells' extension at the new extension repository: http://extensions-test.libreoffice.org/extension-center/copy-only-visible-cellsThanks , Gustavo Pacheco. -- 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 -- 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] Contribute to 'Copy only visible cells' extension project
I'm sorry, but in Libo 3.3 or OOo 3.3, only non hidden rows and columns are copied.I think the problem is paste on the non hidden cells.Miguelngel.El 21/09/11 0:39, Gustavo Pacheco escribi:Hi people! I would invite you to collaborate with the development of Copy only visible cells extension. In many cases, Copy only visible cells provides an alternative to the 'Select Visible Cells' command in Microsoft Excel. Its useful to use with subtotals or ranges with hidden columns or rows. At moment, the extension supports only English, Portuguese, French, German, Italian and Spanish languages. My goal is to add more languages with the help of the community. If you want to contribute, just send me a private email (to: gbpacheco AT gmail.com) with a translation of the phrase Copy only visible cells, your language, your country and your name (for the credits). Its simple and you can help other people who speak your language. You can try 'Copy only visible cells' extension at the new extension repository:http://extensions-test.libreoffice.org/extension-center/copy-only-visible-cellsThanks, Gustavo Pacheco. -- 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
