[libreoffice-users] libreoffice 4.1.4.2 install problem
Just some feedback for the Devs on an install problem which I have managed to workaround - so no reply necessary - unless the Devs want further details. System: Acer X1420 - AMD Athlon dual core CPU / 4GB RAM, running Windows 8.1. I downloaded the install file on two occasions - both displayed identical behaviour during the install. During the install, two warning dialogs are displayed: Warning 1946. 'System.AppUserModel.ID' for shortcut 'LibreOffice Draw.lnk' could not be set. Warning 1946. 'System.AppUserModel.ID' for shortcut 'LibreOffice Impress.lnk' could not be set. Installation stalls completely when status reads 'creating shortcuts'. However, I have since discovered that version 4.1.4.2 did install, and I was able to create the shortcuts manually from the Start Screen. Regards Alan -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc Function
At 10:17 11/01/2014 -0800, James E Lang wrote: Please fill in the blank (___) below with a function name or tell me there is no such function: SUM(range) is to SUMIF(range1,criteria,range2) as COUNT(range) is to ___(range1,criteria,range2) COUNTIF would seem to be the logical answer but I don't think it supports the third parameter and thus it is not analogous to COUNT. I'm wanting to use it as follows: =IF(___(A$3:A7,A7,Q$3:Q7)=___(A$3:A7,A7,R$3:R7),SUM(A$3:A7,A7,R$3:R7)-SUM(A$3:A7,A7,Q$3:Q7),Error 4) Where Error 4 means that the start miles in Q$3:Q7 and end miles in R$3:R7 are not properly paired and thus the miles driven on date A7 cannot be determined. Your formula - if it worked - would count the cells in columns Q and R which correspond to cells in column A which match your criterion for the contents of the cells in column A. As has already been pointed out, this is no different from counting the relevant cells in column A - and this means that your test of equality will always be true and your error message will never be triggered. The COUNTIF(), even if you could use it as you hoped, would pick out the appropriate date but not take any account of the contents of the cells in columns Q and R. (This is no doubt why COUNTIF() cannot have that third parameter: it would be of no use!) ... the corresponding cell in column Q or R respectively contains a number (otherwise it's a zero length string). At no point have you tested the contents of relevant cells in columns Q and R, which would be counted even if they were empty. But more fundamentally, counting such cells is surely an insufficient test anyway: if you have the same number of missing start miles as missing end miles, your counts would match up (and no error would be triggered) even if the missing values were in different rows. I trust this helps. Brian Barker -- 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] getting larger set of colors that the standard that comes with LO -corrected URL
Thanks som I redid the arrangement of some of the colors in the original large color file and put that in the ownCloud folder. Plus I added a few more colors I found. I found Hex codes for colors like Silver, Copper, Wood, etc.. So I added it to the second one. I found a set of Hex codes that do not have any named to them, but they explore the range of colors, from light to dark, starting with one color/code. This is a sample of those color tables. http://libreoffice-na.us/color-coder-tables.png I may work on creating a file with those color in it. Although there are not names for them, I would end up using their Hex codes for the names, unless there is no need for naming the colors in the list. If you look at the color table in Writer, via. its table properties for the background of a cell, you can see it another way. http://libreoffice-na.us/writer-color-table.png This is a screen clip of Writer and one of my calendars that I made from a .doc template I found. The bottom two rows, and part of the row above that, are the Branding Colors, so if you want to create something with the LO Branded Colors you do not have to look any farther. Yes, above those colors there are colors like Blue 8 or Turquoise 2, but there is no indication if any of those colors are the Branded Colors or not. I made sure that the colors had names like LO green 4 or LO yellow 1 so you know that they are the colors listed in the Branding information page. With over 2,000 colors in the list, the users should be able to find something they would like to use. When I have the time to make a new one, with the colors in the first image's file, then there will be a lot more choices. On 01/11/2014 11:33 PM, som wrote: On Saturday, 11 January 2014 10:07 PM, Kracked_P_P---webmaster webmas...@krackedpress.com wrote: https://owncloud.documentfoundation.org/Common/QA/New-Colors# this worked. thanks for the file. here (https://db.tt/pLDjVXJW) is a screenshot of libreoffice after replacing the original with this standard.soc on a Xubuntu 13.10. regards, som -- 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 LibO/Calc problem
Happy New Year Dear LibO experts, Since years back I have copied my bank's digital listing of my bank account(s); first using MSOWord and later on MSOExcel. My intension is to transform these listings so I can calculate with the currency values in LibO-Calc. The bank's table has four cols: colA=date, colBcolC= text and colD is the currency as text. Each listing consists of several hundreds of events (rows). The problem is that the damn bank -- against all standards -- gives the currency values with a dot (.) as thousand separator and + or - chars (plus or minus) in the right end of each number (e.g. 987,65+, 1.234,56-, 23.456,78+) -- which is against Calc's will. By now I have managed to get LibO/Calc to accept all values less than 9.999,99: first dragged (copied) the table from MSWord = MSExcel; MSExcel-file saved in LibO/Calc as ods in Calc = function TRIM(D5) to get rid of non-printable chars formula (in E5) : removes the separator/dot and the + sign and changes the value from text to number /=VALUE(IF(RIGHT($E4;1)=+;IF(MID($E4;2;1)=.;CONCATENATE(MID($E4;1;1);MID($E4;3;LEN($E4)-3));MID($E4;1;LEN($E4)-1));0))/ formula (in F5): removes the separator/dot and the - sign and changes the value from text to number /=VALUE(IF(RIGHT(//E4//;1)=-;IF(MID(//E4//;2;1)=.;CONCATENATE(MID(//E4//;1;1);MID(//E4//;3;LEN(//E4//)-3));MID(//E4//;1;LEN(//E4//)-1));0))/ copy(dragged) down the 100-300 rows Copy(cols EF) = PasteSpecial to colG:H gives the desired list of incomes and expences separated in their own cols as acceptable numbers _Question:_ What formula/function gives the same result for the bank's currency values bigger than 9.999,99? e.g. 11.222,33+, 11.222.333,44- I have tried to define the . using the Find() - but have had trouble with it when nested in another function/formula (e.g. an IF() function); the definition of it in Calc/Help is obviously at least unclear if not wrong. Cannot get the Fixed() -- when trying to eliminate the separator/dot that way -- working in this 'project' either. Any advice and help is greatly appreciated. Best regards Pertti Rönnberg computer: PC, win7prof/64bit; LO4.0.4.2 -- 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 LibO/Calc problem
I haven't so much tried to answer your question directly, instead I attempted to solve the same problem you did. For me, this gives a simpler answer. Given: Col A: The initial bank value as text Col B: =IF(RIGHT(A1,1)=-,Debit,Credit) Col C: =LEN(A1) Col D: =LEFT(A1,C1-1) Col E: =FIND(,,D1) Col F: =SUBSTITUTE(D1,.,,) Col G: =REPLACE(F1,E1,1,.) Col H: =VALUE(G1) Col I: =IF(B1=Debit, 0-H1, H1) Col A holds the initial value as given by your bank, as text. Col B then looks at the last character of that value, and displays either Debit, if the character was a minus sign, or Credit for anything else. Col C gives the total length of the initial text value Col D gives the initial value stripped of the last character, the plus or minus sign. Col E gives us the position of the comma, so that we can turn it into a period later. Col F gives us the stripped value (from col D) with the periods replaced by commas, for correct thousand separators. Col G gives us the value from col F with the final comma changed to a period, for correct decimal separator. This text string should now be correctly formatted for interpreting as a number. Col H gives us the value from col G interpreted as a number. Col I gives us the final value we want. This is derived from col H, which has the initial value as a number, without the correct plus or minus sign, and we use the value in col B to determine if we should use the number as is, or subtract it from zero to get a negative number. I formatted this column as currency. I tested it with the following: 11.200,33+ == R 11,200.3 2.500.236,65- == R-2,500,236.65 11,25+ == R 11.25 0,96- == R-0.96 If I understand you correctly, this is exactly what you want. No need to mess around with numbers under or over 9.999,99. Of course, you can combine some of those formulas to use less extra cells, but the more you combine stuff, the more complex it becomes, and I don't know where you'd like to draw the line for complexity of formulas vs complexity of page layout, so I leave that part up to you. Hope this helps you out. Paul On Sun, 12 Jan 2014 17:55:17 +0200 Pertti Rönnberg p...@elisanet.fi wrote: Happy New Year Dear LibO experts, Since years back I have copied my bank's digital listing of my bank account(s); first using MSOWord and later on MSOExcel. My intension is to transform these listings so I can calculate with the currency values in LibO-Calc. The bank's table has four cols: colA=date, colBcolC= text and colD is the currency as text. Each listing consists of several hundreds of events (rows). The problem is that the damn bank -- against all standards -- gives the currency values with a dot (.) as thousand separator and + or - chars (plus or minus) in the right end of each number (e.g. 987,65+, 1.234,56-, 23.456,78+) -- which is against Calc's will. By now I have managed to get LibO/Calc to accept all values less than 9.999,99: first dragged (copied) the table from MSWord = MSExcel; MSExcel-file saved in LibO/Calc as ods in Calc = function TRIM(D5) to get rid of non-printable chars formula (in E5) : removes the separator/dot and the + sign and changes the value from text to number /=VALUE(IF(RIGHT($E4;1)=+;IF(MID($E4;2;1)=.;CONCATENATE(MID($E4;1;1);MID($E4;3;LEN($E4)-3));MID($E4;1;LEN($E4)-1));0))/ formula (in F5): removes the separator/dot and the - sign and changes the value from text to number /=VALUE(IF(RIGHT(//E4//;1)=-;IF(MID(//E4//;2;1)=.;CONCATENATE(MID(//E4//;1;1);MID(//E4//;3;LEN(//E4//)-3));MID(//E4//;1;LEN(//E4//)-1));0))/ copy(dragged) down the 100-300 rows Copy(cols EF) = PasteSpecial to colG:H gives the desired list of incomes and expences separated in their own cols as acceptable numbers _Question:_ What formula/function gives the same result for the bank's currency values bigger than 9.999,99? e.g. 11.222,33+, 11.222.333,44- I have tried to define the . using the Find() - but have had trouble with it when nested in another function/formula (e.g. an IF() function); the definition of it in Calc/Help is obviously at least unclear if not wrong. Cannot get the Fixed() -- when trying to eliminate the separator/dot that way -- working in this 'project' either. Any advice and help is greatly appreciated. Best regards Pertti Rönnberg computer: PC, win7prof/64bit; LO4.0.4.2 -- 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] Get spell check to ignore website addresses?
Is there a way to get spell check to ignore website addresses? -- View this message in context: http://nabble.documentfoundation.org/Get-spell-check-to-ignore-website-addresses-tp4091851.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] libreoffice untitled docs constantly autosaving
On 09/01/14 15:36, Tom Davies wrote: Hi :) It might be worth contacting the openSuSE forums to ask in there, http://forums.opensuse.org/ errr, right now their forums are down for maintenance but will probably be up by the time you read this. Jic it isn't this wiki might be more help http://en.opensuse.org/openSUSE:Communication_channels I guess you probably already asked the same question there somewhere. Also it might be worth posting a bug-report in the oepnSuSE bug-tracker regardless of whether you get any replies or not. Regards from Tom :) I have now located a bug report on this issue: https://bugs.freedesktop.org/show_bug.cgi?id=46635 It applies to other distributions besides opensuse. Essentially, if the option in Tools-Option-Load/Save-General is set to 'Automatically save the document too', then untitled/unnamed files will go into a save loop every few seconds. I have submitted a confirmation of the bug report, but cannot at the moment test it out on any version of Windows. Could anyone else check this and update the bug report? John On 9 January 2014 15:26, John King johnmking...@yahoo.co.uk wrote: Opensuse 12,3 both KDE 4.12 (but also occurred with 4.11) and Gnome 3.6.2 Libreoffice 4.1.4.2 (also occured with 4.1.3) This problem does not occur in Kubuntu 13.1, Xubuntu 12.04 , or Windows XP with the same version of Libreoffice. It seems to be specific to Opensuse. If a file is created in writer or calc, but not saved and thereby given a file name, then at the end of the period set in Tools-Option-Load/Save-General for saving autorecovery information (and optionally the document itself), libreoffice saves, and then keeps on saving every 5-10 seconds, with the result that the ~/.config/libreoffice/4-suse/user/backup/ directory builds up a series of untitled -n.odt files. Sometimes, and in particular when both calc and writer are open with untitled files, the saving becomes so frequent that the program is unmanageable and has to be killed. I have tested this with libreoffice on opensuse 12.3 in both KDE and Gnome (separate machines) and confirmed that it happens consistently with both. However, Kubuntu, Xubuntu and Windows XP do not have this problem. Can anyone else confirm this behaviour? John -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] libreoffice untitled docs constantly autosaving
2014/1/12 John King johnmking...@yahoo.co.uk On 09/01/14 15:36, Tom Davies wrote: Hi :) It might be worth contacting the openSuSE forums to ask in there, http://forums.opensuse.org/ errr, right now their forums are down for maintenance but will probably be up by the time you read this. Jic it isn't this wiki might be more help http://en.opensuse.org/openSUSE:Communication_channels I guess you probably already asked the same question there somewhere. Also it might be worth posting a bug-report in the oepnSuSE bug-tracker regardless of whether you get any replies or not. Regards from Tom :) I have now located a bug report on this issue: https://bugs.freedesktop.org/show_bug.cgi?id=46635 It applies to other distributions besides opensuse. Essentially, if the option in Tools-Option-Load/Save-General is set to 'Automatically save the document too', then untitled/unnamed files will go into a save loop every few seconds. I have submitted a confirmation of the bug report, but cannot at the moment test it out on any version of Windows. Could anyone else check this and update the bug report? As a quick test on my current computer (Windows 7 64Bit, LO 4.1.4.2) I did this: - Set autosave to 1 minute - Check the save document too option - Open a new writer document - Type a few words - Wait a minute. It created an untitled_1.odt file in the backup directory, and nothing else - Typed a few more words - After a while, the backup file updated. No extra files where created, and LO doesn't seem to go crazy with I/O either. However I'm not sure that this specific bug report is related. I'll add these informations nonetheless. -- 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] libreoffice untitled docs constantly autosaving
Additionnaly, how did you install LibreOffice on your system? Did you use some distribution-specific repositories, or got it from the Libreoffice website ? Maybe there is something opensuse-specific that cause this. If it doesn't happen with the version downloaded from the website, you'll have to report this issue to the Opensuse folks. -- Cley Faye http://cleyfaye.net 2014/1/12 Cley Faye cleyf...@gmail.com 2014/1/12 John King johnmking...@yahoo.co.uk On 09/01/14 15:36, Tom Davies wrote: Hi :) It might be worth contacting the openSuSE forums to ask in there, http://forums.opensuse.org/ errr, right now their forums are down for maintenance but will probably be up by the time you read this. Jic it isn't this wiki might be more help http://en.opensuse.org/openSUSE:Communication_channels I guess you probably already asked the same question there somewhere. Also it might be worth posting a bug-report in the oepnSuSE bug-tracker regardless of whether you get any replies or not. Regards from Tom :) I have now located a bug report on this issue: https://bugs.freedesktop.org/show_bug.cgi?id=46635 It applies to other distributions besides opensuse. Essentially, if the option in Tools-Option-Load/Save-General is set to 'Automatically save the document too', then untitled/unnamed files will go into a save loop every few seconds. I have submitted a confirmation of the bug report, but cannot at the moment test it out on any version of Windows. Could anyone else check this and update the bug report? As a quick test on my current computer (Windows 7 64Bit, LO 4.1.4.2) I did this: - Set autosave to 1 minute - Check the save document too option - Open a new writer document - Type a few words - Wait a minute. It created an untitled_1.odt file in the backup directory, and nothing else - Typed a few more words - After a while, the backup file updated. No extra files where created, and LO doesn't seem to go crazy with I/O either. However I'm not sure that this specific bug report is related. I'll add these informations nonetheless. -- 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] Default Template
I inadvertently created a Default Template. It arrived very time I opened Writer, so in Manage Templates I deleted it. Now when I open Writer I get the following Message: Users/jt/Library/Application Support/LibreOffice/4/user/template/LettersJT.ott does not exist. It is still calling for the Default Template. How can I stop it? I am using a Mac 10.9.1. and LO 4.2.0.2. Tink. -- View this message in context: http://nabble.documentfoundation.org/Default-Template-tp4091871.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] Import into a Template
I have downloaded a c,s.v file from my Bank and created a Template for the Bank listing. I can load the Bank file into a new Spreadsheet and I then have to reformat it. Why can I not Import it into the Template, or is there another way? Tink. -- View this message in context: http://nabble.documentfoundation.org/Import-into-a-Template-tp4091874.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] Re: libreoffice untitled docs constantly autosaving
On 12-01-2014 20:38, Cley Faye wrote: Additionnaly, how did you install LibreOffice on your system? Did you use some distribution-specific repositories, or got it from the Libreoffice website ? Maybe there is something opensuse-specific that cause this. If it doesn't happen with the version downloaded from the website, you'll have to report this issue to the Opensuse folks. I have an OpenSUSE 12.3 system too, here's some version info. (last patches/updates are installed) I could not reproduce the bug. luuk@opensuse:~/temp cat /etc/os-release NAME=openSUSE VERSION=12.3 (Dartmouth) VERSION_ID=12.3 PRETTY_NAME=openSUSE 12.3 (Dartmouth) (x86_64) ID=opensuse ANSI_COLOR=0;32 CPE_NAME=cpe:/o:opensuse:opensuse:12.3 luuk@opensuse:~/temp ooffice --version LibreOffice 3.6 luuk@opensuse:~/temp zypper info libreoffice | grep -i version Version: 3.6.3.2.4-2.4.1 -- 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] Inserting a row does not change formula
Running LO 3.5.7.2 on Ubuntu 12.04 If I have cells: A1 = 2 A2 = 2 A3 = 2 A4 = =SUM(A1:A3) which equals 6 If I right click on the number 2 to the left of cell A2 to select that row and then insert a row from the popup menu and enter the number 2 in that blank cell, I get: A1 = 2 A2 = 2 A3 = 2 A4 = 2 A5 = =SUM(A1:A4) which equals 8 If instead I right click on the number 4 to the left of cell A4 to select that row and then insert a row from the popup menu and enter the number 2 in that blank cell, I get: A5 = =SUM(A1:A3) which equals 6. If you need to insert a new row in a column of figures, right above the cell where you calculate a total seems to be the natural place to do it. So why doesn't the formula update when you do so? Thanks, Jim -- 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: SOLVED Default Template
I do not know whether this was correct, but I made Writer Untitled 1 my Default Template. Tink. -- View this message in context: http://nabble.documentfoundation.org/Default-Template-tp4091871p4091886.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] Re: Inserting a row does not change formula
Maybe this option can help: Menu/Tools/Options/LibreOffic calc/General - Expand references when new columns/rows are inserted. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Inserting-a-row-does-not-change-formula-tp4091882p4091887.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Import into a Template
Tinkerer wrote: I have downloaded a c,s.v file from my Bank and created a Template for the Bank listing. I can load the Bank file into a new Spreadsheet and I then have to reformat it. Why can I not Import it into the Template, or is there another way? Templates are used to create documents in a standardized way. You're not supposed to write to them. What you should be able to do is create a custom spreadsheet template for that bank info then create a new document and import the data into it. -- 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: Inserting a row does not change formula
On 01/12/2014 03:34 PM, mariosv wrote: Maybe this option can help: Menu/Tools/Options/LibreOffic calc/General - Expand references when new columns/rows are inserted. Miguel Ángel. Thank you, that worked. I'm curious why without that setting I can insert a row in the middle of a column of numbers and it expands correctly, but if I insert at the very top or very bottom row it does not? Regards, Jim -- 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: Import into a Template
James That is exactly what I am trying to do. I open the CSV Template then I go to Insert Sheet from File OK and it creates another sheet either before or after the sheet from the Template. I finish up with a two sheet file, one sheet Formatted and the other sheet with the Bank info. What I want is a straight Import to wherever I have put the cursor. No complicated choices either. Tink -- View this message in context: http://nabble.documentfoundation.org/Import-into-a-Template-tp4091874p4091903.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Inserting a row does not change formula
Hi :) Excel does exactly the same thing. When i show/train people to use spreadsheets i try to get them to make the row above the totals row much smaller so that people leave that row blank. Generally people don't have time for that sort of thing and then have to spend hours trying to work out why their formulas don't work. I've never understood why spreadsheet programs are designed that way. Regards from tom :) On 12 January 2014 21:34, mariosv mari...@miguelangel.mobi wrote: Maybe this option can help: Menu/Tools/Options/LibreOffic calc/General - Expand references when new columns/rows are inserted. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Inserting-a-row-does-not-change-formula-tp4091882p4091887.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Import into a Template
On Sun, 12 Jan 2014 14:52:25 -0800 (PST) Tinkerer j_taylo...@btinternet.com wrote: James That is exactly what I am trying to do. I open the CSV Template then I go to Insert Sheet from File OK and it creates another sheet either before or after the sheet from the Template. Tink, You aren't understanding what James stated. The ONLY purpose of a template is to create a NEW file having the desired characteristics. It should not be written to or it could be damaged and not produce the desired results upon future use. As an example, if you do much writing of program code, you probably use a template in your text editor for the language you are coding in. In that case you select the template to use and the editor creates a NEW text file based upon the template. Same principal. Use the template to create a NEW file and then import the csv data into the NEW file and save it. Tom, moderator snip -- It is curious that physical courage should be so common in the world, and moral courage so rare. - Mark Twain ^^ --... ...-- / -.- --. --... -.-. ..-. -.-. Tom Taylor - retired penguin - KG7CFC AMD Phenom II x4 955 -- 4GB RAM -- 2x1.5TB sata2 openSUSE 13.1_RC2-x86_64 KDE 4.11.12, FF 24.0, claws-mail 3.9.2 registered linux user 263467 -- 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] Default Template
At 11:51 12/01/2014 -0800, J Taylor wrote: I inadvertently created a Default Template. It arrived very time I opened Writer, so in Manage Templates I deleted it. Now when I open Writer I get the following Message: Users/jt/Library/Application Support/LibreOffice/4/user/template/LettersJT.ott does not exist. It is still calling for the Default Template. How can I stop it? I am using a Mac 10.9.1. and LO 4.2.0.2. o In the Template Manager dialog, click the Action Menu icon (on the right). o Go to Reset Default Template | Text Document. This option does not appear unless it is useful, i.e. unless you have set an alternative template as the default. At 13:27 12/01/2014 -0800, J Taylor wrote: I do not know whether this was correct, but I made Writer Untitled 1 my Default Template. That depends on which template was actually used to create Untitled 1. If your alternative template had ben deleted, we can hope that the default Default was used. In any case, now that you have successfully set an alternative template as default, you can reset the original if you wish. I trust this helps. Brian Barker -- 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] Import into a Template
At 12:12 12/01/2014 -0800, J Taylor wrote: I have downloaded a c,s.v file from my Bank and created a Template for the Bank listing. I can load the Bank file into a new Spreadsheet and I then have to reformat it. Why can I not Import it into the Template, or is there another way? At 14:52 12/01/2014 -0800, J Taylor wrote: I open the CSV Template then I go to Insert Sheet from File OK and it creates another sheet either before or after the sheet from the Template. I finish up with a two sheet file, one sheet Formatted and the other sheet with the Bank info. You are nearly there! o Select the complete range of data on the new (unformatted) sheet. o Copy the data. o Paste the data into your empty (formatted) sheet, but using Edit | Paste Special ... (or Ctrl+Shift+V) instead of ordinary Paste. In the Paste Special dialogue, remove the tick from Paste All if necessary and ensure that Formats is *not* ticked. o Delete the imported sheet. What I want is a straight Import to wherever I have put the cursor. No complicated choices either. Only you can decide if this is complicated. I trust this helps. Brian Barker -- 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: Import into a Template
Tinkerer wrote: That is exactly what I am trying to do. I open the CSV Template then I go to Insert Sheet from File OK and it creates another sheet either before or after the sheet from the Template. I finish up with a two sheet file, one sheet Formatted and the other sheet with the Bank info. What I want is a straight Import to wherever I have put the cursor. No complicated choices either. Create your document first from the template, then insert the data. This is the way templates work. For example, I have a standard form that I use to create letters. I started by creating a new document from the default template, made my changes and then saved as my Letter template. Now, when I want to create a letter, I make a new document from that template and go from there. You do not add data to a template, but you can create a new one by creating a document the way you want and then save that as your new template. Then use that template to make a new document. -- 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 LibO/Calc problem
At 17:55 12/01/2014 +0200, Pertti Rönnberg wrote: Since years back I have copied my bank's digital listing of my bank account(s); first using MSOWord and later on MSOExcel. My intention is to transform these listings so I can calculate with the currency values in LibO-Calc. The bank's table has four cols: colA=date, colBcolC= text and colD is the currency as text. Each listing consists of several hundreds of events (rows). The problem is that the damn bank -- against all standards -- gives the currency values with a dot (.) as thousand separator and + or - chars (plus or minus) in the right end of each number (e.g. 987,65+, 1.234,56-, 23.456,78+) -- which is against Calc's will. By now I have managed to get LibO/Calc to accept all values less than 9.999,99: first dragged (copied) the table from MSWord = MSExcel; MSExcel-file saved in LibO/Calc as ods I'm not sure why you want to use Microsoft Word or Excel. You can open a .doc file in LibreOffice (as a text file) and copy and paste the table into a spreadsheet there. You can open an .xls file directly in LibreOffice. If your bank's original data is plain text or web material, you can import this directly into a LibreOffice spreadsheet. _Question:_ What formula/function gives the same result for the bank's currency values bigger than 9.999,99? e.g. 11.222,33+, 11.222.333,44- It's a bit messy, but this should work: =VALUE(RIGHT(Xn;1)SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Xn;.;);+;);-;)) Cannot get the Fixed() -- when trying to eliminate the separator/dot that way -- working in this 'project' either. This is no help. If you already had correctly interpreted numbers (which you don't: that's the problem), FIXED() would convert these to text (with which you then couldn't calculate) - exactly the opposite of what you are trying to do. Once you have your real numbers, you can control their appearance by choosing appropriate cell formats, of course. I trust this helps. Brian Barker -- 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