[libreoffice-users] Re: Adding values to CSV File via Terminal
Le 11/04/2013 02:47, Joel Madero a écrit : Hi Joel, A quick trawl reveals several possibilities : http://stackoverflow.com/questions/4749658/inserting-filename-into-last-column-of-csv-file http://stackoverflow.com/questions/9506810/add-column-to-end-of-csv-file-using-awk-in-bash-script http://www.unix.com/shell-programming-scripting/213419-add-extra-column-csv-file.html etc Alex -- 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] pasting numbers into Calc
Replace does work for these. Found this on the web many moons ago. How to convert numeric text to number by re-entering everything in one step. Select the cells in question. Apply any number format other than @ (text) menu:FindReplace... [More Options...] [X] Current Selection [X] Regular expression Search: .+ (a dot and a plus) Replace: [Replace All] On Thursday 11 Apr 2013 04:42:15 Brian Barker wrote: At 23:36 10/04/2013 +, Herbert Fruchtl wrote: This question seems to have been discussed before, but none of the replies I understand work for me. So what have you tried, in fact? If I copy a column-based piece of text, containing numbers in some columns, into LibreOffie Calc and apply the (hopefully) correct text-to-column delimiters, ... I'm not sure what you mean here. What are delimiters? Do you mean that you have, say, quote marks around your data? Is this perhaps a .CSV file? ... all columns (including the numbers) are interpreted as text. Then you presumably don't have this part correct, in fact! On closer inspection I find that at the start of each number there is a single quote (invisible in Calc, but I can delete it with backspace, and then the number is recognized as such). That leading single quote does not really exist in the cell; instead it appears in the Input Line to show that what appears to be a number is actually being stored in the cell as a text string - exactly what you don't want. You will also notice that, by default, the numbers-as-text are left aligned, whereas true numbers are right-aligned. Doing it manually cell by cell is the only way that works. No, there is a better method: read on! Paste special as number or as text doesn't work. You cannot Paste Special *as* anything; you can select only *what* you paste. If, as here, you have text, you can use Paste Special to select whether or not you paste it somewhere else, but not to change it to numbers. Search and replace doesn't work (or I do it wrong). That's right: the quote marks are not really there in the cell, so you cannot search for them. I have used OpenOffice and derivatives for years, but this one stumps me. Any ideas? Yes. But what works will depend on exactly what is going wrong for you. o Are the relevant destination cells already formatted as Text before you paste in the material? Ensure that they are formatted as General or Number instead. o When you paste the material in, do you see the Text Import panel? Can you tinker with the options there to achieve what you need? In particular, does Merge delimiters help? What are the column types indicated in the panel at the bottom of the panel? You can click each column and then adjust the column type using the drop-down menu. You probably need Standard, not Text. o In any case, you can solve the problem with your incorrect data. Suppose your data is in column A. In row 1 of a spare column, enter =VALUE(A1) and fill this formula down the column (and possibly across columns). The VALUE() function should take your text strings and convert them to true numbers. Now copy the data from the new column(s) and paste it back over the original data, 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 then ensure that Numbers is ticked but Formulas is not ticked. (Note that freezing the result of a formula into a plain value in this way is something you *can* do using Paste Special... .) I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Adding values to CSV File via Terminal
On 2013-04-11 18:17, Alex Thurgood wrote:
Le 11/04/2013 02:47, Joel Madero a écrit :
Hi Joel,
A quick trawl reveals several possibilities :
http://stackoverflow.com/questions/4749658/inserting-filename-into-last-column-of-csv-file
http://stackoverflow.com/questions/9506810/add-column-to-end-of-csv-file-using-awk-in-bash-script
http://www.unix.com/shell-programming-scripting/213419-add-extra-column-csv-file.html
etc
Alex
Hi Alex.
First example implements easily.
Converts all files with extension .csv
Not sure if the OP wants to append 2012_01_02.csv or just 2012_01_02
Assuming the latter, the following worked for me in a bash file. Copy
the files to a new directory for conversion as the files will be
altered, new files are not created. These strip the .csv.
#!/bin/bash
for file in *.csv; do
file1=${file%.*}
sed -i s/$/,$file1/ $file
done
For tab separated files
for file in *.csv; do
file1=${file%.*}
sed -i s/$/\t$file1/ $file
done
Steve
--
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] [SOLVED] Using a Button to activate Subform.
Hi All As Noel suggested here is the reply I sent to him after we had worked on the problem for a while off-list ... *I have cracked the problem*!! - I now have my Form working fine, (except for it's position on the screen - but that's a cosmetic!!). I went through what you last sent me and just got the same old error messages!! So I dropped back to my old favorite 'Google' and came across a video Tutorial by a guy called *Shane Piper* in the UK, (who I have corresponded with in the past). He has a great Tutorial on this subject - http://www.youtube.com/watch?v=9Zmd-zidIvg - and basically he is saying that all you need is the following ... /sub OpenForm// //const sNewDocumentName=NameOfYourForm// //oNewFormDocument=ThisDatabaseDocument.FormDocuments.getbyname(sNewDocumentName).open// //end sub/ I checked this on a couple of other sites and it was confirmed so I gave it a try ... Nothing happened!!! (??) No error messages accept if I tried a couple of clicks I got the 'sun.AnExceptionHas Occured' error. I messed around with this a bit with no change and then had a brain wave!!! Maybe you need the full path? - So I changed the first line to .. /const sNewDocumentName=NameOfDataBase.NameOfYourForm// / And as I have said *IT WORKS*!! Hope this will be of use to others. IanW Pretoria RSA -- 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] Just a new Easy Hack I think
https://bugs.freedesktop.org/show_bug.cgi?id=63432 FORMATTING: Change Case does not work in some situations when symbols appear Hi, I like the beauty of LibreOffice because many people can change it if they want to. I do not have enough programming skills but someone else may look into this potential Easy Hack. Thanks. Regards, C. H. D. LibreOffice User _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- 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] Printing speed is glacial for large file
Have you attempted anything in particular to see if it allows for a speed improvement? For example: 1. Check on memory usage. How high is it? Are you running out of memory? 2. Change graphics settings: Tools Options LibreOffice Memory Then try increasing the memory for things such as graphics objects and number of objects? On 04/11/2013 01:59 PM, David Ronis wrote: Hi Girvin, Most of the graphics in the document are PDF pages that I've imported into Draw and then cut and pasted them into an odt file, which in turn is incorporated into the full document as laid out in the odm file. Also normal scrolling of the odm document is horrendously slow as well (minutes to scroll to the next page and redraw). David -Original Message- From: Girvin Herr girvin.h...@sbcglobal.net To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Printing speed is glacial for large file Date: Thu, 11 Apr 2013 10:21:16 -0700 On 04/10/2013 03:13 PM, David Ronis wrote: I have a project managed by an odm file that ends up being ca 1600 pages long and contains several OLE objects, many graphics (some comprising entire pages that started out as PDFs). I find LO unbelievably slow (even on such simple things as refreshing the window after remapping it). I've turned of recording/displaying changes, upped the graphics cache numbers, set the swap directory to a ram disk, and turned off all to-disk swapping; nothing helps. This is on a 2 CPU machine with gig's of ram. I'm currently trying to print the project to a file (postscript format). This takes 4-6 hours, with 1 of the CPU's running at 100% [BTW is LO multi-threaded?]. The resulting postscript file is big, (about 350M) but not that big. I'm on a Slackware Linux box. Any suggestions? David David, There is a known problem with LO and Encapsulated PostScript (EPS) graphics. They slow down video rendering tremendously, causing frustrating long scrolling time. This may also cause a problem with printing, I never tried it. When I converted my document's EPS images to JPEG, LO rendering/scrolling sped up tremendously. Hope this helps. (Fellow Slacker.) Girvin Herr -- 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
