[discuss] OpenOffice Calc - Unsupported Cell Formats

2011-04-17 Thread John P Baker
In migrating a Microsoft Office 2010 Excel spreadsheet to OpenOffice 3.3.0 Calc, I have noted that the Accounting and URL cell formats do not appear to be supported. Are there any plans to incorporate support for these cell formats into a future release of OpenOffice Calc? John P. Baker --

Re: [discuss] Openoffice calc/writer layout change between Windows Linux version

2008-01-10 Thread Nicolas Mailhot
Le Jeu 10 janvier 2008 04:02, kstan a écrit : Hi Michael, Thanks for your reply, I mean, I open a same file in Windows Linux, the layout change. The font is same (I did try use default, freeserif, aria and etc) The font is the same in the document but is it available on both systems ? If

[discuss] Openoffice calc/writer layout change between Windows Linux version

2008-01-09 Thread kstan
Hi all, I facing problem on layout change between Windows Linux version of openoffice (2.3). Below is my problem The font width (at Linux standard sentence can fill into cell, but it won't show all) The look of picture change, in Linux look well but in Windows

Re: [discuss] Openoffice calc/writer layout change between Windows Linux version

2008-01-09 Thread kstan
Hi Michael, Thanks for your reply, I mean, I open a same file in Windows Linux, the layout change. The font is same (I did try use default, freeserif, aria and etc) Regards, Ks On Thu, 2008-01-10 at 08:47 +1300, Michael Adams wrote: On Tue, 08 Jan 2008 00:09:49 +0800 kstan wrote: Hi all,

[discuss] openoffice-calc improve grouping of lines

2007-10-19 Thread Stefan Ritter
Hi, yesterday i tried to group some lines in a table to easily hide them. This works great with F12 and connected lines (like 2,3,4 and 5). I think it would be fine if there is a possibility to group non-connected lines like line 5, 7 and 10 to hide them. Hope you understand what i mean ...

Re: [discuss] OpenOffice Calc: sometimes cannot set font and save as XLS file

2006-11-12 Thread Lotus Studio
Dankon. / Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [discuss] OpenOffice Calc: sometimes cannot set font and save as XLS file

2006-11-10 Thread Eike Rathke
Hi lotus, On Thursday, 2006-11-09 15:11:38 +0800, [EMAIL PROTECTED] wrote: OpenOffice Calc 2.0.1, Chinese traditional characters (latest offical release). If you want to report an issue with the software, please file an issue, see http://qa.openoffice.org/issue_handling/pre_submission.html

[discuss] OpenOffice Calc: sometimes cannot set font and save as XLS file

2006-11-09 Thread lotus
OpenOffice Calc 2.0.1, Chinese traditional characters (latest offical release). Intel-based IBM-compatible PC, Windows XP Home. 1. Select whole file (maybe 10 column, 20 rows). 2. Change all fonts to Latin: Arial; East Asias: MingLiU. 3. Save as Microsoft XLS and open again. 4.

[discuss] OpenOffice Calc: no way of changing hyperlink back to normal text

2006-10-27 Thread lotus
OpenOffice 2.0.1 (latest official Chinese-Traditional-character version), Windows XP, Intel-x86-compatible computer. If automatic hyperlink recognition is enabled, then it will automatically change all \\xxx and http://xxx; etc. into hyperlinks. There is no way to change The help says

Re: [discuss] OpenOffice Calc: no way of changing hyperlink back to normal text

2006-10-27 Thread Terry
[EMAIL PROTECTED] wrote: OpenOffice 2.0.1 (latest official Chinese-Traditional-character version), Windows XP, Intel-x86-compatible computer. If automatic hyperlink recognition is enabled, then it will automatically change all \\xxx and http://xxx; etc. into hyperlinks. There is no way to

[discuss] OpenOffice Calc

2006-09-26 Thread Robert Sitter
Wow, I've just been sold! I've been using Microsoft Office for 4 years, working with spreadsheets and Word. I just tried Calc and I gotta say, Built in pdf feature, super easy functions (that are easy to switch over from Excel), just everything was great! And free!? Wow, just sending an email

[discuss] OpenOffice Calc: make your window narrow, select background colour or text colour

2006-08-10 Thread lotus
OpenOffice Calc, 2.0, Chinese (Traditional Characters) version on Windows XP 1. Open OpenOffice Calc. 2. Make your window narrow, so that the toolbar buttons for background colour and text colour become drop-down menu items at the right side of the tool bar. 3. Select background

Re: [discuss] OPENOFFICE CALC

2006-03-20 Thread Simon Hogg
On 3/18/06, Marco [EMAIL PROTECTED] wrote: Dear sirs, we would like to inform you that we have found a bug on the suite OpenOffice. In Openoffice Calc, if we write =0^0, the result is 1, but 0^0 it's IMPOSSIBLE. We hope the bug will disappear in the next version of your program.

Re: [discuss] OPENOFFICE CALC

2006-03-20 Thread Daniel Carrera
Simon Hogg wrote: Actually this is not a bug, any number[1] raised to the power zero is 1. Simon [1] http://en.wikipedia.org/wiki/Exponentiation#Exponents_one_and_zero Wikipedia is not an authority on mathematics :) I think that 0^0 should be an error. You won't reach a conclusion using

Re: [discuss] OPENOFFICE CALC

2006-03-20 Thread [EMAIL PROTECTED]
Hi Daniel, actually you're right, zero to the power of zero may not be one, but IT IS DEFINED to be one, so the calculation is correct. This definition was made to circumvent a singularity problem. Have fun Bob Simon Hogg wrote: Actually this is not a bug, any number[1] raised to

Re: [discuss] OPENOFFICE CALC

2006-03-20 Thread Henrik Sundberg
2006/3/20, Daniel Carrera [EMAIL PROTECTED]: Simon Hogg wrote: Actually this is not a bug, any number[1] raised to the power zero is 1. Simon [1] http://en.wikipedia.org/wiki/Exponentiation#Exponents_one_and_zero Wikipedia is not an authority on mathematics :) I think that 0^0

Re: [discuss] OPENOFFICE CALC

2006-03-20 Thread Daniel Carrera
[EMAIL PROTECTED] wrote: Hi Daniel, actually you're right, zero to the power of zero may not be one, but IT IS DEFINED to be one, so the calculation is correct. This definition was made to circumvent a singularity problem. It might be. Mathemtecians do make weird definitions some times. But

Re: [discuss] OPENOFFICE CALC

2006-03-20 Thread Ian Lynch
On Mon, 2006-03-20 at 13:56 +, Daniel Carrera wrote: So, what should we pick in the context of a spread sheet? I think that a spread sheet should err on the side of caution and not magically hide things that are likely to be user error. So I think that 0^0 should give an error so the

Re: [discuss] OPENOFFICE CALC

2006-03-20 Thread Simon Hogg
On 3/20/06, Daniel Carrera [EMAIL PROTECTED] wrote: Simon Hogg wrote: Actually this is not a bug, any number[1] raised to the power zero is 1. Simon [1] http://en.wikipedia.org/wiki/Exponentiation#Exponents_one_and_zero Wikipedia is not an authority on mathematics :) I think that

Re: [discuss] OPENOFFICE CALC

2006-03-20 Thread [EMAIL PROTECTED]
This definition is not weired at all! if you calculate lim x^x x- 0 you get 1 try to calculate by hand (or use calc) 0.1^0.1 0.01^0.01 0.001^0.001 see? converging to one! happy coding! Bob [EMAIL PROTECTED] wrote: Hi Daniel, actually you're right, zero to the power of zero

Re: [discuss] OPENOFFICE CALC

2006-03-20 Thread Daniel Carrera
[EMAIL PROTECTED] wrote: This definition is not weired at all! if you calculate lim x^x x- 0 you get 1 try to calculate by hand (or use calc) 0.1^0.1 0.01^0.01 0.001^0.001 see? converging to one! That's a very limited case. It is true that f(x)^g(x) converges to 1 if f and g are analytic

[discuss] OPENOFFICE CALC

2006-03-18 Thread Marco
Dear sirs, we would like to inform you that we have found a bug on the suite OpenOffice. In Openoffice Calc, if we write =0^0, the result is 1, but 0^0 it's IMPOSSIBLE. We hope the bug will disappear in the next version of your program.

[discuss] OpenOffice Calc: unable to open embedded document

2006-02-09 Thread lotus
OpenOffice Calc 2.0, traditional Chinese version. If you embed a Microsoft Word document inside a Micosoft Excel document, and the embedded document can be opened in Microsoft Office 2000, then the embedded document cannot be opened in OpenOffice Calc 2.0. It will say something like:

Re: [discuss] OpenOffice - Calc

2005-07-25 Thread Niklas Nebel
Peter Kupfer OOo wrote: True, but pictures always have names. Question, how do you name a drawing object? Name Object in the context menu. Currently this is available only for embedded (OLE) obejcts, graphics and groups. It might be extended to other objects in the future, see issue 51351.

Re: [discuss] OpenOffice - Calc

2005-07-23 Thread Peter Kupfer OOo
Niklas Nebel wrote: Peter Kupfer OOo wrote: I have had that problem. I have some instructions here: http://openoffice.peschtra.com/tips/ooott_calc_remove_background.html. Actually, once you have activated the selection tool (arrow), you don't have to draw a selection rectangle. You can

Re: [discuss] OpenOffice - Calc

2005-06-10 Thread Niklas Nebel
Peter Kupfer OOo wrote: I have had that problem. I have some instructions here: http://openoffice.peschtra.com/tips/ooott_calc_remove_background.html. Actually, once you have activated the selection tool (arrow), you don't have to draw a selection rectangle. You can then just click to select

Re: [discuss] OpenOffice - Calc

2005-06-09 Thread Peter Kupfer OOo
Jens Kellermann wrote: First of all :Sorry for my bad english ! I need some help with following problem : If i insert a graphic in a new table and bring it to background, i'm not able to bring it back on top. The graphic becomes a watermark and is no longer accessable. While the text is

[discuss] OpenOffice - Calc

2005-06-08 Thread Jens Kellermann
First of all :Sorry for my bad english ! I need some help with following problem : If i insert a graphic in a new table and bring it to background, i'm not able to bring it back on top. The graphic becomes a watermark and is no longer accessable. While the text is still open, i use Edit -

Re: [discuss] OpenOffice - Calc

2005-06-08 Thread cono
Hello Jens, Jens Kellermann wrote: First of all :Sorry for my bad english ! No prob for me. I need some help with following problem : If i insert a graphic in a new table and bring it to background, i'm not able to bring it back on top. The graphic becomes a watermark and is no longer

Re: [discuss] openoffice calc

2005-03-09 Thread Eike Rathke
Hi atila, On Tue, Mar 08, 2005 at 06:47:29 -0800, atila thehaan wrote: there is a problem at the left-to-right,right-to-left buttons on the toolbar at the menus opptions it is working ok ! It is different functionality. The menu Format.Sheet.RightToLeft switches the entire sheet. The toolbar

[discuss] openoffice calc

2005-03-08 Thread atila thehaan
there is a problem at the left-to-right,right-to-left buttons on the toolbar at the menus opptions it is working ok ! - Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web