[libreoffice-users] Calc problem

2014-01-28 Thread IOmazic
Hi, I am testing LibreOffice to replace MS Office 2003. So I created 4 xlsx files with LibreOffice Calc 4.1.4.2 and while files are open formula syntax is working (Calc A1), and it is looking like this: =SUM(B22:B22*'file:///C:/temp/Test file 2.xlsx'#$Sheet1.B22) But as soon as I save it and

[libreoffice-users] Calc problem

2013-04-05 Thread Paul Schwartz
I am using LibreOffice 3.5.7.2 in Ubuntu 12.04. Ever since I changed from OpenOffice I have noticed that Calc will not allow me to copy a selection of cells in one row to several other rows. It only allows me to do one cell to a range in a column. Does anybody have this problem? Is it a bug that

Re: [libreoffice-users] Calc problem

2013-04-05 Thread Kracked_P_P---webmaster
On 04/05/2013 04:09 PM, Steve Edmonds wrote: On 2013-04-06 05:02, Paul Schwartz wrote: I am using LibreOffice 3.5.7.2 in Ubuntu 12.04. Ever since I changed from OpenOffice I have noticed that Calc will not allow me to copy a selection of cells in one row to several other rows. It only allows

Re: [libreoffice-users] calc problem

2013-03-28 Thread Tom Davies
but the answer to that is just No and that solves the problem. Regards from Tom :)  From: Tim Lloyd tim.ll...@gmx.com To: nvrk nvrk.89...@gmail.com Cc: users@global.libreoffice.org Sent: Thursday, 28 March 2013, 3:23 Subject: Re: [libreoffice-users] calc

Re: [libreoffice-users] calc problem

2013-03-28 Thread Jay Lozier
: users@global.libreoffice.org Sent: Thursday, 28 March 2013, 3:23 Subject: Re: [libreoffice-users] calc problem It was not a matter of preferences. It was because calc could not open a .XLS file. On further investigation it was found that it is not an XLS file hence the problem Cheers On 03/28/2013 01

Re: [libreoffice-users] calc problem

2013-03-28 Thread Tom Davies
chap.  Regards from Tom :)  From: Jay Lozier jsloz...@gmail.com To: users@global.libreoffice.org Sent: Thursday, 28 March 2013, 18:23 Subject: Re: [libreoffice-users] calc problem On 03/28/2013 01:23 PM, Tom Davies wrote: Hi :) So it meant that instead

Re: [libreoffice-users] calc problem

2013-03-28 Thread Michael Wu
something in LibreOffice is needed to be checked. Regards from Michael From: Tim Lloyd tim.ll...@gmx.com To: nvrk nvrk.89...@gmail.com Cc: users@global.libreoffice.org Sent: Thursday, 28 March 2013, 3:23 Subject: Re: [libreoffice-users] calc problem

Re: [libreoffice-users] calc problem

2013-03-28 Thread Tom Davies
@global.libreoffice.org Sent: Friday, 29 March 2013, 1:13 Subject: Re: [libreoffice-users] calc problem Jay Lozier 提到: On 03/28/2013 01:23 PM, Tom Davies wrote: Hi :) So it meant that instead of discovering a bug with LibreOffice it was a discovered problem with the 3rd party's website and their strange

Re: [libreoffice-users] calc problem

2013-03-28 Thread TomW
On 2013-03-27 23:23, Tim Lloyd wrote: It was not a matter of preferences. It was because calc could not open a .XLS file. On further investigation it was found that it is not an XLS file hence the problem Cheers On 03/28/2013 01:48 PM, nvrk wrote: Is there a reason why the .xls file version

Re: [libreoffice-users] calc problem

2013-03-28 Thread Michael Wu
:) From: Michael Wu m...@tercel.com.tw To: users@global.libreoffice.org Sent: Friday, 29 March 2013, 1:13 Subject: Re: [libreoffice-users] calc problem Jay Lozier 提到: On 03/28/2013 01:23 PM, Tom Davies wrote: Hi :) So it meant that instead

Re: [libreoffice-users] calc problem

2013-03-27 Thread Michael Wu
On Tue, Mar 26, 2013 at 7:44 AM, Tim Lloyd tim.ll...@gmx.com mailto:tim.ll...@gmx.com wrote: Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables

Re: [libreoffice-users] calc problem

2013-03-27 Thread Tim Lloyd
It was not a matter of preferences. It was because calc could not open a .XLS file. On further investigation it was found that it is not an XLS file hence the problem Cheers On 03/28/2013 01:48 PM, nvrk wrote: Is there a reason why the .xls file version is preferred to the .csv version from

[libreoffice-users] calc problem

2013-03-25 Thread Tim Lloyd
Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables from a financial newspaper here in Oz. Yesterday I inadvertently clicked on the wrong table by accident and tried to

Re: [libreoffice-users] calc problem

2013-03-25 Thread Brad Rogers
On Tue, 26 Mar 2013 07:44:00 +1100 Tim Lloyd tim.ll...@gmx.com wrote: Hello Tim, Just click on the xls link next to Warrant Market Any comments? Yes, it locked up here too, using v3.5.4.2 in Debian, at about 50% through loading. Top showed 100% CPU usage. After a minute or so, I killed the

Re: [libreoffice-users] calc problem

2013-03-25 Thread Jay Lozier
On 03/25/2013 04:44 PM, Tim Lloyd wrote: Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables from a financial newspaper here in Oz. Yesterday I inadvertently clicked on

Re: [libreoffice-users] calc problem

2013-03-25 Thread Steve Edmonds
On 2013-03-26 09:44, Tim Lloyd wrote: Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables from a financial newspaper here in Oz. Yesterday I inadvertently clicked on

Re: [libreoffice-users] calc problem

2013-03-25 Thread Tim Lloyd
Thanks Jay and Brad. I'll raise a bug report Ironically that site has language along the lines of you will need MS Excel to open these files. I was going to write to correct them on this. Best keep my mouth shut now :( Cheers On 03/26/2013 09:13 AM, Jay Lozier wrote: On 03/25/2013 04:44 PM,

Re: [libreoffice-users] calc problem

2013-03-25 Thread TomW
On 2013-03-25 16:44, Tim Lloyd wrote: Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables from a financial newspaper here in Oz. Yesterday I inadvertently clicked on the

Re: [libreoffice-users] calc problem

2013-03-25 Thread Jay Lozier
On 03/25/2013 09:30 PM, TomW wrote: On 2013-03-25 16:44, Tim Lloyd wrote: Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables from a financial newspaper here in Oz.

Re: [libreoffice-users] calc problem

2013-03-25 Thread Tim Lloyd
Hi Michael, looks like this one didn't make it to the list. And it is very interesting. In light of all the XML reports I think the first step is to ask the site why XML docs are masquerading as XLS. It would be good to know the version of MSO you are using so I can quote this to them. FYI I

RE: [libreoffice-users] calc problem

2013-03-25 Thread Dennis E. Hamilton
: Re: [libreoffice-users] calc problem Hi Michael, looks like this one didn't make it to the list. And it is very interesting. In light of all the XML reports I think the first step is to ask the site why XML docs are masquerading as XLS. It would be good to know the version of MSO you are using

Re: [libreoffice-users] calc problem

2012-02-27 Thread Václav Medek
Still no answer. Can anybody help me please? Thank you. Václav Medek Systémový administrátor lokální sítě - CZ.NIC, z.s.p.o. Americka 23 120 00 Praha 2 mail: vaclav.me...@nic.cz tel: +420 222 745 114 web: http://www.nic.cz/ Dne 24.2.2012 13:34, Václav

Re: [libreoffice-users] calc problem

2012-02-27 Thread Steve Edmonds
If I paste into the formula entry bar there is no dialogue. steve On 2012-02-28 01:21, Václav Medek wrote: Still no answer. Can anybody help me please? Thank you. Václav Medek Systémový administrátor lokální sítě - CZ.NIC, z.s.p.o. Americka 23 120 00 Praha

[libreoffice-users] calc problem

2012-02-24 Thread Václav Medek
Hi, I would like to ask you how to solve a problem with Calc. Ill try to explain you how to reproduce it. Just open any web page in your browser and find there an e-mail contact which is in html link form. I.e. users+subscr...@global.libreoffice.org

[libreoffice-users] Calc - problem with graphs

2011-04-25 Thread dunbrokin
I am new to LibreOffice. I have a graph of about 600 data points. There are too many of these on the X axis and so I want to only have labels every 30th point or so. But I cannot change the interval because when I access the X axis - scale, the page is grayed out and won't let me change anything.

[libreoffice-users] Calc: Problem pasting listboxes

2011-03-20 Thread Jim Trigg
I'm trying to set up a sheet with multiple listboxes nearly alike, each taking its data from a cell range in another sheet in the same file ('other sheet'.b218:b238). If I copy one and paste it, the pasted copy does not work -- it does not pull any data (drop-down does not have any items, even