[libreoffice-users] Re: OpenOffice Spreadsheet LibreOffice Calc
hi rrand, try to deactivate the pre-start-option (?) - with me (unter Win 7 and XP) it works. regards Frank Am 06.04.2011 06:42, schrieb rrand: I am having problems with LibreOffice which will not link cells correctly from one sheet to another, whether they were originally created in OpenOffice or not. On 05/04/11 07:49, Ryan Jendoubi [via Document Foundation Mail Archive] wrote: Hello rrand, On 24/03/11 00:27, rrand wrote: There is a difference in the way these two handle linked cells. If you have a cell linked to another spreadsheet in OpenOffice then if you open it in LibreOffice the value is not automatically updated if it changes/or has changed in the spreadsheet it is linked to. LibreOffice seems to only 'remember' the old value even if you relink the cell. This could pose problems when one wishes to no longer use OpenOffice in favour of LibreOffice as you do not know if any linked values are being updated properly. I've not experienced your problem directly, but I know that in Writer the default settings for updating linked Fields are sometimes not intuitive. Maybe there's a preference you can set somewhere about automatic vs manual updating of links? Bests, -r -- Unsubscribe instructions: E-mail to [hidden email] /user/SendEmail.jtp?type=nodenode=2777174i=0by-user=t Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2777174.html To unsubscribe from OpenOffice Spreadsheet LibreOffice Calc, click here http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=2723166code=cG9zdHJtckBnbWFpbC5jb218MjcyMzE2NnwxNDI2MDQ1MjA0. -- View this message in context: http://nabble.documentfoundation.org/OpenOffice-Spreadsheet-LibreOffice-Calc-tp2723166p2783708.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: A Sort problem...
Am 15.04.2011 01:44, Zed wrote: Using LibreOffice 3.3.1 on LinuxMint Debian Edition (LMDE) I have created a spreadsheet in Calc as a Customer database, which I will save as a CSV file and use to create form letters. The columns are: Firstname, Surname, Street, Town, City, Postcode, Salutation. I originally sorted them Surname, Firstname, Town and got what I expected. However, somehow I have made a complete pigs ear with a subsequent sort, and for the life of me I cannot remember the three fields on which I chose to sort, and the Salutation field is now not aligned with the correct surname. For example, the customer name is Faye Abel and the Salutation should be Dear Faye. However it is Dear Marion! My question is, apart from completely retyping the correct Salutation, is there any sort method by which i can have the correct salutation aligned with the correct surname? Zed Your mail merge is based on a database document which reads the csv files for any text or spreadsheet document. You can use the database interface in the data source window (F4) or mail merge dialog for sorting, filtering and/or picking manually selected row sets. You can also define fixed sort orders and/or filters by means of queries. A query derives a virtual table where the original table data can be shown in any order of rows and columns. Queries are stored in the database and they can be used in the same way the original tables. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: [BASIC]: Timer() function only has resolution of 1 second
Johnny Rosenberg wrote: GetSystemTicks() Ah, ok. Thanks for the suggestion. Johnny Rosenberg wrote: Seems like one tick is one millisecond, at least on my system. The rest is simple math. I suspect it's a little more complicated conversion between ticks and conventional time. I ran a few simple tests, and it looks like there's more to it than just 1 to 1 conversion. But for my application, system ticks should work fine. Thanks again. Regards -- View this message in context: http://nabble.documentfoundation.org/BASIC-Timer-function-only-has-resolution-of-1-second-tp2819804p2824316.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Where do I click?
Hello, I clicked on Download and now I have all these options so I clicked on English Help Pack which loaded fine. But it does not help me download libreoffice. Is there a simple button anywhere that I can click on that leads me through your download procedure. I do not mean to sound like some MS junkie but I am use to clicking and then being led to the next page and so on. Robison2009 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Where do I click?
Hi Bill, Bill Robison wrote (15-04-11 20:22) I clicked on Download and now I have all these options so I clicked on English Help Pack which loaded fine. But it does not help me download libreoffice. Pls find the file with install in the name :-) Best, Cor -- - http://nl.libreoffice.org - giving openoffice.org its foundation :: The Document Foundation - -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Font display in LibreOffice documents
Hello, being an extensive user of LibO rather than iWorks or MSO on my Mac (OS X 10.6.6), the (only) one thing that tempers delight is the blurred unsharp display of text in documents. Currently, I am writing rather long reports for my work, and I employed Latin Modern Roman (version 2 or so) 11pt as the main document text. (I was playing around with many more fonts, just to mention.) However, whatever font size, document zoom or user interface zoom I use, the only one usable fonts are the ones from the DejaVue font family -- yet, also here the display is far away from a clean sharp display as I can find in Pages or MSW. I was just wondering whether there is upcoming development on that issue (obviously only a Mac one), or if there is simple tricks to make fonts display clear, sharp, and reader-friendly. Thanks for comments and tipps. Bests, *S* -- Sascha Vieweg, saschav...@gmail.com -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Where do I click?
On Fri, 2011-04-15 at 11:22 -0700, Bill Robison wrote: Hello, I clicked on Download and now I have all these options so I clicked on English Help Pack which loaded fine. But it does not help me download libreoffice. Is there a simple button anywhere that I can click on that leads me through your download procedure. I do not mean to sound like some MS junkie but I am use to clicking and then being led to the next page and so on. Robison2009 Bill When I tried the download a few minutes ago I got the page which guessed which OS version I wanted. If the box does not say Windows, change it to Windows. After the page resets, click on LibO_3.3.2_Win_x86_install_multi.exe (this is not a link), which has a size of 214 MB for Windows. I was making sure there were no other problems with the page. LibreOffice has versions for Mac and Linux OSs. The actual link for the Windows version is http://download.documentfoundation.org/libreoffice/stable/3.3.2/win/x86/LibO_3.3.2_Win_x86_install_multi.exe If the above link does not work, try copying it to your browser -- Jay Lozier jsloz...@gmail.com -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] 3.4Beta loading error - Ubuntu
Running ubuntu 10.10. Uninstalled libreoffice 3.3. Downloaded the new 3.4 beta US debs. Installed Lib0_3.4 and the Lib0_ure files and now when I try to launch libreoffice from the command line I get: /opt/libreoffice/program/oosplash.bin: symbol lookup error: /opt/libreoffice/program/oosplash.bin: undefined symbol: sal_detail_initialize, version PRIVATE_1.1 Any Ideas? -- View this message in context: http://nabble.documentfoundation.org/3-4Beta-loading-error-Ubuntu-tp2825770p2825770.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Base - can't find TEXT[VARCHAR_IGNORECASE]
Hi, I can't find the field type TEXT[VARCHAR_IGNORECASE] in LibreOffice. Is that type not present in LibreOffice ? Cheers Alex -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Font display in LibreOffice documents
On 11-04-15 22:27, Ken Springer wrote: On 4/15/11 1:06 PM, Sascha Vieweg wrote: Hello, being an extensive user of LibO rather than iWorks or MSO on my Mac (OS X 10.6.6), the (only) one thing that tempers delight is the blurred unsharp display of text in documents. Currently, I am writing rather long reports for my work, and I employed Latin Modern Roman (version 2 or so) 11pt as the main document text. (I was playing around with many more fonts, just to mention.) However, whatever font size, document zoom or user interface zoom I use, the only one usable fonts are the ones from the DejaVue font family -- yet, also here the display is far away from a clean sharp display as I can find in Pages or MSW. I was just wondering whether there is upcoming development on that issue (obviously only a Mac one), or if there is simple tricks to make fonts display clear, sharp, and reader-friendly. Thanks for comments and tipps. Bests, *S* I was going to try your font here, iMac with 10.6.7, but I don't have it on my system. Is it a free font that can be downloaded from somewhere? If I did download, it would have to the exact same file as you are using. Side by side, the LO blank page seems to be slightly grayish, where the Pages is white. That may account for some of the difference. I used Times Roman, 11 point, and couldn't tell any real difference. From a cynical point of view, be glad you are not using Windows. LOL They used to have a lousy screen display, I don't know why. I had older computers and operating systems that far exceeded the Windows display. I haven't paid enough attention lately to know if they've solved that issue or not. You can download the bundle of Latin Modern Fonts at: http://www.gust.org.pl/projects/e-foundry/latin-modern There is a Wiki on DejaVu Fonts, here: http://dejavu-fonts.org/wiki/Main_Page However, both font families were installed on my system, I guess, Latin Modern through MacTeX and DejaVu through LibO. *S* -- Sascha Vieweg, saschav...@gmail.com -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Font display in LibreOffice documents
On 16/04/11 9:43 AM, Sascha Vieweg wrote: On 11-04-15 22:27, Ken Springer wrote: On 4/15/11 1:06 PM, Sascha Vieweg wrote: Hello, being an extensive user of LibO rather than iWorks or MSO on my Mac (OS X 10.6.6), the (only) one thing that tempers delight is the blurred unsharp display of text in documents. Currently, I am writing rather long reports for my work, and I employed Latin Modern Roman (version 2 or so) 11pt as the main document text. (I was playing around with many more fonts, just to mention.) However, whatever font size, document zoom or user interface zoom I use, the only one usable fonts are the ones from the DejaVue font family -- yet, also here the display is far away from a clean sharp display as I can find in Pages or MSW. I was just wondering whether there is upcoming development on that issue (obviously only a Mac one), or if there is simple tricks to make fonts display clear, sharp, and reader-friendly. Thanks for comments and tipps. Bests, *S* I was going to try your font here, iMac with 10.6.7, but I don't have it on my system. Is it a free font that can be downloaded from somewhere? If I did download, it would have to the exact same file as you are using. Side by side, the LO blank page seems to be slightly grayish, where the Pages is white. That may account for some of the difference. I used Times Roman, 11 point, and couldn't tell any real difference. From a cynical point of view, be glad you are not using Windows. LOL They used to have a lousy screen display, I don't know why. I had older computers and operating systems that far exceeded the Windows display. I haven't paid enough attention lately to know if they've solved that issue or not. You can download the bundle of Latin Modern Fonts at: http://www.gust.org.pl/projects/e-foundry/latin-modern There is a Wiki on DejaVu Fonts, here: http://dejavu-fonts.org/wiki/Main_Page However, both font families were installed on my system, I guess, Latin Modern through MacTeX and DejaVu through LibO. I have a macbook pro 13, 10.6.7, and all my fonts are sharp in LO 3.3.2, even on the small screen. Can you use the application Grab to provide an illustration of the blurred text. Have you got Use LCD font smoothing.. ticked under System PreferencesAppearance steve -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Ellison's Oracle washes hands of OpenOffice
http://www.theregister.co.uk/2011/04/15/oracle_letting_openoffice_go/ Oracle is turning OpenOffice into a purely community project, and no longer plans to offer a commercial version of the collaboration suite loved by many. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Font display in LibreOffice documents
On 2011/04/15 1:06 PM Sascha Vieweg wrote: Hello, being an extensive user of LibO rather than iWorks or MSO on my Mac (OS X 10.6.6), the (only) one thing that tempers delight is the blurred unsharp display of text in documents. Currently, I am writing rather long reports for my work, and I employed Latin Modern Roman (version 2 or so) 11pt as the main document text. (I was playing around with many more fonts, just to mention.) However, whatever font size, document zoom or user interface zoom I use, the only one usable fonts are the ones from the DejaVue font family -- yet, also here the display is far away from a clean sharp display as I can find in Pages or MSW. I was just wondering whether there is upcoming development on that issue (obviously only a Mac one), or if there is simple tricks to make fonts display clear, sharp, and reader-friendly. Thanks for comments and tipps. Bests, *S* Fonts appear sharp in LibO on my 13 MacBook (OS X version 10.6.7) and on my 24 Samsung external monitor. I see no difference in sharpness between LibO and Pages. Larry -- _ Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Font display in LibreOffice documents
Hi, Steve, Thanks for the info, please see below... On 4/15/11 9:20 PM, Steve Edmonds wrote: On 16/04/11 12:57, Ken Springer wrote: On 4/15/11 3:43 PM, Sascha Vieweg wrote: You can download the bundle of Latin Modern Fonts at: http://www.gust.org.pl/projects/e-foundry/latin-modern There is a Wiki on DejaVu Fonts, here: http://dejavu-fonts.org/wiki/Main_Page However, both font families were installed on my system, I guess, Latin Modern through MacTeX and DejaVu through LibO. A roadblock here... The Latin-Modern fonts are Postscript, and I don't know how to handle them on a Mac. In my Windows days, it wouldn't be a problem. Any idea how to deal with it to save me some time in Googling all over the world? :-) The Deja-Vu is something else all together. :-( I've downloaded both the zip and tar.bz2 files, and get nowhere. Attempting to open them just takes me in some kind of loop from one compressed file format to another and back. Even tried opening the zip file in Windows using WinRAR, and it says the compressed file has nothing in it. Any thoughts? I thought the Latin-Modern to select should be the OTF fonts. 72 of them. These should install to the mac in one of 2 ways. http://www.myfonts.com/support/help_install_mac.html http://www.switchingtomac.com/tutorials/how-to-install-fonts-in-os-x/ Two things, I didn't remember that OTF stood for Open Type Fonts, and I didn't know that OS X supported OTF and Postscript fonts. But I did know that System 9 could be used, so it was my assumption that Postscript was the format I needed to install. It's been over 10 years since I actively dealt with different font formats. I just went with whatever fonts were installed on my system. I'll try those out tomorrow afternoon. My interest in really digging into a particular OS to find out what can actually be done with an OS has been dormant for a number of years. I just wanted to turn the darn thing on and use it with no problems. But of late, I've burned a couple Linux Live CD's to see what that hullabaloo is all about, the the visual appearance of some of them have resparked that interest! :-) I like to actually use a computer, I really could care less about the programming and hardware end of the package. I just downloaded *2.33/dejavu-fonts-ttf-2.33.zip http://sourceforge.net/projects/dejavu/files/dejavu/2.33/dejavu-fonts-ttf-2.33.zip *from the link, unzipped it and the fonts were there*. steve * I found the problem, although I have no explanation as to why this happens. And... I've never had it happen before... A lot of pages/links for downloading end up opening a blank tab in your browser when you left click on it. So, by habit at my end, I right click and select Save Link As so I don't end up with an Untitled and empty tab. And I end up with the screwed up zip file. I even tried it again after reading your post. FF 3.6.16, haven't taken the FF 4 plunge yet. But... If I left click on the link, either yours or the one you can get to by following Sascha's link, the zip file downloads and extracts as it should. I have *no* explanation as to why. Ken -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] LibreOffice 3.4 beta1 -warning-
Intel Mac 10.5.8. Removed all LO previous copies, downloaded twice. At start, will launch, but quits unexpectedly before Write screen appears. Looks like something is wrong. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LibreOffice 3.4 beta1 -warning-
Hi, On Sat, Apr 16, 2011 at 06:36, David Nuddleman wrote: Intel Mac 10.5.8. Removed all LO previous copies, downloaded twice. At start, will launch, but quits unexpectedly before Write screen appears. Looks like something is wrong. Yes. Some bug reports regarding LibO 3.4 beta1: Bug 36263 - No icons in user interface https://bugs.freedesktop.org/show_bug.cgi?id=36263 Bug 36267 - LO3.4 - Crash on run Mac OS X https://bugs.freedesktop.org/show_bug.cgi?id=36267 Bug 36271 - LO 3.4 Writer Won't Open https://bugs.freedesktop.org/show_bug.cgi?id=36271 Bug 36275 - LibO 3.4b1 fails to start with symbol lookup error https://bugs.freedesktop.org/show_bug.cgi?id=36275 Bug 36277 - desktop-integration package use wrong version (3.3 instead of 3.4) - productversion.mk not updated https://bugs.freedesktop.org/show_bug.cgi?id=36277 Bug 36284 - LibO 3.4 beta1 - Error saving a document https://bugs.freedesktop.org/show_bug.cgi?id=36284 Bug 36285 - LibO 3.4 beta1 – No available language modules, spell check is impossible https://bugs.freedesktop.org/show_bug.cgi?id=36285 -- Ellison's Oracle washes hands of OpenOffice http://www.theregister.co.uk/2011/04/15/oracle_letting_openoffice_go/ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted