Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

Download or installation problems? Try these steps
Problems after upgrading to NeoOffice 2017? Try these steps


Support
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


RSS Feeds
· Announcements Only
· All Posts


  
NeoOffice :: View topic - Spreadsheet won't save formats
Spreadsheet won't save formats
 
Post new topic   Reply to topic    NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
Wickerman
Operator


Joined: Apr 14, 2008
Posts: 49

PostPosted: Wed Mar 30, 2011 8:31 am    Post subject: Spreadsheet won't save formats Reply with quote

My spreadsheet documents no longer retain formatting such as spacing to cell contents. What has happened and how can I make it remember my settings?
Back to top
View user's profile Send private message
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11911
Location: California, USA

PostPosted: Wed Mar 30, 2011 8:37 am    Post subject: Reply with quote

I am not sure how to reproduce the problem that you are seeing. Can you attach sample spreadsheet and tell us which cells to look at to see this problem? Also, can select the Help :: About NeoOffice menu and tell us which NeoOffice version and patch you are using?

You can attach a sample document to your post using the steps in this forum post.

Patrick
Back to top
View user's profile Send private message Visit poster's website
Wickerman
Operator


Joined: Apr 14, 2008
Posts: 49

PostPosted: Wed Mar 30, 2011 8:59 am    Post subject: Reply with quote

3.1.2 Patch 4.
Back to top
View user's profile Send private message
Wickerman
Operator


Joined: Apr 14, 2008
Posts: 49

PostPosted: Wed Mar 30, 2011 9:02 am    Post subject: Reply with quote

It's because I've resaved the file as an .xls file. How can I keep the file extension but retain control over the formatting?
Back to top
View user's profile Send private message
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11911
Location: California, USA

PostPosted: Wed Mar 30, 2011 9:20 am    Post subject: Reply with quote

Wickerman wrote:
It's because I've resaved the file as an .xls file. How can I keep the file extension but retain control over the formatting?


I have good news and bad news. The bad news is that you cannot save to Excel format and retain NeoOffice's cell spacing formatting. The reason is that the Excel file format does not support cell spacing. Cell spacing is a feature that exists only in NeoOffice's native .ods file format so when you export to Excel, .ods formatting that does not have an exact matching Excel formatting will be lost.

The good news is that there is a workaround. The Excel file format does support cell alignment settings. So, to emulate cell spacing in Excel select the Format :: Cells menu and, in the dialog that appears, click on the Alignment tab, and set the horizontal text alignment and indent settings. Unfortunately, this workaround will only be able to emulate cell spacing in the sides of the cell. To emulate cell spacing on the top and bottom, you will need to set the vertical alignment to "Middle" and then resize the row height of the cell.

Hope that helps.

Patrick
Back to top
View user's profile Send private message Visit poster's website
Wickerman
Operator


Joined: Apr 14, 2008
Posts: 49

PostPosted: Wed Mar 30, 2011 9:32 am    Post subject: Reply with quote

That's great. Thanks. Smile
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.03 Seconds