/* 5. Test the _write_sheet_views() method with selection set. */ CTEST(worksheet, set_selection05) { char* got; char exp[] = "<sheetViews><sheetView tabSelected=\"1\" workbookViewId=\"0\"><selection activeCell=\"D3\" sqref=\"D3:F4\"/></sheetView></sheetViews>"; FILE* testfile = tmpfile(); lxw_worksheet *worksheet = lxw_worksheet_new(NULL); worksheet->file = testfile; worksheet_select(worksheet); worksheet_set_selection(worksheet, RANGE("D3:F4")); _worksheet_write_sheet_views(worksheet); RUN_XLSX_STREQ(exp, got); lxw_worksheet_free(worksheet); }
/* 1. Test the _write_sheet_views() method with selection set. */ CTEST(worksheet, set_selection01) { char* got; char exp[] = "<sheetViews><sheetView tabSelected=\"1\" workbookViewId=\"0\"/></sheetViews>"; FILE* testfile = tmpfile(); lxw_worksheet *worksheet = lxw_worksheet_new(NULL); worksheet->file = testfile; worksheet_select(worksheet); worksheet_set_selection(worksheet, 0, 0, 0, 0); _worksheet_write_sheet_views(worksheet); RUN_XLSX_STREQ(exp, got); lxw_worksheet_free(worksheet); }
/* 5. Test the _write_sheet_views() method with freeze panes. */ CTEST(worksheet, set_selection25) { char* got; char exp[] = "<sheetViews><sheetView tabSelected=\"1\" workbookViewId=\"0\"><pane xSplit=\"6\" ySplit=\"3\" topLeftCell=\"I7\" activePane=\"bottomRight\" state=\"frozen\"/><selection pane=\"topRight\" activeCell=\"G1\" sqref=\"G1\"/><selection pane=\"bottomLeft\" activeCell=\"A4\" sqref=\"A4\"/><selection pane=\"bottomRight\" activeCell=\"G4\" sqref=\"G4\"/></sheetView></sheetViews>"; FILE* testfile = tmpfile(); lxw_worksheet *worksheet = lxw_worksheet_new(NULL); worksheet->file = testfile; worksheet_select(worksheet); worksheet_set_selection(worksheet, RANGE("G4:G4")); worksheet_freeze_panes_opt(worksheet, 3, 6, 6, 8, 0); _worksheet_write_sheet_views(worksheet); RUN_XLSX_STREQ(exp, got); lxw_worksheet_free(worksheet); }
/* 4. Test the _write_sheet_views() method with freeze panes. */ CTEST(worksheet, set_selection24) { char* got; char exp[] = "<sheetViews><sheetView tabSelected=\"1\" workbookViewId=\"0\"><pane xSplit=\"1\" topLeftCell=\"E1\" activePane=\"topRight\" state=\"frozen\"/><selection pane=\"topRight\"/></sheetView></sheetViews>"; FILE* testfile = tmpfile(); lxw_worksheet *worksheet = lxw_worksheet_new(NULL); worksheet->file = testfile; worksheet_select(worksheet); worksheet_set_selection(worksheet, RANGE("A1:A1")); worksheet_freeze_panes_opt(worksheet, 0, 1, 0, 4, 0); _worksheet_write_sheet_views(worksheet); RUN_XLSX_STREQ(exp, got); lxw_worksheet_free(worksheet); }
/* 4. Test the _write_sheet_views() method with split panes + selection. */ CTEST(worksheet, set_selection34) { char* got; char exp[] = "<sheetViews><sheetView tabSelected=\"1\" workbookViewId=\"0\"><pane xSplit=\"6150\" ySplit=\"1200\" topLeftCell=\"G4\" activePane=\"bottomRight\"/><selection pane=\"topRight\" activeCell=\"G1\" sqref=\"G1\"/><selection pane=\"bottomLeft\" activeCell=\"A4\" sqref=\"A4\"/><selection pane=\"bottomRight\" activeCell=\"I5\" sqref=\"I5\"/></sheetView></sheetViews>"; FILE* testfile = lxw_tmpfile(NULL); lxw_worksheet *worksheet = lxw_worksheet_new(NULL); worksheet->file = testfile; worksheet_select(worksheet); worksheet_set_selection(worksheet, RANGE("I5:I5")); worksheet_split_panes(worksheet, 45, 54.14); _worksheet_write_sheet_views(worksheet); RUN_XLSX_STREQ(exp, got); lxw_worksheet_free(worksheet); }
/* 2. Test the _write_sheet_views() method with split panes + selection. */ CTEST(worksheet, set_selection32) { char* got; char exp[] = "<sheetViews><sheetView tabSelected=\"1\" workbookViewId=\"0\"><pane xSplit=\"1350\" topLeftCell=\"B1\" activePane=\"topRight\"/><selection pane=\"topRight\" activeCell=\"B1\" sqref=\"B1\"/></sheetView></sheetViews>"; FILE* testfile = lxw_tmpfile(NULL); lxw_worksheet *worksheet = lxw_worksheet_new(NULL); worksheet->file = testfile; worksheet_select(worksheet); worksheet_set_selection(worksheet, RANGE("B1:B1")); worksheet_split_panes(worksheet, 0, 8.43); _worksheet_write_sheet_views(worksheet); RUN_XLSX_STREQ(exp, got); lxw_worksheet_free(worksheet); }
/* 1. Test the _write_sheet_views() method with split panes + selection. */ CTEST(worksheet, set_selection31) { char* got; char exp[] = "<sheetViews><sheetView tabSelected=\"1\" workbookViewId=\"0\"><pane ySplit=\"600\" topLeftCell=\"A2\" activePane=\"bottomLeft\"/><selection pane=\"bottomLeft\" activeCell=\"A2\" sqref=\"A2\"/></sheetView></sheetViews>"; FILE* testfile = lxw_tmpfile(NULL); lxw_worksheet *worksheet = lxw_worksheet_new(NULL); worksheet->file = testfile; worksheet_select(worksheet); worksheet_set_selection(worksheet, RANGE("A2:A2")); worksheet_split_panes(worksheet, 15, 0); _worksheet_write_sheet_views(worksheet); RUN_XLSX_STREQ(exp, got); lxw_worksheet_free(worksheet); }