Reproducible in the demos.
=HYPERLINK("https://google.com")
The link does not work. It does if you specify a "friendly name":
=HYPERLINK("https://google.com", "google")
The link works with and without a "friendly name" specified, as in Excel.
Office 365 Comment are shown with a warning:
"[Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
go to demo - https://demos.telerik.com/kendo-ui/spreadsheet/index
import a file from ticket - 1447268
A warning is displayed
No warning is displayed
When trying to import an Excel document into the Kendo UI Spreadsheet with a missing/corrupt image reference, the file will not show.
The Kendo UI Spreadsheet fails to load the document.
The Kendo UI Spreadsheet should handle the error and load the Spreadsheet data without the image.
Describe the bug
When a custom editor is defined and next to it there is a frozen column, the custom editor cannot be opened.
To reproduce
Steps to reproduce the behavior:
Expected behavior
The calendar should be opened
Workaround
.k-spreadsheet .k-selection-wrapper .k-spreadsheet-editor-button.k-spreadsheet-last-column {
transform: translateX(-100%);
}
The issue is a regression starting with themes version 6.3.0
Affected package (please remove the unneeded items)
Affected suites (please remove the unneeded items)
Affected browsers (please remove the unneeded items)
Dojo example.
The first row is duplicated.
The first row is not duplicated
The Spreadsheet doesn't' load correctly Excel files which definition of the tag is a single cell, instead of a cell range.
Test files: test-2.zip
The The "test.xlsx" file is not loading correctly in the Spreadsheet and loses data
The "test.xlsx" file should load correctly in the Spreadsheet without losing data
The AND
formula, when used as part of an array formula, does not evaluate the whole array.
{=AND(A1:D1="")}
would return TRUE if a value is entered in the range B1:D1 and FALSE only if value is entered in A1
=IF(AND(A1="",B1="",C1="",D1=""),TRUE,FALSE)
would return FALSE if value is entered in any cell in range A1:D1
Ctrl
+Shift
+Enter
to enter as an array formulaArray formula should be evaluated correctly and return FALSE when a value is entered in any cell in range A1:D1.
Dojo example.
The text in B2 is not unwrapped.
The merged cell prevents the unwrap. If there is no merged cell, or if the tool is used over the cell itself, wrapping/unwrapping works as expected.
The text in B2 is unwrapped.
Bug report
YEAR, MONTH and DATE functions do not return the same value on a black cell as in MS Excel
Reproduction of the problem
Apply the Year, Month or Date functions on any blank cell, it returns #VALUE!, where as Excel returns the respective value.
Environment
Kendo UI version: [all]
Browser: [all]
Hello there,
I am developing a Web application using Kendo UI Spreadsheet control, but I noticed that when I copy some numbers from a Excel sheet to the spreadsheet and then copy back to Excel, the decimal values are quite different, I mean, the decimal precision has been affected.
For example:
I have the following numbers on a Excel sheet:
1 | 0.5 | 0.333333333 | 0.25 | 0.2 | 0.166667 | 0.142857 | 0.125 | 0.111111 | 0.1 | 0.090909 | 0.083333 | 0.076923 | 0.071429 | 0.066667 | 0.0625 | 0.058824 | 0.055556 | 0.052632 |
Then, I copy them to the Kendo spreadsheet and I got the following:
100.00% | 50.00% | 33.33% | 25.00% | 20.00% | 16.67% | 14.29% | 12.50% | 11.11% | 10.00% | 9.09% | 8.33% | 7.69% | 7.14% | 6.67% | 6.25% | 5.88% | 5.56% | 5.26% |
But when I copy them back to Excel I got this:
1 | 0.5 | 0.3333 | 0.25 | 0.2 | 0.1667 | 0.1429 | 0.125 | 0.1111 | 0.1 | 0.0909 | 0.0833 | 0.0769 | 0.0714 | 0.0667 | 0.0625 | 0.0588 | 0.0556 | 0.0526 |
Losing many decimals affecting the results of my computation and calculation.
Can you tell me why is this happening?
Thank you some much.
Hi Team,
I have getting warning message when open down loaded excel file . This warning is coming if we apply conditional formatting in kendo spreadsheet .Please
check the URL
The wrap text tool hides some of the cell's text if it is too long.
Go to this Dojo. Select cell A1 and toggle the wrap text tool. The beginning of the text is not displayed.
Part of the cell's content is hidden.
All the text should be visible.
Hi team,
In kendo spreadsheet if you disable any row by adding enable property to false and apply sort from data tab, then the disable row is changing based on the sort. instead of applying to particular row it is applying to perticular range and while sorting the row items are changing. The cell properties are not applying there while sorting.
link for example: https://dojo.telerik.com/IkoJeMIz
please let me know if I am doing anything wrong here.
thanks.
Dear Concerned,
1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Select column B and drag mouse towards C, both columns will be selected which is correct behavior
3. Now just scroll down 2-3 rows using vertical scroll bar
4. Repeat step 2, this time it does not select B & C, instead it selects B,C,D,E.
5. Seems a bug, not an expected behavior.
Observation that might help you in fixing it:
1. if you move scroll bar in such a way so that no merged cell is visible it works well, e.g. scroll down till 20th row becomes first visible row on screen and now repeat step 2, it will work
2. if scroll position is on top then behavior is correct as well
3. Same issue exists in case of multiple row selection with merged column and scroll position.
Reproducible in this demo: https://demos.telerik.com/kendo-ui/spreadsheet/datasource
The data cleared by the "undo" shortcut is saved and sent to the server
A different behavior is exhibited if the data is pasted over the row header instead of the row's first cell. Follow the same steps, but on step 3. instead of pasting over the first cell, paste the data over the row 79 header. After undo and then clicking "Save", the fields have null values.
No data is sent with the request
Memory usage is increased if the DevTools is open. Navigation between sheets is also slower.
Memory usage increased and slower sheet change.
Memory usage should not be increased and sheet navigation should not be slow.
Hi Team,
When I add comments to enabled columns(product)it is allowing me to add and after reopening the comments it is retained. But when I add comments to disabled columns(ID) it is not adding to it and no messages are added like it is disabled and comments are not allowed.
demo: https://dojo.telerik.com/ISIvATiN
thanks.
Describe the bug
To reproduce
Steps to reproduce the behavior:
Expected behavior
The panes are frozen without breaking the layout of the Spreadsheet and without cells/column duplication.
Affected package (please remove the unneeded items)
Affected suites (please remove the unneeded items)
Affected browsers (please remove the unneeded items)
Build system information (please remove the unneeded items)
Additional context
Add any other context about the bug.
When the Sheetsbar is hidden the horizontal scrollbar is not adjusted to the bottom of the widget
The horizontal scrollbar should be adjusted to the bottom of the widget.
As a possible workaround, when hiding the Sheetsbar add the following styling:
<style>
.k-spreadsheet-sheets-bar {
padding: 0;
border-style: none;
}
</style>