Skip to main content
Solved

Excel writer - apostrophe

R
Forum|alt.badge.img

Hi,

I'm exporting numbers to an EXCEL template.

When I open the file in Excel some cells are marked with a green triangle and the following information is displayed: "The number in this cell is formatted as text or is preceded by an apostrophe".

This only happens to those cells for which I perform a division in FME. Other cells where I only have numbers or sums are not affected.

The problem also occurs if the template is just an empty Excel file.

Any idea how to avoid this? Is there any setting in Excel writer or do I need re-format those numbers before they are written? I tried already to explicitly convert the numbers beforehand (@double(<float>)) but to no avail,

Thanks, Rob

 

Best answer by rob_f

Hi Lena,

the numbers causing an issue are of type float, the other ones are integers. The cells in Excel were formatted the same - as Numbers.

Anyway - your question made me look at the Excel Writer settings: I changed data type from "auto" to "number" and that seems to do the trick.

Many Thanks, Rob

View original
Did this help you find an answer to your question?

3 replies

lau
Forum|alt.badge.img+3
  • lau
  • January 17, 2018
Can you provide us your workspace?

 

 

L
Forum|alt.badge.img
  • lenaatsafe
  • January 17, 2018

Hi @rob_f

are the not formatted numbers integer or float? Is there the same decimal separator in both - formatted and not formatted numbers? What is your system default decimal separator?

R
Forum|alt.badge.img
  • rob_f
  • Author
  • Best Answer
  • January 22, 2018

Hi Lena,

the numbers causing an issue are of type float, the other ones are integers. The cells in Excel were formatted the same - as Numbers.

Anyway - your question made me look at the Excel Writer settings: I changed data type from "auto" to "number" and that seems to do the trick.

Many Thanks, Rob

Reply


Helpful Members This Week

Community Stats

31,157
Posts
118,126
Replies
38,780
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.