| View previous topic :: View next topic |
| Author |
Message |
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
|
| Back to top |
|
 |
exactt
General User
Joined: 14 Mar 2007
Posts: 15
|
 Posted: Tue Jun 12, 2007 2:16 am Post subject: |
 |
|
i would like to add thread http://www.oooforum.org/forum/viewtopic.phtml?t=15255 about drawing/deleting cell borders using something like the pencil/rubber function in excel. i just posted to the dev-api mailing lists about creating the functions. i wlll keep the mentioned thread updated.
thx |
|
| Back to top |
|
|
OfficeProfessor
General User
Joined: 10 Oct 2007
Posts: 6
|
|
| Back to top |
|
|
huwg
Super User
Joined: 14 Feb 2007
Posts: 890
|
|
| Back to top |
|
|
vasjpan2
Newbie
Joined: 18 Oct 2007
Posts: 4
|
| Posted: Thu Oct 18, 2007 2:30 pm Post subject: References and Calculations $B$6 |
|
|
I put myself on a limb and recommended Calc for a nonprofit.
We had a function like .34*b6/sum($b$6:$b$254) in Excel in cells g6:g254
Calc did not give the result we had in Excel, only Zero.
After weeks of my assuring them Calc would be fine,
they had to go out near a board deadline and buy Excel.
I not only have egg on my face,
but I have absolutely no idea why this would not work.
It does not make sence. It happens with both the PortableApps
version and the regular version of Calc.
All the docs for OO say it should work, no?
Now, as I was testing I found out another thing that didn't work like most
Spreadsheets I'd used before (I go back to MultiPlan and SUperCalc.. well,
even ADR EMpires, but it wasn't on-screen): I hit a + and then point to
another cell to get the address and it just goes to the cell, not give me the address.
I'm hoping all of this is because of some compatibility indicator I have to switch on, or equally simple.. |
|
| Back to top |
|
|
acknak
Moderator
Joined: 13 Aug 2004
Posts: 4295
Location: ~ 40°N,75°W
|
| Posted: Thu Oct 18, 2007 5:29 pm Post subject: |
|
|
There is no such thing as a "drop in replacement" for any piece of software as complex as a spreadsheet, and certainly Calc is not one. Such a migration should not be attempted without planning for mysterious things to fail--however, most of the mysteries can be solved, with time. If you go in without the time and expertise to solve the problems, you are doomed to be stuck with Excel.
| Quote: | | Calc did not give the result we had in Excel, only Zero. |
You can check the thread linked above: "Numbers entered as text" for more detail and some suggestions, but I'll bet this is our old friend "numeric text": in Excel, text that looks like a number is converted to the value of the number, while in Calc, it is converted to zero. The situation in Excel is almost always a mistake during data entry, but Excel does you a favor and performs the calculation anyway, where Calc is unforgiving.
| Quote: | ... I hit a + and then point to
another cell to get the address and it just goes to the cell, not give me the address. |
This feature is due to arrive in the next release of Calc.
If you want any firm answers to debugging the problems, you'll need to find a place to share the document (or a sample of it). |
|
| Back to top |
|
|
CHPCASTELLON
Power User
Joined: 10 Sep 2007
Posts: 51
Location: SPAIN
|
| Posted: Wed Oct 24, 2007 1:24 am Post subject: Re: Migration issues : Calc's idiosyncrasies |
|
|
Good morning,
I'm beginning to migrate from MS Excel to Calc. The users who already have migrated, are telling me the issues that they have seen.
For example:
1.- to insert a formula, they have to write (=) when in excel it's not necessary
2.- when they have two columns with two cells in the same file combined, they can't insert a column between the two columns. In excel they can.
3.- when they open a excel document with calc, the width of the columns is not the same as the original width.
If you want I tell you the issues emerging, let me know.
Thanks.
_________________
Lorena Monraval
Consorcio Hospitalario Provincial Castellon |
|
| Back to top |
|
|
huwg
Super User
Joined: 14 Feb 2007
Posts: 890
|
| Posted: Wed Oct 24, 2007 1:47 am Post subject: |
|
|
| CHPCASTELLON wrote: | 1.- to insert a formula, they have to write (=) when in excel it's not necessary
2.- when they have two columns with two cells in the same file combined, they can't insert a column between the two columns. In excel they can.
3.- when they open a excel document with calc, the width of the columns is not the same as the original width. |
- issue 20496, in next release (see acknaks post directly above yours).
- Issue 8302, which is only a proposal on Calc's To Do List, so don't hold your breath.
- Has been discussed on this forum more than once. Unfortunately not a surprise it remains a problem. Issue 76881?
Edit: added quote for clarity
Last edited by huwg on Tue Nov 27, 2007 2:02 am; edited 1 time in total |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Wed Oct 24, 2007 4:39 am Post subject: Re: References and Calculations $B$6 |
|
|
| vasjpan2 wrote: | I put myself on a limb and recommended Calc for a nonprofit.
We had a function like .34*b6/sum($b$6:$b$254) in Excel in cells g6:g254
Calc did not give the result we had in Excel, only Zero.
After weeks of my assuring them Calc would be fine,
they had to go out near a board deadline and buy Excel.
I not only have egg on my face,
but I have absolutely no idea why this would not work. |
It does not work because somewhere in the Excel spreadsheet they have included a text formated cell in the equation. Calc and Excel handle these differently. IMO both are wrong but that's another matter.
See http://ca.geocities.com/jrkrideau/OpenOffice/spreadsheet_problems.pdf
| Quote: | It does not make sence. It happens with both the PortableApps
version and the regular version of Calc.
All the docs for OO say it should work, no? |
It's sloppy programming in Excel. The same sloppy programming in Calc gets you another result. Neither is good.
| Quote: | Now, as I was testing I found out another thing that didn't work like most
Spreadsheets I'd used before (I go back to MultiPlan and SUperCalc.. well,
even ADR EMpires, but it wasn't on-screen): I hit a + and then point to
another cell to get the address and it just goes to the cell, not give me the address.
I'm hoping all of this is because of some compatibility indicator I have to switch on, or equally simple.. |
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
huwg
Super User
Joined: 14 Feb 2007
Posts: 890
|
|
| Back to top |
|
|
lufavara
Newbie
Joined: 03 Dec 2007
Posts: 1
|
| Posted: Mon Dec 03, 2007 7:33 am Post subject: |
|
|
| huwg wrote: | | CHPCASTELLON wrote: | 1.- to insert a formula, they have to write (=) when in excel it's not necessary
2.- when they have two columns with two cells in the same file combined, they can't insert a column between the two columns. In excel they can.
3.- when they open a excel document with calc, the width of the columns is not the same as the original width. |
- issue 20496, in next release (see acknaks post directly above yours).
- Issue 8302, which is only a proposal on Calc's To Do List, so don't hold your breath.
- Has been discussed on this forum more than once. Unfortunately not a surprise it remains a problem. Issue 76881?
Edit: added quote for clarity |
Why using Openoffice in Linux Mandriva we can insert a formula whithout usign (=) but (+) ore (-) ... In windows xp and ubuntu we can put (=)????? |
|
| Back to top |
|
|
huwg
Super User
Joined: 14 Feb 2007
Posts: 890
|
| Posted: Mon Dec 03, 2007 8:12 am Post subject: |
|
|
| lufavara wrote: | | Why using Openoffice in Linux Mandriva we can insert a formula whithout usign (=) but (+) ore (-) ... In windows xp and ubuntu we can put (=)????? |
Some Linux distros don't include the standard OpenOffice - they have a customised compile of it. The current standard release of OpenOffice still requires = at the beginning of an input equation. Release 2.4 is expected to accept formulas without = at the start. |
|
| Back to top |
|
|
JJJoseph
Power User
Joined: 25 Sep 2005
Posts: 81
|
| Posted: Thu Jan 03, 2008 7:44 am Post subject: OO Open File |
|
|
| I hope that OO can fix the "File Open" dialog. OO tries to intelligently open files, but the tool is more trouble than it's worth. It will open an unrecognized tab delimited file in OO Writer for example, when I want it to open as a spreadsheet. The resulting hassle is usually much worse than a simple error message would be. OO also will list ALL file-types in "Recent Documents" instead of just spreadsheets.This, too, is a really irritating module! |
|
| Back to top |
|
|
mfaynberg
General User
Joined: 20 Dec 2007
Posts: 28
Location: Campbell, CA USA
|
| Posted: Wed Jan 09, 2008 11:32 am Post subject: Another migration issue |
|
|
You are writing about the Calc HYPERLINK function, which Excel does not recognize. What about the opposite? I open an Excel spreadsheet during the migration from MS Office to StartOffice - and alas! all Excel hyperlinks are lost!  Any ideas?
Thanks,
Mike |
|
| Back to top |
|
|
KentG
Newbie
Joined: 23 May 2008
Posts: 2
|
| Posted: Fri May 23, 2008 11:06 am Post subject: Re: OO Open File |
|
|
| JJJoseph wrote: | | I hope that OO can fix the "File Open" dialog. OO tries to intelligently open files, but the tool is more trouble than it's worth. It will open an unrecognized tab delimited file in OO Writer for example, when I want it to open as a spreadsheet. The resulting hassle is usually much worse than a simple error message would be. OO also will list ALL file-types in "Recent Documents" instead of just spreadsheets.This, too, is a really irritating module! |
I have the same problem with thousands of colon ( : ) delimited .dat files. I am currently scanning the forum for a elegant solution. Any ideas? |
|
| Back to top |
|
|
|
