Converting excel sheet to text file is removing ' from beginning of Strings

Aspose.Cells Product Family
1

I am using Aspose.Cells for Java 19.10.6.
I have an Excel file with String values starting with single quote.
On converting it into text file, the single quote from the beginning of the string is being removed.
How do I stop the single quote from being removed?

Here is the code:

    Workbook testWb = new Workbook();
	Worksheet testWs = testWb.getWorksheets().add("testWs");
	
	Object[][] data = new Object[2][1];
	data[0][0] = "''abc''";
	data[1][0] = "'xyz''";
	
	testWs.getCells().importTwoDimensionArray(data, 0, 0);
	
	testWb.getWorksheets().setActiveSheetIndex(testWs.getIndex());
	
	TxtSaveOptions options = new TxtSaveOptions();
	options.setFormatStrategy(CellValueFormatStrategy.NONE);
	options.setSeparatorString("\t");
	testWb.save("C:\\Users\\sg\\Desktop\\test.txt", options);

The output in the test.txt file is:
‘abc’’
xyz’’

The output I want is:
‘‘abc’’
‘xyz’’

2

@sandipanghosh111,
We have noted your requirement and logged it in our database for providing sample code to generate desired text file. You will be notified here once any update is ready for sharing.

This issue is logged as:
CELLSJAVA-43396 - Converting Excel sheet to text file removes single quote from the beginning

3

@sandipanghosh111,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

Thank you.
Any rough estimate by when the fixed version would be available?

5

@sandipanghosh111,
Hopefully it will be available in 3-4 days. We will update you soon.

6

@sandipanghosh111,
Please try our latest version/fix: Aspose.Cells for Java v21.2.3:
aspose-cells-21.2.3.zip (7.1 MB)

Your issue should be fixed in it.

Let us know your feedback.

7

@sandipanghosh111,

Because the changes made in the fix 21.2.3(for your issue) break the existing functions of other users, we have to roll back this part of the changes.

For your requirement, now we provide new option from fix 21.3.3:

TxtSaveOptions.ExportQuotePrefix

by default this property’s value is false. Please set it as true if you need the heading ’ for Strings.

Please try it with our latest version/fix Aspose.Cells for Java v21.3.3:

aspose-cells-21.3.3-java.zip (7.2 MB)

8

The issues you have found earlier (filed as CELLSJAVA-43396) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi