« Free Online Linux and OpenOffice.org Courses | Main | Unrelated: Free Online Course for JSP and Servlets Certification Exam »

January 19, 2007

Comments

Hello,

I had more of these weird cells, and I found out that the problem is with their Style.
When I selected all these cells, right-clicked and selected "Default" style, all formulas are acting OK (but you'll lose original formatting). Maybe it's possible to define custom formatting(s) and apply this to these cells.

Had the same problem with showing formula instead of calculating the cell, though cell was in number format though.
The cause was in my old habit in writing formula - I used to put + (plus) sign to show it will be content to calculate instead of text. (example - "+2+3")
In OO 2.3 version the + does not work anymore - you have to put = sign.(example - "=2+3")

I have a table in writer and I wish to add 1 month to say January.. can someone let me know what is the formula to be entered into the cell

Hi Spread sheet,

I'm afraid I don't understand the question. Can you give more detail?

If you're doing anything complicated I would say do it in a spreadsheet, then copy and paste it, if necessary, into Writer. Copy, then choose Edit > Paste Special. Choose Link and you can edit it in the spreadsheet and it'll update in the Writer doc. Choose Formatted Text and it will be pasted into Writer as a normal table.

Do a normal paste and you can double-click the spreadsheet in the Writer doc and edit it with all the usual spreadsheet tools.

Solveig

If you're doing anything complicated I would say do it in a spreadsheet, then copy and paste it, if necessary, into Writer. Copy, then choose Edit > Paste Special. Choose Link and you can http://www.batterygoshop.co.uk/asus/a42-a4.htm asus a4 a4d a4g a4k a4l a4s a4000 a42-a4 ,
edit it in the spreadsheet and it'll update in the Writer doc. Choose Formatted Text and it will be pasted into Writer as a normal table.

Do a normal paste and you can double-click the spreadsheet in the Writer doc and edit it with all the usual spreadsheet tools.

Hi! This is helpful indeed! But I hope you can help me. I can't seem to resolve my sorting problem. I already used until row 1170 and I need to sort by date in one column. The problem is, if I sort one date, for example April 20, I get April 20 to 28. But I just need to display April 20. In excel this works and I wonder why Calc doesn't recognize this.

GOOD

The comments to this entry are closed.

GetOpenOffice Consulting

Get Book Resources

Search This Blog