const XLSX = require('xlsx');

const wb = XLSX.utils.book_new();

const ws = XLSX.utils.json_to_sheet([]);

XLSX.utils.book_append_sheet(wb, ws, 'Bug sheet');

ws.A1 = { t: 's', f: 'square' };

XLSX.writeFile(wb, 'formula.ods');

The resulting .ODS file contains:

<table:table-cell table:formula="of:=square" office:value-type="string"><text:p>undefined</text:p></table

Description

Options skipColumnOnPaste and skipRowOnPaste when added to table settings hang the browser down after pasting.

It is said that

When added to a column property, it skips the colum

This would be a nice little feature to have, Excel users are using this a lot.

Environment info

Operating System: Windows server
Python version: Python 3.7.5
gspread version: gspread==3.1.0

Steps to reproduce

1. Connect to Sheet like in this link https://gspread.readthedocs.io/en/latest/oauth2.html
2. Use def get_all_values for get ~4000 rows
3. Get
   Error: {
   "error": {
   "code": 503,
   "message": "The service is currently unavailable.",
   "st

Below steps leads to unexpected behavior:

1. Mouse click on any cell
2. Release the mouse
3. Move the mouse to hover other cells
4. The application will automatically select those hover cell

Codesandbox: https://4jdit.csb.app

Code:

import React, { useState } from "react";
import ReactDataSheet from "react-datasheet";
import "react-datasheet/lib/react-datasheet.css";

expor

This isn't so much an issue as a question about contributing --

I'm an avid user of the library, and have submitted a few issues in the past as well. I'd love to contribute to the library and I thought a good way to start would be by improving the docs, starting with React.
Since React has added hooks and is moving away from class components, I t

When creating a document, things get a little annoying once you start working with tables. I think one of the main annoyances is that once you have a table in the document, you cannot continue adding content after you've inserted the table. Instead you have to do something like:

p1 := doc.AddParagraph()
pAfterTable := doc.InsertParagraphAfter(p1)
table := doc.InsertTableAfter(p1)

//

This is motivated by the weirdness that is Excel's "center across selection". After playing around with Excel for a bit, I now understand how this works. And it makes complete sense that it is achieved in XlsxWriter the way it is.

However, I think it would be nice to have an additional worksheet method which makes it easier. I was thinking format_range, which would be somewhat like `merge_ran

The documentation says

The :datefmt command takes the cell's text content that represents a date,
and uses a given format to set the numeric value of the cell.
Its format is ':datefmt "{strftime_format}"', taking a strftime-compatible
format string.  The format is applied to the cell (as could be done with
the :format function) so that the value is displayed as

When i Installing Document Server for Linux on CentOS7.5.
Reference:https://helpcenter.onlyoffice.com/server/linux/document/linux-installation-centos.aspx
In the end,the document server is ok，
but When I test editing files，
ws://XXXX/5.5.1-76/doc/b81fdff747a247929253f4701a92bc521588227954180/c/208/zp1umjpc/websocket
This link has been pending.
Centos7.5：port all open，firewall is closed.
Wha

Sounds like it will be tricky to fix in IE, and maybe even the current version of Edge:

https://developer.mozilla.org/en-US/docs/Web/CSS/overscroll-behavior
https://stackoverflow.com/questions/23502941/preventing-overscroll-in-internet-explorer-11

Not an issue in Chrome or Firefox.

Maybe get rid of the status bar at the bottom? What purpose does it serve?

Those who fail to find a document or an example refer here to resolve the issue first.
We are planned to build our official document site and before that is completed, please refer to the below link.

• Tutorial
  • ko: https://github.com/nhn/tui.grid/tree/master/packages/toast-ui.grid/docs/ko
  • en: https://github.com/nhn/tui.grid/tree/master/packages/toast-ui.grid/docs/en
• ex

In pandas dataframe, dtype of a column with NaN+integer would be changed into 'float', in cases of must-keep-integer, it's useful to replace dtype:'float' with dtype:'Int64', see: https://pandas.pydata.org/pandas-docs/stable/user_guide/integer_na.html

I use wks.set_dataframe(df, (1,1), nan="") to transfer a dataframe to a gsheet worksheet, but the pandas column with dtype:'float' (mixture of Na

The links to this library just show a page mentioning that the app had been moved to this project already.

Do you want to request a feature or report a bug?
Request a feature.
What is the current behavior?
The equation editor of OnlyOffice generally uses LaTex shortcuts, which is good.
But the \frac shortcut for creating fractions does not work.
If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem.

**What is the ex

Either refuse to do this or disambiguate the sheet title with a suffix. Who wants >1 sheets with exact same title?

When I try to open a sample xslx file, which has a sheet in it with an embedded PowerPoint, I get the following exception: xlnt::exception : missing global header signature

If there are more sheets in it, none of them can be handled as loading the xslx file fails with that exception. I was wondering if there is a way to still be able to read the other sheets, simply ignoring the sheets which

Description

It looks like currently it is impossible to pass props to the renderer components.

Steps to reproduce

1. Go to http://jsfiddle.net/js_ziggle/1jy4o0Lf/
2. The test-prop prop should be readable in the renderer component, but it's not.

Demo

http://jsfiddle.net/js_ziggle/1jy4o0Lf/

Your environment

• Vue wrapper version: 4.1.1
• Handsontable version: 7.4.2