Ask Your Question

When saving in XSLX format, I am losing "cell format"

asked 2017-03-18 20:59:52 +0200

Lew Merrick gravatar image

updated 2017-03-18 21:04:49 +0200

I am writing a coil compression spring design program. It has to be saved in "XLSX format" to be compatible with my CAD program. When I do so, I am losing (numeric display) "cell format." What am I doing wrong?

I am unable to "attach" a link to my screenshot images. E-mail me at and I will send them (or a "link") to you.

edit retag flag offensive close merge delete


Pls, what's your LibreOffice version and OS?

m.a.riosv gravatar imagem.a.riosv ( 2017-03-19 00:15:02 +0200 )edit

Calc Version under Windows 7 Ultimate (64-bit).

Lew Merrick gravatar imageLew Merrick ( 2017-03-19 03:20:21 +0200 )edit

Please what it's the cel format that it's lost?, can you past a copy here.from the cell's edit?, you can attach here editing your question a sample file with a couple of formulas.

m.a.riosv gravatar imagem.a.riosv ( 2017-03-19 11:47:42 +0200 )edit

if you e-mail me, I can provide "screen shots" that show the problem. They are values expressing the torsional stress in the spring's wire and deflection values that are "centered and rotated" values in a table that defined stress/deflection values in the spring. Please note that I can either send you the (JPG) screen shots themselves of a "link" for you to download them.

Lew Merrick gravatar imageLew Merrick ( 2017-03-19 18:50:14 +0200 )edit

The spreadsheet leads one through the SAE/DoD procedure to create a round wire straight coil compression spring with a number of "cross-checks." It then modifies a "base model" and saves it to a "project directory" under a "formally correct" designation (file name). What I would really like is an "Iron Python" library that would allow me to stay in ODS format!

Lew Merrick gravatar imageLew Merrick ( 2017-03-19 18:54:07 +0200 )edit

The numeric values all turn into "###" and refuse to display (I have screen shots that demonstrate this) and the "conditional formatting" (that changes the background and font colors) has disappeared.

Lew Merrick gravatar imageLew Merrick ( 2017-03-20 02:36:13 +0200 )edit

This visualization is habitual when the column it's not enough wide to show the result.

m.a.riosv gravatar imagem.a.riosv ( 2017-03-20 10:18:19 +0200 )edit

I realize that "###" normally says that the "cell is too narrow." But making is wider has no effect. The "base width" is more than sufficient for the "ODS" format. Making it 30% "wider" ("taller," in this instance) has no effect whatsoever.

Lew Merrick gravatar imageLew Merrick ( 2017-03-20 23:34:02 +0200 )edit

Is there any problem to show what is the cell format with the issue?

m.a.riosv gravatar imagem.a.riosv ( 2017-03-21 01:50:59 +0200 )edit

In the XLSX format, the numbers are identified as having 2 decimal places and NO "comma separators" whereas in the ODS format, they have 0 decimal places and "comma separators."

Lew Merrick gravatar imageLew Merrick ( 2017-03-21 03:11:38 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-03-20 01:27:23 +0200

m.a.riosv gravatar image

updated 2017-03-20 01:27:55 +0200

Please what is the lost cell format?

image description

edit flag offensive delete link more

answered 2017-03-22 22:29:43 +0200

Lew Merrick gravatar image

I am running Calc Version under Windows-7 Ultimate (64-bit). (1) Updated to Version and the "problem" went away. (2) It turned out (last night, just before updating) that changing from Times New Roman font to Arial font made the "problem" go away.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-18 20:59:52 +0200

Seen: 231 times

Last updated: Mar 22 '17