Re: [libreoffice-users] Calc will not save file after sheet deleted.
On 10/08/11 13:07, Steve Edmonds wrote: Hi. On 2011-08-10 14:00, Simon Cropper wrote: On 10/08/11 10:22, Bill Gradwohl wrote: On 08/09/2011 05:46 PM, Simon Cropper wrote: *Has anyone encountered or heard of a similar problem?* *Anyone got some ideas?* Check out the bug I just created at https://bugs.freedesktop.org/show_bug.cgi?id=39930 I've been fighting this corruption issue for YEARS and can't get anyone to look at it seriously. They keep coming out with new releases, but none of them ever solve these corruption problems. When LO saves a file and then can't reopen it successfully, it is LO's problem regardless of what an end user might have done. They keep putting a new coat of paint on a rusty chassis and are shocked, shocked when someone points out the rot. -- Bill Gradwohl Roatan, Honduras Hi Bill, I was aware of your issue but don't believe we are talking about the same problem. My symptoms are quite different. I am not sure at present whether the problem is a corrupt file or wonky OO/LO code. I may be wrong, but I have always thought that a Save As saves in a newly created file formatted from scratch. If a file that has been Saved As still exhibits the problem I would think that 1. if the file is corrupted LO is corrupting it and has a bug or 2. if the file is not corrupted (you could delete a sheet in say OOO?) then the bug is in LO. Either way LO has a bug. steve Steve, 1. I am not sure about 'Save as' myself. My testing though suggests it only converts or resets the internal file structure on conversion to another format. ODS to ODS does not appear to rewrite the internal structure. 2. the files created with 'Save as' does exhibit the problem. This indicates the problem is file specific and able to be transmitted to derivatives. 3. The problem can not be recreated in a freshly created ODS file, so in essence you could argue it is not a bug. 4. My gut feeling is the file structure is somehow corrupted. Nothing that would affect normal operation but shows up when conducting broadscale sheet manipulations. How this change has come about is unclear. OK, to prove a point, I stripped everything out of a copy of the file except the tabs and underlying structure. I opened each tab, deleted the text and cleared the font / background / linework formatting using the toolbar options. Removed the freeze panes and an object (images or textboxes) from the sheet. Saved. Tried to delete a sheet and behold, wouldn't you guess it, the file saved OK. This is a Seinfield moment I am currently holding my head in my hands repeating serenity now! serenity now! OK. OK. This indicates that something has been added to the file in recent months that is causing the problem -- an image, some imported text... h.. Really the only input to this file is text/numbers entered via the keyboard or the importation of text/numbers via CSV downloaded from a bank account. I stripped these but it made no change. *The short version* To cut a long process short I deleted a sheet then proceeded to clear the contents of other sheets progressively *until* I was able to save. This identified the sheet. I then repeated this process until I identified a single cell. In fact it was a 'duplicate cell'. This cell has an associated picklist -- that is cell range with a variety of legitimate values. It also has a comment inserted. This comment is simply an explanation and reminder to do something. *Delete the comment* and the sheet saves as expected; undo the change and the error appears. I say 'duplicate' because I copied and paste this block to another location on the same sheet as a 'fixed' copy (as the original has VLOOKUPs that change based on picklist value) but neglected to omit the comments so they were duplicated. *Some additional testing* 1. Going back to some 'uncorrupted' files from 2009 I am unable to reproduce the error. 2. If I create a new file I can not reproduce the error. 3. It is necessary to delete both the original and copy of the comment in question. Deleting one or the other makes no difference, both must be deleted. inspection of the contents.xml in the archive only shows one comment (I have no idea if this is normal; I presume a reference to the 'comment' object was cmpies not the object). 4. Once the offending comment-pair are deleted then the file works as expected. 5. If you reinsert a comment in the sheet -- after saving, closing and reopening the 'corrupted' file, you get an error again. 6. If you insert a comment in other sheet. In most the save works but for a couple it does not. I can not find any visible similarity in the data, format or objects on these pages (the error is triggered on certain sheets only). 7. If you create a new sheet, copy the text/numbers/format//formulas to the new sheet and delete the offending 'corrupt sheet'. Deleting another sheet does not trigger the error. If you insert a
[libreoffice-users] The macro script to copy range cell from another file
Is there anyone knows how to copy range cell from another file ... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] mailinglist
Werte Damen und Herren, bitte meine E-Mail Adresse aus der mailinglist streichen. Danke Rainer Kretzschmar Kärrnerweg 25 09350 Lichtenstein e-Mail: srkretzsch...@vodafone.de -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Macro not active when the document start
I'm using macro's function and it doesn't start when the document start. It would start if I change the value of the variabel at the function. The code is to change numeric value to string. If I execute the code: ubah(123) the result is seratus dua puluh tiga. Any idea how to make the function executed when I open the document? The code is: Public Function ubah(x as currency) as String Dim triliun As Currency Dim milyar As Currency Dim juta As Currency Dim ribu As Currency Dim satu As Currency Dim sen As Currency Dim baca As String If x 1 Then gusti = Modul belum tersedia saat ini Exit Function End If 'Jika x adalah 0, maka dibaca sebagai 0 If x = 0 Then baca = angka(0, 1) Else 'Pisah masing-masing bagian untuk triliun, milyar, juta, ribu, rupiah, dan sen triliun = Int(x / 1000 ^ 4) milyar = Int((x - triliun * 1000 ^ 4) / 1000 ^ 3) juta = Int((x - triliun * 1000 ^ 4 - milyar * 1000 ^ 3) / 1000 ^ 2) ribu = Int((x - triliun * 1000 ^ 4 - milyar * 1000 ^ 3 - juta * 1000 ^ 2) / 1000) satu = Int(x - triliun * 1000 ^ 4 - milyar * 1000 ^ 3 - juta * 1000 ^ 2 - ribu * 1000) sen = Int((x - Int(x)) * 100) 'Baca bagian triliun dan ditambah akhiran triliun If triliun 0 Then baca = ratus(triliun, 5) + triliun End If 'Baca bagian milyar dan ditambah akhiran milyar If milyar 0 Then baca = ratus(milyar, 4) + milyar End If 'Baca bagian juta dan ditambah akhiran juta If juta 0 Then baca = baca + ratus(juta, 3) + juta End If 'Baca bagian ribu dan ditambah akhiran ribu If ribu 0 Then baca = baca + ratus(ribu, 2) + ribu End If 'Baca bagian rupiah dan ditambah akhiran rupiah If satu 0 Then baca = baca + ratus(satu, 1) End If 'Baca bagian sen dan ditambah akhiran sen If sen 0 Then baca = baca + ratus(sen, 0) End If End If ubah = UCase(Left(baca, 1)) LCase(Mid(baca, 2)) End Function Function ratus(x As Currency, Posisi As Integer) As String Dim a100 As Integer, a10 As Integer, a1 As Integer Dim baca As String a100 = Int(x * 0.01) a10 = Int((x - a100 * 100) * 0.1) a1 = Int(x - a100 * 100 - a10 * 10) 'Baca Bagian Ratus If a100 = 1 Then baca = Seratus Else If a100 0 Then baca = angka(a100, Posisi) + ratus End If End If 'Baca Bagian Puluh dan Satuan If a10 = 1 Then baca = baca + angka(a10 * 10 + a1, Posisi) Else If a10 0 Then baca = baca + angka(a10, Posisi) + puluh End If If a1 0 Then baca = baca + angka(a1, Posisi) End If End If ratus = baca End Function Function angka(x As Integer, Posisi As Integer) Select Case x Case 0: angka = Nol Case 1: If Posisi = 1 Or Posisi 2 Then angka = Satu Else angka = Satu End If Case 2: angka = Dua Case 3: angka = Tiga Case 4: angka = Empat Case 5: angka = Lima Case 6: angka = Enam Case 7: angka = Tujuh Case 8: angka = Delapan Case 9: angka = Sembilan Case 10: angka = Sepuluh Case 11: angka = Sebelas Case 12: angka = Duabelas Case 13: angka = Tigabelas Case 14: angka = Empatbelas Case 15: angka = Limabelas Case 16: angka = Enambelas Case 17: angka = Tujuhbelas Case 18: angka = Delapanbelas Case 19: angka = Sembilanbelas End Select End Function -- 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 Calc: Format column titles in DataPilot
Hi Joe, JOE Conner wrote (09-08-11 23:04) *One thing I noticed right away - there is a serious bug when changing orientations, in that it is difficult to keep the text within the cell. As I was rotating the text it would often bounce into the adjoining cell. It seems that the text alignment feature does not extend to rotated text, and chooses any random alignment.* In the section Rotation, you can choose the reference boarder too. -- - Cor - http://nl.libreoffice.org -- 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] Macro not active when the document start
toto wrote (10-08-11 09:23) I'm using macro's function and it doesn't start when the document start. You can change that via Tools Customize Events. Find the OnOpen event and link it to the macro for the document. Regards, -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] LO showing wrong version in About
Because of recent problems with Calc I updated LibreOffice from 3.3.2 to 3.3.3 to 3.4.2. When installing under XP the package LibO_3.4.2_Win_x86_install_multi.exe the Help/About screen shows wrong information: LibreOffice 3.3.2 OOO330m19 (Build:202) tag libreoffice-3.3.2.2 Is this a bug or a feature? ;-) -- View this message in context: http://nabble.documentfoundation.org/LO-showing-wrong-version-in-About-tp3241824p3241824.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] mailinglist
On 08/10/2011 10:48 AM, RK wrote: Werte Damen und Herren, bitte meine E-Mail Adresse aus der mailinglist streichen. Danke Rainer Kretzschmar Kärrnerweg 25 09350 Lichtenstein e-Mail: srkretzsch...@vodafone.de -- 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 Nobody here can do what you ask. The only one that can unsubscribe you is you yourself. To do so, READ the instructions just above (which appear at the bottom of each and every message you receive from the list. -- Stan Goodman Qiryat Tiv'on Israel -- 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 showing wrong version in About
Hi :) The 3.3.3 is the latest stable release. The 3.4.2 is for early adopters, ie development branch, and has quite a few extra features with possibly greater success at converting docX files. Sorry i can't help with the actual question! Hopefully someone else will. Regards from Tom :) From: Jorgo ma...@jorgo.com To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 9:45:12 Subject: [libreoffice-users] LO showing wrong version in About Because of recent problems with Calc I updated LibreOffice from 3.3.2 to 3.3.3 to 3.4.2. When installing under XP the package LibO_3.4.2_Win_x86_install_multi.exe the Help/About screen shows wrong information: LibreOffice 3.3.2 OOO330m19 (Build:202) tag libreoffice-3.3.2.2 Is this a bug or a feature? ;-) -- View this message in context: http://nabble.documentfoundation.org/LO-showing-wrong-version-in-About-tp3241824p3241824.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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 showing wrong version in About
On 10/08/2011 09:45, Jorgo wrote: Because of recent problems with Calc I updated LibreOffice from 3.3.2 to 3.3.3 to 3.4.2. When installing under XP the package LibO_3.4.2_Win_x86_install_multi.exe the Help/About screen shows wrong information: LibreOffice 3.3.2 OOO330m19 (Build:202) tag libreoffice-3.3.2.2 Is this a bug or a feature? ;-) I installed 3.4.2 in Windows 7 and HelpAbout says LibreOffice 3.4.2 OOO340m1 (Build:203) so I'm not sure why yours doesn't... -- 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] add ttf fonts to LibreOffice
Hi :) Is this something to do with Paths? Can it be fixed in Tools - Options - LibreOffice - Paths? Errr is LE being used to refer to LibreOffice? Is it used in the French lists or something? Regards from Tom :) From: planas jsloz...@gmail.com To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 6:15:08 Subject: Re: [libreoffice-users] add ttf fonts to LibreOffice Hi On Tue, 2011-08-09 at 21:05 -0700, SillyOne wrote: My question is really basic, but I couldn't find anything about it, sorry. So here goes. Adding fonts to the windows version of LE is simple, just add them to the c:/windows/fonts folder (or install via control panel), and you can use them in LE just as in any other applications. But in Linux (I'm using Linux Mint 11 x64) I can't figure out how to get it done. *what I have tried:* 1) copied the fonts to /usr/share/fonts/truetype/windows-fonts, updated the font cache doing sudo fc-cache -fv, they show up using fc-list, but they didn't show up in LibreOffice. 2) opened the font in font viewer and clicked install, same as above. I'd prefer a solution that can be automated (I'm about to install hundreds of fonts), but everything is appreciated. Thank you! -- View this message in context: http://nabble.documentfoundation.org/add-ttf-fonts-to-LibreOffice-tp3241306p3241306.html Sent from the Users mailing list archive at Nabble.com. You can use Synaptic, it may be called Package Manager, to select the fonts from the Ubuntu/Debian/Repositories to be installed. They be installed so the system will see them. The other reference you can check is the Ubuntu help and OpenOffice help. OOo is our older sibling and they have extensive documentation. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Printing selected sheet from 3.4.0 calc prints all sheets.
Yes, not only the version for mac, but this is actually happen in libreoffice 3.3.3 ubuntu version. -- View this message in context: http://nabble.documentfoundation.org/Printing-selected-sheet-from-3-4-0-calc-prints-all-sheets-tp3047106p3241957.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Need Calc help
Am 09.08.2011 16:49, Onyeibo Oku wrote: There is a Calc Section of the forum? Where? Overwiew native language forums: http://user.services.openoffice.org/ Overview English forum with all sections and subsections: http://user.services.openoffice.org/en/forum/index.php Search mask: http://user.services.openoffice.org/en/forum/search.php All topics in chronological order of last posting: http://user.services.openoffice.org/en/forum/search.php?search_id=active_topics -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: LO showing wrong version in About
Found the solution: 3.4 installed itself in another directory in parallel to 3.3, so most shortcuts were on the 3.3 version... some cleaning reconfiguring solves the mess. thanks for your feedback! -- View this message in context: http://nabble.documentfoundation.org/LO-showing-wrong-version-in-About-tp3241824p3242327.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] add ttf fonts to LibreOffice
On 2011-08-10, Tom Davies wrote: On Tue, 2011-08-09 at 21:05 -0700, SillyOne wrote: Adding fonts to the windows version of LE is simple [...] Errr is LE being used to refer to LibreOffice? Is it used in the French lists or something? Sounds like the official Firefox shortening, Fx (while many people use Ff). I've been using LibO, but, BTW, do we have some official shortening? -- Nuno J. Silva (aka njsg) gopher://sdf-eu.org/1/users/njsg -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc will not save file after sheet deleted.
Am 10.08.2011 01:46, Simon Cropper wrote: Hi, I have an old spreadsheet in ODS format. The file was originally an XLS file then converted to ODS format several years ago *and* has been used weekly over that period without any problems. Since the days of OpenOffice.org 1.0 I use the same dBase file together with Calc data pilots as reporting engine. I'm pretty sure that this file will take another 50,000 records during the next 10 years without any problems. Spreadsheets are the worst data storage, regardless if Excel, ODF or whatever. Even a collection of plain text tables is far better than spreadsheets. -- 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] The macro script to copy range cell from another file
On 08/10/2011 03:30 AM, toto wrote: Is there anyone knows how to copy range cell from another file ... Do you mean from another file that is open, or another file that is on disk and not loaded into RAM? Off hand, I believe that you need to select the the cells, copy them to the clipboard, focus the cursor in the destination sheet, then paste. I do not believe that copy range works between Calc documents. Here are some hints: http://www.oooforum.org/forum/viewtopic.phtml?t=23067 http://www.oooforum.org/forum/viewtopic.phtml?t=26491 http://www.oooforum.org/forum/viewtopic.phtml?t=115480 -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] How can I build only libreoffice-writer instead of whole office suite ?
Hallo all.This is my first post to the list. I have successfully build libreoffice-3.3.3.1 form source.However, I need office only to open and edit word documents and nothing else. So I want only to build the writer part and not the whole office.I have googled but have not found anything to this effect.The documentation covers only building from git and not the individual parts. So is it possible only to build a part of libreoffice instead of whole suite ? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: LibreOffice Calc: Format column titles in DataPilot
Joe, Download this document: http://www.mediafire.com/?qfhk56r2eyihccu The 3rd sheet has a data pilot derived from the data on the first sheet. Apply whatever format to the column headers (Category 1 etc.). Then call DataDataPilotRefresh from the menu or the pilot's context menu. You may also select a header, look up the underlying cell style in the stylist and modify that. In this case the formatting will survive a refresh but the formatting is applied to the row headers as well. -- 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] add ttf fonts to LibreOffice
The KDE desktop has a nice application built in to add fonts. The Gnome desktop is from a time when programmers lived in caves and ate their young. You have to know the super secret directories to copy into, then the 3 name never spoken script files to edit. There is a Gnome font adding application, but most distros don't include it. On Tue, 2011-08-09 at 21:05 -0700, SillyOne wrote: My question is really basic, but I couldn't find anything about it, sorry. So here goes. Adding fonts to the windows version of LE is simple, just add them to the c:/windows/fonts folder (or install via control panel), and you can use them in LE just as in any other applications. But in Linux (I'm using Linux Mint 11 x64) I can't figure out how to get it done. *what I have tried:* 1) copied the fonts to /usr/share/fonts/truetype/windows-fonts, updated the font cache doing sudo fc-cache -fv, they show up using fc-list, but they didn't show up in LibreOffice. 2) opened the font in font viewer and clicked install, same as above. I'd prefer a solution that can be automated (I'm about to install hundreds of fonts), but everything is appreciated. Thank you! -- View this message in context: http://nabble.documentfoundation.org/add-ttf-fonts-to-LibreOffice-tp3241306p3241306.html Sent from the Users mailing list archive at Nabble.com. -- Roland Hughes, President Logikal Solutions (630)-205-1593 http://www.theminimumyouneedtoknow.com http://www.infiniteexposure.net No U.S. troops have ever lost their lives defending our ethanol reserves. -- 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] add ttf fonts to LibreOffice
On 10/08/2011 14:04, Roland Hughes wrote: The Gnome desktop is from a time when programmers lived in caves and ate their young. You have to know the super secret directories to copy into, then the 3 name never spoken script files to edit. Eh? Just copy into the Fonts folder - just like you do in Windows. No need to edit anything... -- 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] add ttf fonts to LibreOffice
i dont know about other distros or desktop manager but in ubuntu 10.04 (Gnome classic),i could install fonts by double clicking it. On 10 August 2011 18:34, Roland Hughes rol...@logikalsolutions.com wrote: The KDE desktop has a nice application built in to add fonts. The Gnome desktop is from a time when programmers lived in caves and ate their young. You have to know the super secret directories to copy into, then the 3 name never spoken script files to edit. There is a Gnome font adding application, but most distros don't include it. On Tue, 2011-08-09 at 21:05 -0700, SillyOne wrote: My question is really basic, but I couldn't find anything about it, sorry. So here goes. Adding fonts to the windows version of LE is simple, just add them to the c:/windows/fonts folder (or install via control panel), and you can use them in LE just as in any other applications. But in Linux (I'm using Linux Mint 11 x64) I can't figure out how to get it done. *what I have tried:* 1) copied the fonts to /usr/share/fonts/truetype/windows-fonts, updated the font cache doing sudo fc-cache -fv, they show up using fc-list, but they didn't show up in LibreOffice. 2) opened the font in font viewer and clicked install, same as above. I'd prefer a solution that can be automated (I'm about to install hundreds of fonts), but everything is appreciated. Thank you! -- View this message in context: http://nabble.documentfoundation.org/add-ttf-fonts-to-LibreOffice-tp3241306p3241306.html Sent from the Users mailing list archive at Nabble.com. -- Roland Hughes, President Logikal Solutions (630)-205-1593 http://www.theminimumyouneedtoknow.com http://www.infiniteexposure.net No U.S. troops have ever lost their lives defending our ethanol reserves. -- 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 -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- 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] mailinglist
could any language be used to ask question in this mailing list? On 10 August 2011 14:41, Stan Goodman stan.good...@hashkedim.com wrote: On 08/10/2011 10:48 AM, RK wrote: Werte Damen und Herren, bitte meine E-Mail Adresse aus der mailinglist streichen. Danke Rainer Kretzschmar Kärrnerweg 25 09350 Lichtenstein e-Mail: srkretzsch...@vodafone.de -- 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 Nobody here can do what you ask. The only one that can unsubscribe you is you yourself. To do so, READ the instructions just above (which appear at the bottom of each and every message you receive from the list. -- Stan Goodman Qiryat Tiv'on Israel -- 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 -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- 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] add ttf fonts to LibreOffice
Which font app are you talking about? I use GNOME on Ubuntu and I had several to choose from. It even had a default font viewer app included. Besides, I do not live in a cave, but on the 10 floor of a building that houses the elderly and the physically handicapped. No jokes about that please, since I am an advocate for the rights of handicapped/disabled people. Myself, I choose GNOME over KDE. There are some nice things about KDE, but I rather use GNOME and add some of the KDE utilities to it to give me the best of both worlds. On 08/10/2011 09:04 AM, Roland Hughes wrote: The KDE desktop has a nice application built in to add fonts. The Gnome desktop is from a time when programmers lived in caves and ate their young. You have to know the super secret directories to copy into, then the 3 name never spoken script files to edit. There is a Gnome font adding application, but most distros don't include it. -- 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: Base 3.4.2 doesn't run on Windows 7
Hi :) Thanks for confirming that the _21 is the best version for LibreOffice. Is there any chance of joining the Documentation Team to write-up the instructions for installing a separate version of Java specifically for LibreOffice? I think a chapter about Java is likely to start off as being very small and it's not clear exactly where it could go but i think once written it could be moved fairly easily. Alternatively perhaps an Ubuntu Community Documentation page? Either a radical re-write of https://help.ubuntu.com/community/Java or something more specific to LibreOffice such as creating a new page https://help.ubuntu.com/community/Base/Java With a longer-term view of having a single main page about Base that then has sub-pages (such as the Java one) and/or links to proper LibreOffice documentation. Regards from Tom :) From: Don Myers donmy...@myersfarm.com To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 4:09:06 Subject: Re: [libreoffice-users] Re: Base 3.4.2 doesn't run on Windows 7 Hi, When we had the long thread about Base working really slowly and the problem being Java, I thought someone said the issue only affected those running Base in Linux. I only run it (but on 4 machines) in Ubuntu. I have no Windows installs. When Ubuntu had 1.6.0_22 as the default, my base worked fine. When the Java 1.6.0_24 update was installed, base became horribly slow. When the 1.6.0_26 update was installed, it was still very slow. Someone in the thread said that in Linux you can have two Java versions installed on a system side by side, and he gave instructions on how to do it. Following those instructions, I've tried both 1.6.0_21 and 1.6.0_22. Base works well with both of them, but is just a tiny bit faster on my systems with the _21 version. When you install the second version as per the instructions this person gave, the older version is only used for LibreOffice. The browsers are still using the latest version, so you have all of the security protection of the latest version. I'm sorry I can't give you advise relative to Windows systems. I don't know if Windows has the same situation as Linux. The problem wasn't that Base didn't run in Linux. It was just very sluggish. On 08/09/2011 06:50 PM, Tom Davies wrote: Hi :) Except that quite a few people have reported problems with ultra-new java such as the _26 version. The _22 and _20 were ok but the _21 seems to be the best for LibreOffice Base. I think the _22 is the standard one in the Ubuntu repos but i'm not sure about other distros or Windows (or Mac or Bsd). It might mean you need to have 2 versions of Java installed as your web-browser might be using something other than the _20 - _22 Regards from Tom :) From: webmaster for Kracked Press Productionswebmas...@krackedpress.com To: users@global.libreoffice.org Sent: Sun, 7 August, 2011 14:00:59 Subject: Re: [libreoffice-users] Re: Base 3.4.2 doesn't run on Windows 7 I remember something about Sun/Oracle older version of Java having problem with LibreOffice, but there is an open-source version that would instead. The one on my Ubuntu system states it is Sun's Java, but the file's name [folder's name] of the runtime engine seems to be Java-6-openjdk. I know someone on this list would know what the best link for it is. Ubuntu seems to have it on its repository, but Windows would need a link to find/download it for their use. As for the latest version of Java, it is always a good idea to keep your version of Java up-to-date. On 08/07/2011 07:20 AM, Juan Antonio wrote: Solved . The problem was *Java*. It wasn't correctly installed in my pc. I've desinstalled Java and then installed the last version, and LibreOffice Base runs normally. Regards! -- View this message in context: http://nabble.documentfoundation.org/Base-3-4-2-doesn-t-run-on-Windows-7-tp3222847p3232949.html l Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- *** * -- 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?
Re: [libreoffice-users] mailinglist
Hi :) Not really. It is nice to see different languages in here but native English-speakers are often unable to understand more than 1 language and many have trouble even with that one. There are many other lists for many other languages. Regards from Tom the monoglot :) From: soumalya ray drsouma...@gmail.com To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 14:12:31 Subject: Re: [libreoffice-users] mailinglist could any language be used to ask question in this mailing list? On 10 August 2011 14:41, Stan Goodman stan.good...@hashkedim.com wrote: On 08/10/2011 10:48 AM, RK wrote: Werte Damen und Herren, bitte meine E-Mail Adresse aus der mailinglist streichen. Danke Rainer Kretzschmar Kärrnerweg 25 09350 Lichtenstein e-Mail: srkretzsch...@vodafone.de -- 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 Nobody here can do what you ask. The only one that can unsubscribe you is you yourself. To do so, READ the instructions just above (which appear at the bottom of each and every message you receive from the list. -- Stan Goodman Qiryat Tiv'on Israel -- 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 -- Dr soumalya ray http://drsoumalya.blogspot.com drsouma...@gmail.com MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp -- 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] How can I build only libreoffice-writer instead of whole office suite ?
On 08/10/2011 03:37 PM, Partha Chowdhury wrote: Hallo all.This is my first post to the list. I have successfully build libreoffice-3.3.3.1 form source.However, I need office only to open and edit word documents and nothing else. So I want only to build the writer part and not the whole office.I have googled but have not found anything to this effect.The documentation covers only building from git and not the individual parts. So is it possible only to build a part of libreoffice instead of whole suite ? There are not parts of LO, each of which performs one of these functions. What appear to be separate programs bundled together are simply aspects of a single application. So no, one can't have Writer alone -- Stan Goodman Qiryat Tiv'on Israel -- 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] add ttf fonts to LibreOffice
Hi :) Smart. I guess most of us just hadn't thought of it. I think short-forms are quite cute and friendly but the marketing team asked us not to use them outside the lists to the wider world (personal emails and smaller groups can do what they want of course). We need to get the full name out there apparently. Normally a name change such as from OpenOffice to LibreOffice would be phased in using both names in conjunction with each other for about a year or more apparently otherwise there is a risk of losing and confusing people and losing the Brand recognition. Early on the lists agreed to use LibO as the agreed shortening but to me that makes it sound like the thousands of library files i routinely ignore so a few of us started using LO as in Lo and behold (oops). Fx is the term used backstage rather than writing Special Effects. Lx is for electrics or electronics although people tend to pronounce it elec-trickery or Leccy to try to be amusing or cute or express annoyance. Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 14:42:32 Subject: Re: [libreoffice-users] add ttf fonts to LibreOffice 2011/8/10 Nuno J. Silva nunojsi...@ist.utl.pt: On 2011-08-10, Tom Davies wrote: On Tue, 2011-08-09 at 21:05 -0700, SillyOne wrote: Adding fonts to the windows version of LE is simple [...] Errr is LE being used to refer to LibreOffice? Is it used in the French lists or something? Sounds like the official Firefox shortening, Fx (while many people use Ff). I've been using LibO, but, BTW, do we have some official shortening? We are using computers, aren't we? So why shorten anything? I use a text expansion tool called AutoKey (there are other ones for other operating systems) to expand all my shortenings as I type, like ”” for ”OpenOffice.org”, ”lboo” for ”LibreOffice”, ”lboc” for ”LibreOffice Calc” and ”kregj” for: ”Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ” -- Nuno J. Silva (aka njsg) gopher://sdf-eu.org/1/users/njsg -- 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 -- 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 will not save file after sheet deleted.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 12:41 AM, Simon Cropper wrote: Unless someone recognised these symptoms and can put forward some ideas, I am treating this as a corrupt file. When LO can't read its own handwriting, so to speak, does that not prove LO has a serious problem? When you use only the tools provided by LO to manipulate your document and that document gets trashed due to corruption, does that not prove LO has a serious problem? Now that you've concluded that corruption has occurred, what do you think should happen to the software that did the corrupting? A: ) Should it get fixed? or B: ) Should it stay broken, and in return for not expending the effort to fix the underlying rot, you'll accept the next releases 3 new bells and 4 whistles? Check the archives and you'll note that file corruption is a frequent problem. Its as though giving buggy software the label file corruption absolves the developers of investigating and eliminating the underlying code bugs. I've been reporting corruption issues for years and in that time only one developer (with an oracle email address) ever showed any interest. Even he dropped off the radar when Oracle lost interest in the office suite. Does LO provide a needed service? Yes it does, just as a Ford coasting down a highway provides a service. The difference is that if a Ford gas tank blew up periodically, Ford would fix it. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5CkUsACgkQ7Orvev+eC8p1pQCeOXYJZ0Hxviu0Vx3FQrS1y0KY OPAAn1FA2iVoMjWyXvUwdLIuTaYVfAT6 =KOyQ -END PGP SIGNATURE- -- 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 will not save file after sheet deleted.
Hi :) Please post a new bug-report against LibreOffice rather than against OpenOffice. It stands a good chance of getting soem attention now. A lot of stuff just got sat on by Sun forever it seems. LibreOffice is vastly more interested in actually fixing things and TDF doesn't block the devs from doing stuff even if they are voluntary devs rather employees. As long as stuff passes quality control it's allowed in. Regards from Tom :) From: Bill Gradwohl b...@ycc.com To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 15:10:26 Subject: Re: [libreoffice-users] Calc will not save file after sheet deleted. -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 12:41 AM, Simon Cropper wrote: Unless someone recognised these symptoms and can put forward some ideas, I am treating this as a corrupt file. When LO can't read its own handwriting, so to speak, does that not prove LO has a serious problem? When you use only the tools provided by LO to manipulate your document and that document gets trashed due to corruption, does that not prove LO has a serious problem? Now that you've concluded that corruption has occurred, what do you think should happen to the software that did the corrupting? A: ) Should it get fixed? or B: ) Should it stay broken, and in return for not expending the effort to fix the underlying rot, you'll accept the next releases 3 new bells and 4 whistles? Check the archives and you'll note that file corruption is a frequent problem. Its as though giving buggy software the label file corruption absolves the developers of investigating and eliminating the underlying code bugs. I've been reporting corruption issues for years and in that time only one developer (with an oracle email address) ever showed any interest. Even he dropped off the radar when Oracle lost interest in the office suite. Does LO provide a needed service? Yes it does, just as a Ford coasting down a highway provides a service. The difference is that if a Ford gas tank blew up periodically, Ford would fix it. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5CkUsACgkQ7Orvev+eC8p1pQCeOXYJZ0Hxviu0Vx3FQrS1y0KY OPAAn1FA2iVoMjWyXvUwdLIuTaYVfAT6 =KOyQ -END PGP SIGNATURE- -- 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
[libreoffice-users] Re: LO showing wrong version in About
In news:1312968701.68269.yahoomai...@web24108.mail.ird.yahoo.com, Tom Davies tomdavie...@yahoo.co.uk typed: Hi :) The 3.3.3 is the latest stable release. The 3.4.2 is for early adopters, ie development branch, and has quite a few extra features with possibly greater success at converting docX files. Sorry i can't help with the actual question! Hopefully someone else will. Regards from Tom :) From: Jorgo ma...@jorgo.com To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 9:45:12 Subject: [libreoffice-users] LO showing wrong version in About Because of recent problems with Calc I updated LibreOffice from 3.3.2 to 3.3.3 to 3.4.2. When installing under XP the package LibO_3.4.2_Win_x86_install_multi.exe the Help/About screen shows wrong information: LibreOffice 3.3.2 OOO330m19 (Build:202) tag libreoffice-3.3.2.2 Is this a bug or a feature? ;-) -- View this message in context: http://nabble.documentfoundation.org/LO-showing-wrong-version-in-About-tp3241824p3241824.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted 3,4,2 is now a stable producton release. -- 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] How can I build only libreoffice-writer instead of whole office suite ?
Hi :) There is a way to open Writer by default rather than the general screen that shows the different apps. It will be slightly different between different platforms but at a guess you are using a *nix such as GnuLinux or Bsd? Basically you need to have a soft-link/short-cut or something to swriter but i am not sure about the pathname. The S is leftover from when LibreOffice was called StarOffice which was about a decade ago. Regards from Tom :) From: Stan Goodman stan.good...@hashkedim.com To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 14:53:13 Subject: Re: [libreoffice-users] How can I build only libreoffice-writer instead of whole office suite ? On 08/10/2011 03:37 PM, Partha Chowdhury wrote: Hallo all.This is my first post to the list. I have successfully build libreoffice-3.3.3.1 form source.However, I need office only to open and edit word documents and nothing else. So I want only to build the writer part and not the whole office.I have googled but have not found anything to this effect.The documentation covers only building from git and not the individual parts. So is it possible only to build a part of libreoffice instead of whole suite ? There are not parts of LO, each of which performs one of these functions. What appear to be separate programs bundled together are simply aspects of a single application. So no, one can't have Writer alone -- Stan Goodman Qiryat Tiv'on Israel -- 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
[libreoffice-users] Re: How can I build only libreoffice-writer instead of whole office suite ?
Am 10.08.2011 14:37, Partha Chowdhury wrote: Hallo all.This is my first post to the list. I have successfully build libreoffice-3.3.3.1 form source.However, I need office only to open and edit word documents and nothing else. So I want only to build the writer part and not the whole office.I have googled but have not found anything to this effect.The documentation covers only building from git and not the individual parts. So is it possible only to build a part of libreoffice instead of whole suite ? http://abiword.org/ 18 MB download, excellent .doc filters. -- 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] How can I build only libreoffice-writer instead of whole office suite ?
Hi :) On Ubuntu and just using the package manager i see a separate package called libreoffice-writer but i assume their are a LOT of dependencies that would get pulled in, presumably including Calc, Draw, Math but possibly not Base as that one seems to be handled differently and needs to be installed separately. Is ti possible to try an entry-level GnuLinux distro in a VM to see what dependencies do get pulled in from the PPA or whatever? Hmm, it might be tricky to find one that doesn't include LibreOffice as the default office suite now. Regards from Tom :) From: Partha Chowdhury parthachowdhur...@gmail.com To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 13:37:26 Subject: [libreoffice-users] How can I build only libreoffice-writer instead of whole office suite ? Hallo all.This is my first post to the list. I have successfully build libreoffice-3.3.3.1 form source.However, I need office only to open and edit word documents and nothing else. So I want only to build the writer part and not the whole office.I have googled but have not found anything to this effect.The documentation covers only building from git and not the individual parts. So is it possible only to build a part of libreoffice instead of whole suite ? -- 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] Re: How can I build only libreoffice-writer instead of whole officesuite ?
Lol! Very funny ... And very adequate. Why would anybody want to compile just the writer component? As in ... COMPILE? If you are using Linux just install writer Yum install libreoffice-writer - from twohot@device.mobile :) -Original Message- From: Andreas Säger ville...@t-online.de Date: Wed, 10 Aug 2011 17:19:43 To: users@global.libreoffice.org Reply-To: users@global.libreoffice.org Subject: [libreoffice-users] Re: How can I build only libreoffice-writer instead of whole office suite ? Am 10.08.2011 14:37, Partha Chowdhury wrote: Hallo all.This is my first post to the list. I have successfully build libreoffice-3.3.3.1 form source.However, I need office only to open and edit word documents and nothing else. So I want only to build the writer part and not the whole office.I have googled but have not found anything to this effect.The documentation covers only building from git and not the individual parts. So is it possible only to build a part of libreoffice instead of whole suite ? http://abiword.org/ 18 MB download, excellent .doc filters. -- 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] Calc will not save file after sheet deleted.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 08:24 AM, Tom Davies wrote: Hi :) Please post a new bug-report against LibreOffice rather than against OpenOffice. It stands a good chance of getting soem attention now. I already did: https://bugs.freedesktop.org/show_bug.cgi?id=39930 I'm in the process of once again rewriting my spreadsheet from scratch and importing my macro code into it. At least 2 days worth of tedious work. The bug report I submitted was to help someone else avoid my problems in the future should the underlying root cause of the corruption I'm seeing get fixed. A fix won't help me now, as I don't trust the .ods file contents. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAk5CpyoACgkQ7Orvev+eC8rAvwCgs8vTIfZBzm7oljLl0U8yPRmK NqMAoMT9BNc7BctLOyye0ILePyYN2m5Y =UQsx -END PGP SIGNATURE- -- 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: How can I build only libreoffice-writer instead of whole officesuite ?
Hi :) It might be Bsd rather than GnuLinux or it might be one of the more purist distros such as a lovingly tended Slackware or Arch that is kept as minimalist as possible. Remember true hi-fi connoisseurs would often prefer an amp that had only 1 dial rather than all the extra levels and indicators. GnuLinux is about choosing your own way of doing things. Regards from Tom :) From: Onyeibo Oku twoho...@gmail.com To: Libre, Users users@global.libreoffice.org Sent: Wed, 10 August, 2011 16:43:19 Subject: Re: [libreoffice-users] Re: How can I build only libreoffice-writer instead of whole officesuite ? Lol! Very funny ... And very adequate. Why would anybody want to compile just the writer component? As in ... COMPILE? If you are using Linux just install writer Yum install libreoffice-writer - from twohot@device.mobile :) -Original Message- From: Andreas Säger ville...@t-online.de Date: Wed, 10 Aug 2011 17:19:43 To: users@global.libreoffice.org Reply-To: users@global.libreoffice.org Subject: [libreoffice-users] Re: How can I build only libreoffice-writer instead of whole office suite ? Am 10.08.2011 14:37, Partha Chowdhury wrote: Hallo all.This is my first post to the list. I have successfully build libreoffice-3.3.3.1 form source.However, I need office only to open and edit word documents and nothing else. So I want only to build the writer part and not the whole office.I have googled but have not found anything to this effect.The documentation covers only building from git and not the individual parts. So is it possible only to build a part of libreoffice instead of whole suite ? http://abiword.org/ 18 MB download, excellent .doc filters. -- 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 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: How can I build only libreoffice-writer instead of whole officesuite ?
Am 10.08.2011 17:43, Onyeibo Oku wrote: Lol! Very funny ... And very adequate. Why would anybody want to compile just the writer component? As in ... COMPILE? If you are using Linux just install writer Yum install libreoffice-writer - from twohot@device.mobile :) And what do you get when you install Writer only? May be 320 instead of 350 Megabyte? I need office only to open and edit word documents and nothing else. In this case you should install Writer and Abiword. No software can interprete word documents perfectly, not even WinWord. Sometimes Abiword makes a better guess than LibreOffice. Refer to http://zamzar.com/ which converts almost any trash into something usable. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] unopkg error
Hello, I have compiled an addin which works find under openoffice 3.2. Using either libreoffice 3.3 or 3.4 the following error message appears: ERROR: Fehler beim Hinzuf�gen von: vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/luecz64g.tmp_/CalcAddins.oxt Cause: Media-Typ konnte nicht ermittelt werden: file:///root/.libreoffice/3/user/uno_packages/cache/uno_packages/luecz64g.tmp_/CalcAddins.oxt unopkg failed. The directory CalcAddins.oxt has not been created and the oxt file has not been unziped. What do I have to change to get a working addin using libreoffice? Regards, Lars -- NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie! Jetzt informieren: http://www.gmx.net/de/go/freephone -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: LibreOffice Calc: Format column titles in DataPilot
Am 10.08.2011 01:57, jorge wrote: Hi I suggest you this: 1) Make the pilot data 2) If you format cell orientation (cell of pilot selected), you can chage the orientation (Vertical in grade that you want, except the first column). If you want to change the titles of headers, select the cell and use F2 to do it. 3) If you want to change all the columns headers orientations you can copy the pilot data to other space or sheet and then change the format cell orientation (Menu-Format-Cell) When you do this by means of hard attributes, they will be lost on refresh. When you do this by means of styles, it applies to the row headers as well. When you copy the pilot you don't have a refreshable pilot anymore. -- 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: How can I build only libreoffice-writer instead of whole officesuite ?
Hi :) Yes, i liked the suggestion for just installing AbiWord. Gnome Office only has a few components but they are good and the AbiWord component seems to be exactly what Partha Chowdhury (= the OP) needs. I think it's good when communities work together like this. I'm not sure that AbiWord allows you to easily set the default formats to MS Office ones (ie .doc or .docX) which is one reason i prefer Writer but the native OpenDocument Formats are more secure and are the same for Gnome Office, LibreOffice/OpenOffice, Google-docs and many more too :) Regards from Tom :) From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 17:11:11 Subject: [libreoffice-users] Re: How can I build only libreoffice-writer instead of whole officesuite ? Am 10.08.2011 17:43, Onyeibo Oku wrote: Lol! Very funny ... And very adequate. Why would anybody want to compile just the writer component? As in ... COMPILE? If you are using Linux just install writer Yum install libreoffice-writer - from twohot@device.mobile :) And what do you get when you install Writer only? May be 320 instead of 350 Megabyte? I need office only to open and edit word documents and nothing else. In this case you should install Writer and Abiword. No software can interprete word documents perfectly, not even WinWord. Sometimes Abiword makes a better guess than LibreOffice. Refer to http://zamzar.com/ which converts almost any trash into something usable. -- 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] Re: Calc will not save file after sheet deleted.
Hi :) +1 Hmm, well maybe not the absolute worst. A sieve or broken floppy disc or an ancient format that no program can read might be worse but yes, databases with an audit-trail are much more secure and plain text such as Csv ensure that there will always be some program somewhere that can at least access the data. Regards from Tom :) From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 13:21:23 Subject: [libreoffice-users] Re: Calc will not save file after sheet deleted. Am 10.08.2011 01:46, Simon Cropper wrote: Hi, I have an old spreadsheet in ODS format. The file was originally an XLS file then converted to ODS format several years ago *and* has been used weekly over that period without any problems. Since the days of OpenOffice.org 1.0 I use the same dBase file together with Calc data pilots as reporting engine. I'm pretty sure that this file will take another 50,000 records during the next 10 years without any problems. Spreadsheets are the worst data storage, regardless if Excel, ODF or whatever. Even a collection of plain text tables is far better than spreadsheets. -- 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] My secret password recovery procedure
Hi :) +1 Tpyos do happen and that Caps-Lock is a great example of one that rarely gets noticed if what you type is replaced by stars or not visible at all. It's one of the great classics along with waggling the wires or rebooting a Windows machine. I think something else Dennis did fixed this particular problem this time tho. Regards from Tom :) From: Dennis E. Hamilton dennis.hamil...@acm.org To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 3:50:40 Subject: [libreoffice-users] My secret password recovery procedure Having trouble decrypting that file you saved with a password just yesterday? You try your familiar password over and over and are told it is incorrect? Try changing your Caps Lock setting. Sometimes when we set the password, the Caps Lock is set wrong but we type the password twice exactly the same without noticing. You'd be surprised how often that happens. - Dennis -- 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] Calc will not save file after sheet deleted.
Hi :) I was wondering if it's to do with permissions of the folder you are trying to save into. In linux systems it's difficult to save in folders such as /root /boot and sometimes into other users or guests folders on a multi-user system. I have a feeling that you have already tried saving into another folder or onto your own desktop but i am not certain. Regards from Tom :) From: Simon Cropper scrop...@botanicusaustralia.com.au To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 1:46:06 Subject: Re: [libreoffice-users] Calc will not save file after sheet deleted. On 10/08/11 10:26, Steve Edmonds wrote: Hi. On 2011-08-10 12:18, Simon Cropper wrote: Question -- Check if the file is opened as read only No it is not and permissions are all OK. Question -- If it is like that you have to save the file with new name for changing it. The problem occurs on original, copies of original and when I try and save as different name. On 10/08/11 10:03, jorge wrote: Hi Check if the file is opened as read only If it is like that you have to save the file with new name for changing it. Regards, Jorge Rodríguez __ El mié, 10-08-2011 a las 09:46 +1000, Simon Cropper escribió: Hi, I have an old spreadsheet in ODS format. The file was originally an XLS file then converted to ODS format several years ago *and* has been used weekly over that period without any problems. When I try an delete a sheet from the file I get an error Error saving the document FILE: Write Error. The file could not be written. If, prior to attempting the sheet removal, I change the contents of a cell the file is saved without any problems. When the error occurs the saving progress bar appears, moves to ~20% completion stops for several seconds, then progresses to ~80% completion at normal saving speed, stops again for several seconds then crashes. This is in contrast to a normal save where the progress bar moves at a constant rate for the entire saving process. If I attempt to insert a sheet I get the same problem. *I should point out* here that the sheet being deleted and inserted are mid-file, that is I have 18 tabs and I am trying to delete sheet 7. When I insert a sheet I am inserting after sheet 7 or 8 (does not really matter). What I have noticed is if I use the 'add sheet' tab -- that is the last tab with the green '+' sign instead of the name to add a sheet; a sheet can be added and the document saved. This same sheet can be deleted, although the progress bar behaves as if the error is going to happen, that is it pauses at 20% and 80% completion; except this time it finishes without the error dialog appearing. My tests indicate that the last sheet of the original untouched file can be deleted. Like above the progress bar behaves an unusual way but does complete without the error dialog appearing. I can not reproduce the error on a new clean file. If I work back through the historical copies of the file, I can only reproduce the error in this years version. It is as if the file has become partially corrupted. The question is how and can it be easily fixed. Before I spend the time recreating the file from scratch or modifying one of the old backups... *Has anyone encountered or heard of a similar problem?* *Anyone got some ideas?* *Is it worth upgrading LibreOffice?* I am running LibreOffice 3.4.1 OOO340m1 (Build:103) on Ubuntu 10.04 LTS. The java version used is Sun Microsystems Inc. 1.6.0_26, although I have also checked and verified the problem occurs on 1.6.0_20 (which just happened to be on the system). LibreOffice was manually installed from downloaded DEB files *not* installed from the LibreOffice PPA repository or the Ubuntu Software Centre. -- Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au And do you get the same problem if you save as a new name without deleting the sheet (so it saves OK) and exit running instances of LO and then re-open it. Are there references to/from the sheet you deleted from other sheets that could be broken and causing problems. steve 1. do you get the same problem if you save as a new name without deleting the sheet... No. The file saves OK and behaves as per normal unless I delete or insert sheet mid-file. 2. Problem persists even if I reboot. 3. Are there references to/from the sheet... Yes, the file is riddled with cross-references. That said I have tried deleting sheets that are orphaned and the problem still occurs. If I insert a new sheet mid-file, the problem still occurs. I can chomp off the last sheet, which is cross-referenced in several locations elsewhere in the file and the problem *does not occur*. -- Cheers Simon -- For unsubscribe instructions e-mail to:
Re: [libreoffice-users] LibreOffice Calc: Format column titles in DataPilot
On 8/10/2011 1:06 AM, Cor Nouws wrote: Hi Joe, JOE Conner wrote (09-08-11 23:04) *One thing I noticed right away - there is a serious bug when changing orientations, in that it is difficult to keep the text within the cell. As I was rotating the text it would often bounce into the adjoining cell. It seems that the text alignment feature does not extend to rotated text, and chooses any random alignment.* In the section Rotation, you can choose the reference boarder too. True, the selection is possible. However selecting a different edge does not have the desired effect. In fact, the effects are unpredictable and illogical. A true bug. Joe Conner, Poulsbo, WA USA -- 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 Calc: Format column titles in DataPilot
JOE Conner wrote (10-08-11 20:15) On 8/10/2011 1:06 AM, Cor Nouws wrote: JOE Conner wrote (09-08-11 23:04) *One thing I noticed right away - there is a serious bug when changing orientations, in that it is difficult to keep the text within the cell. As I was rotating the text it would often bounce into the adjoining cell. It seems that the text alignment feature does not extend to rotated text, and chooses any random alignment.* In the section Rotation, you can choose the reference boarder too. True, the selection is possible. However selecting a different edge does not have the desired effect. In fact, the effects are unpredictable and illogical. Might well be - I did not use it often. Though from the last times I remember, I could cope with it. A true bug. Might well be too - could you please be so kind to find out what works and what not, a sort of pattern, and file a bug with that :-) Thanks, -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: How can I build only libreoffice-writer instead of whole officesuite ?
Am 10.08.2011 18:24, Tom Davies wrote: Hi :) Yes, i liked the suggestion for just installing AbiWord. Gnome Office only has a few components but they are good and the AbiWord component seems to be exactly what Partha Chowdhury (= the OP) needs. I think it's good when communities work together like this. I'm not sure that AbiWord allows you to easily set the default formats to MS Office ones (ie .doc or .docX) which is one reason i prefer Writer but the native OpenDocument Formats are more secure and are the same for Gnome Office, LibreOffice/OpenOffice, Google-docs and many more too :) Regards from Tom :) Hi, I never work in any file format other than the respective application's native file format. While working with *.doc subtile formatting errors may increase with every save. When I receive *.doc per mail, I use to open the attachment, save a local copy as odt, edit and save that one, and finally I send back my version using FileSendEmail as doc or FileSendEmail as PDF (final version). -- 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 Calc: Format column titles in DataPilot
Hi :) Here is the guide for posting bug-reports. http://wiki.documentfoundation.org/BugReport Note that it is a guide only, not a set of rules. If you can't follow all of it the just post as the devs can always ask for extra info if they really need it. Regards from Tom :) From: JOE Conner joeconner2...@gmail.com To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 19:15:59 Subject: Re: [libreoffice-users] LibreOffice Calc: Format column titles in DataPilot On 8/10/2011 1:06 AM, Cor Nouws wrote: Hi Joe, JOE Conner wrote (09-08-11 23:04) *One thing I noticed right away - there is a serious bug when changing orientations, in that it is difficult to keep the text within the cell. As I was rotating the text it would often bounce into the adjoining cell. It seems that the text alignment feature does not extend to rotated text, and chooses any random alignment.* In the section Rotation, you can choose the reference boarder too. True, the selection is possible. However selecting a different edge does not have the desired effect. In fact, the effects are unpredictable and illogical. A true bug. Joe Conner, Poulsbo, WA USA -- 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] new book
Same here. It's really annoying. From: Gail Dawson johngail5...@att.net To: users@global.libreoffice.org Sent: Tue, August 9, 2011 6:51:55 AM Subject: Re: [libreoffice-users] new book Please someone tell me how do I get out of this forum? I am receiving hundreds of emails a day about LibreOffice. I can't remember how I got in. Again, please help me get out of this forum. Thanks, Gail Dawson On Aug 9, 2011, at 8:06 AM, Tom Davies wrote: Hi :) Pages in any word-processing format often display different between one machine and another due to, for example, printer settings. Pdf is a format that displays the same on every machine but not if it's made after changes have occurred. The proper Pdfs are available for download http://www.libreoffice.org/get-help/documentation/ Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Tue, 9 August, 2011 12:35:34 Subject: Re: [libreoffice-users] new book 2011/8/5 Andrew Douglas Pitonyak and...@pitonyak.org: I am actively adding content to this release of the book. I am currently working through the Calc section. When I finish with that, I will move on to the next section, which is not yet in the document. The German translation is on chapter 7 I believe. Great book. I downloaded it and exported it to PDF. I found a strange page break however, on page 488 (PDF version) or 487 (ODF version). Just thought you wanted to know… I also wonder why the page numbers of the PDF (the one I exported to myself) are not the same as those on the ODF, but that has probably nothing to do with the document itself. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ On 08/05/2011 08:49 AM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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 --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 -- 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] new book
Read the footer on your message sir. It answers your question, I think? - from twohot@device.mobile :) -Original Message- From: Lynn Wilde life48dan...@att.net Date: Wed, 10 Aug 2011 12:58:12 To: users@global.libreoffice.org Reply-To: users@global.libreoffice.org Subject: Re: [libreoffice-users] new book Same here. It's really annoying. From: Gail Dawson johngail5...@att.net To: users@global.libreoffice.org Sent: Tue, August 9, 2011 6:51:55 AM Subject: Re: [libreoffice-users] new book Please someone tell me how do I get out of this forum? I am receiving hundreds of emails a day about LibreOffice. I can't remember how I got in. Again, please help me get out of this forum. Thanks, Gail Dawson On Aug 9, 2011, at 8:06 AM, Tom Davies wrote: Hi :) Pages in any word-processing format often display different between one machine and another due to, for example, printer settings. Pdf is a format that displays the same on every machine but not if it's made after changes have occurred. The proper Pdfs are available for download http://www.libreoffice.org/get-help/documentation/ Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Tue, 9 August, 2011 12:35:34 Subject: Re: [libreoffice-users] new book 2011/8/5 Andrew Douglas Pitonyak and...@pitonyak.org: I am actively adding content to this release of the book. I am currently working through the Calc section. When I finish with that, I will move on to the next section, which is not yet in the document. The German translation is on chapter 7 I believe. Great book. I downloaded it and exported it to PDF. I found a strange page break however, on page 488 (PDF version) or 487 (ODF version). Just thought you wanted to know… I also wonder why the page numbers of the PDF (the one I exported to myself) are not the same as those on the ODF, but that has probably nothing to do with the document itself. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ On 08/05/2011 08:49 AM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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 --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 -- 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] new book
Hi :) There is a guide here http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ It has been unusually busy over the last 7 days and was unusually quiet for about a fortnight before that. Regards from Tom :) From: Lynn Wilde life48dan...@att.net To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 20:58:12 Subject: Re: [libreoffice-users] new book Same here. It's really annoying. From: Gail Dawson johngail5...@att.net To: users@global.libreoffice.org Sent: Tue, August 9, 2011 6:51:55 AM Subject: Re: [libreoffice-users] new book Please someone tell me how do I get out of this forum? I am receiving hundreds of emails a day about LibreOffice. I can't remember how I got in. Again, please help me get out of this forum. Thanks, Gail Dawson On Aug 9, 2011, at 8:06 AM, Tom Davies wrote: Hi :) Pages in any word-processing format often display different between one machine and another due to, for example, printer settings. Pdf is a format that displays the same on every machine but not if it's made after changes have occurred. The proper Pdfs are available for download http://www.libreoffice.org/get-help/documentation/ Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Tue, 9 August, 2011 12:35:34 Subject: Re: [libreoffice-users] new book 2011/8/5 Andrew Douglas Pitonyak and...@pitonyak.org: I am actively adding content to this release of the book. I am currently working through the Calc section. When I finish with that, I will move on to the next section, which is not yet in the document. The German translation is on chapter 7 I believe. Great book. I downloaded it and exported it to PDF. I found a strange page break however, on page 488 (PDF version) or 487 (ODF version). Just thought you wanted to know… I also wonder why the page numbers of the PDF (the one I exported to myself) are not the same as those on the ODF, but that has probably nothing to do with the document itself. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ On 08/05/2011 08:49 AM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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 --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 -- 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] new book
On 2011-08-10 3:58 PM, Lynn Wilde life48dan...@att.net wrote: Same here. It's really annoying. What is really annoying is people who cannot take 2 seconds and read the instructions that are included at the bottom of every message they get on a mail list, but choose to whine and complain on the list like little children. Grow up. Learn how to interact online, or GET OFF THE NET. From: Gail Dawson johngail5...@att.net To: users@global.libreoffice.org Sent: Tue, August 9, 2011 6:51:55 AM Subject: Re: [libreoffice-users] new book Please someone tell me how do I get out of this forum? I am receiving hundreds of emails a day about LibreOffice. I can't remember how I got in. Again, please help me get out of this forum. Thanks, Gail Dawson On Aug 9, 2011, at 8:06 AM, Tom Davies wrote: Hi :) Pages in any word-processing format often display different between one machine and another due to, for example, printer settings. Pdf is a format that displays the same on every machine but not if it's made after changes have occurred. The proper Pdfs are available for download http://www.libreoffice.org/get-help/documentation/ Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Tue, 9 August, 2011 12:35:34 Subject: Re: [libreoffice-users] new book 2011/8/5 Andrew Douglas Pitonyak and...@pitonyak.org: I am actively adding content to this release of the book. I am currently working through the Calc section. When I finish with that, I will move on to the next section, which is not yet in the document. The German translation is on chapter 7 I believe. Great book. I downloaded it and exported it to PDF. I found a strange page break however, on page 488 (PDF version) or 487 (ODF version). Just thought you wanted to know… I also wonder why the page numbers of the PDF (the one I exported to myself) are not the same as those on the ODF, but that has probably nothing to do with the document itself. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ On 08/05/2011 08:49 AM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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 --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 -- 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] new book
And this is why bottom posting creatures are being weeded out of the gene pool. Soon we will have a genetics test so they can be eliminated prior to birth. You don't see this because it is at the bottom: For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Where nobody )(*)(*)_ing looks On Wed, 2011-08-10 at 12:58 -0700, Lynn Wilde wrote: Same here. It's really annoying. From: Gail Dawson johngail5...@att.net To: users@global.libreoffice.org Sent: Tue, August 9, 2011 6:51:55 AM Subject: Re: [libreoffice-users] new book Please someone tell me how do I get out of this forum? I am receiving hundreds of emails a day about LibreOffice. I can't remember how I got in. Again, please help me get out of this forum. Thanks, Gail Dawson On Aug 9, 2011, at 8:06 AM, Tom Davies wrote: Hi :) Pages in any word-processing format often display different between one machine and another due to, for example, printer settings. Pdf is a format that displays the same on every machine but not if it's made after changes have occurred. The proper Pdfs are available for download http://www.libreoffice.org/get-help/documentation/ Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Tue, 9 August, 2011 12:35:34 Subject: Re: [libreoffice-users] new book 2011/8/5 Andrew Douglas Pitonyak and...@pitonyak.org: I am actively adding content to this release of the book. I am currently working through the Calc section. When I finish with that, I will move on to the next section, which is not yet in the document. The German translation is on chapter 7 I believe. Great book. I downloaded it and exported it to PDF. I found a strange page break however, on page 488 (PDF version) or 487 (ODF version). Just thought you wanted to know… I also wonder why the page numbers of the PDF (the one I exported to myself) are not the same as those on the ODF, but that has probably nothing to do with the document itself. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ On 08/05/2011 08:49 AM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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 --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 -- 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 -- Roland Hughes, President Logikal Solutions (630)-205-1593 http://www.theminimumyouneedtoknow.com http://www.infiniteexposure.net No U.S. troops have ever lost their lives defending our ethanol reserves. -- 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
Re: [libreoffice-users] new book
That's because real human beings don't read the bottom of any on-line message. There are only a handful of genetically inferior bottom posting dinosaurs left on the face of the planet and soon this problem will passand given enough time below ground they'll turn into crude which we can make gas and oil out of On Wed, 2011-08-10 at 16:31 -0400, Tanstaafl wrote: On 2011-08-10 3:58 PM, Lynn Wilde life48dan...@att.net wrote: Same here. It's really annoying. What is really annoying is people who cannot take 2 seconds and read the instructions that are included at the bottom of every message they get on a mail list, but choose to whine and complain on the list like little children. Grow up. Learn how to interact online, or GET OFF THE NET. From: Gail Dawson johngail5...@att.net To: users@global.libreoffice.org Sent: Tue, August 9, 2011 6:51:55 AM Subject: Re: [libreoffice-users] new book Please someone tell me how do I get out of this forum? I am receiving hundreds of emails a day about LibreOffice. I can't remember how I got in. Again, please help me get out of this forum. Thanks, Gail Dawson On Aug 9, 2011, at 8:06 AM, Tom Davies wrote: Hi :) Pages in any word-processing format often display different between one machine and another due to, for example, printer settings. Pdf is a format that displays the same on every machine but not if it's made after changes have occurred. The proper Pdfs are available for download http://www.libreoffice.org/get-help/documentation/ Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Tue, 9 August, 2011 12:35:34 Subject: Re: [libreoffice-users] new book 2011/8/5 Andrew Douglas Pitonyak and...@pitonyak.org: I am actively adding content to this release of the book. I am currently working through the Calc section. When I finish with that, I will move on to the next section, which is not yet in the document. The German translation is on chapter 7 I believe. Great book. I downloaded it and exported it to PDF. I found a strange page break however, on page 488 (PDF version) or 487 (ODF version). Just thought you wanted to know… I also wonder why the page numbers of the PDF (the one I exported to myself) are not the same as those on the ODF, but that has probably nothing to do with the document itself. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ On 08/05/2011 08:49 AM, rogerio dandrea wrote: new book http://www.pitonyak.org/OOME_3_0.odt :0) thanks Pitonyak for the excellent work :0) From Brazil -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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 --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 -- Roland Hughes, President Logikal Solutions (630)-205-1593 http://www.theminimumyouneedtoknow.com http://www.infiniteexposure.net No U.S. troops have ever lost their lives defending our ethanol reserves. -- 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
[libreoffice-users] Print in reverse page order missing for LibreOffice 3.4.2?
Hi. I'm trying to switch from OpenOffice.org 3.3.0 to LibreOffice 3.4.2; both installations on my Linux 2.6.28.6 system. When I do a File-Print on OpenOffice the 'Options' tab has four listed options; the second last is this: [] Print in reverse page order But the same tab with LibreOffice doesn't have that option for its 'Options' tab (it just has the other three). In both cases with the same system printer selected. The option just seems to have disappeared with LibreOffice 3.4.2. I've done a search in the LibreOffice-Users forum and couldn't find any discussion on it. The LibreOffice help page references the option (http://help.libreoffice.org/Writer/Printing_in_Reverse_Order) as if it should be there. Can anyone tell me what happened to the option with LibreOffice 3.4.2? I rely on the 'reverse page order' option so I can do a poor-man's duplex printing (printing the 'left pages' of my documents on one side of the paper, then feeding the sheets back into the non-duplex printer for the 'right pages'). Thanks! -- View this message in context: http://nabble.documentfoundation.org/Print-in-reverse-page-order-missing-for-LibreOffice-3-4-2-tp3244255p3244255.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc will not save file after sheet deleted.
On 11/08/11 00:10, Bill Gradwohl wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/10/2011 12:41 AM, Simon Cropper wrote: Unless someone recognised these symptoms and can put forward some ideas, I am treating this as a corrupt file. When LO can't read its own handwriting, so to speak, does that not prove LO has a serious problem? When you use only the tools provided by LO to manipulate your document and that document gets trashed due to corruption, does that not prove LO has a serious problem? Now that you've concluded that corruption has occurred, what do you think should happen to the software that did the corrupting? A: ) Should it get fixed? or B: ) Should it stay broken, and in return for not expending the effort to fix the underlying rot, you'll accept the next releases 3 new bells and 4 whistles? Check the archives and you'll note that file corruption is a frequent problem. Its as though giving buggy software the label file corruption absolves the developers of investigating and eliminating the underlying code bugs. I've been reporting corruption issues for years and in that time only one developer (with an oracle email address) ever showed any interest. Even he dropped off the radar when Oracle lost interest in the office suite. Does LO provide a needed service? Yes it does, just as a Ford coasting down a highway provides a service. The difference is that if a Ford gas tank blew up periodically, Ford would fix it. - -- Bill Gradwohl Roatan, Honduras -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ Bill, It is obvious that you do not like OO or LO Calc, and that you don't like the fact that your data is continually corrupted. You also say you continuously have to rebuild your spreadsheet and that the process can take several days. If you are so unhappy with the format, corruption and dirty code, my question is why do you persist? Change packages. With the time and effort you have already put into recreating corrupted spreadsheets you could of written your own application or mastered alternative packages. I am not trying to be rude here it just if I had a package that caused me so much wasted time I would just move on. -- Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au -- 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: LibreOffice Calc: Format column titles in DataPilot
Hi I'm sorry but I made an example with Style and the first column header (Title) wasn't changed. Besides, I refreshed the pilot table and lost the headers format. What did I wrong ? Regards, Jorge Rodríguez El mié, 10-08-2011 a las 13:48 +0200, Andreas Säger escribió: Am 10.08.2011 01:57, jorge wrote: Hi I suggest you this: 1) Make the pilot data 2) If you format cell orientation (cell of pilot selected), you can chage the orientation (Vertical in grade that you want, except the first column). If you want to change the titles of headers, select the cell and use F2 to do it. 3) If you want to change all the columns headers orientations you can copy the pilot data to other space or sheet and then change the format cell orientation (Menu-Format-Cell) When you do this by means of hard attributes, they will be lost on refresh. When you do this by means of styles, it applies to the row headers as well. When you copy the pilot you don't have a refreshable pilot anymore. -- Atentamente, Jorge Rodríguez -- 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] Print in reverse page order missing for LibreOffice 3.4.2?
Hi brad, brad schrieb: [..] Can anyone tell me what happened to the option with LibreOffice 3.4.2? I rely on the 'reverse page order' option so I can do a poor-man's duplex printing (printing the 'left pages' of my documents on one side of the paper, then feeding the sheets back into the non-duplex printer for the 'right pages'). Thanks! It has been moved to the first tab, the tab General, so that you can reach it immediately :) Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Calc will not save file after sheet deleted.
On 11/08/11 02:53, Tom Davies wrote: Hmm, well maybe not the absolute worst. A sieve or broken floppy disc or an ancient format that no program can read might be worse but yes, databases with an audit-trail are much more secure and plain text such as Csv ensure that there will always be some program somewhere that can at least access the data. I agree but there are no good front ends to the myriad of relational database backends that you can utilise on Linux. I could list tons of SQL engines but as the copious posts on this list about Base attest, there are few decent alternatives for Rapid Application Development, Data Mining or even simple application development available; let alone something that can be integrated into LO. When working on Windows I use Microsoft Visual Foxpro. Fantastic package but now discontinued (and I have moved my primary platform to Ubuntu now!). There is absolutely nothing comparable to it on Linux. You either have to write a complete application every time you want to do something (e.g. Python+wxPython; Dabo) or need to poke at a SQL file from the command line. If I could recreate my spreadsheet in a database format that allowed me to quickly develop and easily maintain an application -- I would be developing it now. -- Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au -- 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 will not save file after sheet deleted.
Simon On Thu, 2011-08-11 at 09:38 +1000, Simon Cropper wrote: On 11/08/11 02:53, Tom Davies wrote: Hmm, well maybe not the absolute worst. A sieve or broken floppy disc or an ancient format that no program can read might be worse but yes, databases with an audit-trail are much more secure and plain text such as Csv ensure that there will always be some program somewhere that can at least access the data. I agree but there are no good front ends to the myriad of relational database backends that you can utilise on Linux. I could list tons of SQL engines but as the copious posts on this list about Base attest, there are few decent alternatives for Rapid Application Development, Data Mining or even simple application development available; let alone something that can be integrated into LO. When working on Windows I use Microsoft Visual Foxpro. Fantastic package but now discontinued (and I have moved my primary platform to Ubuntu now!). There is absolutely nothing comparable to it on Linux. You either have to write a complete application every time you want to do something (e.g. Python+wxPython; Dabo) or need to poke at a SQL file from the command line. If I could recreate my spreadsheet in a database format that allowed me to quickly develop and easily maintain an application -- I would be developing it now. -- Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au Both MySQL/MariaFB and Postgresql have GUI interfaces available for Linux , MySQL Worbench from the MySQL site and pgadmin for Postgresql in the Ubuntu repository. Both allow a users to most of the db work in a desktop environment not CLI. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Calc will not save file after sheet deleted.
On 11/08/11 09:47, planas wrote: Simon On Thu, 2011-08-11 at 09:38 +1000, Simon Cropper wrote: On 11/08/11 02:53, Tom Davies wrote: Hmm, well maybe not the absolute worst. A sieve or broken floppy disc or an ancient format that no program can read might be worse but yes, databases with an audit-trail are much more secure and plain text such as Csv ensure that there will always be some program somewhere that can at least access the data. I agree but there are no good front ends to the myriad of relational database backends that you can utilise on Linux. I could list tons of SQL engines but as the copious posts on this list about Base attest, there are few decent alternatives for Rapid Application Development, Data Mining or even simple application development available; let alone something that can be integrated into LO. When working on Windows I use Microsoft Visual Foxpro. Fantastic package but now discontinued (and I have moved my primary platform to Ubuntu now!). There is absolutely nothing comparable to it on Linux. You either have to write a complete application every time you want to do something (e.g. Python+wxPython; Dabo) or need to poke at a SQL file from the command line. If I could recreate my spreadsheet in a database format that allowed me to quickly develop and easily maintain an application -- I would be developing it now. -- Cheers Simon Both MySQL/MariaFB and Postgresql have GUI interfaces available for Linux , MySQL Worbench from the MySQL site and pgadmin for Postgresql in the Ubuntu repository. Both allow a users to most of the db work in a desktop environment not CLI. All these packages are administration utilities not RAD or Data Mining environments. MySQL Workbench is a visual database design tool that is developed by MySQL. It is the successor application of the DBDesigner4 project. http://wb.mysql.com/?page_id=28 pgAdmin is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, http://www.pgadmin.org/ Data mining allows the 'researcher' to import, export, convert, merge and manipulate data for a particular project, and maintain the original data and any derivatives. RAD allows, at minimum, input forms, menues and reports. Ideally a programming language should be available to manipulate the data and user experience. Granted I should have been more careful with my choice of words. All these packages do provide simple GUI interfaces that allow you to design and query a database created with the respective tool. Some projects do provide some import and export facilities for use in a once-off situation. BUT they are not really designed as RAD tools or provide you with the *easy* ability to collate disparate data sources, manipulate this information and export it again. -- Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc will not save file after sheet deleted.
On 08/10/2011 04:38 PM, Simon Cropper wrote: ... If I could recreate my spreadsheet in a database format that allowed me to quickly develop and easily maintain an application -- I would be developing it now. Pick OS We used to sell it when I was based in Australia (McDonnell Douglas/Microdata). Too bad Dick Pick isn't still around :-) -- 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 will not save file after sheet deleted.
Tom, I have checked all these issues. Permissions, folder permissions, owner/grp attributes have all been checked. As stated I can turn the save / no-save behaviour on and off with deletion or reinsertion of comments into the sheet. If the file was read only or write protected then this could not be done. No harm asking though :) On 11/08/11 03:23, Tom Davies wrote: Hi :) I was wondering if it's to do with permissions of the folder you are trying to save into. In linux systems it's difficult to save in folders such as /root /boot and sometimes into other users or guests folders on a multi-user system. I have a feeling that you have already tried saving into another folder or onto your own desktop but i am not certain. Regards from Tom :) From: Simon Cropperscrop...@botanicusaustralia.com.au To: users@global.libreoffice.org Sent: Wed, 10 August, 2011 1:46:06 Subject: Re: [libreoffice-users] Calc will not save file after sheet deleted. On 10/08/11 10:26, Steve Edmonds wrote: Hi. On 2011-08-10 12:18, Simon Cropper wrote: Question -- Check if the file is opened as read only No it is not and permissions are all OK. Question -- If it is like that you have to save the file with new name for changing it. The problem occurs on original, copies of original and when I try and save as different name. On 10/08/11 10:03, jorge wrote: Hi Check if the file is opened as read only If it is like that you have to save the file with new name for changing it. Regards, Jorge Rodríguez __ El mié, 10-08-2011 a las 09:46 +1000, Simon Cropper escribió: Hi, I have an old spreadsheet in ODS format. The file was originally an XLS file then converted to ODS format several years ago *and* has been used weekly over that period without any problems. When I try an delete a sheet from the file I get an error Error saving the document FILE: Write Error. The file could not be written. If, prior to attempting the sheet removal, I change the contents of a cell the file is saved without any problems. When the error occurs the saving progress bar appears, moves to ~20% completion stops for several seconds, then progresses to ~80% completion at normal saving speed, stops again for several seconds then crashes. This is in contrast to a normal save where the progress bar moves at a constant rate for the entire saving process. If I attempt to insert a sheet I get the same problem. *I should point out* here that the sheet being deleted and inserted are mid-file, that is I have 18 tabs and I am trying to delete sheet 7. When I insert a sheet I am inserting after sheet 7 or 8 (does not really matter). What I have noticed is if I use the 'add sheet' tab -- that is the last tab with the green '+' sign instead of the name to add a sheet; a sheet can be added and the document saved. This same sheet can be deleted, although the progress bar behaves as if the error is going to happen, that is it pauses at 20% and 80% completion; except this time it finishes without the error dialog appearing. My tests indicate that the last sheet of the original untouched file can be deleted. Like above the progress bar behaves an unusual way but does complete without the error dialog appearing. I can not reproduce the error on a new clean file. If I work back through the historical copies of the file, I can only reproduce the error in this years version. It is as if the file has become partially corrupted. The question is how and can it be easily fixed. Before I spend the time recreating the file from scratch or modifying one of the old backups... *Has anyone encountered or heard of a similar problem?* *Anyone got some ideas?* *Is it worth upgrading LibreOffice?* I am running LibreOffice 3.4.1 OOO340m1 (Build:103) on Ubuntu 10.04 LTS. The java version used is Sun Microsystems Inc. 1.6.0_26, although I have also checked and verified the problem occurs on 1.6.0_20 (which just happened to be on the system). LibreOffice was manually installed from downloaded DEB files *not* installed from the LibreOffice PPA repository or the Ubuntu Software Centre. -- Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au And do you get the same problem if you save as a new name without deleting the sheet (so it saves OK) and exit running instances of LO and then re-open it. Are there references to/from the sheet you deleted from other sheets that could be broken and causing problems. steve 1. do you get the same problem if you save as a new name without deleting the sheet... No. The file saves OK and behaves as per normal unless I delete or insert sheet mid-file. 2. Problem persists even if I reboot. 3. Are there references to/from the sheet... Yes, the file is riddled with cross-references. That said I have tried deleting sheets that are orphaned and
Re: [libreoffice-users] Re: Calc will not save file after sheet deleted.
Simon On Thu, 2011-08-11 at 10:30 +1000, Simon Cropper wrote: On 11/08/11 09:47, planas wrote: Simon On Thu, 2011-08-11 at 09:38 +1000, Simon Cropper wrote: On 11/08/11 02:53, Tom Davies wrote: Hmm, well maybe not the absolute worst. A sieve or broken floppy disc or an ancient format that no program can read might be worse but yes, databases with an audit-trail are much more secure and plain text such as Csv ensure that there will always be some program somewhere that can at least access the data. I agree but there are no good front ends to the myriad of relational database backends that you can utilise on Linux. I could list tons of SQL engines but as the copious posts on this list about Base attest, there are few decent alternatives for Rapid Application Development, Data Mining or even simple application development available; let alone something that can be integrated into LO. When working on Windows I use Microsoft Visual Foxpro. Fantastic package but now discontinued (and I have moved my primary platform to Ubuntu now!). There is absolutely nothing comparable to it on Linux. You either have to write a complete application every time you want to do something (e.g. Python+wxPython; Dabo) or need to poke at a SQL file from the command line. If I could recreate my spreadsheet in a database format that allowed me to quickly develop and easily maintain an application -- I would be developing it now. -- Cheers Simon Both MySQL/MariaFB and Postgresql have GUI interfaces available for Linux , MySQL Worbench from the MySQL site and pgadmin for Postgresql in the Ubuntu repository. Both allow a users to most of the db work in a desktop environment not CLI. All these packages are administration utilities not RAD or Data Mining environments. MySQL Workbench is a visual database design tool that is developed by MySQL. It is the successor application of the DBDesigner4 project. http://wb.mysql.com/?page_id=28 pgAdmin is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, http://www.pgadmin.org/ Data mining allows the 'researcher' to import, export, convert, merge and manipulate data for a particular project, and maintain the original data and any derivatives. RAD allows, at minimum, input forms, menues and reports. Ideally a programming language should be available to manipulate the data and user experience. Granted I should have been more careful with my choice of words. All these packages do provide simple GUI interfaces that allow you to design and query a database created with the respective tool. Some projects do provide some import and export facilities for use in a once-off situation. BUT they are not really designed as RAD tools or provide you with the *easy* ability to collate disparate data sources, manipulate this information and export it again. -- Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au I should read more closely sometimes. I would think the problem with data mining is determine what bits might be yield nuggets out of the mass. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Calc will not save file after sheet deleted.
On 11/08/11 10:57, NoOp wrote: On 08/10/2011 04:38 PM, Simon Cropper wrote: ... If I could recreate my spreadsheet in a database format that allowed me to quickly develop and easily maintain an application -- I would be developing it now. Pick OS We used to sell it when I was based in Australia (McDonnell Douglas/Microdata). Too bad Dick Pick isn't still around :-) I have not used Pick. I have used Revelation before, which is a derivative of this system. Not bad but still Windows based and files in proprietary format. The beauty of dbase files was for a long time they were the default 'desktop' (rather than server style) database format. Information stored in this format was accessible by a wide variety of packages (foxbase, foxpro, dBaseIII/IV, Clipper, Paradox, ...). Dbase files are old school now. The closest format is sqlite. This relational database system is serverless making it portable and able to be maintained in a similar fashion to the dissociated project based tables that formed part of the dbase database. But alais no packages are around that provide the functionality I desire. Before anyone tells me I am aware of 'sqlite data browser' and sqliteman and the firefox addon. All useful to query and maintain files but not good for data mining or RAD. -- Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au -- 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] unopkg error
Lars, On Wed, 2011-08-10 at 09:22 +0200, Lars Callenbach wrote: Hello, I have compiled an addin which works find under openoffice 3.2. Using either libreoffice 3.3 or 3.4 the following error message appears: ERROR: Fehler beim Hinzuf�gen von: vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/luecz64g.tmp_/CalcAddins.oxt Cause: Media-Typ konnte nicht ermittelt werden: file:///root/.libreoffice/3/user/uno_packages/cache/uno_packages/luecz64g.tmp_/CalcAddins.oxt unopkg failed. The directory CalcAddins.oxt has not been created and the oxt file has not been unziped. What do I have to change to get a working addin using libreoffice? Regards, Lars -- NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie! Jetzt informieren: http://www.gmx.net/de/go/freephone I would check OOo to see if they have an updated version and check http://libreplanet.org/wiki/Group:OpenOfficeExtensions/List and http://wiki.documentfoundation.org/Downloads/Templates . Plugins, unless they are official ones, may lag the release somewhat some if they need significant changes they may not work with the latest version. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Macro not active when the document start
The macro is active, but the function in the cell not active. Somehow I have to change the function variable with another value then I have to change it back again. So in the cell if I put =ubah(E7) I have to change it to =ubah(100) and then change it back again to =ubah(E7) to get the result that I want. On 08/10/2011 03:16 PM, Cor Nouws wrote: toto wrote (10-08-11 09:23) I'm using macro's function and it doesn't start when the document start. You can change that via Tools Customize Events. Find the OnOpen event and link it to the macro for the document. Regards, -- 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 will not save file after sheet deleted [SOLUTION]
On 10/08/11 16:41, Simon Cropper wrote: *The upshot* Unless someone recognised these symptoms and can put forward some ideas, I am treating this as a corrupt file. I have drawn this conclusion because (a) I can only reproduce the error on the effected file, (b) the comment insert/delete trick is suggestive but not consistent (or at least from what I can tell) - random sheets cause the file save error if comments are inserted; inserting comments into new sheets also trigger the error. I just hope that recreating this file does not corrupt the new file as I will need to copy blocks of text, numbers and formulas. *My attempts at recreating a clean file* ATTEMPT 1 Created a new file with one less tab. All tabs were named the same as the original. I then cut-and-paste all the data from the original to this newly created file. This took about 10 minutes. The problem is that all tab / sheet references after the omitted sheet moved across one. Despite the formula referencing the sheet name, the name is actually just a human readable cue for the underlying sheet number. So sheet Accounts (sheet #17 on the original file), which pointed to 'accounts lookup list' now points to the Tax sheet, which was #18 but is now #17 in the new file. ATTEMPT 2 Created a new file with exactly the same number of tabs. All tabs were named the same as the original. I then cut-and-paste all the data from the original to this newly created file. This took about 10 minutes. Then with baited breath I deleted the unrequired sheet that triggered this journey in the first place and clicked save. *It worked* - that is, it saved without triggering a write error. I have checked - (a) all data is intact, and (b) all the formulas are working. :) -- Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] New Custom Style in Writer - odd behavior
Aug 07, 2011; 8:42pm - john herron wrote: I created a style (Default_2, next style also Default_2) which I based on the standard Default style. The only difference between the two is that Default has single line spacing whereas for Default_2 calls for double spacing. When I assign Default_2 to a paragraph from Styles and Formatting, it properly displays double-spaced. But when I then finish editing the paragraph with Return (or Enter, if you prefer that), the paragraph reverts to single space. The same also occurs with an indenting style (Def_2_Ind_1) derived from Default_2. Am I doing something wrong or could this be a bug? TIA john Aug 08 Simon Cropper (The foss Workflow Guides) Aug 08, 2011; 12:49am replied: Try not using the underscore. So rename Default_2 to Default2 or DefaultDouble and see what happens. -- Cheers Simon Simon Cropper Website Administrator http://www.fossworkflowguides.com - Hello, Simon Cropper. I tried following your suggestion to not use _ as a style name separator (i.e. renamed the style Default2) but to no avail. Closing the double-spaced Default2 paragraph with Return/Enter still causes the paragraph to revert to single-spaced. Why do I suspect that this behavior might be a bug? Because in OOo's 3.2 Writer, which I also use, the problem does not occur. What now? john -- 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 will not save file after sheet deleted [SOLUTION]
Congratulations,... it was an interesting investigation. Regards, Jorge Rodríguez __ El jue, 11-08-2011 a las 11:50 +1000, Simon Cropper escribió: On 10/08/11 16:41, Simon Cropper wrote: *The upshot* Unless someone recognised these symptoms and can put forward some ideas, I am treating this as a corrupt file. I have drawn this conclusion because (a) I can only reproduce the error on the effected file, (b) the comment insert/delete trick is suggestive but not consistent (or at least from what I can tell) - random sheets cause the file save error if comments are inserted; inserting comments into new sheets also trigger the error. I just hope that recreating this file does not corrupt the new file as I will need to copy blocks of text, numbers and formulas. *My attempts at recreating a clean file* ATTEMPT 1 Created a new file with one less tab. All tabs were named the same as the original. I then cut-and-paste all the data from the original to this newly created file. This took about 10 minutes. The problem is that all tab / sheet references after the omitted sheet moved across one. Despite the formula referencing the sheet name, the name is actually just a human readable cue for the underlying sheet number. So sheet Accounts (sheet #17 on the original file), which pointed to 'accounts lookup list' now points to the Tax sheet, which was #18 but is now #17 in the new file. ATTEMPT 2 Created a new file with exactly the same number of tabs. All tabs were named the same as the original. I then cut-and-paste all the data from the original to this newly created file. This took about 10 minutes. Then with baited breath I deleted the unrequired sheet that triggered this journey in the first place and clicked save. *It worked* - that is, it saved without triggering a write error. I have checked - (a) all data is intact, and (b) all the formulas are working. :) -- Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] How to use the command /msoreg=1 ?
My computer does not have Microsoft office installed; rather the minute Starter office is in place. I followed the instructions in the System Requirements and downloaded--mmsvc90.dll. My computer is running Win7, so I went to Programs--Accessories-- Command Prompt, where the screen shows C:\users\name_ I type the command /msoreg=1 at the prompt, and it refuses to acknowledge it. What went wrong? Tks, Sobriquet -- View this message in context: http://nabble.documentfoundation.org/How-to-use-the-command-msoreg-1-tp3244777p3244777.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc will not save file after sheet deleted [SOLUTION]
Thanks. It was interesting. I am upset though I was unable to pin down the exact cause of the corruption. +/- the comment was obviously a symptom of a underlying structural problem solved through ATTEMPT 2 below. The file was originally created in June 2008 to replace my accounting package due to my frustration at the package not being able to do simple transactions and not being able to get at the underlying data or lookup tables (e.g. tax schedules). The ODS spreadsheet has been accessed at over 152 times from both Windows XP/Ubuntu/XP+VirtualBox, had data imported from external Internet sites 45 times as CSV files, purged then repopulated 3 times and converted from XLS to ODS once. I think all things considered the file has been relatively stable. What some people seem to forget who 'bag' the format, is that I have been able to access my data the entire time *even when this issue occurred*. In the absence of a RAD for a database system on Linux I will be sticking to using LibreOffice Calc to complete my accounting needs. On 11/08/11 14:44, jorge wrote: Congratulations,... it was an interesting investigation. Regards, Jorge Rodríguez __ El jue, 11-08-2011 a las 11:50 +1000, Simon Cropper escribió: On 10/08/11 16:41, Simon Cropper wrote: *The upshot* Unless someone recognised these symptoms and can put forward some ideas, I am treating this as a corrupt file. I have drawn this conclusion because (a) I can only reproduce the error on the effected file, (b) the comment insert/delete trick is suggestive but not consistent (or at least from what I can tell) - random sheets cause the file save error if comments are inserted; inserting comments into new sheets also trigger the error. I just hope that recreating this file does not corrupt the new file as I will need to copy blocks of text, numbers and formulas. *My attempts at recreating a clean file* ATTEMPT 1 Created a new file with one less tab. All tabs were named the same as the original. I then cut-and-paste all the data from the original to this newly created file. This took about 10 minutes. The problem is that all tab / sheet references after the omitted sheet moved across one. Despite the formula referencing the sheet name, the name is actually just a human readable cue for the underlying sheet number. So sheet Accounts (sheet #17 on the original file), which pointed to 'accounts lookup list' now points to the Tax sheet, which was #18 but is now #17 in the new file. ATTEMPT 2 Created a new file with exactly the same number of tabs. All tabs were named the same as the original. I then cut-and-paste all the data from the original to this newly created file. This took about 10 minutes. Then with baited breath I deleted the unrequired sheet that triggered this journey in the first place and clicked save. *It worked* - that is, it saved without triggering a write error. I have checked - (a) all data is intact, and (b) all the formulas are working. :) -- Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au -- Cheers Simon Simon Cropper Principal Consultant Botanicus Australia Pty Ltd PO Box 160, Sunshine, VIC W: www.botanicusaustralia.com.au -- 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