Re: [libreoffice-users] Problem with LibreOffice-text won't stay put

2012-03-14 Thread Steve Edmonds
On 2012-03-15 14:13, Wanda Moore wrote: I have scoured the site to find where I can ask a question, but I couldn't find it. ( I tried the mailing list, but I got about 100 emails within a couple days, and all repeating over and over. ) I have Mac OS X and have been trying to use LibreOffice f

Re: [libreoffice-users] Re: Calc changes cells with . to 0

2012-03-14 Thread Andrew Koeser
Thanks for lead with the quotes. It looks like the problem was two fold. When exporting to text, I needed to select the check box "quote all text cells". Upon opening the .csv file, I needed to click the "quoted field as text" box in the text import prompt. New question. When I selected the

Re: [libreoffice-users] Generic formulas or inverse scenarii

2012-03-14 Thread Jay Lozier
On 03/14/2012 06:49 PM, Ninj wrote: In fact, i thought of possible solution after i submitted this question. Is there a way to link cells between sheets in a way that they are "virtually the same"? Changing B4 in a sheet would change also B4 in other sheets where B4 is linked. If cell B4 is on

[libreoffice-users] Problem with LibreOffice-text won't stay put

2012-03-14 Thread Wanda Moore
I have scoured the site to find where I can ask a question, but I couldn't find it. ( I tried the mailing list, but I got about 100 emails within a couple days, and all repeating over and over. ) I have Mac OS X and have been trying to use LibreOffice for a year at least. I can't find out why th

Re: [libreoffice-users] Re: standard.dic?

2012-03-14 Thread webmaster for Kracked Press Productions
I use to have a software that could do a find/replace for non-printable characters. I turned on the non-printable characters and copied the characters I wanted into the replace and took the "gray box" style of character. Then I did a "global" find/replace for the document. I have not don

[libreoffice-users] Re: standard.dic?

2012-03-14 Thread john.egger
OS: Kubuntu Maverick Format: Yes, opening the OOo standard.dic in Kate shows a WBSWG6 at the start. I tried opening the dic in a Calc spreadsheet, with tab and space delimiters; that got each word into one cell. I then rearranging then in one column and saved it as a txt file. Then, when opened in

Re: [libreoffice-users] Generic formulas or inverse scenarii

2012-03-14 Thread Tom Davies
Hi :) I have attached a simplistic and rather horrible example.  The mailing list wont get the attachment but Ninj should.  A lot of finesse is possible!  For example, getting rid of the 0's. Regards from Tom :) --- On Wed, 14/3/12, Ninj wrote: From: Ninj Subject: Re: [libreoffice-users] Gene

[libreoffice-users] Re: Calc changes cells with . to 0

2012-03-14 Thread Andreas Säger
Am 14.03.2012 23:40, Andrew Koeser wrote: Hey everyone, I notice that Calc will sometimes change the value of a cell from a period to a zero. I notice it mostly when I save from .ods to csv. This is an issue, as one of the stats software programs I use denotes missing data with a "." Is there a

Re: [libreoffice-users] standard.dic?

2012-03-14 Thread Manfred J. Krause
Hi, On Wed, Mar 14, 2012 at 9:04 PM, john.egger wrote: > When I copied the ~10 Kbyte standard.dic from my old StarOffice8 into > OpenOffice3.2, it worked fine. Examination of the dictionary > (Tools/Options/Language Settings/Writing Aids, select Standard and choose > Edit) shows each word on its o

Re: [libreoffice-users] Generic formulas or inverse scenarii

2012-03-14 Thread Ninj
In fact, i thought of possible solution after i submitted this question. Is there a way to link cells between sheets in a way that they are "virtually the same"? Changing B4 in a sheet would change also B4 in other sheets where B4 is linked. Because my problem is not more complicated than that

Re: [libreoffice-users] Re: calc: how to label columns

2012-03-14 Thread Tom Davies
Hi :) Try having a look at a print-preview.  The headings do not appear.  I think a lot of people put their own headings in row 1 and then maybe colour the background to suite.  Regards from Tom :) --- On Wed, 14/3/12, Andreas Säger wrote: From: Andreas Säger Subject: [libreoffice-users] Re

[libreoffice-users] Re: standard.dic?

2012-03-14 Thread john.egger
You're right, kracked... in Kate there are rectangular boxes (taller than their width) between the run-together words. But I can't figure out how to replace them with carriage returns. I got the old dictionary to open without the boxes, but with just spaces between the words (not returns). I hope

[libreoffice-users] Calc changes cells with . to 0

2012-03-14 Thread Andrew Koeser
Hey everyone, I notice that Calc will sometimes change the value of a cell from a period to a zero. I notice it mostly when I save from .ods to csv. This is an issue, as one of the stats software programs I use denotes missing data with a "." Is there an auto-correct setting that I can chang

[libreoffice-users] Re: calc: how to label columns

2012-03-14 Thread Andreas Säger
Am 14.03.2012 20:04, matias kaukonen wrote: Hi all, I would like to assign labels to each of my columns and have them appear instead of A, B, C, ... Does calc support this feature? I searched the help but I did not find the instructions. What do you suggest? thanks. m like 90% of today's sp

[libreoffice-users] Generic formulas or inverse scenarii

2012-03-14 Thread Ninj
Hi, I wonder if Calc can help in my case: I'm writing a financial forecast for my company. We sell 3 kinds of products. But they all use the same scheme when it comes to computing fees and incomes. So i made one (big) table with all the computation process and the comments (it has to be shown

Re: [libreoffice-users] calc: how to label columns

2012-03-14 Thread MiguelAngel
El 14/03/12 20:04, matias kaukonen escribió: Hi all, I would like to assign labels to each of my columns and have them appear instead of A, B, C, ... Does calc support this feature? I searched the help but I did not find the instructions. What do you suggest? thanks. m As I know not, but if

Re: [libreoffice-users] standard.dic?

2012-03-14 Thread webmaster for Kracked Press Productions
Try this, use a text editor, like Kate [KDE] or some other one that is only a text editor. If it is read as a one word per line, then save it as a .txt file - maybe Text [encoded] .txt file. That should make sure the file keeps a single word per line file. Then just rename it back to a .d

Re: [libreoffice-users] Differences between LibreOffice and OpenOffice

2012-03-14 Thread Tom Davies
Hi :) I thought it was a neat summary of the differences between LO and OOo.  It might need a bit of re-working if you want to use it is an intro to your page.  It's not exactly Wordsworth tho so i wouldn't create a whole new page for it!  I think a very very brief intro is the main thing that i

Re: [libreoffice-users] Print range not always loading

2012-03-14 Thread Tom Davies
Hi :) You might find the 3.4.5 is better http://www.libreoffice.org/download/?type=win-x86&lang=en-US&version=3.4.5 If you want the English (UK) version then just change the US to GB in that link.  Quite a few other languages are available too. We generally have 2 branches being developed at the

[libreoffice-users] standard.dic?

2012-03-14 Thread john.egger
When I copied the ~10 Kbyte standard.dic from my old StarOffice8 into OpenOffice3.2, it worked fine. Examination of the dictionary (Tools/Options/Language Settings/Writing Aids, select Standard and choose Edit) shows each word on its own line. When I copied it into LibreOffice, however, words were

[libreoffice-users] Print range not always loading

2012-03-14 Thread Ron Gregor
I am trying to switch from Open Office 3.3 to Libre Office 3.5 but I am having problems with my print ranges. All files work well in Open Office 3.3. In Libre Office when we first open the files most don't show any print range in use. When we go to Format>Print ranges the Remove is grayed out

Re: [libreoffice-users] Differences between LibreOffice and OpenOffice

2012-03-14 Thread Dotan Cohen
On Tue, Mar 13, 2012 at 17:00, Tom Davies wrote: > Hi :) > I think it's probably worth just saying that OpenOffice develops a lot more > slowly and is therefore "more stable".  Bugs go unfixed for longer. > Hi there! I have noticed the difference in the pace of development. LibreOffice fixed my

Re: [libreoffice-users] Differences between LibreOffice and OpenOffice

2012-03-14 Thread Dotan Cohen
On Tue, Mar 13, 2012 at 15:41, Nino Novak wrote: > LibreOffice has received plenty of code patches since forking. New features > are listed in [1,2,3]. But take care to make a difference between changes > restricted to LibreOffice itself and features "inherited" from "upstream" > OOo/AOO code chan

[libreoffice-users] calc: how to label columns

2012-03-14 Thread matias kaukonen
Hi all, I would like to assign labels to each of my columns and have them appear instead of A, B, C, ... Does calc support this feature? I searched the help but I did not find the instructions. What do you suggest? thanks. m -- For unsubscribe instructions e-mail to: users+h...@global.libreoff

Re: [libreoffice-users] Can't install LibreOffice

2012-03-14 Thread Regina Henschel
Hi Frank, Frank Bonar schrieb: I have downloaded LibO_3.5.0_Win_x86_install_multi(2).msi, but installation fails. After I give User Account Control permission to install, the Install Wizard opens, showing a progress bar, and saying installation may take several minutes. The progress bar rema

Re: [libreoffice-users] Re: Can't install LibreOffice

2012-03-14 Thread Tom Davies
Hi :) I am not sure what antivirus Frank uses but i do remember him mentioning that he had solved the problem on his machine.  I'm not sure how he solved it.  He doesn't have an on-all-the-time-broadband connection and doesn't have much time to stop and chat when he is connected but he did say a

Re: [libreoffice-users] Can't openi odt Files

2012-03-14 Thread Tom Davies
Hi :) Errr, can you try re-install LibreOffice?  Does i offer a "Repair" option?  During install i seem to remember if you want LO to be the default app that opens documents that are in the MS format but i can't remember it asking about native formats.  I thought it just does it, well most of th

Re: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress

2012-03-14 Thread Tom Davies
Hi :) They all left.  The people that are using the system are not the ones that set it up.  I think part of the idea was that we would have to pay the previous people a consultancy fee in order to do fairly normal stuff.  Now it's my turn to create even more confusion by creating forms that are

Re: [libreoffice-users] Differences between LibreOffice and OpenOffice

2012-03-14 Thread jorge
Hi: I think it is a good and necesary job for users to know about and take the best option but with knowledge. And this summary could show how LO has been improved. Regards, Jorge Rodríguez El mar, 13-03-2012 a las 13:52 +0200, Dotan Cohen escribió: > There is a discussion on

Re: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress

2012-03-14 Thread drew jensen
On Wed, 2012-03-14 at 13:12 +, Tom Davies wrote: > Hi :) > Ahhhah. Right. Ok, so it sounds as though i could at least give it a go and > see what it looks like. So far i have been a bit scared of even trying. > > So, first step for me is to back-up the Access file and see if i can get Ba

Re: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress

2012-03-14 Thread Tom Davies
Hi :) Ahhhah.  Right.  Ok, so it sounds as though i could at least give it a go and see what it looks like.  So far i have been a bit scared of even trying.  So, first step for me is to back-up the Access file and see if i can get Base working with that.  The Access we have at work is a mess of

Re: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress

2012-03-14 Thread drew jensen
On Wed, 2012-03-14 at 12:49 +, Tom Davies wrote: > Hi :) > So Base can't update Accesses internal tables? That is NOT what I said. What I said was, that when connecting to an MS Access file the users need to be mindful of the fact that queries in the Access file will appear to them to be tabl

Re: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress

2012-03-14 Thread Tom Davies
Hi :) So Base can't update Accesses internal tables? Regards from Tom :) --- On Wed, 14/3/12, drew jensen wrote: From: drew jensen Subject: [libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress To: documentat...@global.libreoffice.org Cc: users@global.libreoffic

[libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress

2012-03-14 Thread drew jensen
On Wed, 2012-03-14 at 11:59 +, Tom Davies wrote: > Hi :) > Ok, so when migrating from Access to Base would it be best to first export > the Access tables into a different database program and then get Access to > read those tables? No. I referred to situations where Base is updating ms-jet

[libreoffice-users] Re: [libreoffice-documentation] Chapter 2 of Base Guide progress

2012-03-14 Thread Tom Davies
Hi :) Ok, so when migrating from Access to Base would it be best to first export the Access tables into a different database program and then get Access to read those tables?  Would that mean re-writing Access's Reports and Forms that are based on the tables? Regards from Tom :) --- On Wed,

Re: [libreoffice-users] Can't openi odt Files

2012-03-14 Thread Tom Davies
Hi :) If swriter or LibreOffice is not in the list then another route is to open LibreOffice from the "Start" button - "All Programs" - LibreOffice - Writer Then drag&drop an odt into the open window or use File - Open and then save the file again.  Something in that seemed to remind Xp that i ha

Re: [libreoffice-users] Can't openi odt Files

2012-03-14 Thread Gordon Burgess-Parker
On 13/03/2012 21:54, Bernie Doran wrote: I uninstalled Open Office and then installed LO 3.4. Now my computer (running XP) tells me it can't open any .odt files, and to make an association in Folder Options, Control Panel. I have tried unsuccessfully to do this. I cannot find LO listed unde