在inline-edit-table.vue里边设置自定义的指令 v-el-height-adaptive-table="{bottomOffset: 30}"报错：Failed to resolve directive: el-height-adap

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

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

Hi folks,

I would seriously change your documentation on performance reading from this:
https://github.com/ClosedXML/ClosedXML/wiki/Where-to-use-the-using-keyword

Because you've removed the IDisposable interface, it means that your documented practice on speeding up performance is no longer valid.

Thanks

_Originally posted by @harpsicord86 in https://github.com/ClosedXML/ClosedXML/iss

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

You have type set to project in your composer.json file, which on packagist makes it suggest this command: composer create-project mk-j/php_xlsxwriter.

Should it be changed to library?

I recently ran into an issue where hidden rows/columns were nto being read.

From this I stumbled upon pyexcel/pyexcel#53 which gave me the answer to use skip_hidden_row_and_column like so:

from pyexcel_xlsx import get_data
data = get_data("file.xlsx", skip_hidden_row_and_column=False)

This however is not documented anywhere that I could find (and I'd

Currently, no models are unit tested (only collection)

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

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

While using rows for a project, could not use the import_from_pdf function after putting rows as a dependency. The solution, ultimately, was to also include PyMuPDF and cached_property as dependencies for my project, so as to enable the pdf plugin for rows. This information, however, is not clear by looking only at the docs. It would be desirable to list the dependencies for each plugi

This guide is dated January 21st, 2020.

Assumptions:

• Qt is/will be installed to C:\Qt
• Project directory (location of unpacked zlib and libxlsxwriter) is C:\Projects
• Install destination of compiled zlib will be C:\Qt\Tools\zlib(32/64)
• Install destination of compiled libxlsxwriter will be C:\Qt\Tools\xlsxwriter(32/64)

Prerequisites:

• Installed Qt + Qt-Creator, selected packag

It takes the solution described in #546 and makes it a bit more formal.

Wait until the change in r-lib/vctrs#430 is in a CRAN version of vctrs.

Per the documentation, if I create a new file from an encrypted workbook, the new file will not be encrypted.

xlsx.fromFileAsync('template.xlsx', { password: 'S3cret!' })
    .then(wb => {
        // do some stuff
        return wb.toFileAsync('new-file.xlsx') // not encrypted
    })

However, if the source file also requires a password to modify, then the file created by xlsx-p

The Apache POI project used by Docjure has released version 4.0.0.
Docjure should be upgraded from the 3.x series to use the latest version.
Read about Apache POI here: http://poi.apache.org

Describe the bug
ReoGrid Editor's printer-settings-dialog is too small

To Reproduce
Steps to reproduce the behavior:

1. Select [File] - [Print Settings...]
2. Size of the displayed dialog is not enough

Expected behavior
The entire Cancel button located in the lower right is displayed (or the dialog has scollbars)

Screenshots
![image](https://user-images.githubusercon

So that we can setup mypy on CI we need to elliminate all errors. Currently all serious mypy errors are in canmatrix.canmatrix and most of them are bound to float_factory playing with attrs.

The problem is, that mypy currently only undertsand attr converters, if they are named functions. That means NEITHER converter=decimal.Decimal NOR converter=CanId.from_compound_integer.