what is the purpose of preserve format and where we use that.What happens if we enable the preserve format?
The preserve format option is typically used to keep the original formatting of data when it is being copied, moved, or manipulated. This can be useful for ensuring that the data is displayed correctly in the target location or that it can be easily imported into another application.
For example, if you are copying a cell from an Excel spreadsheet to a text file, you can enable the preserve format option to ensure that the cell’s formatting, such as its font, size, and alignment, is preserved in the text file.
If you don’t enable it just reads the text without its format
Refer this doc for example
Hope this helps
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.