widgets.py 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686
  1. """
  2. @package vnet.widgets
  3. @brief Base class for list of points.
  4. Classes:
  5. - widgets::PointsList
  6. - widgets::EditItem
  7. (C) 2012 by the GRASS Development Team
  8. This program is free software under the GNU General Public License
  9. (>=v2). Read the file COPYING that comes with GRASS for details.
  10. @author Original author Michael Barton
  11. @author Original version improved by Martin Landa <landa.martin gmail.com>
  12. @author Rewritten by Markus Metz redesign georectfier -> GCP Manage
  13. @author Stepan Turek <stepan.turek seznam.cz> (Created PointsList from GCPList) (GSoC 2012, mentor: Martin Landa)
  14. """
  15. import os
  16. import sys
  17. import six
  18. from copy import copy, deepcopy
  19. import wx
  20. from wx.lib.mixins.listctrl import CheckListCtrlMixin, ColumnSorterMixin, \
  21. ListCtrlAutoWidthMixin, TextEditMixin
  22. from core import globalvar
  23. from gui_core.wrap import Button, StaticText, StaticBox, TextCtrl, ListCtrl
  24. if sys.version_info.major >= 3:
  25. basestring = str
  26. class PointsList(ListCtrl,
  27. CheckListCtrlMixin,
  28. ListCtrlAutoWidthMixin,
  29. ColumnSorterMixin):
  30. def __init__(self, parent, cols, id=wx.ID_ANY,
  31. pos=wx.DefaultPosition, size=wx.DefaultSize,
  32. style=wx.LC_REPORT | wx.SUNKEN_BORDER | wx.LC_HRULES |
  33. wx.LC_SINGLE_SEL):
  34. """Creates list for points.
  35. PointsList class was created from GCPList class in GCP manager. It is possible
  36. to be shared by GCP and VNET front end.
  37. Important parameters:
  38. :param cols: is list containing list items. which represents columns.
  39. This columns will be added in order as they are in list.
  40. Class will add as first column "use" with number of point and checkbox.
  41. Structure of list item must be this:
  42. -1. item: column name
  43. -2. item: column label
  44. -3. item: If column is editable by user, it must contain convert function to convert
  45. inserted string to it's type for sorting. Use None for not editable
  46. columns. Values for insertion can be in list. This allows insert
  47. just values in the list.
  48. -4. item: Default value for column cell. Value should be given in it's type
  49. in order to sorting would work properly. If 3. item is list, it must be index
  50. of some item in the list.
  51. Example of cols parameter:
  52. column name, column label, convert function, default val
  53. @code
  54. cols = [
  55. ['E', _('source E'), float, 0.0],
  56. ['N', _('source N'), float, 0.0],
  57. ['E', _('target E'), float, 0.0],
  58. ['N', _('target N'), float, 0.0],
  59. ['F_Err', _('Forward error'), None, 0],
  60. ['B_Err', _(Backward error'), None, 0]
  61. ['type', _('type'), [_(""), _("Start point"), _("End point")], 0] # Select from 3 choices ("Start point", "End point"),
  62. # Choice with index 0 ("") is default.
  63. ]
  64. @endcode
  65. """
  66. ListCtrl.__init__(self, parent, id, pos, size, style)
  67. # Mixin settings
  68. CheckListCtrlMixin.__init__(self)
  69. ListCtrlAutoWidthMixin.__init__(self)
  70. # TextEditMixin.__init__(self)
  71. # inserts first column with points numbers and checkboxes
  72. cols.insert(0, ['use', _('use'), False, 0])
  73. self.colsData = cols
  74. self.dataTypes = {
  75. "colName": 0,
  76. "colLabel": 1,
  77. "colEditable": 2,
  78. "itemDefaultValue": 3} # just for better understanding
  79. # information whether list items are checked or not
  80. self.CheckList = []
  81. self._createCols()
  82. self.hiddenCols = {}
  83. self.Bind(wx.EVT_LIST_ITEM_SELECTED, self.OnItemSelected)
  84. self.Bind(wx.EVT_LIST_ITEM_ACTIVATED, self.OnItemActivated)
  85. self.Bind(wx.EVT_LIST_COL_CLICK, self.OnColClick)
  86. self.selected = wx.NOT_FOUND
  87. self.selectedkey = -1
  88. # CheckListCtrlMixin must set an ImageList first
  89. self.il = self.GetImageList(wx.IMAGE_LIST_SMALL)
  90. # images for column sorting
  91. SmallUpArrow = wx.BitmapFromImage(self.getSmallUpArrowImage())
  92. SmallDnArrow = wx.BitmapFromImage(self.getSmallDnArrowImage())
  93. self.sm_dn = self.il.Add(SmallDnArrow)
  94. self.sm_up = self.il.Add(SmallUpArrow)
  95. # initialize column sorter
  96. self.itemDataMap = []
  97. ncols = self.GetColumnCount()
  98. ColumnSorterMixin.__init__(self, ncols)
  99. # init to ascending sort on first click
  100. self._colSortFlag = [1] * ncols
  101. # same structure as itemDataMap, information about choice index selected
  102. # if cell is in column without values to choose then is -1
  103. self.selIdxs = []
  104. self.ResizeColumns()
  105. self.SetColumnWidth(0, 50)
  106. def _createCols(self):
  107. """Creates columns in list"""
  108. if 0:
  109. # normal, simple columns
  110. for col in enumerate(self.colsData):
  111. iLabel = self.dataTypes["colLabel"]
  112. self.InsertColumn(col[0], col[1][iLabel])
  113. else:
  114. # the hard way: we want images on the column header
  115. info = wx.ListItem()
  116. info.SetMask(
  117. wx.LIST_MASK_TEXT | wx.LIST_MASK_IMAGE | wx.LIST_MASK_FORMAT)
  118. info.SetImage(-1)
  119. if globalvar.wxPythonPhoenix:
  120. info.Format = wx.LIST_FORMAT_LEFT
  121. else:
  122. info.m_format = wx.LIST_FORMAT_LEFT
  123. for col in enumerate(self.colsData):
  124. iLabel = self.dataTypes["colLabel"]
  125. info.SetText(col[1][iLabel])
  126. if globalvar.wxPythonPhoenix:
  127. self.InsertColumn(col[0], info)
  128. else:
  129. self.InsertColumnInfo(col[0], info)
  130. def AddItem(self):
  131. """Appends an item to list with default values"""
  132. iDefVal = self.dataTypes["itemDefaultValue"]
  133. iColEd = self.dataTypes["colEditable"]
  134. itemData = []
  135. itemIndexes = []
  136. for col in self.colsData:
  137. if type(col[iColEd]).__name__ == "list":
  138. itemData.append(col[iColEd][col[iDefVal]])
  139. itemIndexes.append(col[iDefVal])
  140. else:
  141. itemData.append(col[iDefVal])
  142. itemIndexes.append(-1) # not a choise column
  143. self.selIdxs.append(itemIndexes)
  144. for hCol in six.itervalues(self.hiddenCols):
  145. defVal = hCol['colsData'][iDefVal]
  146. if type(hCol['colsData'][iColEd]).__name__ == "list":
  147. hCol['itemDataMap'].append(hCol['colsData'][iColEd][defVal])
  148. hCol['selIdxs'].append(defVal)
  149. else:
  150. hCol['itemDataMap'].append(defVal)
  151. hCol['selIdxs'].append(-1)
  152. self.selectedkey = self.GetItemCount()
  153. itemData[0] = self.selectedkey + 1
  154. self.itemDataMap.append(copy(itemData))
  155. self.Append(list(map(str, itemData)))
  156. self.selected = self.GetItemCount() - 1
  157. self.SetItemData(self.selected, self.selectedkey)
  158. self.SetItemState(self.selected,
  159. wx.LIST_STATE_SELECTED,
  160. wx.LIST_STATE_SELECTED)
  161. self.ResizeColumns()
  162. return self.selected
  163. def GetCellValue(self, key, colName):
  164. """Get value in cell of list using key (same regardless of sorting)"""
  165. colNum = self._getColumnNum(colName)
  166. if colNum < 0:
  167. return None
  168. iColEd = self.dataTypes["colEditable"]
  169. if self.selIdxs[key][colNum] != -1:
  170. return self.selIdxs[key][colNum]
  171. return self.itemDataMap[key][colNum]
  172. def GetCellSelIdx(self, key, colName):
  173. """Get selected index in cell of list using key (same regardless of sorting)
  174. :return: number of chosen value, if column has values to choose
  175. :return: -1 if column does not has values to choose
  176. """
  177. colNum = self._getColumnNum(colName)
  178. iColEd = self.dataTypes["colEditable"]
  179. return self.selIdxs[key][colNum]
  180. def EditCellIndex(self, index, colName, cellData):
  181. """Changes value in list using key (same regardless of sorting)"""
  182. colNum = self._getColumnNum(colName)
  183. key = self.GetItemData(index)
  184. iColEd = self.dataTypes["colEditable"]
  185. if type(self.colsData[colNum][iColEd]).__name__ == "list":
  186. cellVal = self.colsData[colNum][iColEd][cellData]
  187. self.selIdxs[key][colNum] = cellData
  188. else:
  189. cellVal = cellData
  190. self.selIdxs[key][colNum] = -1
  191. self.itemDataMap[key][colNum] = cellVal
  192. if not isinstance(cellVal, basestring):
  193. cellVal = str(cellVal)
  194. self.SetItem(index, colNum, cellVal)
  195. def EditCellKey(self, key, colName, cellData):
  196. """Changes value in list using index (changes during sorting)"""
  197. colNum = self._getColumnNum(colName)
  198. iColEd = self.dataTypes["colEditable"]
  199. if type(self.colsData[colNum][iColEd]).__name__ == "list":
  200. cellVal = self.colsData[colNum][iColEd][cellData]
  201. self.selIdxs[key][colNum] = cellData
  202. else:
  203. cellVal = cellData
  204. self.selIdxs[key][colNum] = -1
  205. self.itemDataMap[key][colNum] = cellVal
  206. index = self._findIndex(key)
  207. if index != -1:
  208. if not isinstance(cellVal, basestring):
  209. cellVal = str(cellVal)
  210. self.SetItem(index, colNum, cellVal)
  211. def _findIndex(self, key):
  212. """Find index for key"""
  213. index = -1
  214. while True:
  215. index = self.GetNextItem(index,
  216. wx.LIST_NEXT_BELOW)
  217. if key == self.GetItemData(index):
  218. return index
  219. if index == -1:
  220. break
  221. return -1
  222. def ChangeColEditable(self, colName, colType):
  223. """Change 3. item in constructor parameter cols (see the class constructor hint)"""
  224. colNum = self._getColumnNum(colName)
  225. iColEd = self.dataTypes["colEditable"]
  226. self.colsData[colNum][iColEd] = colType
  227. def DeleteItem(self):
  228. """Delete selected item in list"""
  229. if self.selected == wx.NOT_FOUND:
  230. return
  231. key = self.GetItemData(self.selected)
  232. ListCtrl.DeleteItem(self, self.selected)
  233. del self.itemDataMap[key]
  234. self.selIdxs.pop(key)
  235. # update hidden columns
  236. for hCol in six.itervalues(self.hiddenCols):
  237. hCol['itemDataMap'].pop(key)
  238. hCol['selIdxs'].pop(key)
  239. # update key and point number
  240. for newkey in range(key, len(self.itemDataMap)):
  241. index = self.FindItemData(-1, newkey + 1)
  242. self.itemDataMap[newkey][0] = newkey
  243. self.SetItem(index, 0, str(newkey + 1))
  244. self.SetItemData(index, newkey)
  245. # update selected
  246. if self.GetItemCount() > 0:
  247. if self.selected < self.GetItemCount():
  248. self.selectedkey = self.GetItemData(self.selected)
  249. else:
  250. self.selected = self.GetItemCount() - 1
  251. self.selectedkey = self.GetItemData(self.selected)
  252. self.SetItemState(self.selected,
  253. wx.LIST_STATE_SELECTED,
  254. wx.LIST_STATE_SELECTED)
  255. else:
  256. self.selected = wx.NOT_FOUND
  257. self.selectedkey = -1
  258. def ClearItem(self, event):
  259. """"Set all values to default in selected item of points list and uncheck it."""
  260. if self.selected == wx.NOT_FOUND:
  261. return
  262. index = self.selected
  263. iDefVal = self.dataTypes["itemDefaultValue"]
  264. iColEd = self.dataTypes["colEditable"]
  265. i = 0
  266. for col in self.colsData:
  267. if i == 0:
  268. i += 1
  269. continue
  270. if type(col[iColEd]).__name__ == "list":
  271. self.EditCell(index, i, col[iColEd][col[iDefVal]])
  272. else:
  273. self.EditCell(index, i, col[iDefVal])
  274. i += 1
  275. self.CheckItem(index, False)
  276. def ResizeColumns(self, minWidth=[90, 120]):
  277. """Resize columns"""
  278. for i in range(self.GetColumnCount()):
  279. self.SetColumnWidth(i, wx.LIST_AUTOSIZE)
  280. # first column is checkbox, don't set to minWidth
  281. if i > 0 and self.GetColumnWidth(i) < minWidth[i > 4]:
  282. self.SetColumnWidth(i, minWidth[i > 4])
  283. self.SendSizeEvent()
  284. def GetSelected(self):
  285. """Get index of selected item."""
  286. return self.selected
  287. # Used by the ColumnSorterMixin, see wx/lib/mixins/listctrl.py
  288. def GetSortImages(self):
  289. return (self.sm_dn, self.sm_up)
  290. # Used by the ColumnSorterMixin, see wx/lib/mixins/listctrl.py
  291. def GetListCtrl(self):
  292. return self
  293. def OnItemActivated(self, event):
  294. """When item is double clicked, open editor to edit editable columns."""
  295. data = []
  296. index = event.GetIndex()
  297. key = self.GetItemData(index)
  298. changed = False
  299. iColEd = self.dataTypes["colEditable"]
  300. for col in enumerate(self.colsData):
  301. if col[1][iColEd]:
  302. data.append([col[0], # culumn number
  303. self.GetItem(
  304. index, col[0]).GetText(), # cell value
  305. col[1][iColEd]]) # convert function for type check
  306. if not data:
  307. return
  308. dlg = self.CreateEditDialog(data=data, pointNo=key)
  309. if dlg.ShowModal() == wx.ID_OK:
  310. editedData = dlg.GetValues() # string
  311. if len(editedData) == 0:
  312. GError(parent=self, message=_(
  313. "Invalid value inserted. Operation canceled."))
  314. else:
  315. i = 0
  316. for editedCell in editedData:
  317. if editedCell[1] != data[i][1]:
  318. value = editedCell[1]
  319. if not isinstance(editedCell[1], basestring):
  320. value = str(editedCell[1])
  321. self.SetItem(index, editedCell[0], value)
  322. self.itemDataMap[key][editedCell[0]] = editedCell[1]
  323. changed = True
  324. i += 1
  325. self.selIdxs[key] = dlg.GetSelectionIndexes()
  326. dlg.Destroy()
  327. return changed, key
  328. def CreateEditDialog(self, data, pointNo):
  329. """Helper function
  330. It is possible to define in child derived class
  331. and adapt created dialog (e. g. it's title...)
  332. """
  333. return EditItem(parent=self, id=wx.ID_ANY, data=data, pointNo=pointNo)
  334. def OnColClick(self, event):
  335. """ListCtrl forgets selected item..."""
  336. self.selected = self.FindItemData(-1, self.selectedkey)
  337. self.SetItemState(self.selected,
  338. wx.LIST_STATE_SELECTED,
  339. wx.LIST_STATE_SELECTED)
  340. event.Skip()
  341. def OnItemSelected(self, event):
  342. """Updates class attributes holding information about selected item"""
  343. if self.selected != event.GetIndex():
  344. self.selected = event.GetIndex()
  345. self.selectedkey = self.GetItemData(self.selected)
  346. event.Skip()
  347. def getSmallUpArrowImage(self):
  348. """Get arrow up symbol for indication of sorting"""
  349. stream = open(
  350. os.path.join(
  351. globalvar.IMGDIR,
  352. 'small_up_arrow.png'),
  353. 'rb')
  354. try:
  355. img = wx.ImageFromStream(stream)
  356. finally:
  357. stream.close()
  358. return img
  359. def getSmallDnArrowImage(self):
  360. """Get arrow down symbol for indication of sorting"""
  361. stream = open(
  362. os.path.join(
  363. globalvar.IMGDIR,
  364. 'small_down_arrow.png'),
  365. 'rb')
  366. try:
  367. img = wx.ImageFromStream(stream)
  368. finally:
  369. stream.close()
  370. return img
  371. def _getColumnNum(self, colName):
  372. """Get position of column among showed columns
  373. :param colName: name of column
  374. :type colName: str
  375. :return: index of columns or -1 if col was not found
  376. """
  377. for iCol, col in enumerate(self.colsData):
  378. if colName == col[0]:
  379. return iCol
  380. return -1
  381. def HideColumn(self, colName):
  382. """Hide column (hidden columns are not editable)
  383. :param colName: name of column
  384. :type colName: str
  385. :return: True - if column was hidden
  386. :return: False - if position is not valid or column is not showed
  387. """
  388. colNum = self._getColumnNum(colName)
  389. if colNum == -1:
  390. return False
  391. hiddenCol = self.GetColumn(colNum)
  392. self.DeleteColumn(colNum)
  393. self.hiddenCols[colName] = {}
  394. self.hiddenCols[colName]['wxCol'] = hiddenCol
  395. hiddenMaps = []
  396. hiddenSelIdxs = []
  397. for item in self.itemDataMap:
  398. hiddenMaps.append(item.pop(colNum))
  399. for item in self.selIdxs:
  400. hiddenSelIdxs.append(item.pop(colNum))
  401. self.hiddenCols[colName]['itemDataMap'] = hiddenMaps
  402. self.hiddenCols[colName]['selIdxs'] = hiddenSelIdxs
  403. self.hiddenCols[colName]['colsData'] = self.colsData.pop(colNum)
  404. self.ResizeColumns()
  405. return True
  406. def ShowColumn(self, colName, pos):
  407. """Show column
  408. :param colName: name of column
  409. :type colName: str
  410. :param pos: zero based index of position among showed columns (including added 'use' column)
  411. :return: True if column was shown
  412. :return: False if position is not valid or column is not hidden
  413. """
  414. if pos < 0 and pos >= self.self.GetColumnCount():
  415. return False
  416. if colName in self.hiddenCols:
  417. col = self.hiddenCols[colName]
  418. for item in enumerate(self.itemDataMap):
  419. item[1].insert(pos, col['itemDataMap'][item[0]])
  420. for item in enumerate(self.selIdxs):
  421. item[1].insert(pos, col['selIdxs'][item[0]])
  422. self.colsData.insert(pos, col['colsData'])
  423. self.InsertColumnItem(pos, col['wxCol'])
  424. self.ResizeColumns()
  425. del self.hiddenCols[colName]
  426. return True
  427. return False
  428. def IsShown(self, colName):
  429. """Is column shown
  430. :param colName: name of column
  431. :type colName: str
  432. :return: True - if is shown
  433. :return: False - if is not shown
  434. """
  435. if self._getColumnNum(colName) == -1:
  436. return False
  437. else:
  438. return True
  439. class EditItem(wx.Dialog):
  440. def __init__(
  441. self, parent, data, pointNo, itemCap="Point No.", id=wx.ID_ANY,
  442. title=_("Edit point"),
  443. style=wx.DEFAULT_DIALOG_STYLE):
  444. """Dialog for editing item cells in list"""
  445. wx.Dialog.__init__(self, parent, id, title=_(title), style=style)
  446. self.parent = parent
  447. panel = wx.Panel(parent=self)
  448. sizer = wx.BoxSizer(wx.VERTICAL)
  449. box = StaticBox(parent=panel, id=wx.ID_ANY,
  450. label=" %s %s " % (_(itemCap), str(pointNo + 1)))
  451. boxSizer = wx.StaticBoxSizer(box, wx.VERTICAL)
  452. # source coordinates
  453. gridSizer = wx.GridBagSizer(vgap=5, hgap=5)
  454. self.fields = []
  455. self.data = deepcopy(data)
  456. col = 0
  457. row = 0
  458. iField = 0
  459. for cell in self.data:
  460. # Select
  461. if type(cell[2]).__name__ == "list":
  462. self.fields.append(wx.ComboBox(parent=panel, id=wx.ID_ANY,
  463. choices=cell[2],
  464. style=wx.CB_READONLY,
  465. size=(110, -1)))
  466. # Text field
  467. else:
  468. if cell[2] == float:
  469. validator = FloatValidator()
  470. elif cell[2] == int:
  471. validator = IntegerValidator()
  472. else:
  473. validator = None
  474. if validator:
  475. self.fields.append(
  476. TextCtrl(
  477. parent=panel, id=wx.ID_ANY, validator=validator,
  478. size=(150, -1)))
  479. else:
  480. self.fields.append(TextCtrl(parent=panel, id=wx.ID_ANY,
  481. size=(150, -1)))
  482. value = cell[1]
  483. if not isinstance(cell[1], basestring):
  484. value = str(cell[1])
  485. self.fields[iField].SetValue(value)
  486. label = StaticText(
  487. parent=panel,
  488. id=wx.ID_ANY,
  489. label=_(
  490. parent.GetColumn(
  491. cell[0]).GetText()) +
  492. ":") # name of column)
  493. gridSizer.Add(label,
  494. flag=wx.ALIGN_CENTER_VERTICAL,
  495. pos=(row, col))
  496. col += 1
  497. gridSizer.Add(self.fields[iField],
  498. pos=(row, col))
  499. if col % 3 == 0:
  500. col = 0
  501. row += 1
  502. else:
  503. col += 1
  504. iField += 1
  505. boxSizer.Add(gridSizer, proportion=1,
  506. flag=wx.EXPAND | wx.ALL, border=5)
  507. sizer.Add(boxSizer, proportion=1,
  508. flag=wx.EXPAND | wx.ALL, border=5)
  509. #
  510. # buttons
  511. #
  512. self.btnCancel = Button(panel, wx.ID_CANCEL)
  513. self.btnOk = Button(panel, wx.ID_OK)
  514. self.btnOk.SetDefault()
  515. btnSizer = wx.StdDialogButtonSizer()
  516. btnSizer.AddButton(self.btnCancel)
  517. btnSizer.AddButton(self.btnOk)
  518. btnSizer.Realize()
  519. sizer.Add(btnSizer, proportion=0,
  520. flag=wx.ALIGN_RIGHT | wx.ALL, border=5)
  521. panel.SetSizer(sizer)
  522. sizer.Fit(self)
  523. def GetValues(self):
  524. """Return list of values (as strings).
  525. """
  526. iField = 0
  527. for cell in self.data:
  528. value = self.fields[iField].GetValue()
  529. if type(cell[2]).__name__ == "list":
  530. cell[1] = value
  531. else:
  532. try:
  533. cell[1] = cell[2](value)
  534. except ValueError:
  535. return []
  536. iField += 1
  537. return self.data
  538. def GetSelectionIndexes(self):
  539. """Return indexes of selected values (works just for choice
  540. columns).
  541. """
  542. iField = 0
  543. itemIndexes = []
  544. for cell in self.parent.colsData:
  545. if type(cell[2]).__name__ == "list":
  546. itemIndexes.append(self.fields[iField].GetSelection())
  547. else:
  548. itemIndexes.append(-1) # not a choise column
  549. if cell[2]:
  550. iField += 1
  551. return itemIndexes