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
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
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
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
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:
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, then
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:
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 up a
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
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:
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:
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
Caesar wrote:
On Fri, 3 Jun 2011 21:10:39 -0700, Robert Holtzman lt;hol...@cox.netgt;
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 don't
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
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
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
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
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
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 stressed ;)
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
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
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 the
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:
Cor Nouws wrote:
Simply FormatCells
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 column
(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:
:)
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:
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
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 that
@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
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.
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:
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
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 second
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
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
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
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
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
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 Nabble,
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
(downloaded
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
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_Replace.png
@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.
@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:
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
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 ;)
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
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:
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
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:
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:
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:
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
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
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
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
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
@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
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:
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
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:
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
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:
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:
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
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)
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:
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:
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
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)
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,
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
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
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
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
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
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?
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...)
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:
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:
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
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:
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
I'm currently installing RC3 (under Windows) and something puzzles me: why is
the list of dictionaries available different from the language packs?
If there is some criteria for including languages in the multi package,
shouldn't it be consistent? E.g. I can choose the Portuguese language pack
No, it's not equal at all. Your data will be updated dinamically as you
modify if it the ods file.
There is no similarity with a static HTML table.
I'm glad I could help ;)
--
View this message in context:
http://nabble.documentfoundation.org/Including-a-ods-in-a-odt-tp2200869p2216108.html
You can include up to 4000 rows (do you think you will have more than that?)
and it will always be updated.
Before delivering the report you just need to delete the lines in excess (or
leave them in...)
The other option (mail merge) I was suggesting would require one page per
post instead of a
I'm not sure I understand your problem, but if you would refer to the ODS
cells in the ODF document like a mail merge then you could create a document
which will have all your up-to-date cell contents when you print it to a
final document (in addition to what you type in the ODF document, of
Actually that is not what I imagined from your first post.
I thought it would be a spreadsheet with a single column used where each
line would be a new post to your journal.
Maybe you can upload an example of the ods (two lines of fake data are
enough) and what you expect the final odf to look
I thought it was something more complex :)
The easiest way to include it is to open the ods file, select the cells with
data and then switch to the Appendix and choose Paste Special, DDE Link.
From now on, each time you open the file it will ask you if you want to
Update all links.
You should
I thought it was something more complex :)
The easiest way to include it is to open the ods file, select the cells with
data and then switch to the Appendix and choose Paste Special, DDE Link.
From now on, each time you open the file it will ask you if you want to
Update all links.
You
RC2 is already available for download on selected mirrors...
This one for instance
http://ftp.heanet.ie/mirrors/tdf/libreoffice/testing/
--
View this message in context:
http://nabble.documentfoundation.org/Re-Closing-LibreOffice-results-in-a-crash-tp2128832p2132613.html
Sent from the Users
I found Ubuntu Brainstorm very dis-satisfying. The main problem with it
(imo)
is that the first few pages are all old ideas that have received a lot of
votes.
If the first page had the most easily viable ideas along with the most
innovative and interesting ideas then it would work a lot
This is a know limitation/feature of OpenOffice and now of LibreOffice.
In my opinion it should be modified to make it consistent with other
spreadsheets.
There is no easy way other than to type a high number (currently it can be
as high as 1048576) or to make it faster just type 1 followed by
It had already been reported
https://bugs.freedesktop.org/show_bug.cgi?id=31494
and a workaround has already been committed to the branch (meaning it will
be solved in the next build)
Thanks!
--
View this message in context:
Same here on two machines. Same Win version, same LO build.
Is this an XP problem only?
LO 3.3 b2 didn't have this bug.
--
View this message in context:
http://nabble.documentfoundation.org/On-Applications-Exit-tp1950798p1956061.html
Sent from the Users mailing list archive at Nabble.com.
Bill, do the cells in the range contain only natural numbers?
I suspect that you are having a problem with the decimal separator.
Your cells are probably identified as text because of that (are the values
aligned to the left?)
Paste this in cell D2 to check
=VALUE(C2)
--
View this message
Actually it depends on your Language Settings.
And LibreOffice inherited the problems from OpenOffice...
E.g. for Portuguese (European) the decimal separator is a comma(,) but if I
prefer to use a point (because most international publications are formatted
according to US notation) when I
97 matches
Mail list logo