Writing to PRN adding non existent spaces. #3063

New Issue

AA · 2024-01-24T11:48:47Z

AA commented

2024-01-24 11:48:47 +00:00

		bits/40_harb.js
		Line 1099 in 29d46c07a8
	
								while(w.length < 10) w += " ";

Due to this line of code, when a cell value is shorten than 10 characters, the original value is changed, I see no reasoning for this behaviour.

https://git.sheetjs.com/sheetjs/sheetjs/src/commit/29d46c07a895bdfd948d15b5115529ae697ccb48/bits/40_harb.js#L1099 Due to this line of code, when a cell value is shorten than 10 characters, the original value is changed, I see no reasoning for this behaviour.

sheetjs commented

2024-01-25 04:46:55 +00:00

That specifically applies to the Lotus Formatted Text (.PRN) format. For example, consider the following array of arrays:

[
  ["a", "b", "c"],
  [1, 2, 3]
]

The PRN version is

a         b         c
         1         2         3

The referenced code adds whitespace, but admittedly it should do something a little more intelligent than adding space characters in a loop (prepend when the value is numeric). There is no official spec, so the current strategies are based on observing how Lotus 1-2-3 and Excel generate PRN files.

That specifically applies to the Lotus Formatted Text (.PRN) format. For example, consider the following array of arrays: ```js [ ["a", "b", "c"], [1, 2, 3] ] ``` The PRN version is ``` a b c 1 2 3 ``` The referenced code adds whitespace, but admittedly it should do something a little more intelligent than adding space characters in a loop (prepend when the value is numeric). There is no official spec, so the current strategies are based on observing how Lotus 1-2-3 and Excel generate PRN files.

AA commented

2024-01-31 15:50:50 +00:00

I have observed that when used with excel the export to PRN created by it respects the column widths that are set. Anyhow, feel free to close the issue if you find it appropriate.

Sign in to join this conversation.