net/py-gspread: update to 6.1.2

Changes:
  * get_notes return [[]] instead of [] if there are no notes

net/py-gspread: Update to v6.1.0

Changelog: https://github.com/burnash/gspread/compare/v5.11.3...v6.1.0

net/py-gspread: update to 5.11.3

Changes:
 * Fix list_spreadsheet_files return value

net/py-gspread: Add dependency on flit-core

Add py-flit-core as a build dependency

net/py-gspread: unbreak

Replace distutils with pep517

net/py-gspread: update to 5.10.0

Changes:
  * Fix rows_auto_resize in worksheet.py by removing redundant self
  * Add deprecation warning for future release 6.0.x
  * FEATURE: show/hide gridlines
  * CLEANUP: cleanup tox.ini, and ignore ./env
  * Refactor/update-contributing-guide
  * Spelling fix (with legacy option)
  * 457-fetch-without-hidden-worksheets
  * Add_deprecated_warning_sort_method
  * Update (and test for) internal properties on change
  * Feature: Add "Remove tab colour" method
  * Refresh-test-cassettes
  * update self._properties after batch_update
  * 700-fill-merged-cells
  * Fix/update-internal-properties
  * Add breaking change warning in Worksheet.update()
  * Bump codespell from 2.2.4 to 2.2.5
  * Add/refresh last update time
  * Update-build-tools by @alifeee in #1231
  * add read the doc configuration file
  * update licence year
  * remove deprecated methods from tests

all: remove explicit versions in USES=python for "3.x+"

The logic in USES=python will automatically convert this to 3.8+ by
itself.

Adjust two ports that only had Python 3.7 mentioned but build fine
on Python 3.8 too.

finance/quickfix: mark BROKEN with PYTHON

libtool: compile:  c++ -DHAVE_CONFIG_H -I. -I../.. -I -I. -I.. -I../.. -I../C++
-DLIBICONV_PLUG -DPYTHON_MAJOR_VERSION=3 -Wno-unused-variable
-Wno-maybe-uninitialized -O2 -pipe -DLIBICONV_PLUG -fstack-protector-strong
-fno-strict-aliasing -DLIBICONV_PLUG -Wall -ansi
-Wno-unused-command-line-argument -Wpointer-arith -Wwrite-strings
-Wno-overloaded-virtual -Wno-deprecated-declarations -Wno-deprecated -std=c++0x
-MT _quickfix_la-QuickfixPython.lo -MD -MP -MF
.deps/_quickfix_la-QuickfixPython.Tpo -c QuickfixPython.cpp  -fPIC -DPIC -o
.libs/_quickfix_la-QuickfixPython.o
warning: unknown warning option '-Wno-maybe-uninitialized'; did you mean
'-Wno-uninitialized'? [-Wunknown-warning-option]
QuickfixPython.cpp:175:11: fatal error: 'Python.h' file not found
          ^~~~~~~~~~
1 warning and 1 error generated.

Reviewed by:	portmgr, vishwin, yuri
Differential Revision:	<https://reviews.freebsd.org/D40568>

net/py-gspread: Add NO_ARCH

Approved by:	portmgr (blanket)

*/*: rename CHEESESHOP to PYPI in MASTER_SITES

PR:			267994
Differential revision:	D37518
Approved by:		bapt

net/py-gspread: Update to 5.7.1

Changes:
  * Fix dependencies required version
  * chore: Update outdated LICENSE year
  * add dependabot to maintain dependencies
  * improve trigger on CI
  * Bump bandit from 1.7.0 to 1.7.4
  * cancel previous run on same ref
  * Bump actions/setup-python from 2 to 4
  * Bump actions/checkout from 2 to 3
  * Bump black from 22.3.0 to 22.10.0
  * Bump isort from 5.9.3 to 5.10.1
  * Bump codespell from 2.1.0 to 2.2.2
  * add named tuple for `DateTimeRenderOption`
  * Feature/copy cut paste
  * isSheetHidden method added to worksheet.py

net/py-gspread: Update to 5.6.2

Changes:
  * update parent folder for client.copy method

Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)

Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.

net/py-gspread: update to version 5.5.0

Changes:
  * Use pathlib
  * Migrate to drive API V3
  * Implement eq method for Cell
  * Add missing documentation on set_timeout
  * Add method to transfer / accept ownership of a spreadsheet
  * Add client_factory parameter to auth methods
  * Fix list_protected_ranges
  * Add function to convert column letter to column index
  * Fix docstring name of named_range() param
  * Fix grammar in docstring for client.export
  * Many typo fixes to worksheet docstrings
  * Fix function numericise_all
  * Fix documentation about oauth_from_dict
  * inherit_from_before option for insert_row/insert_rows
  * add method to change the color of a tab
  * docs: Fix a few typos
  * Fix typo in Worksheet.batch_format method

net: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  <ports@c0decafe.net>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Aaron Straup Cope <ascope@cpan.org>
  *  Aaron Zauner <az_mail@gmx.at>
  *  Adam Jette <jettea46@yahoo.com>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Alan Eldridge <alane@geeksrus.net>
  *  Alex Bakhtin <Alex.Bakhtin@gmail.com>
  *  Alex Deiter <Alex.Deiter@Gmail.COM>
  *  Alex Dupre <ale@FreeBSD.org>
  *  Alex Dupre <sysadmin@alexdupre.com>

net/py-gspread: update to version 5.4.0

Changes:
  * Fix error message in get_all_records
  * Auto resizing is now available for rows
  * add new method to hide/show a worksheet
  * Download PDF from Spreadsheet
  * Add test on auto_resize_columns
  * Add method to unmerge cells
  * Add method to delete a protected range
  * Feature/clean organize documentation
  * Add warning about deprecated oauth flow
  * Add new batch_format method.
  * Encode string to utf-8 when importing CSV content

net/py-gspread: update to version 5.3.2

Changelog:
 * Bugfix: get all record duplicated columns

net/py-gspread: Update to version 5.3.0

Changes:
  * Feature/rework test cassettes recording
  * Add method list protected ranges
  * Add new methods to add/list/delete dimensionGroups
  * Add method to hide rows/columns
  * Add ability to rename Spreadsheets (via a new Spreadsheet.update_title)

net/py-gspread: Update to version 5.2.0

Changes:
  * Copy comments when during spreadsheet copy
  * Update user-guide.rst
  * merge setup test cassettes
  * Feature/add header validation get all records
  * Add timeout to client
  * Feature/update timezone and locale
  * Feature/make case comparison in find
  * Updated API rate limits
  * Feature/prevent insert row to sheet with colon

net/py-gspread: Update to version 5.1.1

Changelog: https://github.com/burnash/gspread/releases/tag/v5.1.1

net/py-gspread: Update to version 5.0.0

Notable Changes:
  * Avoid IndexError when row_values() returns an empty row
  * Add Worksheet.index property
  * Add ability to create directory if it does not exist before saving
      the credentials to disk
  * Add functions for defining, deleting and listing named ranges
  * Implement open sheet within Drive folder
  * Fix get range for unbounded ranges
  * Remove potential I/O when reading spreadsheet title
  * Replace raw string "ROWS" & "COLUMNS" to Dimension named tuple
  * Replace raw string "FORMATTED_VALUE", "UNFORMATTED_VALUE", "FORMULA" to
      ValueRenderOption named tuple
  * Replace raw string "RAW", "USER_ENTERED" to ValueInputOption named tuple

*: fix tab vs. space issues, and comments according to the guide.

net/py-gspread: Update to version 4.0.1

Update to version 4.0.1 which fixes a bug in the numericise function in
which the original value is overwritten when trying to convert to a number.

net/py-gspread: Update to version 4.0.0

Remove # $FreeBSD$ from Makefiles.

Drop python 2.7 support from a few ports

With hat:	portmgr

Update to version 3.5.0

  * Simplified OAuth2 flow
  * Fix Worksheet.delete_rows() index error
  * Deprecate Worksheet.delete_row()
  * Scope Worksheet.find() to a specific row or a column
  * Add Worksheet.add_protected_range()
  * Add ability to fetch cell address in A1 notation
  * Add Worksheet.delete_columns()
  * Ignore numericising specific columns in get_all_records
  * Add option folder_id when creating a spreadsheet
  * Add insertDataOption to Worksheet.append_row() and Worksheet.append_rows()

Update to version 3.3.0

Remove DEPRECATED flag as this port now supports python3

* Added Spreadsheet.values_batch_update()
* Added:
  * Worksheet.get()
  * Worksheet.batch_get()
  * Worksheet.update()
  * Worksheet.batch_update()
  * Worksheet.format()
  * Added more parameters to Worksheet.append_row()
* Fix usage of client.openall when a title is passed in

Deprecate a few ports

With hat:	portmgr

Fix USE_GITHUB usage.

Upgrade to version 3.0.1

Use PY_FLAVOR for dependencies.

FLAVOR is the current port's flavor, it should not be used outside of
this scope.

Sponsored by:	Absolight

Update to version 2.0.0

Reduce dependency on the python2 metaport

PR:		225752
Submitted by:	Yasuhiro KIMURA

Convert Python ports to FLAVORS.

  Ports using USE_PYTHON=distutils are now flavored.  They will
  automatically get flavors (py27, py34, py35, py36) depending on what
  versions they support.

  There is also a USE_PYTHON=flavors for ports that do not use distutils
  but need FLAVORS to be set.  A USE_PYTHON=noflavors can be set if
  using distutils but flavors are not wanted.

  A new USE_PYTHON=optsuffix that will add PYTHON_PKGNAMESUFFIX has been
  added to cope with Python ports that did not have the Python
  PKGNAMEPREFIX but are flavored.

  USES=python now also exports a PY_FLAVOR variable that contains the

Update to version 0.6.2

Update to version 0.4.0

Remove ${PORTSDIR}/ from dependencies, categories m, n, o, and p.

With hat:	portmgr
Sponsored by:	Absolight

Update to version 0.3.0

Update to 0.2.5

Simple API access to Google Spreadsheets

WWW: http://burnash.github.io/gspread/