[libreoffice-users] Re: helping Users and LibreOffice - proposal

Hi Cour (none of the following criticisms are directed at you, who are one of the few (only?) members of the SC who sees this project as a productivity tool for the users) I don't know if you are aware that installing LibO 3.4.0 under Windows silently uninstalls 3.3 without asking (even if the ins

[libreoffice-users] Re: hide white space

A quick Google search provides the answer http://office.microsoft.com/en-us/word-help/show-or-hide-white-space-in-print-layout-view-HP003072013.aspx http://support.microsoft.com/kb/297564 Does anyone know if this feature exists in LO? If not a feature request could be added ;) -- View this messa

[libreoffice-users] Re: Re: Re: SVG embedding in LibreOffice

I just inserted the arrow.svg into a ODS using OOo 3.4 Beta. The interesting results are: 1) Opening the ODS in LibreOffice shows the blur (while if I insert the svg in LO it won't) 2) Exporting to PDF has higher quality in LO than OOo -- View this message in context: http://nabble.documentfound

[libreoffice-users] Release dates/versions

Can someone explain why the latest daily build is named libreoffice-3-4~2011-06-07_11.47.03_LibO_3.4.0rc1_Win_x86_install_multi.exe ? This was compiled yesterday but it is still named 3.4.0rc1? Build 3.4.0 final was announced on June 3rd while the files are dated from May 26th (because the fina

[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

Hi Stephan I will test this one later. With don't you simply name the range "Jack"? It's much easier to use and modify ;) I think that there is no need to know the second, third, etc text celss. You only need to know the first error to go there and fix it. One error at a time :) Thanks! -- View

[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

Hi Jack Jack wrote: > > See the formula in cell C2. Let me know whether or not you succeed. > It does work perfectly. In fact the formula was already working on my spreadsheet (after I used your array trick). I thought something was wrong because when I replaced all the text cells with values

[libreoffice-users] Re: LibreOffice Manager disc usage

>From my experience and from reports here at the Users list, the MS filters are much more stable in version 3.3.x If you want to test a new version I would recommend 3.3.3RC1 (Go to Download, Pre-Releases on the libreoffice.org site) -- View this message in context: http://nabble.documentfounda

[libreoffice-users] Re: A huge bug in Calc (writting/reading xls files)

Hi Ismael You can't attach files to this mailing list. You have to upload the files somewhere and post the link here. LibreOffice 3.4.0 was released on June 3rd. But if someone manages to fix the bug you are reporting it will be incorporated in a future release (3.4.1, 3.5.0,etc ) In any case bu

[libreoffice-users] Re: SVG embedding in LibreOffice

Nuno J. Silva wrote: > > Like this one? > > http://upload.wikimedia.org/wikipedia/commons/9/91/Arrows_bend.svg > > So if I understand you correctly, the blurred shadow is correctly > imported in OOo. > I can confirm that inserting the linked SVG into a OOo 3.4 Beta Writer document does show u

[libreoffice-users] Re: SVG embedding in LibreOffice

Actually I am almost sure LibreOffice added that feature first http://www.libreoffice.org/download/new-features-and-fixes/ I don't know if the code was shared with both projects but OpenOffice does that too :) -- View this message in context: http://nabble.documentfoundation.org/SVG-embedding-i

[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

Jack wrote: > > array formulas in LibO/OOo are a little tricky (little more so than in > Excel). If you've entered the formula correctly and pressed ENTER > (instead of CTRL+SHIFT+ENTER), then obviously it does not work. If you > then select the cell/formula again and press CTRL+SHIFT+ENTER, th

[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

Hi Jack I couldn't make it work. In fact I just found out that array functions don't work in Lib (3.3 or 3.4) nor in OOo (3.4 beta) I don't know if it ever worked (I use it every now and then, so I couldn't say if I used it before in OOo/LO) but if it did, someone broke it :) Another bug to fix

[libreoffice-users] Re: Is this list unmoderated?

Nabble just LOOKS like a forum. Functionally, it's not. You have to subscribe to each "section" because each is a separate mailing list. If Mono works in the same way, then it's not an alternative. Please TDF consider setting up an OFFICIAL forum! -- View this message in context: http://nabble

[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

Brian Barker wrote: > > One useful facility in this case is Value Highlighting. Go to View | > Value Highlighting or press Ctrl+F8. The font colour for text > (temporarily) becomes black, for numbers and other values blue, and > for formulae green. (Formulae should be no problem, since it's

[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

Michael D. Setzer II wrote: > > If you use count on a range it only counts numeric cells, but > counta counts numeric and non-empty cells, so if they don't give > the same results for the same range, there is an error? > Yes, that would work but it forces me to do this verification for each c

[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

Actually I had never noticed that spreadsheets (all including Excel) ignore text values mixed with numbers. This worries me a lot! I work with 300.000+ line spreadsheets and if one line has a text value (because of a typo) I wouldn't notice that. Is there any setting that triggers a warning (inst

[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

It must be a new feature :) I advise you to test 3.3 RC1 and update to 3.3 when it is released. Version 3.4 is not ready for real work as stated in the release announcement http://nabble.documentfoundation.org/The-Document-Foundation-announces-LibreOffice-3-4-0-tt3019206.html -- View this messag

[libreoffice-users] Re: Is this list unmoderated?

Caesar wrote: > > On Fri, 3 Jun 2011 21:10:39 -0700, Robert Holtzman > >>Which is precisely the reason I dislike forums. Way too many brainless >>questions from users (and I use the term loosely) who barely know how to >>turn on their computer. > > +1 on that. They certainly

[libreoffice-users] Re: 3.4.0

Roland Hughes wrote: > > Any word on when this new version will roll through the OpenSuSE > repositories? We are currently at 3.3.2. > It's more likely that it is updated to 3.3.3 which is currently in RC1 ;) -- View this message in context: http://nabble.documentfoundation.org/3-4-0-tp30210

[libreoffice-users] Re: TDF - Novos membros em 31-05-2011

I agree with you Vitorio. The list should in fact be sorted alphabetically (I think that the date is irrelevant) I would suggest that a third column with Nationality should be added just to show off how international this project is ;) Greetings from the other side of the Atlantic ;) -- View th

[libreoffice-users] Re: Is this list unmoderated?

Hi Tom ;) Tom Davies wrote: > > Some kind user did kindly develop a Forum but people here seem more > interested > in creating blockages and creating restrictions rather than diversifying > to suit > a variety of different people's needs. > Relax bud and have a good weekend :) > I'm not stre

[libreoffice-users] Re: no 3.4.0 Windows all-language link

No, it's not. The branch 3.4 no longer has the ALL Languages pack. This means there is only one pack for Windows users: the Multi pack which includes all languages that are still maintained (many of the languages had been so neglected that most of the items were in English, so they were removed).

[libreoffice-users] Re: Is this list unmoderated?

James Wilde wrote: > >> But I haven't noticed any post from a real user being eliminated or any >> user >> banned. > > Well, by definition, you wouldn't! :) > If I read a post or posts from a user an then they are no longer in the archive, I would notice that :) Similarly if an "active user"

[libreoffice-users] Re: Is this list unmoderated?

It is benevolently moderated in the sense that real spam and commercial spammers are eliminated. But I haven't noticed any post from a real user being eliminated or any user banned. I guess some of the off-topic can be annoying but that is the price of freedom of speech ;) -- View this message

[libreoffice-users] Re: AutoCorrect/AutoFormat issue

Earl Melton wrote: > > I thought Lotus 1-2-3 used the Shift+2 (or @ character), i.e., > @SUM(A1..A12). > Did I think wrong? Maybe we're talking about different flavors of Lotus. > Or > maybe I'm having another one of those darned senior moments. > No you didn't. It was my mistake (I noticed t

[libreoffice-users] Re: AutoCorrect/AutoFormat issue

Hi Regina Regina Henschel wrote: > > Then you get a formula and not a value and it is displayed as 0,333. I > thought fraction display was desired. > Interesting. I had never noticed the Fraction format before :) Probably because I never needed such a function... I thought Matthew wanted the

[libreoffice-users] Re: AutoCorrect/AutoFormat issue

You can use an "old school" trick: type +1/3 ;) (In fact Lotus used + as an indicator for a formula which was much more practical than = since it's already on the Num Pad... But everybody started following Excel... :( ) -- View this message in context: http://nabble.documentfoundation.org/AutoCo

[libreoffice-users] Re: Dollars & Cents in Spreadsheet

:) In fact, after a quick search in Google, I found out that there is such a feature in a competing product ;) http://www.teachexcel.com/excel-help/ev.php?i=2957 Maybe this could be added as a feature request for Calc? -- View this message in context: http://nabble.documentfoundation.org/Dolla

[libreoffice-users] Re: Dollars & Cents in Spreadsheet

> (can even give a clumsy work around). > If it's better than having calculations in another column, please do. I could use a trick that saves me from typing the dot (because I often type the dot twice and then have to go back to correct it...) -- View this message in context: http://nabble.doc

[libreoffice-users] Re: Dollars & Cents in Spreadsheet

Cor Nouws wrote: > > Simply Format>Cells > Or via the Styles window (F11) you can also define styles for > (different) cells > That wouldn't work, Cor ;) It's not a question of formatting. The OP wants to type 123 and for the cell to display $1.23 The only solution I can see is to have a colu

[libreoffice-users] Re: Sun Weblog Publisher broken

I have to disagree both with you Cor and with NoOp. Tom is answering as a member of the community. Here is a quote from the LibreOffice homepage "Support and documentation is free from our large, dedicated community of users, contributors and developers." So you see, miserable lowly human beings

[libreoffice-users] Re: Trivia Question - Further Observation

Excellent post, Alexander. I agree that it is essential to have written rules of what to expect and what not to expect from a project. I totally disagree with LO's philosophy of "Even if we broke something we might not fix it" but it is better to know that than for users to complain and demand po

[libreoffice-users] Re: tabs in LibreOffice - like you can do for MS-Word?

Did you at least try the extension suggested by toki on this topic? http://wiki.services.openoffice.org/wiki/Framework/WorkInProgress/Tabbed_Windows_Extension I tested it and it does work in LO 3.4 (at least under Windows XP) -- View this message in context: http://nabble.documentfoundation.org

[libreoffice-users] Re: tabs in LibreOffice - like you can do for MS-Word?

@toki, thank you for the tip. The extension does work with LO version 3.4. It's a shame it has no options. I would rather have the tabs on top (like in Firefox :) ) Maybe one of the developers (I heard there are nearly 200 :) ) can do a quick fix to this extension ;) It would surely be useful wh

[libreoffice-users] Re: tabs in LibreOffice - like you can do for MS-Word?

>Are you aware that, at least >in Win. that you can move between documents using Alt+tab? I find that much >faster than trying to use a mouse. If you have a bunch of tasks running it's >not so handy, but normally you are only switching between a few windows and >it is very quick. Are you aware th

[libreoffice-users] Re: Calc: set page number

Format, Page, Sheet tab, in the Page Order section change First Page Number to 26 ;) Enjoy ;) -- View this message in context: http://nabble.documentfoundation.org/Calc-set-page-number-tp2988097p2988344.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E

[libreoffice-users] Yay! Parallel dev builds at last :)

Actually for a few days now (since the 19th) You can get an installer (for Windows and Mac currently) for the current code on the master (trunk). Browse here http://dev-builds.libreoffice.org/daily/ This includes the fix that allows to install a dev version simultaneously with a stable build. W

[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2

Hi Gary I don't have a link for it - M. Henri Day sent it to me directly. But > I'll be happy to email it to you if you'd like. Note: I had to do > considerable timing adjustments to get it to sync with the external .wav > file in order to get it to work in OOo with gstreamer. > I meant upload it

[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2

But, it is clear that > OOo/LO could use some 'fine tuning' in the file size/image > compression/conversion area - at least with respect to Impress. If I get > time & if it is interest to anyone I can just build a 1 slide Impress > presentation using the extracted .ppt jpg & compare. I've only MS

[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2

Hi Tom ;) If you re-write the document from scratch using exactly the same formatting > in > both then i would guess that LibreOffice generates the best and possibly > smallest .odt. I did. It is not :) Since the MS ODF is so incomplete it manages to be the smallest. And the OOo file is the seco

[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2

The simple explanation is that the MSO file is missing many ODF features ;) Interestingly both your files fail the ODF validation on this site http://tools.odftoolkit.org/odfvalidator/ Does it make any sense that only when I create an identical file under OOo 3.4 Beta the file is valid? Should

[libreoffice-users] Re: Test for Error Conditions in Calc

Here is an example: =IF(ISNA(A1); "None"; A1) See the Information Functions on this page for more http://www.techonthenet.com/excel/formulas/index.php -- View this message in context: http://nabble.documentfoundation.org/Test-for-Error-Conditions-in-Calc-tp2982777p2983265.html Sent from the Use

[libreoffice-users] Re: Fwd: [tdf-announce] failure notice

This is a polite way of telling you that you were NOT selected as one of the ESC members :) -- View this message in context: http://nabble.documentfoundation.org/Fwd-tdf-announce-failure-notice-tp2975606p2975783.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instruc

[libreoffice-users] RE: using libre office with portable apps

Probably the files in the pen are badly fragmented. Since that is a pen (and not a hard disk) the easiest, fastest and most efficient way to defrag is simply to MOVE all contents to a folder in another disk (preferably a HDD) and then move them back. Since files are moved sequentially they will b

[libreoffice-users] Re: lower part of dialog boxes not visible

> > Of course LO can't predict all these situations but in this > > particular case there is a lot of vertical space wasted on the dialog > > which could be optimized. > ... > > Agree. > Just for fun I re-organized the dialog (this is a mock-up screen) http://dl.dropbox.com/u/2347109/Find_Replac

[libreoffice-users] Re: lower part of dialog boxes not visible

Hi again Thomas I think this is a pretty good solution: http://sourceforge.net/projects/fp-winmngr/ Just download and unpack the program in any folder. Execute FP Windowmanager and press the Hide button. From now on, to move the top window anywhere just press Win+Alt+Cursor keys It does work pe

[libreoffice-users] Re: lower part of dialog boxes not visible

> > > > In the Ubuntu version of LibreOffice, some of the taller dialogs have > > been rearranged so the "bottom half" is to the side, so they fit better > > into a widescreen display such as found on many netbooks and laptops. > > (PDF Options is an example.) AFAIK, the standard version of LibO >

[libreoffice-users] Re: lower part of dialog boxes not visible

Hi NoOp > You didn't say he was what? It is helpful if you'd quote what you are > replying to. Snipping is good, but simply replying without some quote & > attribution isn't helpful - particularly if someone is sorting through > the archives. > I didn't snip anything. I simply replied through Na

[libreoffice-users] Re: lower part of dialog boxes not visible

@NoOp I didn't say he was. I said this should be fixed because this will affect netbook users (and it is quite easy since there is a lot of wasted space on the dialog) Maybe Thomas is simply using a Theme with a Large Font... -- View this message in context: http://nabble.documentfoundation.org

[libreoffice-users] Re: lower part of dialog boxes not visible

@Thomas You can use this Open Source program to solve your problem http://winsize2.sourceforge.net/en/index.html But I think that the options in the dialog should be rearranged. There is a lot of empty space on the dialog and this creates a problem with low resolution devices such as netbooks.

[libreoffice-users] Re: Draw extra slow with 4 slides

I assume you are adding notes to a PDF (since you mention Adobe Acrobat) Since you are using Windows I would recommend for such a task the free program PDF Xchange Viewer. It is a lightweight PDF reader with annotation tools. The advantage over Draw is that it doesn't convert the PDF. The disadva

[libreoffice-users] Re: Pronunciation of LibreOffice in English

Actually if you read Libre as a Spanish word (instead of French) then the closest pronunciation for English speakers is probably Lee-Brea : Lee as Bruce and Brea as the word Bread but without pronouncing the final d This means that there are (at least) two correct pronunciations :) Just my 2 cent

[libreoffice-users] Re: No Help

Hi Jeff The help pack is in a separate RPM. If you go to http://www.libreoffice.org/download/ and choose Linux x86 there are two downloads: the 147Mb installer which you already have, and a 8.6Mb helppack. Just get this and install it (don't ask me how because I'm a Windows user :) ) Enjoy ;) -

[libreoffice-users] Re: Opening/converting a Lotus wk4 file for Calc?

I'm glad you solved your problem ;) That is why Microsoft makes sure that it is easy to get and use irregular copies: when other programs fail you can always go back to MS Office :) -- View this message in context: http://nabble.documentfoundation.org/Opening-converting-a-Lotus-wk4-file-for-Calc

[libreoffice-users] Re: Opening/converting a Lotus wk4 file for Calc?

I use Gnumeric and I couldn't find any information on opening wk4. It does mention that it opens wk1 and wks but I suspect that wk4 is quite different. Yes, there is a Windows version and it is kept up-to-date. TBH if Gnumeric had a Pivot Table/Data Pilot function it would be light years ahead of

[libreoffice-users] Re: Opening/converting a Lotus wk4 file for Calc?

FYI Symphony doesn't open Lotus spreadsheets (to Lotus users dismay) According to this page I found, Openoffice 3.2 does? http://www.ehow.com/how_6462332_convert-wk4-xls.html Then LO should do it too... (Can you link to one of this files?) -- View this message in context: http://nabble.documen

[libreoffice-users] Re: .docx can't be read

Could this be simply because LibO (and OOo) is not handling correctly windows OLE objects in the docx format? See my post on the previous page (on the nabble site for this topic) about Equations. -- View this message in context: http://nabble.documentfoundation.org/docx-can-t-be-read-tp2889232p2

[libreoffice-users] Re: .docx can't be read

Yes, Tom, there are new problems between build 3.4 and docx which didn't exist in 3.3.2 (interestingly this applies to the 3.4 betas of both LO and OOo) E.g. for a docx file containing an Equation, OOo simply ignores the equation while LO ignores the equation and everything after it. But it's not

[libreoffice-users] Re: .docx can't be read

Dotan, "Well, allow me to retort" (as a famous movie character said) :) LibreOffice IS fully compatible in the sense that it will open any MS Office file. HOWEVER files created in MS Office may not look exactly the same (or some features, e.g. Equations not be loaded at all) in LO or OOo IMO th

[libreoffice-users] Re: List of download mirrors

I have been looking for such a page for ages. Thanks! It would be easier to find a mirror if they were simply sorted alphabetically. It the page was on a wiki I would sort it myself...-- View this message in context: http://nabble.documentfoundation.org/List-of-download-mirrors-tp2883129p2884415.

[libreoffice-users] Re: Chart "how to"

If you used Excel you would know what CohoMike is talking about. Excel allows to create a special type of Sheet named Chart where the only object is a Chart using data from one of the other Sheets. It is particularly useful when you have large spreadsheets with many tabs. It makes it easy to locat

[libreoffice-users] Re: Chart "how to"

CohoMike, actually if you do that in Excel and open the file in Calc, the Chart tab will show up as a regular spreadsheet tab with a large chart on top of the cells :) -- View this message in context: http://nabble.documentfoundation.org/Chart-how-to-tp2861232p2872014.html Sent from the Users ma

[libreoffice-users] Re: -convert-to command line option on Windows

There is no problem with this function if you use the installed LibreOffice. The problem is that you are passing the parameters to the PortableApps executable which is probably not passing it correctly to soffice.exe So, if you intend to use the Portable LOffice you need to report this to whoever

[libreoffice-users] Re: LibreOffice Update Mechanism

Hi Arief Yes, it is planned but there is no schedule for when it will be available http://nabble.documentfoundation.org/update-service-td2479818.html -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-Update-Mechanism-tp2838224p2838957.html Sent from the Users mai

[libreoffice-users] Re: Opening a PPS file in not-presentation mode

Double clicking a PPS opens the file in slideshow as expected. The problem is that starting Impress and then opening a PPS file should open it in Edit mode (as PowerPoint does). Instead it opens it in slideshow mode and closes Impress on ESC. This is indeed a bug which makes it impossible to ed

[libreoffice-users] Re: Ellison's Oracle washes hands of OpenOffice

@Wayne I think that the BEST option would be to have 3 options available: 1) Classic menu 2) Ribbon and 3) the Future ;) (By the Future I'm referring to this topic http://nabble.documentfoundation.org/Impressive-mockups-td2389105.html) The UI could be selected on first use (or later in some conf

[libreoffice-users] Re: Ellison's Oracle washes hands of OpenOffice

@Mark Stanton What you say is true. Symphony was indeed created in the 80's. But that doesn't mean that version 3 is not based on OpenOffice ;) http://en.wikipedia.org/wiki/IBM_Lotus_Symphony BTW If you follow the link I provided you will notice at the end of the page the following sentence just

[libreoffice-users] Re: Ellison's Oracle washes hands of OpenOffice

@Wayne Being a biologist, I find your Evolution parallel quite interesting. Answering your previous question: of course IBM has it's own flavour of Office (based on OpenOffice in fact): it's called IBM Lotus Symphony http://www-03.ibm.com/software/lotus/symphony/home.nsf/products Enjoy! ;) --

[libreoffice-users] Re: Spreadsheet Problem

It's hard to guess what happened to the file or what format it is in... If the data is not confidential, please upload it somewhere (e.g. http://depositfiles.com/en/) and post the link here. -- View this message in context: http://nabble.documentfoundation.org/Spreadsheet-Problem-tp2830785p28309

[libreoffice-users] Re: upgrading from Repository killed LO

>People keep saying the beta is 3.4 but the files show 3.3.4 or 3_3.4. >Presumably people are just using a short-hand that ignores the 1st 3_ ? Which >seems sensible but i get confused thinking there is a different beta for a major >mile-stone release. No, Tom. People are saying 3.4 because i

[libreoffice-users] Re: Ellison's Oracle washes hands of OpenOffice

Good morning Tom ;) Although I agree with most of your arguments, Microsoft's position on Office has changed a lot lately. First it is almost impossible to buy a new Win7 machine which doesn't have some version of Office bundled. It varies from a Trial version to a Starter version and sometimes e

[libreoffice-users] Re: Impress: Importing multiple pictures, one per slide?

This add-on does exactly what you asked and works perfectly under LibreOffice 3.3.2 (tested in Windows XP) http://extensions.services.openoffice.org/en/project/PhotoAlbum -- View this message in context: http://nabble.documentfoundation.org/Impress-Importing-multiple-pictures-one-per-slide-tp266

[libreoffice-users] Re: LO Calc very slow and freezes

Gnumeric supports up to 16777216 lines (yes, 16 million...) Maybe you are using an older version. The current build is 1.10.13 -- View this message in context: http://nabble.documentfoundation.org/LO-Calc-very-slow-and-freezes-tp2710811p2712956.html Sent from the Users mailing list archive at Na

[libreoffice-users] Re: LO Calc very slow and freezes

It is a performance problem. If you are using an xlsx file you can decrease loading time by 2/3 if you save it to ODS. See this topic http://nabble.documentfoundation.org/Why-is-LO-OOo-so-slow-loading-a-spreadsheet-td2006665.html HTH -- View this message in context: http://nabble.documentfound

[libreoffice-users] Re: Day zero is 1904-01-01 for new spreadsheets

Very interesting, Andreas. Today I learned something about leap years thanks to you ;) http://kalender-365.de/leap-years.php I'm glad I don't have any time series of data going back to the 19th century :) -- View this message in context: http://nabble.documentfoundation.org/Day-zero-is-1904-0

[libreoffice-users] Re: Day zero is 1904-01-01 for new spreadsheets

This is puzzling: if day Zero is 0-Jan-1900 and day 1 is 1-Jan-1900 for Excel and day Zero is 30-12-1899 and day 1 is 31-12-1899 for both LibO 3.3.1 and OOo Dev101, how come =now() returns the same value in both spreadsheets? -- View this message in context: http://nabble.documentfoundation

[libreoffice-users] Re: Calc trumps Excel

Hi Tom I'm sorry to say but you are wrong on this one. LibO and OOo don't auto-resize but Excel does. Just type =now() on any cell and watch one of the reasons why Excel is the number one spreadsheet bar none ;) Cheers, Pedro -- View this message in context: http://nabble.documentfoundation.o

[libreoffice-users] Re: Calc trumps Excel

That doesn't make any sense, does it? The format of the values depends on the width of the cell??? There are only two logical options: 1) the cell width is automatically adjusted to show the whole data (as Excel does) or 2) the data is correctly formatted (in this case in the DATE TIME format) an

[libreoffice-users] Re: Calc trumps Excel

T.R. Valentine When you open a tab delimited file in Excel it automatically recognizes the data types. Therefore your string e.g. 2011-02-26 10:23:47 is correctly interpreted as a value. Therefore it is natural that using FIND, VALUE, LEFT or any other functions would not work. As I said in the p

[libreoffice-users] Re: Calc trumps Excel

VALUE and TIMEVALUE apply to TEXT strings ONLY both in Excel and LibO If you want to parse a value field you have to use different functions How did you import the Tab delimited file to LibO? -- View this message in context: http://nabble.documentfoundation.org/Calc-trumps-Excel-tp2573005p2574

[libreoffice-users] Re: Update from 3.3.1-rc-2 to 3.3.1

I couldn't agree more, Marcus. In fact the About box should also mention RC1, RC2, etc It should be easy to find out if the version you are using is the same available on the downloads page... -- View this message in context: http://nabble.documentfoundation.org/Update-from-3-3-1-rc-2-to-3-3-1

[libreoffice-users] Re: Missing function: Bankers Rounding

What I meant was: if the original numbers have a mixed number of decimal cases you can't apply my solution because of the base 2 calculations. But I assume that in a table you don't have values with 3 decimal cases mixed with one decimal case? Therefore you could go from 4 decimal cases to 1 in

[libreoffice-users] Re: Missing function: Bankers Rounding

It's only slightly more complicated :) =IF(VALUE(RIGHT(A9))=5;IF(ISEVEN(VALUE(LEFT(RIGHT(A9;2;A9-0.005;A9+0.005);ROUND(A9;2)) Check if the last digit is 5. If it is add 0.005 if the previous digit is odd or subtract if it is even. Otherwise use the standard round function with two cases. No

[libreoffice-users] Re: Missing function: Bankers Rounding

I had never heard of bankers rounding before. Interesting concept. There is no such function in OOo/LO, Excel or Gnumeric... But you can easily create a function =IF(A1-INT(A1)=0.5;IF(ISEVEN(INT(A1));A1-0.5;A1+0.5);ROUND(A1)) (Adjust if your separator is a comma instead of a semi-colon) What

[libreoffice-users] Re: Open pps as ppt

I did try and the result is the same (starts Slideshow). In any case even if that did work it would be a workaround, not the expected action ;) -- View this message in context: http://nabble.documentfoundation.org/Open-pps-as-ppt-tp2457168p2513898.html Sent from the Users mailing list archive at

[libreoffice-users] Re: Installing LibreOffice under Ubuntu 9.10 aka Karmic

Yes, that does work. But I was looking for a solution that didn't involve manually downloading, unpackaging, etc... In theory, adding the PPA options would not only install the current version but also allow updates when available. What puzzles me is that unless Hit means something different, mo

[libreoffice-users] Installing LibreOffice under Ubuntu 9.10 aka Karmic

I'm an advanced Windows user but absolute Linux newbie. I was trying to install Libreoffice under Ubuntu Netbook Edition 9.10 (the only version that has drivers for my eeePC netbook) following these instructions http://www.omgubuntu.co.uk/2011/01/new-ppa-makes-installing-libreoffice-on-ubuntu-eas

[libreoffice-users] Re: Open pps as ppt

There is indeed a bug (or at least a different behaviour from MS Office and OOo) with .pps files If a user double clicks or "opens with" a pps file with MS Powerpoint or LO Impress it is supposed to autostart the presentation. However if you open Powerpoint and use File Open to open the pps file

[libreoffice-users] Re: Calc

I have four comments on relative paths in OOo/LO: 1) It doesn't work. I changed to relative paths, created a new file with a relative path, moved both files (source and reference) to another drive and it kept looking for the file in the original location 2) It doesn't make any sense to save a pa

[libreoffice-users] Re: Calc

OpenOffice and LibreOffice use absolute paths ='file:///C:/Source.ods'#$Sheet1.B2 while Excel uses relative paths =[Source.xls]Sheet1!$B$2 This means that in Excel as long as the files are on the same folder or in the same relative folder, the references will work This is obviously a OOo/LO l

[libreoffice-users] Re: Calc

I suggest that you move forward instead of back (many bugs have been fixed meanwhile) http://ftp.heanet.ie/mirrors/tdf/libreoffice/testing/3.3.1-rc1/ Please report your findings in either case ;) -- View this message in context: http://nabble.documentfoundation.org/Calc-tp2475968p2476212.html

[libreoffice-users] RE: Poor formatting and extremely slow performance

I know this won't help a bit, but it looks as bad under OOo 3.3.0, OOo 3.4.0 m99 and Abiword (all under Windows XP SP3) If these files are not meant for editing I advise you to export to PDF using the fantastic FLOSS program PDF Creator. (BTW the reason most documents work in MS programs is that

[libreoffice-users] Re: where is the guidelines on what to put on a CD/DVD distro of LibreOffice?

Yes, you are right. I failed to notice the "_de" detail but if you read this thread you are now aware that there is a wiki page on this subject ;) http://wiki.documentfoundation.org/Marketing#Documents_and_Resources -- View this message in context: http://nabble.documentfoundation.org/where-is-

[libreoffice-users] Re: where is the guidelines on what to put on a CD/DVD distro of LibreOffice?

Hi Stefan, indeed much better. I can see now why the original is not shared ;) In any case you should replace those low res labels ASAP ;) Here is a much nicer PNG (BTW I have no idea why the corner crop marks grow inside the light green area in your PDF...) http://dl.dropbox.com/u/2347109/lib

[libreoffice-users] Re: where is the guidelines on what to put on a CD/DVD distro of LibreOffice?

> IMO the project has the potential to become internationalized. Are you joking? I can't even understand why the other national teams aren't taking advantage of this initiative! Congratulations! I hope others will follow the German example! (I'm curious: why is the Slimcase Inlay so low res? I

[libreoffice-users] Re: where is the guidelines on what to put on a CD/DVD distro of LibreOffice?

You obviously need to get official labels and stuff but there is no need to download packages. There is already an all_platform DVD available in the mirrors... http://ftp.heanet.ie/mirrors/tdf/libreoffice/box/3.3.0/ Maybe it hasn't been announced but it's there since Feb 5th ;) -- View this me

[libreoffice-users] Re: Calc too slow in opening Excel spreadsheets

Yes, this has been reported. The problem is not restricted to the xls format... See a similar topic http://nabble.documentfoundation.org/Why-is-LO-OOo-so-slow-loading-a-spreadsheet-td2006665.html Cheers, Pedro -- View this message in context: http://nabble.documentfoundation.org/Calc-too-slow

[libreoffice-users] Re: Libreoffice and openoffice issues

Yes, they are. And in my (short) experience here at LibreOffice they seem to be more efficient in solving bugs than the guys at OO.org That doesn't mean it will be fixed tomorrow ;) In any case there is a separate bug tracker for LO here https://bugs.freedesktop.org/ -- View this message in co

[libreoffice-users] Re: How to sort this dataset in Calc?

Stefan, you can either move the cell or use Data, Sort instead. I prefer to see the options I'm choosing instead of relying on focus. Regarding selecting only one column, currently LO and OOo have the same behaviour as Excel 2003 (I refuse to use newer versions): ask if the user wants to expand

[libreoffice-users] Re: How to sort this dataset in Calc?

Actually it does work. Just select columns A and B and press the sort icon or choose Data, Sort for more options. The only situation where LO and OOo don't accept whole columns is in cell formulas :( -- View this message in context: http://nabble.documentfoundation.org/How-to-sort-this-dataset-

  1   2   >