https://bugs.documentfoundation.org/show_bug.cgi?id=157548
Bug ID: 157548
Summary: After exporting a sheet to .CSV file by StoreToUrl(),
last rows from the sheet are missing in the .CSV file.
Product: LibreOffice
Version: 7.5.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
After exporting a sheet to .CSV file by StoreToURL(), last rows from the sheet
are missing in the .CSV file.
After repeating export with changed number of rows to be exported, exported
number rows in target .CSV file is not changing, it is constant.
Macro used for export follows:
sub export_to_CSV()
Dim AAS( 1 ) as New com.sun.star.beans.PropertyValue
AAS( 0 ).Name = "FilterName"
AAS( 0 ).Value = "Text - txt - csv (StarCalc)"
AAS( 1 ).Name = "FilterOptions"
AAS( 1 ).Value = "44,34,0,1,1"
ThisComponent.getCurrentController.setActiveSheet( ThisComponent.Sheets( 0 ) )
S_file = ConvertToURL( "D:\exported.csv" )
ThisComponent.StoreToURL( S_file, AAS )
end sub
Steps to Reproduce:
1.write a macro for exporting a sheet to a .CSV file
2.write more than 10 rows of some data to the 1st sheet
3.call macro for exporting sheet to .CSV file
4.open .csv file and check some last rows are missing
5.change number of rows in the sheet
6.call macro for exporting sheet to .CSV file
7.open .csv file and number of exported lines in the .CSV file is always the
same
Actual Results:
When using StoreToUrl(), number of lines to be exported from the source sheet
and number of exported lines in the .CSV file is not the same.
Expected Results:
When using StoreToUrl(), number of lines to be exported from the source sheet
and number of exported lines in the .CSV file shold be the same.
Reproducible: Always
User Profile Reset: No
Additional Info:
none
--
You are receiving this mail because:
You are the assignee for the bug.
