error_bar.py 1.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
  1. # Copyright (c) 2010-2019 openpyxl
  2. from openpyxl.descriptors.serialisable import Serialisable
  3. from openpyxl.descriptors import (
  4. Typed,
  5. Float,
  6. Set,
  7. Alias
  8. )
  9. from openpyxl.descriptors.excel import ExtensionList
  10. from openpyxl.descriptors.nested import (
  11. NestedNoneSet,
  12. NestedSet,
  13. NestedBool,
  14. NestedFloat,
  15. )
  16. from .data_source import NumDataSource
  17. from .shapes import GraphicalProperties
  18. class ErrorBars(Serialisable):
  19. tagname = "errBars"
  20. errDir = NestedNoneSet(values=(['x', 'y']))
  21. direction = Alias("errDir")
  22. errBarType = NestedSet(values=(['both', 'minus', 'plus']))
  23. style = Alias("errBarType")
  24. errValType = NestedSet(values=(['cust', 'fixedVal', 'percentage', 'stdDev', 'stdErr']))
  25. size = Alias("errValType")
  26. noEndCap = NestedBool(nested=True, allow_none=True)
  27. plus = Typed(expected_type=NumDataSource, allow_none=True)
  28. minus = Typed(expected_type=NumDataSource, allow_none=True)
  29. val = NestedFloat(allow_none=True)
  30. spPr = Typed(expected_type=GraphicalProperties, allow_none=True)
  31. graphicalProperties = Alias("spPr")
  32. extLst = Typed(expected_type=ExtensionList, allow_none=True)
  33. __elements__ = ('errDir','errBarType', 'errValType', 'noEndCap','minus', 'plus', 'val', 'spPr')
  34. def __init__(self,
  35. errDir=None,
  36. errBarType="both",
  37. errValType="fixedVal",
  38. noEndCap=None,
  39. plus=None,
  40. minus=None,
  41. val=None,
  42. spPr=None,
  43. extLst=None,
  44. ):
  45. self.errDir = errDir
  46. self.errBarType = errBarType
  47. self.errValType = errValType
  48. self.noEndCap = noEndCap
  49. self.plus = plus
  50. self.minus = minus
  51. self.val = val
  52. self.spPr = spPr