Writing to Excel cells

[eddyb2]

Hi all,

 

I have an Excel document. It is blank other than the following:

Row 1 has headings

All cells have a border

All cells are set to font size 10.

 

Using scribe I write to a cell, lets say for example B5

 

When scribe writes to the document, the border of the cell is lost and the font size is not 10, it is 12.

 

I am sure I read that writing to a cell that didn't exist (i.e. did not currently have data in it) took on the formatting of the row. But all rows are set to point 10 and to have borders. So why didn't this formatting stay put?

 

I thought instead I would just enter a space into all cells. This way all cells existed and had a format fixed. This brought a new issue though. Scribe would not write to any cells that had a space inserted into them. Instead, all of my spaces had disappeared in the resulting file.

Can you not write to a cell that already has data in it? Why did all the spaces from the cell disappear?

 

Obviously I would prefer to do this without having to put something in every cell, so issue 1 is the one I would most like some assistance with please.

 

Many thanks

[wbasham]

Do you have the most recent version of Scribe installed?  Maintaining formatting was addressed in one of the updates a little while back.  Entering a space into a cell, as far as I know, does not affect the formatting of the cell.  In using ScribeDocWriteValue in a cell with existing data, Scribe will simply overwrite the data.  This behavior should be the same with a string consisting of only a space.

 

If you are using the most recent version, I'd be happy to try to reproduce this locally if you will send me the template document along with a brief description directly ([email protected]).

[eddyb2]

Hi, thanks for the reply, I believe i am using the most recent version... 1.31

 

Have sent you an email. Many thanks