[libreoffice-users] Improvement needed for libreoffice
Dear LibreOffice.4.0.4, I am happy to use this open source software.Its definitely a great replacement for commercial tools. Recently i opened the attached document in Libreoffice and Microsoft office. But in libreoffice the layout is not correctly visible as in Microsoft office. And also text form fields can be improved like directly typing in without need for a dialog as in libre. For your analysis and improvement of libreoffice software.I attached the documents.The word document is the base document and other two pdfs are generated from libreoffice latest and MS office. You could see in *same_document_in_libreoffice.pdf*,that the layout in libreoffice is not exact in other office document. Please add these kind of user experience improvements.Please feel free to contact me back. thanks, Thiyagarajan -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Libre Vs office
Hi, We are planning to use this LibreOffice, Can I get the exact commands comparison between LibreOffice and MS Office. Regards, Mukund Tavag Confidentiality Notice: This e-mail transmission may contain confidential or legally privileged information that is intended only for the individual or entity named in the e-mail address. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or reliance upon the contents of this e-mail is strictly prohibited. If you have received this e-mail transmission in error, please delete the message and any attachments from your Inbox. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Book-writing with Writer
On 10/07/2013 5:20, Urmas wrote: Pablo Dotro: I am beginning a large writing project, that will most probably take the form of a self published, free ebook. please dowload the eLAIX extension, there is a manuel for how to start a ebook with LO And while I have created very long, complex documents before, I have never formatted them as a book. But I find that there is a gap between the techniques described there for working with templates, styles and master documents... and the actual craft needed to make them work. The tool that you use does not matter. Everything thay you write will be decomposed and virtually remade in the DTP program, most likely InDesign. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Libre Vs office
Hi, we don't have a comparison for the commands between LibreOffice and Microsoft Office, but you should have a look at our user manuals for the different components, that you can find here: http://www.libreoffice.org/get-help/documentation/ You will find out very quickly, that most commands (keyboard shortcuts) work the same as in MS Office. Sigrid -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Book-writing with Writer
Urmas wrote: The tool that you use does not matter. Everything thay you write will be decomposed and virtually remade in the DTP program, most likely InDesign. You may be right if the project goes to a professional publisher for final output. But, Pablo's original question stated he would be creating a self published, free ebook. Pablo is apparently looking for a solution that *avoids* the need to present his book to a professional publisher. Virgil -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Fwd: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved?
Once again I sent privately. I'm getting tired of this so I really don't care, but I decided to be nice today, so here's to the list. I also added some stuff at the end. -- Forwarded message -- From: Johnny Rosenberg gurus.knu...@gmail.com Date: 2013/7/10 Subject: Re: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved? To: Tanstaafl tansta...@libertytrek.org 2013/7/9 Tanstaafl tansta...@libertytrek.org: Is it possible to define a range of cells to auto sort themselves, such that anytime one of them is modified, the sort is reapplied? This is some Sales Numbers for some Sales Reps, and the boss wants them to always be sorted based on the total column anytime any numbers in the sheet are changed. Currently I'm manually sorting the sheet every morning, but he'd like this to happen automatically. Thanks I'm not sure you can do it exactly like that. You can make a macro to sort your specific cells, either when you run it manually or at a specific event. Those events are ”when the document is opened” and things like that, I don't think you can trig it to ”when a cell in A1:F19 is modified” or anything like that. I would just add a button in the sheet that sorts when clicked. As a complement to that, I would probably also trig it to when document is opened and maybe saved, if that's possible. Another way is to use cell formulas to keep your cell range sorted. It's possible but somewhat complicated. I have done it, but I need to do some searching, because I don't remember in which document I did this… In that case you will probably want to use two sheets: One for data input and one for viewing (which is the auto-sorted one). If you want to sort by a column with numbers, take a look here: http://ask.libreoffice.org/en/question/1309/is-there-an-automatic-sort-function-in-calc/ I'm doing some experiments right now to find out if this also can be achieved with text… Maybe I'll fail, I don't know… yet… Johnny Rosenberg I did some testing and I finally found how to auto-sort text, rather than just numbers. It's probably slow with big cell ranges though, since I needed to write a cell function to get the job done. I'm sure there are much better ways to do this, but this is what I came up with: First create a new cell function called SortValue. The function returns a number between 0 and 1 corresponding to the input text. This function is VERY simple and there is no error handling at all, so feel free to improve it and customise it after your likings! REM * BASIC * Option Explicit Function SortValue(sText As String) Dim sSorted As String sSorted=0123456789abcdefghijklmnopqrstuvwxyzåäö Dim iLen As Integer iLen=Len(sSorted) Dim d As Double, i As Integer sText=LCase(sText) For i=1 To iLen d=d+InStr(sSorted,Mid(sText,i,1))/iLen^i Next i SortValue=d End Function First of all, the string variable sSorted is defined as ”0123456789abcdefghijklmnopqrstuvwxyzåäö”. This is just the sort order for the characters it can handle. Feel free to remove and add characters to suite your needs. In this case, these are numbers followed by the Swedish alphabet. Only lower case characters are present since the macro converts the input string to lower case anyway. This way, ”A” gives the same numerical value as ”a”. If this isn't what you want, add uppercase letters to the list and place them right and remove the ”sText=LCase(sText)” line, or ”comment it out” by preceding the line with a ' or the text ”REM” (without the quotes). For example: sString=0123456789AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz. Maybe you want to add other characters, like ”,.;:-” or whatever. I didn't test this with UNICODE characters, it could work, I think. By the way, my test document can be found here: http://ubuntuone.com/1I7EY6jMoZ4MYLrPejP5Eh Make sure that macro security is set so that you can run the cell formula properly, otherwise this will not work, of course. Now, if your text to be sorted is located at B1:B13, then add the following in A1: =SORTVALUE(B1) Copy downwards, so A2 contains =SORTVALUE(B2) and so on. In C1 we type: =SMALL(A$1:A$13;ROW()) Copy down the same way as we did with the A column… In D1: =VLOOKUP(C1;A$1:B$13;2;0) Copy down… And there we are! Of course this can be done with different spreadsheets, but the A and B column needs to be together in that order. However, you can hide the A column and other columns that you don't want to see, of course. Please note that I did this rather quickly. Of course I could have made a couple of mistakes here and there. I'm interested to know if you find any. Thanks. The only test I did was that document, see link above. Johnny Rosenberg -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?
Re: [libreoffice-users] Book-writing with Writer
On 07/10/2013 08:37 AM, Virgil Arrington wrote: Urmas wrote: The tool that you use does not matter. Everything thay you write will be decomposed and virtually remade in the DTP program, most likely InDesign. You may be right if the project goes to a professional publisher for final output. But, Pablo's original question stated he would be creating a self published, free ebook. Pablo is apparently looking for a solution that *avoids* the need to present his book to a professional publisher. Virgil The poster might want to look at this page. http://www.hipiers.com/publishing.html In the list, there is information about some publishers and services, with some references to e-book self publishing. IT might be worth a look. If the poster wants to make money on a self-published e-book, then there may be some good information there to guide through the process. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base DB Connections
Hi Mark, Here is the code - Sub BtnPrepareBankEntries() Dim sEntryDateAS String Dim sBkStatAS String Dim sBkStatBakAS String Dim aFields(150,7)AS String Dim sKeyAS String Dim aWhoRef(150,7)AS String Dim iCountAS Integer Dim iFileNoAS Integer Dim iRecAS Integer Dim iFldAS Integer Dim iPtrAS Integer Dim iBSB_AcNoAS Integer Dim iEntryDateAS Integer Dim iTypeCodeAS Integer Dim iAmountAS Integer Dim iEntryTypeAS Integer Dim iWhoAS Integer Dim iWhoRefAS Integer Dim iKeyAS Integer iBSB_AcNo = 1 iEntryDate = 2 iTypeCode = 3 iAmount= 4 iEntryType = 5 iWho = 6 iWhoRef= 7 iKey = 0 sBkStat = D:\Downloads\BBL.csv sBkStatBak = D:\Downloads\BBL.bak if not FileExists(sBkStat) then msgBox(File + sBkStat + not found. Check that you have downloaded the month's entries from the Bank, MB_OK, PRIOR ACTION NEEDED ) else iCount = 0 iRec = 0 iFileNo = FreeFile() ' Read records from D:\Downloads\BBL.csv into the array - (aFields(150,7)) Open sBkStat for Input as #iFileNo Do while NOT EOF(iFileNo) iRec = iRec + 1 For iFld = 1 to 7 Input #iFileNo, aFields(iRec,iFld) Next iFld Loop REM1 - The following lines transform the data to suit the Accounting System. This is where you could delete duplicates or make data adjustments. For iPtr = iRec To 1 Step -1 aFields(iPtr,iEntryType) = fCamelCase(fRemoveNumbers(aFields(iPtr,iEntryType),0)) aFields(iPtr,iWho) = fCamelCase(fRemoveNumbers(aFields(iPtr,iWho),0)) aWhoRef(iPtr,iWhoRef) = fCamelCase(fRemoveNumbers(aFields(iPtr,iWhoRef),2)) Select case aFields(iPtr,iEntryType) Case Debit Card Fee : aFields(iPtr,iKey) = aFields(iPtr,iEntryType) Case Deposit - Cheque(s) : aFields(iPtr,iKey) = aFields(iPtr,iEntryType) Case Direct Credit : aFields(iPtr,iKey) = aFields(iPtr,iWho) if aFields(iPtr,iWho) = Challenger Life then aFields(iPtr,iKey) = aFields(iPtr,iWho) + : + aWhoRef(iPtr,iWhoRef) End if if aFields(iPtr,iWho) = Ing Direct then aFields(iPtr,iKey) = aFields(iPtr,iWho) + Credit End if Case Direct Debit : if aFields(iPtr,iWho) = Ing Direct then aFields(iPtr,iKey) = aFields(iPtr,iWho) + Debit else aFields(iPtr,iKey) = aFields(iPtr,iWho) + : + aWhoRef(iPtr,iWhoRef) End if Case Interest : aFields(iPtr,iKey) = aFields(iPtr,iEntryType) case Pay Anyone : if aFields(iPtr,iAmount) 0 then aFields(iPtr,iKey) = aFields(iPtr,iWho) else aFields(iPtr,iKey) = fCamelCase(fRemoveNumbers(aWhoRef(iPtr,iWhoRef),0))' Remove 2 digits remaining on left of string End if case Pension : aFields(iPtr,iKey) = aFields(iPtr,iWho) + : + aWhoRef(iPtr,iWhoRef) case Retail Purchase : aFields(iPtr,iKey) = aFields(iPtr,iWho) Case Transaction Fees Charged : aFields(iPtr,iKey) = aFields(iPtr,iEntryType) Case Withdrawal - Atm : aFields(iPtr,iKey) = Left(WDraw-ATM: + aFields(iPtr,iWho), 30) Case Withdrawal - Eftpos : aFields(iPtr,iKey) = Left(WDraw-EFTPOS: + aFields(iPtr,iWho), 30) case Else : aFields(iPtr,iKey) = aFields(iPtr,iWho) end Select Next iPtr REM2 - End of transformation section ' Add records to the BankStatments table in date order For iPtr = iRec To 1 Step -1 sEntryDate = fReverseDate(aFields(iPtr,iEntryDate)) gsSQL = INSERT INTO BankStatements (EntryDate,Who,Amount,EntryType,WhoRef,BSB-A/cNo,TypeCode,Key) _ + VALUES (' + sEntryDate + ',' + fProcessSingleQuotes(aFields(iPtr,iWho)) + ',' + aFields(iPtr,iAmount) + ',' _ + aFields(iPtr,iEntryType) + ',' + aFields(iPtr,iWhoRef) + ',' + aFields(iPtr,iBSB_AcNo) + ',' _ + aFields(iPtr,iTypeCode) + ',' + fProcessSingleQuotes(aFields(iPtr,iKey)) + ') if goStmt9.executeUpdate(gsSQL) = 0 then'= row NOT inserted MsgBox(INSERT failed. Command was - ' + gsSQL +
[libreoffice-users] Re: Improvement needed for libreoffice
Hi ) Thanks for your help with this. Unfortunately the mailing list removes attachments. You can upload the file to Nabble so that people can choose to see it if they want. It puts a line of html code into the message and that results in a click-able link for people to just click on in order to see the 'attachment'. Follow the links in this email to get to Nabble. Then just above where you write the reply there is a line of buttons. The end one is More and the top option in More is to Upload a file. After that it works a lot like getting an attachment onto an email. In effect Nabble is storing the file on it's own Cloud. Microsoft's formats vary slightly between different versions of MS Office so documents written in MS Office 2010 may well look different when viewed with anything else, even MS Office 2007 or MS Office 2013 might not display them correctly. It's annoying and seems designed to force people into buying whichever version is used by most of the people they have to deal with. So, a lot of companies and people are currently buying MS Office 2010 even though 2013 just came out. Since some people are ending up with 2013 on home machines and laptops companies will soon have to buy 2013 even though they only just bought 2010. We find that LibreOffice (or OpenOffice) users are able to write documents that can then be viewed correctly by any of the versions of MS Office. So they often become unofficial intermediaries between different colleagues using different versions of MS Office. The situation is improving though. Compatibility with the most used or the latest version of MS's formats increases with each release and more so with each new branch of LibreOffice. Even better the native format used by LibreOffice and most other Office Suites or office programs is also now supported in more recent versions of MS Office. The ODF format is an ISO format and the specification for that is finalised by a committee on which many large organisations have representation. So the implementation tends to be the same in all the different programs that use it. On the rare occasion documents don't display correctly it is hoped that a bug-report will get filed and the program corrected. Unfortunately MS Office 2007 and 2010 only support the ancient version of ODF. It's only the fairly recent MS Office 2013 and 365 that support the current format. So, it is beginning to be better to use ODF now instead of the MS formats. It's certainly better for documents that are being stored to be read in the future. The main problem is whether it is better to use right now when you have a few people working at a document together. It's increasingly better to change to the ODF format for that too but sometimes it is still impossible. So, many thanks for your help here. If you can upload the file to Nabble that would help but don't worry too much if you can't at the moment. Thanks and regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Improvement-needed-for-libreoffice-tp4064772p4064831.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Liber office help with Excel library
Dear sir, Thanking you for your product of liber office. Previously i am using visual basic 6 and i used microsoft Excel 11.0 object library in my machine. Now i am using liber office instead of Microsoft office. When running by VB6 appications, my system shows 'Misssing microsoft Excel 11.0 object library' Kindly help to solve the above issue. thanks in advance Regards V. Annadrai -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Libre Vs office
Hi :) Direct comparison between different commands might not be possible but most of the functions in spreadsheets and so on are identical anyway. Formulas do the same action regardless of whether you write them by hand on a black-board, in a book or in a spreadsheet. Occasionally Excel does do some non-standard things or calls a formula by a wrong name. The defaults for Calc can be set to follow Excel in those cases so that new spreadsheets follow the same patterns. However, old documents or new documents created in MS Office are correctly read by Calc even though they follow the non-standard formulas. On a wider scale the menu structure is much the same as MS Office 2003 and earlier versions so if people don't know exactly where a certain item is in the menus then they can follow the old trick of clicking on 1 menu, such as the File menu and then move the mouse arrow over the other menus until they find what they want. It's much easier than memorising the ribbon-bar. Of course, as Sigrid pointed out, a lot of the keyboard short-cuts are the same and many of them work in almost every program anyway, for example Ctrl c to copy Ctrl x to cut Ctrl v to paste Ctrl z to undo all seem to work in just about every program on any system (except Mac or iThings) Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Libre-Vs-office-tp4064773p4064833.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Clunkiness of the list, was: Fw: Fwd: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved?
Hi :) I have started using Reply to all for my normal emails too and mostly that works just fine. Occasionally i have to be careful and edit out certain people but mostly it works better than trying to work out which button to press for different things. Regards from Tom :) - Forwarded Message - From: Johnny Rosenberg gurus.knu...@gmail.com To: LibreOffice Användare users@global.libreoffice.org Sent: Wednesday, 10 July 2013, 13:41 Subject: Fwd: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved? Once again I sent privately. I'm getting tired of this so I really don't care, but I decided to be nice today, so here's to the list. I also added some stuff at the end. -- Forwarded message -- From: Johnny Rosenberg gurus.knu...@gmail.com Date: 2013/7/10 Subject: Re: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved? To: Tanstaafl tansta...@libertytrek.org 2013/7/9 Tanstaafl tansta...@libertytrek.org: Is it possible to define a range of cells to auto sort themselves, such that anytime one of them is modified, the sort is reapplied? This is some Sales Numbers for some Sales Reps, and the boss wants them to always be sorted based on the total column anytime any numbers in the sheet are changed. Currently I'm manually sorting the sheet every morning, but he'd like this to happen automatically. Thanks I'm not sure you can do it exactly like that. You can make a macro to sort your specific cells, either when you run it manually or at a specific event. Those events are ”when the document is opened” and things like that, I don't think you can trig it to ”when a cell in A1:F19 is modified” or anything like that. I would just add a button in the sheet that sorts when clicked. As a complement to that, I would probably also trig it to when document is opened and maybe saved, if that's possible. Another way is to use cell formulas to keep your cell range sorted. It's possible but somewhat complicated. I have done it, but I need to do some searching, because I don't remember in which document I did this… In that case you will probably want to use two sheets: One for data input and one for viewing (which is the auto-sorted one). If you want to sort by a column with numbers, take a look here: http://ask.libreoffice.org/en/question/1309/is-there-an-automatic-sort-function-in-calc/ I'm doing some experiments right now to find out if this also can be achieved with text… Maybe I'll fail, I don't know… yet… Johnny Rosenberg I did some testing and I finally found how to auto-sort text, rather than just numbers. It's probably slow with big cell ranges though, since I needed to write a cell function to get the job done. I'm sure there are much better ways to do this, but this is what I came up with: First create a new cell function called SortValue. The function returns a number between 0 and 1 corresponding to the input text. This function is VERY simple and there is no error handling at all, so feel free to improve it and customise it after your likings! REM * BASIC * Option Explicit Function SortValue(sText As String) Dim sSorted As String sSorted=0123456789abcdefghijklmnopqrstuvwxyzåäö Dim iLen As Integer iLen=Len(sSorted) Dim d As Double, i As Integer sText=LCase(sText) For i=1 To iLen d=d+InStr(sSorted,Mid(sText,i,1))/iLen^i Next i SortValue=d End Function First of all, the string variable sSorted is defined as ”0123456789abcdefghijklmnopqrstuvwxyzåäö”. This is just the sort order for the characters it can handle. Feel free to remove and add characters to suite your needs. In this case, these are numbers followed by the Swedish alphabet. Only lower case characters are present since the macro converts the input string to lower case anyway. This way, ”A” gives the same numerical value as ”a”. If this isn't what you want, add uppercase letters to the list and place them right and remove the ”sText=LCase(sText)” line, or ”comment it out” by preceding the line with a ' or the text ”REM” (without the quotes). For example: sString=0123456789AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz. Maybe you want to add other characters, like ”,.;:-” or whatever. I didn't test this with UNICODE characters, it could work, I think. By the way, my test document can be found here: http://ubuntuone.com/1I7EY6jMoZ4MYLrPejP5Eh Make sure that macro security is set so that you can run the cell formula properly, otherwise this will not work, of course. Now, if your text to be sorted is located at B1:B13, then add the following in A1: =SORTVALUE(B1) Copy downwards, so A2 contains =SORTVALUE(B2) and so on. In C1 we type: =SMALL(A$1:A$13;ROW()) Copy down the same way as we did with the A column… In D1: =VLOOKUP(C1;A$1:B$13;2;0) Copy down… And there we are! Of course this can be done with different spreadsheets, but the A and B column needs to be
[libreoffice-users] Need Confirmation: since 4.1 MySQL datetime fields are wrangled in LO base tables
I connect with the Windows Native MYSQL connector (compiled against 4.0) to a MySQL database since 4.1 all DateTime fields are wrangled when showing a table in LO base, when changing the values using LO then they are also wrangled in the original MySQL table date values seems to be OK can that been confirmed on other than windows machines and maybe other connectors ? Lionel Elie Mamane suggested that due to some changes in the base code the Windows Connector has to been recompiled against 4.1 ? Greetz Fernand -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved?
2013/7/10 Johnny Rosenberg gurus.knu...@gmail.com: Once again I sent privately. I'm getting tired of this so I really don't care, but I decided to be nice today, so here's to the list. I also added some stuff at the end. -- Forwarded message -- From: Johnny Rosenberg gurus.knu...@gmail.com Date: 2013/7/10 Subject: Re: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved? To: Tanstaafl tansta...@libertytrek.org 2013/7/9 Tanstaafl tansta...@libertytrek.org: Is it possible to define a range of cells to auto sort themselves, such that anytime one of them is modified, the sort is reapplied? This is some Sales Numbers for some Sales Reps, and the boss wants them to always be sorted based on the total column anytime any numbers in the sheet are changed. Currently I'm manually sorting the sheet every morning, but he'd like this to happen automatically. Thanks I'm not sure you can do it exactly like that. You can make a macro to sort your specific cells, either when you run it manually or at a specific event. Those events are ”when the document is opened” and things like that, I don't think you can trig it to ”when a cell in A1:F19 is modified” or anything like that. I would just add a button in the sheet that sorts when clicked. As a complement to that, I would probably also trig it to when document is opened and maybe saved, if that's possible. Another way is to use cell formulas to keep your cell range sorted. It's possible but somewhat complicated. I have done it, but I need to do some searching, because I don't remember in which document I did this… In that case you will probably want to use two sheets: One for data input and one for viewing (which is the auto-sorted one). If you want to sort by a column with numbers, take a look here: http://ask.libreoffice.org/en/question/1309/is-there-an-automatic-sort-function-in-calc/ I'm doing some experiments right now to find out if this also can be achieved with text… Maybe I'll fail, I don't know… yet… Johnny Rosenberg I did some testing and I finally found how to auto-sort text, rather than just numbers. It's probably slow with big cell ranges though, since I needed to write a cell function to get the job done. I'm sure there are much better ways to do this, but this is what I came up with: First create a new cell function called SortValue. The function returns a number between 0 and 1 corresponding to the input text. This function is VERY simple and there is no error handling at all, so feel free to improve it and customise it after your likings! REM * BASIC * Option Explicit Function SortValue(sText As String) Dim sSorted As String sSorted=0123456789abcdefghijklmnopqrstuvwxyzåäö Dim iLen As Integer iLen=Len(sSorted) Dim d As Double, i As Integer sText=LCase(sText) For i=1 To iLen d=d+InStr(sSorted,Mid(sText,i,1))/iLen^i Next i SortValue=d End Function First of all, the string variable sSorted is defined as ”0123456789abcdefghijklmnopqrstuvwxyzåäö”. This is just the sort order for the characters it can handle. Feel free to remove and add characters to suite your needs. In this case, these are numbers followed by the Swedish alphabet. Only lower case characters are present since the macro converts the input string to lower case anyway. This way, ”A” gives the same numerical value as ”a”. If this isn't what you want, add uppercase letters to the list and place them right and remove the ”sText=LCase(sText)” line, or ”comment it out” by preceding the line with a ' or the text ”REM” (without the quotes). For example: sString=0123456789AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz. Maybe you want to add other characters, like ”,.;:-” or whatever. I didn't test this with UNICODE characters, it could work, I think. By the way, my test document can be found here: http://ubuntuone.com/1I7EY6jMoZ4MYLrPejP5Eh Make sure that macro security is set so that you can run the cell formula properly, otherwise this will not work, of course. Now, if your text to be sorted is located at B1:B13, then add the following in A1: =SORTVALUE(B1) Copy downwards, so A2 contains =SORTVALUE(B2) and so on. In C1 we type: =SMALL(A$1:A$13;ROW()) Copy down the same way as we did with the A column… In D1: =VLOOKUP(C1;A$1:B$13;2;0) Copy down… And there we are! Of course this can be done with different spreadsheets, but the A and B column needs to be together in that order. However, you can hide the A column and other columns that you don't want to see, of course. Please note that I did this rather quickly. Of course I could have made a couple of mistakes here and there. I'm interested to know if you find any. Thanks. The only test I did was that document, see link above. Johnny Rosenberg I found one serious one myself,
Re: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved?
2013/7/10 Johnny Rosenberg gurus.knu...@gmail.com: 2013/7/10 Johnny Rosenberg gurus.knu...@gmail.com: Once again I sent privately. I'm getting tired of this so I really don't care, but I decided to be nice today, so here's to the list. I also added some stuff at the end. -- Forwarded message -- From: Johnny Rosenberg gurus.knu...@gmail.com Date: 2013/7/10 Subject: Re: [libreoffice-users] Auto-sort group of cells when any cell is modified/saved? To: Tanstaafl tansta...@libertytrek.org 2013/7/9 Tanstaafl tansta...@libertytrek.org: Is it possible to define a range of cells to auto sort themselves, such that anytime one of them is modified, the sort is reapplied? This is some Sales Numbers for some Sales Reps, and the boss wants them to always be sorted based on the total column anytime any numbers in the sheet are changed. Currently I'm manually sorting the sheet every morning, but he'd like this to happen automatically. Thanks I'm not sure you can do it exactly like that. You can make a macro to sort your specific cells, either when you run it manually or at a specific event. Those events are ”when the document is opened” and things like that, I don't think you can trig it to ”when a cell in A1:F19 is modified” or anything like that. I would just add a button in the sheet that sorts when clicked. As a complement to that, I would probably also trig it to when document is opened and maybe saved, if that's possible. Another way is to use cell formulas to keep your cell range sorted. It's possible but somewhat complicated. I have done it, but I need to do some searching, because I don't remember in which document I did this… In that case you will probably want to use two sheets: One for data input and one for viewing (which is the auto-sorted one). If you want to sort by a column with numbers, take a look here: http://ask.libreoffice.org/en/question/1309/is-there-an-automatic-sort-function-in-calc/ I'm doing some experiments right now to find out if this also can be achieved with text… Maybe I'll fail, I don't know… yet… Johnny Rosenberg I did some testing and I finally found how to auto-sort text, rather than just numbers. It's probably slow with big cell ranges though, since I needed to write a cell function to get the job done. I'm sure there are much better ways to do this, but this is what I came up with: First create a new cell function called SortValue. The function returns a number between 0 and 1 corresponding to the input text. This function is VERY simple and there is no error handling at all, so feel free to improve it and customise it after your likings! REM * BASIC * Option Explicit Function SortValue(sText As String) Dim sSorted As String sSorted=0123456789abcdefghijklmnopqrstuvwxyzåäö Dim iLen As Integer iLen=Len(sSorted) Dim d As Double, i As Integer sText=LCase(sText) For i=1 To iLen d=d+InStr(sSorted,Mid(sText,i,1))/iLen^i Next i SortValue=d End Function First of all, the string variable sSorted is defined as ”0123456789abcdefghijklmnopqrstuvwxyzåäö”. This is just the sort order for the characters it can handle. Feel free to remove and add characters to suite your needs. In this case, these are numbers followed by the Swedish alphabet. Only lower case characters are present since the macro converts the input string to lower case anyway. This way, ”A” gives the same numerical value as ”a”. If this isn't what you want, add uppercase letters to the list and place them right and remove the ”sText=LCase(sText)” line, or ”comment it out” by preceding the line with a ' or the text ”REM” (without the quotes). For example: sString=0123456789AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz. Maybe you want to add other characters, like ”,.;:-” or whatever. I didn't test this with UNICODE characters, it could work, I think. By the way, my test document can be found here: http://ubuntuone.com/1I7EY6jMoZ4MYLrPejP5Eh Make sure that macro security is set so that you can run the cell formula properly, otherwise this will not work, of course. Now, if your text to be sorted is located at B1:B13, then add the following in A1: =SORTVALUE(B1) Copy downwards, so A2 contains =SORTVALUE(B2) and so on. In C1 we type: =SMALL(A$1:A$13;ROW()) Copy down the same way as we did with the A column… In D1: =VLOOKUP(C1;A$1:B$13;2;0) Copy down… And there we are! Of course this can be done with different spreadsheets, but the A and B column needs to be together in that order. However, you can hide the A column and other columns that you don't want to see, of course. Please note that I did this rather quickly. Of course I could have made a couple of mistakes here and there. I'm interested to know if you find any. Thanks. The only test I did was that document, see link above.
Re: [libreoffice-users] Liber office help with Excel library
On 07/10/2013 05:21 AM, ANNADURAI V. wrote: Dear sir, Thanking you for your product of liber office. Previously i am using visual basic 6 and i used microsoft Excel 11.0 object library in my machine. Now i am using liber office instead of Microsoft office. When running by VB6 appications, my system shows 'Misssing microsoft Excel 11.0 object library' Kindly help to solve the above issue. thanks in advance Regards V. Annadrai Seems that you are looking for a library included with Excel, so, if you do not have Excel, you do not have the library. http://social.msdn.microsoft.com/Forums/en-US/ecf7b321-788e-42dc-92f5-2bc74fe84c82/where-can-i-find-microsoft-excel-110-object-library I expect that you would need to use the LibreOffice API to manipulate spreadsheets if using Libre rather than Excel. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base DB Connections
Very Nice! On 07/10/2013 09:08 AM, Marion Noel Lodge wrote: Hi Mark, Here is the code - -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] A feature, or ...?
I have on several occasions been annoyed by something in LO - just a small thing, but none the less: Normally, when you apply a style, like a header style, it sets the typeface etc, but sometimes it doesn't. I think it happens in situations like this: I write a section of text, apply some character formatting (eg. bold or a different font), then decide to break the section up and insert a heading in between - and it doesn't work, ie the font doesn't change etc. Why is that? Is this the way it should be, or is it a bug? If it is a feature, what am I doing wrong? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base DB Connections
Thanks Andrew, Much of my macro's code was built on your examples and those of others. How did we ever manage before the Web? Noel -- Noel Lodge lodg...@gmail.com On 11 July 2013 10:22, Andrew Douglas Pitonyak and...@pitonyak.org wrote: Very Nice! On 07/10/2013 09:08 AM, Marion Noel Lodge wrote: Hi Mark, Here is the code - -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/**AndrewMacro.odthttp://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscribe@global.**libreoffice.orgusers%2bunsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] A feature, or ...?
It is possible that there is some direct formatting applied to the text. Among other things, what determine the final look of text, it first apply the paragraph style, then the character style, then the direct formatting. Those two can be changed independently. For example, applying the bold attribute by hand (using the B button in the toolbars) change the direct formatting. If you then apply a style, it will not override the direct formatting of the text. Usually, if using styles correctly, you shouldn't apply attributes by hand *at all*. To check if this is the issue, you can delete direct formatting quickly by selecting the text, and use the Format-Delete direct formatting menu (or something like that; I'm not sure about the english UI, but it's the first command in the Format menu). -- Cley Faye http://cleyfaye.net 2013/7/11 Jan Andersen j4nd3r...@gmail.com I have on several occasions been annoyed by something in LO - just a small thing, but none the less: Normally, when you apply a style, like a header style, it sets the typeface etc, but sometimes it doesn't. I think it happens in situations like this: I write a section of text, apply some character formatting (eg. bold or a different font), then decide to break the section up and insert a heading in between - and it doesn't work, ie the font doesn't change etc. Why is that? Is this the way it should be, or is it a bug? If it is a feature, what am I doing wrong? -- To unsubscribe e-mail to: users+unsubscribe@global.**libreoffice.orgusers%2bunsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] A feature, or ...?
Ah, that sounds like it could be the explanation; thank you for clearing that up for me :-) On 11/07/13 06:30, Gabriel Risterucci wrote: It is possible that there is some direct formatting applied to the text. Among other things, what determine the final look of text, it first apply the paragraph style, then the character style, then the direct formatting. Those two can be changed independently. For example, applying the bold attribute by hand (using the B button in the toolbars) change the direct formatting. If you then apply a style, it will not override the direct formatting of the text. Usually, if using styles correctly, you shouldn't apply attributes by hand *at all*. To check if this is the issue, you can delete direct formatting quickly by selecting the text, and use the Format-Delete direct formatting menu (or something like that; I'm not sure about the english UI, but it's the first command in the Format menu). -- Cley Faye http://cleyfaye.net 2013/7/11 Jan Andersen j4nd3r...@gmail.com mailto:j4nd3r...@gmail.com I have on several occasions been annoyed by something in LO - just a small thing, but none the less: Normally, when you apply a style, like a header style, it sets the typeface etc, but sometimes it doesn't. I think it happens in situations like this: I write a section of text, apply some character formatting (eg. bold or a different font), then decide to break the section up and insert a heading in between - and it doesn't work, ie the font doesn't change etc. Why is that? Is this the way it should be, or is it a bug? If it is a feature, what am I doing wrong? -- To unsubscribe e-mail to: users+unsubscribe@global.__libreoffice.org mailto:users%2bunsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted